Note: The job is a remote job and is open to candidates in USA. CVS Health is a healthcare company focused on creating a more connected, convenient, and compassionate health experience. The Senior Mainframe DB2 Database Administrator will administer, optimize, automate, and support enterprise Db2 for z/OS and IDMS database environments, including performance tuning, backup and recovery, disaster recovery, upgrades, migrations, and production support.
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
- 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
- Bachelor's degree from accredited university or equivalent work experience (HS diploma + 4 years relevant experience)
- IDMS Database Administration knowledge
- Db2 Distributed (DDF) support
- Z/OS Db2 maintenance and upgrade support
- Stored procedure development/support experience
- REXX scripting experience
Benefits
- CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.
- Medical, dental, and vision coverage
- Paid time off
- Retirement savings options
- Wellness programs
- Other resources, based on eligibility
Company Overview
Company H1B Sponsorship