Jubil ID: 292

Company: City of Fresno

Location: Fresno, CA

Description:
At CVS Health
we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.As the nation's leading health solutions company
we reach millions of Americans through our local presence
digital channels and more than 300
000 purpose-driven colleagues - caring for people where
when and how they choose in

Qualifications:
5+ years' of hands on experience with Db2 z/OS administration 5+ years' experience with Db2 Administration Tools
Query Monitor
and Db2 Omegamon and in-depth knowledge of Db2 utilities such as LOAD
UNLOAD
High Speed Unload
RUNSTAT
REORG
COPY
RECOVERY and SPUFI 5+ years' experience with SQL - Intermediate to Advanced experience with zOS Db2 performance tuning 5+ years' experience with JCL and scheduling DBA jobs 5+ years' experience with 24 X 7 Oncall support rotation 3+ years Data replication design and support skillset in a complex computing environment Education:Bachelor's degree or equivalent experience

Benefits:
Pay Range The typical pay range for this role is:$92
700.00 - $222
480.00This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls The actual base salary offer will depend on a variety of factors including experience
education
geography and other relevant factors This position is eligible for a CVS Health bonus
commission or short-term incentive program in addition to the base pay range listed above We take pride in our comprehensive and competitive mix of pay and benefits - investing in the physical
emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be In addition to our competitive wages
our great benefits include: Affordable medical plan options
a 401(k) plan

Responsibilities:
Mainframe Database Administrator is 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 and IMS database administration
programming
and automation to enhance the efficiency
reliability
and scalability of database systems Implement structural changes through environments
access method analysis
application consulting Optimize Db2z and IMS resource utilization by tuning queries
recommending indexes
reorgs
Db2z and IMS 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