Mainframe DB2 system DBA

Tata Consultancy Services; Chennai District, Bengaluru, Mumbai; On-site; INR 900,000 - 1,100,000; Full time

Job summary

Tata Consultancy Services in Chennai is seeking an experienced Mainframe DBA to manage DB2 on z/OS, including CICS and MQ environments. You will ensure high availability, perform upgrades, and implement DR/backup strategies.

Responsibilities include performance tuning, capacity planning, and ISV tool integration (OmegaMon, AdminTool). Strong REXX/JCL/JES skills are valued for efficient operations.

Qualifications

• Experience in Mainframe DB2 on z/OS with installation, upgrade and patching.
• Proficient in DB2, VSAM performance tuning and capacity planning.
• Experience in Data Sharing in Parallel Sysplex environments.
• Knowledge of ACF2/RACF, CICS, and MQ in mainframe setups.
• Experience with SMPE and ISV tools installation and migration.
• DBA utilities: Unload/Load, DSNJU003/DSNJU004, Reorg, Runstats, image copy.

Responsibilities

• Manage DB2 database administration on z/OS.
• Perform DR, cloning, backup/recovery and PITR tasks.
• Install, configure and upgrade DB2 and related tools.
• Conduct performance tuning and capacity planning.
• Use ISV tools like OmegaMon and AdminTool for monitoring.
• Write/modify/debug SQL queries for application needs.

Skills

DB2 on z/OS

Mainframe DB2

CICS v5.5

MQ v9

ACF2/RACF

JCL

JES

DSNJU003/DSNJU004

REXX/CLIST

DSN tools

z/OS SMPE

Capacity Planning

Performance Tuning

PITR/HA/DR

Tools

OmegaMon

AdminTool

SMPE

Job description

Role & responsibilities

• Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS
• DB2 installation, upgrade, patching, configuration and operations
• Proficiency in DB2, VSAM Systems Performance Tuning and Capacity Planning
• Experience in Data Sharing setup in Parallel Sysplex environment
• Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9
• Experience in SMPE and ISV tools installation and migration

• Database DR, Cloning, Backup/Recovery, HA and Point In Time Recovery (PITR) expertise
• Experience with Database ISV Tools and Products like OmegaMon and AdminTool
• Application related performance tuning; Write, modify, and debug database specific SQL queries
• DBA related utilities like Unload, Load, DSNJU003, DSNJU004,Reorg, Runstats, image copy
• REXX, CLIST, JCL, JES and Assembler knowledge