Senior DB2 Database Administrator

Mphasis is seeking a Senior DB2 Database Administrator with deep expertise in database performance, physical design, workload optimization, and operational administration of IBM Db2 LUW/UDB. The role will serve as a senior technical anchor for enterprise workloads and advise application teams on efficient database usage. Key Responsibilities

• Administer distributed Db2 databases and ensure performance, availability, stability, and recoverability.
• Analyze workload behavior and tune SQL, access paths, indexes, statistics, memory, configuration parameters, and database objects.
• Design and review physical schemas, partitioning approaches, indexing strategies, table spaces, and data placement.
• Use explain plans, monitoring data, and diagnostic tools to identify bottlenecks and recommend corrective actions.
• Partner with Java developers and solution architects to optimize application-to-database interactions.
• Lead root-cause analysis for database incidents and implement sustainable remediation and preventive controls.
• Perform capacity planning, database health reviews, maintenance planning, and standards definition.
• Provide technical guidance, peer reviews, and operational documentation for database support teams.

• Strong hands-on experience administering and tuning IBM Db2 LUW/UDB in enterprise environments.
• Advanced SQL tuning, query-plan analysis, indexing, statistics, and workload-management experience.
• Expertise in physical database design, table spaces, partitioning, buffer pools, locking, concurrency, and utilities.
• Experience with monitoring, diagnostics, backup/recovery, high availability, and production incident resolution.
• Ability to translate business workload characteristics into database configuration and optimization decisions.
• Strong collaboration skills with application, infrastructure, architecture, and production-support teams.

Preferred Skills

• Experience supporting high-volume Java applications and distributed services.
• IBM Data Studio, db2pd, MON_GET interfaces, or comparable Db2 monitoring and diagnostic tooling.
• AWS or cloud-migration exposure.
• Automation or scripting using shell, Python, or similar tools.
• Banking, investment, or financial-services domain experience.