Mainframe z/OS DB2 Database Administrator (DBA) – Level 3 - 26-03396

NavitasPartners•Albany, NY

1d•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

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.