Senior Mainframe DB2 DBA: On-Call, DR Ready, Performance

CVS Health; Trenton (NJ); On-site; USD 83,000 - 222,000; Full time

Benefits offered by this job

Medical benefits

Dental coverage

Vision coverage

Paid time off

Retirement savings

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 lead database performance tuning, backup and recovery, and 24x7 on‑call support across mission-critical systems.

Join a team dedicated to reliability, security, and scalable solutions, with opportunities to implement automation, upgrades, and audits while collaborating with development, infrastructure, and production teams.

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 and support enterprise Db2 z/OS and IDMS databases across production and non‑production environments, including structural changes, application releases, and database migrations.
• Optimize database performance through SQL tuning, access path analysis, index recommendations, RUNSTATS, REORG, and resource utilization analysis.
• Develop and implement automation solutions to improve database administration processes, operational efficiency, and legacy support activities.
• Manage database backup, recovery, replication, and disaster recovery processes, including DR documentation and testing activities.
• Support Db2 Function Level upgrades, version migrations, RSU maintenance, and database utility execution.
• Respond to database support requests, change requests, audit inquiries, and production incidents while participating in a 24x7 on‑call rotation.
• Provide technical consultation, knowledge transfer, and support to development, infrastructure, and application teams.

Skills

Db2 z/OS

SQL tuning

JCL

24x7 on-call

Automation

Education

Bachelor’s degree

Tools

OMEGAMON

LOAD

UNLOAD

RUNSTATS

REORG

COPY

RECOVER

SPUFI

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 lead database performance tuning, backup and recovery, and 24x7 on‑call support across mission-critical systems.

Join a team dedicated to reliability, security, and scalable solutions, with opportunities to implement automation, upgrades, and audits while collaborating with development, infrastructure, and production teams.