Sr. Mainframe Database Administrator

At CVS Health, we’re building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.

As the nation’s leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues – caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.

Position Summary:

The Sr. Mainframe Database Administrator is responsible for designing, developing, and implementing automated solutions for managing and optimizing Db2z and IMS databases within an organization. This role requires a strong knowledge of Db2z and IMS database administration, programming, and automation to enhance the efficiency, reliability, and scalability of database systems.

 Key Responsibilities:

• Implement structural changes through environments, access method analysis, application consulting
• Optimize Db2z and IMS resource utilization by tuning queries, recommending indexes, reorgs, Db2z and IMS support and deploy application releases.
• Building automation to improve legacy processes
• Processing Database Support Requests and Change requests in production and non-production environments
• Building and implementing database backup and recovery strategies
• Preparing disaster recovery (DR) documentation and participating in DR activities
• Maintains complex zOS Db2 databases with respect to JCL, DDL, Security and Db2 customer support.
• Provide technical training and consultation to other members of the IT organization.
• Support day to day monitoring and maintenance activities for Db2 z/OS and IMS
• Support Db2 Function Level and Version Db2 z/OS Migrations and RSU upgrades and IMS upgrades
• Respond to Audit requests and provide necessary documentation
• 24/7 on-call support rotation.

Required Qualifications:

• 5+ years’ of hands on experience with Db2 z/OS administration
• 5+ years’ experience with Db2 Administration Tools, Query Monitor, and Db2 Omegamon and in-depth knowledge of Db2 utilities such as LOAD, UNLOAD, High Speed Unload, RUNSTAT, REORG, COPY, RECOVERY and SPUFI.
• 5+ years’ experience with SQL – Intermediate to Advanced experience with zOS Db2 performance tuning
• 5+ years’ experience with JCL and scheduling DBA jobs
• 5+ years’ experience with 24 X 7 Oncall support rotation
• 3+ years Data replication design and support skillset in a complex computing environment

Preferred Qualifications:

• Service Now knowledge
• Db2 Distributed support knowledge
• zOS Db2 maintenance/upgrade support
• IMS database administrator knowledge
• Experience with stored procedures
• REXX scripting experience
• Tivoli Data Warehouse extract/offload process and reporting
• Strong Experience with zOS large system in Data Sharing Sysplex environment
• Strong Communication skills

Education:

Bachelor’s degree or equivalent experience (High School Diploma and 4 years relevant experience)

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is:

$92,700.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 our comprehensive and competitive mix of pay and benefits – investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.

• No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management progr