Mainframe support -DBA

Cloudxtreme; Hyderabad, Bengaluru, Delhi; On-site; INR 2,800,000 - 4,200,000; Full time

Job summary

Cloudxtreme is seeking an experienced Mainframe DBA to manage DB2 for z/OS and related databases. You will participate in 24x7 production support, ensure high availability, and drive performance tuning across on-prem and cloud environments.

The role requires 7+ years of hands-on DBA experience with mainframe databases, strong scripting skills, and expertise in HA/DR strategies, security, and patching. Collaboration with application and infrastructure teams is essential.

Qualifications

• Bachelor's degree in Computer Science, IT, or related field.
• 7+ years hands-on DBA experience with Mainframe databases (e.g., DB2 for z/OS, IMS, VSAM, IDMS).
• Deep knowledge of maintenance DB architecture, scaling, distribution, partitioning, and throughput management.
• Strong scripting and database troubleshooting skills.
• Proactive in optimizing performance—tuning queries, indexes, and configurations.

Responsibilities

• Provide 24x7 production support for Mainframe databases with rotation and on-call duties.
• Administer, monitor, and maintain Mainframe databases in production and non-production environments.
• Implement backup, recovery, tuning, HA and DR strategies.
• Perform health checks, identify bottlenecks, and optimize queries and configs.
• Automate routine operations and reporting using Mainframe utilities, scripting, or job scheduling tools (JCL, REXX, Python, Shell).
• Manage database security, user permissions, and compliance with policies.
• Coordinate database patching, upgrades, migrations with minimal downtime.
• Collaborate with app and infra teams to support deployments and resolve issues.
• Monitor and resolve incidents including root cause analysis and documented resolutions.
• Automate routine operational tasks using scripts or management tools.
• Maintain documentation of procedures, configurations, and support processes.

Skills

Mainframe DBA

DB2 for z/OS

JCL

REXX

Python

Shell scripting

Azure

GCP

Automation tools

Terraform

Ansible

Security & compliance

Performance tuning

Education

Bachelor's degree in Computer Science/IT

Tools

Dynatrace

Azure Monitor

Nagios

PowerShell

Ansible

Terraform

Job description

Role & responsibilities

Key Responsibilities -

• Provide 24x7 production support for Mainframe databases (such as DB2 for z/OS, IMS, VSAM, or IDMS). by participating in rotational shifts and on-call duties.
• Administer, monitor, and maintain Mainframe databases in production and non-production environments.
• Implement and manage backup, recovery, tuning, high availability and DR (Disaster Recovery) strategies.
• Perform routine health checks, proactively identify performance bottlenecks, and optimize queries and database configurations.
• Automate routine operations and reporting using Mainframe utilities, scripting languages, or job scheduling tools (JCL, REXX, Python, Shell, etc.).
• Manage database security, user permissions, and compliance with organizational policies.
• Coordinate and execute database patching, upgrades, and migrations with minimal downtime.
• Collaborate with application and infrastructure teams to support deployment activities and resolve database-related issues.
• Monitor and resolve incidents, including root cause analysis and documentation of resolutions.
• Automate routine operational tasks using scripts or management tools.
• Maintain accurate documentation of database procedures, configurations, and support processes for internal knowledge sharing.

Required Skills and Experience

• Bachelors degree in Computer Science, Information Technology, or related field.
• 7+ years of hands‑on experience as a DBA managing Mainframe database environments(e.g., IBM DB2 for z/OS, IMS, VSAM, IDMS. etc)
• In‑depth knowledge of Maintenance DB architecture, scaling, global distribution, partitioning, consistency models, and throughput management.
• Strong scripting and database troubleshooting skills.
• Proactively analyze and optimize database performance—tuning queries, indexes, and configurations.
• Enforce security best practices, including authentication, access control, data encryption, and compliance monitoring
• Proficiency with Mainframe utilities, JCL, scripting (REXX, Python, or other), and automation tools.
• Support cloud database deployments, migrations, and upgrades within Azure and GCP environments,
• Automate and optimize routine operational tasks using scripting (Python, shell scripting, IaC etc) and Azure automation tools.
• Deep knowledge of high availability (HA), replication, backup/recovery, and failover strategies for Mainframe.
• Experience with database monitoring tools - Dynatrace, Azure Monitor, Nagios etc and automation frameworks such as Ansible and Terraform .
• Solid understanding of database security best practices.
• Proven experience with patching, upgrading, and migrating databases.
• Ability to manage multiple priorities in a fast‑paced operations setting.
• Ability to support DB audit requirements and license management.
• Excellent communication and documentation skills.

Preferred Qualifications

• Certifications in Mainframe DBA
• Experience supporting modernization or migration projects (Mainframe to distributed/cloud platforms).
• Exposure to cloud‑based database services (Azure, GCP etc).
• Experience with automation tools (e.g., PowerShell, Ansible, Terraform, Shell scripting).
• Exposure to additional Mainframe technologies (IMS, CICS, VSAM, etc.)."