Senior Mainframe DB2 Database Administrator

Job not on LinkedIn

🔥 0 minutes ago

🦌 Connecticut, Montana, +3 more states – Remote

🦌 Connecticut – Remote 🦬 Montana – Remote 🌲 North Carolina – Remote 🎸 Mississippi – Remote 🔔 Pennsylvania – Remote

💵 $83.4k - $222.5k / year

⏰ Full Time

🟠 Senior

📀 Database Administrator

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CVS Health

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1963

🏥 Healthcare

⚕️ Healthcare Insurance

🛒 Retail

Healthcare • Healthcare Insurance • Retail

CVS Health is a leading American healthcare company dedicated to improving health access and affordability. The company focuses on a comprehensive approach that includes health services, health insurance, and pharmacy benefits management. Through its subsidiaries, such as Aetna and CVS Caremark, CVS Health offers a range of services that facilitate wellness, condition management, and affordable prescription drug coverage. CVS Health operates neighborhood pharmacies, provides mail-order pharmacy services, and manages specialty medication programs, aiming to make healthcare convenient and accessible for everyone. Driven by a mission to connect people with essential care services, CVS Health is committed to fostering healthier communities and supporting the wellbeing of all individuals.

📋 Description

• Administer and support enterprise Db2 z/OS and IDMS databases across production and non-production environments • Handle 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 for database administration processes, operational efficiency, and legacy support activities • Manage database backup, recovery, replication, and disaster recovery processes • Create disaster recovery documentation and conduct 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 • Participate in a 24x7 on-call rotation • Provide technical consultation, knowledge transfer, and support to development, infrastructure, and application teams

🎯 Requirements

• 5+ years of hands-on experience as a Db2 for z/OS Database Administrator • Experience with 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 as an alternative to the bachelor’s degree • Preferred: IDMS Database Administration knowledge • Preferred: Db2 Distributed (DDF) support • Preferred: z/OS Db2 maintenance and upgrade support • Preferred: Stored procedure development/support experience • Preferred: REXX scripting experience • Ability to participate in a 24x7 on-call rotation • Qualified applicants with arrest or conviction records will be considered in accordance with federal, state, and local laws

🏖️ Benefits

• CVS Health bonus, commission or short-term incentive program in addition to the base pay range • Medical coverage • Dental coverage • Vision coverage • Paid time off • Retirement savings options • Wellness programs • Other resources supporting the physical, emotional, and financial well-being of colleagues and their families, based on eligibility • Supportive culture of diversity, inclusion and belonging • Recognition programs • Opportunities to collaborate and make a difference • Support for people with military experience and military spouses