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

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 [email protected]