Mainframe z/OS DB2 Database Administrator (DBA) - Level 3 - 26-03396 Job at NavitsPartners, Saratoga Springs, NY

L1FVUjBYYVdubGNtTWVaQXJ0bnY0eEhSR0E9PQ==
  • NavitsPartners
  • Saratoga Springs, NY

Job Description

Job Title: Mainframe z/OS DB2 Database Administrator (DBA) – Level 3

Location: Albany, NY (Onsite for the first week, then remote)

Duration: 12 Months

Job Summary:

We are seeking an experienced Mainframe DB2 Database Administrator (DBA) to support and manage DB2 environments on the z/OS platform. The ideal candidate will have strong expertise in database administration, performance tuning, and mainframe utilities, along with the ability to support mission-critical production systems.

Key Responsibilities:

  • Perform all aspects of DB2 database administration on z/OS platforms.
  • Manage database performance, tuning, and capacity planning.
  • Execute and manage DB2 utilities (Reorg, Runstats, Copy, Load, Unload, Modify, Check, Recover, Rebuild).
  • Develop, modify, and maintain JCL for database operations.
  • Execute DB2 commands (Start, Stop, Display, Cancel, etc.).
  • Design and implement database changes, including DDL execution and schema modifications.
  • Review logical database designs and convert them into efficient physical designs.
  • Manage database backup and recovery processes.
  • Troubleshoot incidents, resolve problems, and document solutions.
  • Implement database security using RACF (grants, revokes, roles, privileges).
  • Follow established processes for change, incident, problem, availability, and capacity management.
  • Provide rotational 24x7 on-call support for production environments.

Required Qualifications:

  • Minimum 5 years of experience with DB2 on z/OS (including version 11/12 experience)
  • Minimum 5 years of experience with z/OS, JCL, TSO/ISPF, and DB2 utilities
  • Strong experience executing DDL and managing database structures
  • Proven experience in performance tuning and capacity management
  • Hands-on experience with DB2 backup and recovery processes
  • Experience in database monitoring, maintenance, and administration
  • Strong problem-solving and troubleshooting skills
  • Fluent in English
  • High School Diploma or GED

Preferred Qualifications:

  • 7+ years of experience with DB2 z/OS (including v11/v12)
  • 7+ years of experience with z/OS, JCL, TSO/ISPF, and DB2 utilities
  • Advanced experience in DDL execution and database design
  • Extensive experience in performance and capacity management
  • Bachelor’s degree in Computer Science or a related field

For more details reach at resumes@navitassols.com

Job Tags

Remote work

Similar Jobs

BJC Healthcare

Cardiac Cath Lab Registered Nurse Job at BJC Healthcare

 ...Sign-On Bonus Eligible ~ Benefits Start 1st of Month After Hire The BJC RN Career Ladder differentiates BJC as the place for nurses to work in the greater St. Louis area. This is a tool to empower nurses to work at the top of their license and own their career... 

Broken Rocks Cafe and Rox Gastropub

Dishwasher Job at Broken Rocks Cafe and Rox Gastropub

 ...water of machines and sinks every two hours, or more often as required by business levels, and properly uses chemical dilutions set by EcoLab. Assists in the timely storing of food deliveries. Maintains trash cans throughout shift and removes full trashcans and boxes... 

ITS Integrated Therapy Solutions

Speech Language Pathologist Assistant (SLPA) Job at ITS Integrated Therapy Solutions

 ...performance. Say goodbye to a fixed salary and the traditional "one-size-fits-all" model and unleash your potential with ITS! As an SLPA, you'll have the exciting opportunity to work with a diverse group of children, ranging from birth to 21 years of age, tailoring... 

WRDW/WAGT News 12 26

Associate Producer Job at WRDW/WAGT News 12 26

 ...Nexstar Media Inc. has an immediate opening for an Associate Producer who wants to support newscast production for the formed duopoly in the Washington, DC DMA (Market #8). The Associate Producer will work closely with Producers, Directors and Anchors to stack, write... 

Confidential

Cherry-Picker and Stand-up High Reach Forklift Job at Confidential

 ...Cherry-Picker and Stand-up High Reach Forklift Elwood Staffing is currently hiring for an experienced stand-up high-reach and cherry picker operator. What's in it for you? Elwood Staffing associates are eligible for a comprehensive and competitive benefits package...