System Administrator DB2 For zOS

People Prime Worldwide; Bengaluru; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

People Prime Worldwide is seeking a skilled System Administrator (DB2 for z/OS) to manage enterprise DB2 subsystems on z/OS. The role focuses on installation, configuration, data sharing, and performance tuning, with emphasis on DR planning and high availability.

You will engage with cross-functional teams to ensure secure, compliant, and reliable database operations across complex environments. You will lead upgrades, migrations, and maintenance activities, support during major incidents, and

Qualifications

• Strong DB2 for z/OS admin capabilities including installation, configuration and SMP/E maintenance.
• Experience with data sharing, RT/backup, and performance tuning.
• Ability to perform disaster recovery planning and SMF/RMF analysis.
• Familiarity with change and release management in enterprise environments.

Responsibilities

• Install, configure, maintain, and upgrade DB2 subsystems on z/OS.
• Plan migrations, upgrades, and maintenance activities.
• Configure and manage DB2 data sharing environments.
• Ensure availability, resiliency, and recovery of DB2 infrastructure.
• Tune DB2 performance and optimize resources.
• Support during incidents and performance issues.
• Define standards for utilities, backup, and capacity planning.
• Perform database utilities such as REORG, RUNSTATS, COPY, RECOVER.
• Integrate DB2 with z/OS, CICS, IMS, MQ, RACF and storage platforms.
• Participate in change, release and vulnerability management.

Skills

DB2 for z/OS

Data sharing

Performance tuning

DR planning

SMF/RMF analysis

Change management

Problem determination

Windows Server 2016/2019

VMware ESX

Cloud migration

Automation basics

DevOps fundamentals

Education

IBM Certified Database Administrator – Db2 for z/OS

Tools

IBM Db2 Tools

OMEGAMON

BMC MainView

CA Database Management solutions

REXX

CLIST

Ansible

z/OSMF

Job description

Job Description

Position: System Administrator DB2 for z/OS

As a System Administrator, you will solve complex problems and identify potential future issues across a wide range of platforms and services. You will work with large enterprise clients, managing systems, providing day-to-day solutions, ensuring security compliance, and supporting technology modernization.

You will manage a queue of assignments, work closely with technical teams, prioritize incidents and requests, and deliver effective solutions to meet client requirements.

Key Responsibilities

• Install, configure, maintain, and upgrade DB2 subsystems on z/OS.
• Plan and execute DB2 version migrations, upgrades, and maintenance activities.
• Configure and manage DB2 data sharing environments.
• Manage DB2 infrastructure availability, resiliency, and disaster recovery.
• Perform DB2 performance tuning and optimize subsystem performance and resource consumption.
• Support application teams during major incidents, performance issues, and problem determination.
• Define and maintain standards for DB2 utilities, backup, recovery, and capacity planning.
• Perform database utilities activities including REORG, RUNSTATS, COPY, and RECOVER.
• Integrate DB2 with z/OS, CICS, IMS, MQ, RACF, and enterprise storage platforms.
• Perform SMF/RMF analysis and troubleshoot DB2 and z/OS-related issues.
• Participate in change and release management processes within enterprise environments.
• Support vulnerability management and security compliance activities.
• Collaborate with technical teams, application teams, stakeholders, and clients to deliver reliable solutions.
• Identify modernization opportunities and recommend improvements to existing infrastructure and processes.
• Support high-availability, disaster recovery, and mission-critical enterprise environments.

Required Technical and Professional Expertise

• Strong experience in DB2 for z/OS Administration, including installation, configuration, data sharing, and SMP/E maintenance.
• Strong expertise in DB2 performance tuning, buffer pool optimization, SQL diagnostics, and database utilities such as REORG, RUNSTATS, COPY, and RECOVER.
• Experience with disaster recovery planning, z/OS internals, SMF/RMF analysis, and problem determination.
• Knowledge of enterprise change and release management processes.
• Experience with Microsoft Windows Server 2016/2019.
• Experience with VMware ESX.
• Experience with public/private cloud management and cloud migration activities.
• Strong analytical and troubleshooting skills.
• Strong documentation and stakeholder management skills.
• Experience working in mission-critical enterprise environments.

Preferred Technical and Professional Experience

• IBM Certified Database Administrator – Db2 for z/OS certification.
• Experience with IBM Db2 Tools, OMEGAMON, BMC MainView, or CA Database Management solutions.
• Knowledge of automation tools such as REXX, CLIST, and Ansible.
• Knowledge of Infrastructure as Code (IaC).
• Familiarity with DevOps and CI/CD practices.
• Experience with z/OSMF and IBM Z technologies.
• Knowledge of Parallel Sysplex, GDPS, and high-availability solutions.
• Experience with Microsoft Active Directory and ADFS.
• Experience with vulnerability management.
• Strong customer-focused approach and ability to work effectively with diverse technical teams.

Professional Skills

• Excellent analytical and problem-solving abilities.
• Strong communication and stakeholder management skills.
• Ability to troubleshoot complex technical issues in critical environments.
• Ability to work independently as well as collaboratively with cross-functional teams.
• Strong focus on customer success, service quality, and operational excellence.
• Willingness to learn new technologies and contribute to modernization initiatives.