CVS Health

Bringing our heart to every moment of your health.

Staff Mainframe DB2 Engineer

EngineerEngineerFull TimeRemoteTeam 10,001+Since 1963H1B No SponsorCompany SiteLinkedIn

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 Categories

Related Job Pages

More Engineer Jobs

Full TimeRemoteTeam 10,001+Since 1971H1B Sponsor

Engineer supporting pharmaceutical compliance through software development and maintenance

AngularBigQueryCloudDockerGoogle Cloud PlatformJavaKafkaKubernetesMicroservicesPostgresSpringSpring BootSpringBootSQL
Ohio
$93.5K - $135.6K / year
Full TimeRemoteTeam 501-1,000Since 2002H1B No Sponsor

Expert Rendering Engineer developing core rendering features for Cyberpunk 2

Unreal Engine
Massachusetts
$168.2K - $257K / year
Full TimeRemoteTeam 501-1,000Since 2002H1B No Sponsor

Senior Rendering Engineer for Cyberpunk 2 with CD PROJEKT RED

Unreal Engine
Massachusetts
$118.8K - $198K / year

Forward Deployed Engineer – Lead

Vozy

Transformamos 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