Senior Mainframe DB2 DBA – On‑Call & Automation Lead

CVS Health; Jackson (MS); On-site; USD 83,000 - 222,000; Full time

Benefits offered by this job

Medical insurance

Dental coverage

Vision coverage

Paid time off

Retirement plan

Wellness programs

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 databases. You will lead performance tuning, backup/recovery, disaster recovery readiness, and automation initiatives across critical healthcare platforms.

The role collaborates with development, infrastructure, and support teams to ensure high availability and scalable operations, including upgrades and migrations.

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 Administration

SQL Performance Tuning

JCL & Utilities

Production Support

DR/BCP & Disaster Recovery

Education

Bachelor's degree

Tools

Db2 Administration Tools

Query Monitor

OMEGAMON

Db2 Utilities (LOAD/UNLOAD/REORG)

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 databases. You will lead performance tuning, backup/recovery, disaster recovery readiness, and automation initiatives across critical healthcare platforms.

The role collaborates with development, infrastructure, and support teams to ensure high availability and scalable operations, including upgrades and migrations.