21 Sep
|
h3 Technologies
|
Gurugram
21 Sep
h3 Technologies
Gurugram
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 strong 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 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 (Gurugram)
🏢 h3 Technologies
📍 Gurugram