Senior Mainframe DB2 Database Administrator

CVS Health

8d

About The Position

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 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. Expectations For The Role: 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

Nice To Haves

• 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

Responsibilities

• 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

Benefits

• 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 programs, confidential counseling and financial coaching.
• Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 5,001-10,000 employees