Senior Mainframe DB2 DBA — Performance & Automation Lead

CVS Health; Atlanta (GA); On-site; USD 83,000 - 222,000; Full time

Job summary

CVS Health is seeking a Senior Mainframe DB2 Database Administrator (DBA) to support, optimize, and automate Db2 for z/OS and IDMS environments. The role focuses on database administration, performance tuning, backup/recovery, DR readiness, and automation initiatives across critical healthcare platforms.

The ideal candidate brings deep Db2 z/OS expertise, SQL tuning skills, JCL experience, and production support capabilities to ensure high availability of mission-critical systems in a large

Qualifications

• 5+ years hands-on Db2 for z/OS DBA experience including design, maintenance, performance tuning, backup/recovery and production support.
• 3+ years of Db2 Administration Tools experience (Query Monitor, OMEGAMON, Db2 utilities such as LOAD/UNLOAD/REORG).
• 3+ years advanced SQL performance tuning, access path analysis, and index management in Db2 z/OS environments.
• 3+ years JCL development, DBA job scheduling, and 24x7 production on-call support in large-scale mainframe environments.
• 1+ year designing, implementing or supporting database replication solutions in enterprise environments.

Responsibilities

• Administer and support enterprise Db2 z/OS and IDMS databases across production and non-production environments, including migrations.
• Optimize database performance through SQL tuning, access path analysis, index recommendations, RUNSTATS, REORG, and resource analysis.
• Develop and implement automation to improve database administration processes and legacy support activities.
• Manage backup, recovery, replication, and disaster recovery processes with DR testing and documentation.
• Support Db2 Function Level upgrades, migrations, RSU maintenance and utility execution.
• Respond to support requests, change requests, and incidents while on 24x7 on-call rotation.
• Provide technical consultation and knowledge transfer to development, infrastructure, and application teams.

Skills

Db2 for z/OS

SQL performance tuning

JCL

DB2 utilities

On-call rotation

Education

Bachelor's degree

Tools

DB2 Administration Tools

Query Monitor

OMEGAMON

LOAD/UNLOAD/REORG

IDMS

Job description

CVS Health is seeking a Senior Mainframe DB2 Database Administrator (DBA) to support, optimize, and automate Db2 for z/OS and IDMS environments. The role focuses on database administration, performance tuning, backup/recovery, DR readiness, and automation initiatives across critical healthcare platforms.

The ideal candidate brings deep Db2 z/OS expertise, SQL tuning skills, JCL experience, and production support capabilities to ensure high availability of mission-critical systems in a large