Database Administrator - z/OS

SourcingXPress; Maharashtra; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

PruTech is seeking an experienced DB2 z/OS Database Administrator with 5+ years of hands-on DB2 experience to manage enterprise DB2 environments on z/OS.

You will analyze performance, run utilities, handle JCL/VSAM, and automate repetitive tasks with SAS or REXX, while collaborating with application and infra teams in an Agile setting.

Qualifications

• 5+ years of hands-on DB2 z/OS DBA experience.
• Experience supporting DB2 environments, performance analysis, and utilities.
• Proficient in JCL and VSAM.
• Familiarity with Agile development practices.
• Nice to have IMS DBA or SAS/REXX for automation.

Responsibilities

• Administer and support DB2 databases on z/OS in enterprise environments.
• Manage DB2 maintenance, monitoring, and performance optimization.
• Analyze database health from space utilization and performance perspectives.
• Execute and manage DB2 utilities (LOAD, UNLOAD, IMAGECOPY, REORG, RUNSTATS).
• Automate repetitive tasks using SAS or REXX where applicable.
• Collaborate with application, infrastructure, and development teams to resolve issues.
• Participate in database performance analysis, capacity planning, and optimization.
• Follow Agile ceremonies and maintain documentation and procedures.

Skills

DB2 z/OS

SQL

JCL

VSAM

DB2 utilities

Agile

Tools

LOAD

UNLOAD

IMAGECOPY

REORG

RUNSTATS

Job description

About PruTech

PruTech is a global technology and digital transformation company delivering solutions across AI, Data & Analytics, Enterprise Software Engineering, Platform Engineering, IoT, Cloud, and Information Security. With a strong global presence and 25+ years of experience, PruTech works with organizations across industries to build scalable and technology-driven solutions.

Company: PruTech Solutions
Website: Visit Website
LinkedIn: Visit LinkedIn
Business Type: Enterprise
Company Type: Product & Service
Business Model: B2B
Funding Stage: Private Equity
Industry: IT Services

Job Description

We are looking for an experienced DB2 z/OS Database Administrator with 5+ years of hands-on experience in DB2 database administration and management. The ideal candidate should have strong experience supporting DB2 environments, analyzing database health and performance, executing DB2 utilities, troubleshooting production issues, and working with JCL and VSAM.

Experience with IMS DBA activities and scripting/automation using SAS or REXX will be an added advantage.

Key Responsibilities

• Administer and support DB2 databases on z/OS in enterprise environments.
• Perform DB2 database management and administration activities, including database maintenance, monitoring, troubleshooting, and optimization.
• Analyze database health from both space utilization and performance perspectives.
• Monitor and analyze tablespaces for space utilization, availability, and performance.
• Execute and manage DB2 utilities such as:
  • LOAD
  • UNLOAD
  • IMAGECOPY
  • REORG
  • RUNSTATS
  • Other database maintenance utilities
• Perform database refreshes and data movement between environments/systems.
• Develop and execute SQL queries for data analysis, troubleshooting, and operational requirements.
• Analyze and troubleshoot DB2-related production issues and identify root causes.
• Work with JCL and VSAM as part of database administration and batch processing activities.
• Automate repetitive database administration and operational tasks using SAS or REXX where applicable.
• Collaborate with application, infrastructure, and development teams to resolve database-related issues.
• Participate in database performance analysis, capacity planning, and ongoing optimization.
• Follow Agile methodologies and actively participate in team ceremonies and delivery activities.
• Maintain database administration standards, documentation, and operational procedures.

Required Skills & Experience

• 5+ years of hands-on experience in DB2 z/OS Database Administration.
• Strong experience in DB2 database management and application DBA activities.
• Good to advanced knowledge of JCL.
• Strong understanding of VSAM.
• Hands-on experience with DB2 utilities such as LOAD, UNLOAD, IMAGECOPY, REORG, and RUNSTATS.
• Experience analyzing tablespace space utilization and database performance.
• Strong SQL/query-writing skills.
• Experience with database refresh and migration between systems/environments.
• Strong analytical and troubleshooting skills.
• Ability to investigate database states, identify issues, and perform root-cause analysis.
• Good understanding of Agile development methodologies.

Good to Have

• Experience with IMS Database Administration.
• Knowledge of SAS or REXX for automation and scripting.
• Experience working in large-scale enterprise/mainframe environments.
• Exposure to production support and performance tuning.

What You Bring

• Strong problem-solving and analytical skills.
• Ability to troubleshoot complex database issues independently.
• Good communication and collaboration skills.
• Ability to work effectively with cross-functional teams in an Agile environment.
• Strong ownership of database availability, performance, and operational stability.