Senior Mainframe DB2 Database Administrator
NaSPA, Inc., Salt Lake City, UT, United States
POSITION SUMMARY
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 to simplify health care one person, one family, and one community at a time.
Responsibilities
Implement structural changes through environments, access method analysis, and application consulting.
Optimize Db2z resource utilization by tuning queries, recommending indexes, reorgs, providing Db2z support, and deploying application releases.
Build automation to improve legacy processes.
Process database support requests and change requests in production and non-production environments.
Create and implement database backup and recovery strategies.
Prepare disaster recovery documentation and participate in DR activities.
Maintain complex z/OS 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 migrations and RSU upgrades.
Respond to audit requests and provide necessary documentation.
Participate in 24/7 on‑call support rotation.
Required 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 z/OS Db2 performance tuning.
3+ years with JCL and scheduling DBA jobs.
3+ years with 24×7 on‑call support rotation.
At least 1 year of data replication design and support skillset in a complex computing environment.
Preferred Qualifications
Strong experience with z/OS large system in Data Sharing Sysplex environment.
Strong communication skills.
ServiceNow knowledge.
Db2 Distributed support knowledge.
z/OS 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 of relevant experience).
Employment Information
Anticipated weekly hours: 40.
Time type: Full time.
Pay range: $83,430.00 – $222,480.00 (base hourly rate or base annual full‑time salary; actual offer will depend on experience, education, geography, and other factors).
Benefits
Comprehensive benefits package includes medical, dental, and vision coverage; paid time off; retirement savings options; wellness programs; and other resources, based on eligibility.
Equal Opportunity Employer
CVS Health is an affirmative action employer and an equal‑opportunity employer. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law. We encourage and support people with military experience, active, veterans, reservists, and National Guard members, and military spouses, to apply for opportunities.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws.
#J-18808-Ljbffr
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 to simplify health care one person, one family, and one community at a time.
Responsibilities
Implement structural changes through environments, access method analysis, and application consulting.
Optimize Db2z resource utilization by tuning queries, recommending indexes, reorgs, providing Db2z support, and deploying application releases.
Build automation to improve legacy processes.
Process database support requests and change requests in production and non-production environments.
Create and implement database backup and recovery strategies.
Prepare disaster recovery documentation and participate in DR activities.
Maintain complex z/OS 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 migrations and RSU upgrades.
Respond to audit requests and provide necessary documentation.
Participate in 24/7 on‑call support rotation.
Required 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 z/OS Db2 performance tuning.
3+ years with JCL and scheduling DBA jobs.
3+ years with 24×7 on‑call support rotation.
At least 1 year of data replication design and support skillset in a complex computing environment.
Preferred Qualifications
Strong experience with z/OS large system in Data Sharing Sysplex environment.
Strong communication skills.
ServiceNow knowledge.
Db2 Distributed support knowledge.
z/OS 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 of relevant experience).
Employment Information
Anticipated weekly hours: 40.
Time type: Full time.
Pay range: $83,430.00 – $222,480.00 (base hourly rate or base annual full‑time salary; actual offer will depend on experience, education, geography, and other factors).
Benefits
Comprehensive benefits package includes medical, dental, and vision coverage; paid time off; retirement savings options; wellness programs; and other resources, based on eligibility.
Equal Opportunity Employer
CVS Health is an affirmative action employer and an equal‑opportunity employer. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law. We encourage and support people with military experience, active, veterans, reservists, and National Guard members, and military spouses, to apply for opportunities.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws.
#J-18808-Ljbffr