Senior Mainframe DB2 Database Administrator

CVS Health; Washington (District of Columbia); On-site; USD 83,000 - 222,000; Full time

Job summary

CVS Health in the Washington, DC area is seeking a Senior Mainframe DB2 DBA to support and optimize Db2 for z/OS and IDMS in enterprise environments. You will lead performance tuning, automation initiatives, and 24x7 production support, collaborating with development, infrastructure, and operations teams.

The ideal candidate has 5+ years of Db2 for z/OS experience, strong SQL tuning, JCL skills, and experience with mainframe utilities.

Qualifications

• 5+ years of hands-on Db2 for z/OS DBA experience.
• 3+ years with Db2 Administration Tools, Query Monitor, OMEGAMON, and Db2 utilities.
• 3+ years of advanced SQL tuning, access path analysis, and index management in Db2 z/OS.
• 3+ years of JCL development and 24x7 production on-call support in large mainframe environments.
• 1+ year designing, implementing, or supporting database replication in complex enterprise environments.

Responsibilities

• Administer Db2 z/OS and IDMS databases across production and non-production environments.
• Optimize database performance through SQL tuning, index recommendations, and RUNSTATS/REORG.
• Develop automation to improve database administration processes and legacy support.
• Manage backup, recovery, replication, and disaster recovery activities.
• Support Db2 Function Level upgrades, version migrations, and database utilities.
• Respond to database requests, changes, audits, and incidents in a 24x7 on-call rotation.
• Provide technical consultation to development, infrastructure, and application teams.

Skills

Db2 for z/OS

SQL performance tuning

JCL development

On-call production support

Database replication

Education

Bachelor's degree

Tools

Db2 Administration Tools

Query Monitor

OMEGAMON

Db2 utilities

Job description

We're building a world of health around every individual - shaping a more connected, convenient and compassionate health experience. At CVS Health you'll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger - helping to simplify health care one person, one family and one community at a time.

POSITION SUMMARY

CVS Health is seeking a Senior Mainframe DB2 Database Administrator (DBA) to support, optimize, and automate enterprise Db2 for z/OS and IDMS database environments. The Senior Mainframe DB2 Database Administrator (DBA) will be responsible for database administration, performance tuning, backup and recovery, disaster recovery readiness, application release support, and database automation initiatives across critical healthcare platforms. The Senior Mainframe DB2 Database Administrator (DBA) will work closely with application development, infrastructure, and support teams to improve database performance, implement structural database changes, support Db2 upgrades and migrations, and ensure high availability of mission‑critical systems. The ideal Senior Mainframe DB2 Database Administrator (DBA) brings deep expertise in Db2 z/OS administration, SQL performance tuning, JCL, database utilities, and production support within large-scale mainframe environments. As a Senior Mainframe DB2 Database Administrator (DBA), you will play a key role in maintaining database reliability, scalability, security, and operational excellence while participating in audit support, disaster recovery activities, and a 24x7 on‑call rotation.

KEY 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.

REQUIRED 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.

PREFERRED QUALIFICATIONS

• IDMS Database Administration knowledge
• Db2 Distributed (DDF) support
• z/OS Db2 maintenance and upgrade support
• Stored procedure development/support experience
• REXX scripting experience

EDUCATION

Bachelor's degree from accredited university or equivalent work experience (HS diploma + 4 years relevant experience).

BUSINESS OVERVIEW

Bring your heart to CVS Health Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human‑centric health care for a rapidly changing world. Anchored in our brand - with heart at its center - our purpose sends a personal message that how we deliver our services is just as important as what we deliver. Our Heart At Work Behaviors support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable. We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an affirmative action employer, and is an equal opportunity employer, as are the physician‑owned businesses for which CVS Health provides management services. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities.

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is:

$83,430.00 - $222,480.00

This pay range represents the base hourly rate or base annual full‑time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors.

This position is eligible for a CVS Health bonus, commission or short‑term incentive program in addition to the base pay range listed above.

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.

Great benefits for great people

We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families.

This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families. The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility.

Additional details about available benefits are provided during the application process and on Benefits Moments.

We anticipate the application window for this opening will close on: 09/30/2026

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.