Sr. Mainframe Database Administrator

Company	CVS Health
Location	Needham, MA, USA, Scottsdale, AZ, USA, New York, NY, USA, Richardson, TX, USA, Illinois, USA
Salary	$92700 – $222480
Type	Full-Time
Degrees
Experience Level	Senior

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

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 (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 and IMS
Support Db2 Function Level and Version Db2 z/OS Migrations and RSU upgrades and IMS upgrades
Respond to Audit requests and provide necessary documentation
24/7 on-call support rotation.