Mainframe Database Specialist

OP; India; On-site; INR 4,000,000 - 7,000,000; Full time

Benefits offered by this job

Health Insurance

Accident Insurance

Job summary

OP is seeking a skilled Mainframe Storage Specialist to lead DB2 and IMS installations, upgrades, and maintenance within our enterprise z/OS environment. You will optimize configurations, ensure security compliance, and drive operational improvements to support disaster recovery and business continuity.

The role focuses on performance tuning, security controls, and coordinating with teams to deliver reliable storage and database services for critical applications.

Qualifications

• 12+ years of professional work experience as a Mainframe System Programmer in zOS & ISVs.

Responsibilities

• Installation & Upgrades: Installing new DB2 and IMS versions and applying maintenance.
• Configuring DB2 and IMS subsystem parameters to optimize performance.
• Utilizing DB2 and IMS tools to monitor database health and application objects.
• Implementing DB2 and IMS security controls and collaborating with DBAs to manage application access.
• Performing SOX audits on database objects to ensure compliance standards.
• Coordinating with application and system teams to implement database enhancements.
• Leading service restoration for issues related to DB2 and associated software products.
• Driving continuous improvement in operational resilience, disaster recovery, and business continuity with measurable KPIs.
• Automating tasks and processes to improve efficiency and reduce manual intervention.
• Maintaining baseline operations for DB2 test and production systems, proactively identifying and resolving issues.
• Participating in disaster recovery exercises to support enterprise system recovery and business continuity.

Skills

DB2

IMS

JCL

SMP/E

IEBGENER

IEBCOPY

TSO/ISPF

REXX/CLIST

SOX Compliance

Disaster Recovery

Education

z/OS Certification

Tools

DB2 Utilities

IMS Utilities

REXX

Job description

We are on the hunt for a skilled Mainframe Storage Specialist to lead critical DB2 and IMS installations, upgrades, and maintenance within our enterprise z/OS environment. If you excel in optimizing database configurations, ensuring security compliance, and driving continuous operational improvements, this is your opportunity to make a lasting impact. Join our team to support seamless system performance, enhance disaster recovery capabilities, and deliver innovative solutions that keep our enterprise systems resilient and efficient.

Job Responsibilities

• Installation & Upgrades: Installing new DB2 and IMS versions and applying maintenance.
• Configuring DB2 and IMS subsystem parameters to optimize performance.
• Utilizing DB2 and IMS tools to monitor database health and application objects.
• Implementing DB2 and IMS security controls and collaborating with DBAs to manage application access.
• Performing SOX audits on database objects to ensure compliance standards.
• Coordinating with application and system teams to implement database enhancements.
• Leading service restoration for issues related to DB2 and associated software products.
• Driving continuous improvement in operational resilience, disaster recovery, and business continuity with measurable KPIs.
• Automating tasks and processes to improve efficiency and reduce manual intervention.
• Maintaining baseline operations for DB2 test and production systems, proactively identifying and resolving issues.
• Participating in disaster recovery exercises to support enterprise system recovery and business continuity.

Experience Level

• 12+ years of professional work experience as a Mainframe System Programmer in zOS & ISVs.

Technical Key Skills (Mandatory Skills)

• Expertise in performing SMP/E and Non-SMPE Installation of ISV products.
• Expertise in IBM and Broadcom Software product installation and Upgrades.
• Mastery of DB2 and IMS Database management and utilities.
• DB2 V12 upgrades or later.
• IMS V15.5 upgrades or later.
• Fluent in JCL and IBM Utilities (IEBGENER/IEBCOPY/AMASPZAP/DFDSS).
• ISPF/TSO and other basics.
• Basic knowledge of REXX/CLIST.
• Designing project plan(upgrades, maintenance, decom) with task list for all stakeholders and communicating the timelines with delivery and customer.
• Formulate roadmaps with all pre-requisites to achieve a project completion.

Benefits

• Health Insurance, Accident Insurance.
• The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.

Additional Responsibilities

• Participate in OP monthly team meetings and participate in team-building efforts.
• Contribute to OP technical discussions, peer reviews, etc.
• Contribute content and collaborate via the OP-Wiki/Knowledge Base.
• Provide status reports to OP Account Management as requested.

About Us

At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we ve been challenging the status quo of the consulting industry, serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.