Jobs → Data & Analytics → IBM Db2 LUW Database Administrator

About the Role We are looking for an experienced IBM Db2 LUW Database Administrator to join our client's team at Mphasis in Pennsylvania. This role involves administering and optimizing enterprise databases, performing advanced SQL tuning, and managing database performance. Key Responsibilities • Administer and optimize enterprise IBM Db2 LUW/UDB databases • Perform advanced SQL tuning, query-plan analysis, indexing, and statistics optimization • Manage physical database design, tablespaces, partitioning, buffer pools, and concurrency • Monitor database performance, troubleshoot production issues, and lead root-cause analysis • Manage backup/recovery, high availability, capacity planning, and database maintenance • Collaborate with Java developers, architects, infrastructure, and production-support teams Requirements • Strong hands-on experience with IBM Db2 LUW/UDB administration and performance tuning • Advanced SQL optimization, access-path analysis, and workload management • Expertise in Db2 configuration, indexing, tablespaces, partitioning, buffer pools, locking, and concurrency • Db2 monitoring and diagnostic tools such as db2pd, MON_GET, and IBM Data Studio • Production troubleshooting, backup/recovery, and high-availability support