Senior Mainframe Db2 z/OS DBA: Performance & Automation

CVS Health; Montpelier (VT); On-site; USD 83,000 - 222,000; Full time

Benefits offered by this job

Medical, dental, vision

Paid time off

Retirement plan

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 performance improvements, implement automation, and participate in disaster recovery and on-call rotations to ensure high availability of mission-critical systems.

The ideal candidate brings deep Db2 z/OS expertise, strong SQL tuning skills, and experience with JCL, production support, and large-scale mainframe environments.

Qualifications

• 5+ years of hands-on Db2 for z/OS DBA experience including design, maintenance and production support.
• 3+ years with Db2 administration tools, Query Monitor and OMEGAMON.
• 3+ years of advanced SQL tuning, access path analysis, and index management in Db2 z/OS environments.

Responsibilities

• Administer Db2 z/OS and IDMS databases in 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 for z/OS

SQL performance tuning

JCL development

Db2 administration tools

24x7 on-call support

Education

Bachelor's degree

Tools

Query Monitor

OMEGAMON

Db2 Utilities

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 performance improvements, implement automation, and participate in disaster recovery and on-call rotations to ensure high availability of mission-critical systems.

The ideal candidate brings deep Db2 z/OS expertise, strong SQL tuning skills, and experience with JCL, production support, and large-scale mainframe environments.