Job Title: Mainframe DBA

Location: Bangalore / Gurgaon

Experience: 5–9 Years

Budget: 25–26 LPA

Job Description:

We are looking for an experienced Mainframe DBA with solid expertise in DB2 z/OS and IMS to support mission-critical databases across development, testing, pre-production, and production data-sharing environments. The role involves database design, optimization, break-fix support, security administration, automation, and implementation of new database features.

Key Responsibilities:

- Design, administer, optimize, and support DB2 z/OS v12 and IMS v15 databases.
- Work with IMS FF/FP databases and DB2 z/OS data-sharing environments.
- Convert logical database models into physical database designs.
- Perform access path re-engineering and optimization for large-scale databases.
- Administer database security in accordance with zDBMS standards.
- Perform backups, reorganizations, database analysis, and troubleshooting.
- Diagnose and resolve database errors and performance issues.
- Use BMC Admin tools, including Change Manager, for database administration.
- Work with IBM Data Studio, IBM utilities, and BMC utilities for DB2 and IMS.




- Support database feature implementations, automation, and break-fix activities.
- Drive/support application migration initiatives from z/OS to PostgreSQL.
- Support conversion of VSAM tablespaces to Universal Table Spaces (UTS) in preparation for DB2 z/OS v13 and large-scale database growth.
- Support mission-critical applications and large database environments.
- Collaborate with application, infrastructure, and development teams.
- Mentor junior DBAs and provide technical guidance.

Required Skills:

- DB2 z/OS
- IMS / IMS DB
- IMS FF/FP
- Mainframe Database Administration
- Database Design & Modeling
- Access Path Optimization
- DB2 Performance Tuning
- DB Security Administration
- Backup & Recovery
- Reorg & Database Utilities
- BMC Admin Toolset / Change Manager
- IBM Data Studio
- IBM/BMC DB2 & IMS Utilities
- VSAM / Universal Table Spaces
- PostgreSQL migration exposure

Preferred Qualification:

- Bachelor's degree in Computer Science, Information Management, or a related field.

📌 Mainframe DBA (Gurugram)
🏢 h3 Technologies
📍 Gurugram