> Markdown version of [/jobs/ext/3829141-senior-db2-database-administrator](https://www.wearedevelopers.com/jobs/ext/3829141-senior-db2-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior DB2 Database Administrator - **Company:** SFE PARTNERS LLC - **Location:** Malvern, PA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Amazon Web Services, Databases, IBM DB2, Database Schema, Database Storage Structures, Python (Programming Language), SQL Databases, Diagnostic Tools, Java Application Server, Universal Database (UDB), System Availability, Concurrency, Database Optimization, Database Performance, Indexer, Physical Design - **Published:** October 18, 2026 - **Apply:** https://www.careerjet.com/jobad/us2d11abe26fa530ca34340b8b6a87d6a9 ## About the Role * 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. ## Description 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.