CVS Health
Bringing our heart to every moment of your health.
Staff Mainframe DB2 Engineer
Location
Pennsylvania
Posted
25 days ago
Salary
$118.5K - $236.9K / year
Bachelor Degree7 yrs expEnglishSQL
Job Description
• Designing, developing, and implementing automated solutions for managing and optimizing Db2z and IMS databases
• Implementing structural changes through environments, access method analysis, application consulting
• Optimize Db2z resource utilization by tuning queries, recommending indexes, reorgs, and deploying application releases
• Building automation to improve legacy processes
• Mentoring other team members
• 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
• Maintaining complex zOS Db2 databases with respect to JCL, DDL, Security and Db2 customer support
• Providing technical training and consultation to other members of the IT organization
• Supporting day to day monitoring and maintenance activities for Db2 z/OS
• Supporting Db2 Function Level and Version Db2 z/OS Migrations and RSU upgrades
• Responding to Audit requests and provide necessary documentation
• 24/7 on-call support rotation
Job Requirements
- 7+ years of hands on experience with Db2 z/OS administration
- 5+ years with Db2 Administration Tools, Query Monitor, and Db2 Omegamon
- 5+ years with SQL – Intermediate to Advanced experience with zOS Db2 performance tuning
- 5+ years with JCL and scheduling DBA jobs
- 5+ years with 24 X 7 Oncall support rotation
- 3+ years Data replication design and support skillset in a complex computing environment
- 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
Benefits
- Affordable medical plan options
- 401(k) plan (including matching company contributions)
- Employee stock purchase plan
- Wellness screenings
- Tobacco cessation programs
- Weight management programs
- Confidential counseling
- Financial coaching
- Paid time off
- Flexible work schedules
- Family leave
- Dependent care resources
- Colleague assistance programs
- Tuition assistance
- Retiree medical access
Related Guides
Related Categories
Related Job Pages
More Engineer Jobs
Engineer25 days ago
Full TimeRemoteTeam 10,001+Since 1971H1B Sponsor
Engineer supporting pharmaceutical compliance through software development and maintenance
AngularBigQueryCloudDockerGoogle Cloud PlatformJavaKafkaKubernetesMicroservicesPostgresSpringSpring BootSpringBootSQL
Engineer25 days ago
Full TimeRemoteTeam 501-1,000Since 2002H1B No Sponsor
Expert Rendering Engineer developing core rendering features for Cyberpunk 2
Unreal Engine
Engineer25 days ago
Full TimeRemoteTeam 501-1,000Since 2002H1B No Sponsor
Senior Rendering Engineer for Cyberpunk 2 with CD PROJEKT RED
Unreal Engine
Forward Deployed Engineer – Lead
VozyTransformamos el servicio al cliente del Enterprise, automatizando lo repetitivo y escalando lo critico con IA.
Engineer26 days ago
ContractRemoteTeam 51-200H1B No Sponsor
Technical Lead for a team of Forward Deployed Engineers at Vozy
United States