Bringing our heart to every moment of your health.

Senior Mainframe DB2 Database Administrator

Database AdministratorDatabase AdministratorFull TimeRemoteTeam 10,001+Since 1963H1B No SponsorCompany Site LinkedIn

Location

Connecticut + 4 more

Posted

46 days ago

Salary

$83.4K - $222.5K / year

Bachelor Degree5 yrs expExperience acceptedEnglishSQL

Job Description

• Designing, developing, and implementing automated solutions for managing and optimizing Db2z and IMS databases • Implementing structural changes through environments and access method analysis • Optimizing Db2z resource utilization by tuning queries and recommending indexes • 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 • Responding to Audit requests and providing necessary documentation

Job Requirements

5+ years of hands-on experience with Db2 z/OS administration
3+ years with Db2 Administration Tools, Query Monitor, and Db2 Omegamon
3+ years with SQL – Intermediate to Advanced experience with zOS Db2 performance tuning
3+ years with JCL and scheduling DBA jobs
3+ years with 24 X 7 Oncall support rotation
At least 1 year of data replication design and support skillset in a complex computing environment

Benefits

Affordable medical plan options
401(k) plan (including matching company contributions)
Employee stock purchase plan
No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching
Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility