Senior Mainframe DB2 DBA – z/OS, Performance & Automation

CVS Health; Sacramento (CA); 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 enterprise Db2 for z/OS and IDMS environments. You will drive database performance, reliability and automation while collaborating with development and operations teams.

The role requires deep Db2 z/OS expertise, strong SQL tuning, and experience with JCL and production support in large mainframe settings.

Qualifications

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

Responsibilities

• Administer Db2 z/OS and IDMS databases in prod and non-prod; handle structural changes and migrations.
• Tune SQL, analyze access paths, optimize indexes, RUNSTATS/REORG, monitor resources.
• Develop automation to improve DBA processes and legacy support.
• Manage backup, recovery, replication, and DR plans with documentation and testing.
• Support Db2 function level upgrades, migrations, RSU maintenance, and utilities.
• Respond to support/change/audit requests and incidents; participate in 24x7 on-call.
• Provide guidance and knowledge transfer to cross-functional teams.

Skills

Db2 z/OS

SQL performance tuning

JCL

DB2 utilities

Production support

Replication

Education

Bachelor's degree

Tools

Db2 utilities

Query Monitor

OMEGAMON

Job description

CVS Health is seeking a Senior Mainframe DB2 Database Administrator (DBA) to support, optimize, and automate enterprise Db2 for z/OS and IDMS environments. You will drive database performance, reliability and automation while collaborating with development and operations teams.

The role requires deep Db2 z/OS expertise, strong SQL tuning, and experience with JCL and production support in large mainframe settings.