Job Description
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.
Role Description
- 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.
- 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
- Qualifications
- 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
- Requirements
- 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
- Education
- Bachelor’s degree or equivalent experience (High School Diploma and 4 years relevant experience)
- Benefits
- 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
- 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
Apply tot his job
Apply To this Job