Job Title: Mainframe DBA Location: Bangalore / Gurgaon Experience: 5–9 Years Budget: 25–26 LPA : 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 settings. The role involves database design, optimization, break-fix support, security administration, automation, and implementation of current 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 Saharanpur (India)
🏢 h3-Technologies
📍 India