Mainframe DBA

h3 Technologies, LLC; Gurugram District; On-site; INR 2,500,000 - 2,600,000; Full time

Job summary

h3 Technologies, LLC in India is looking for an experienced Mainframe DBA to support DB2 z/OS and IMS databases across development, testing, pre-production, and production data-sharing environments.

The role involves database design, optimization, break-fix, security administration, automation, and migration initiatives from z/OS to PostgreSQL, with mentoring of junior DBAs and collaboration with application and infra teams.

Qualifications

• 5–9 years of experience in Mainframe DB administration.
• Strong expertise in DB2 z/OS and IMS.
• Experience with z/OS data-sharing environments and VSAM/UTS.
• Proven database security administration and performance tuning.

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 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.

Education

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

Tools

BMC Admin Toolset / Change Manager

IBM Data Studio

IBM/ BMC DB2 & IMS Utilities

Job description

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 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.