This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
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. CVS Health is currently seeking a Senior Mainframe DB2 Database Administrator who will be 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 database administration, programming, and automation to enhance the efficiency, reliability, and scalability of database systems.
Job Responsibility:
Implementing structural changes through environments, access method analysis, application consulting
Optimize Db2z resource utilization by tuning queries, recommending indexes, reorgs, Db2z 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
Support Db2 Function Level and Version Db2 z/OS Migrations and RSU upgrades
Respond to Audit requests and provide necessary documentation
24/7 on-call support rotation
Requirements:
5+ years of hands on experience with Db2 z/OS administration
3+ years with Db2 Administration Tools, Query Monitor, and Db2 Omegamon and in-depth knowledge of Db2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, RECOVERY and SPUFI.
3+ years with SQL – Intermediate to Advanced experience with zOS Db2 performance tuning
3+ years with JCL and scheduling DBA jobs
3+ years with 24 X 7 Oncall support rotation
At least 1 year of data replication design and support skillset in a complex computing environment
Bachelor’s degree or equivalent experience (High School Diploma and 4 years relevant experience)
Nice to have:
Strong Experience with zOS large system in Data Sharing Sysplex environment
Strong Communication skills
Service Now knowledge
Db2 Distributed support knowledge
zOS Db2 maintenance/upgrade support
Experience with stored procedures
REXX scripting experience
Tivoli Data Warehouse extract/offload process and reporting
What we offer:
Affordable medical plan options
401(k) plan (including matching company contributions)
employee stock purchase plan
No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching