IT IS_AMS_Mainframe_DB2 Administration

Tata Consultancy Services; Bengaluru, Mumbai; On-site; INR 2,400,000 - 3,600,000; Full time

Job summary

Tata Consultancy Services (TCS) is seeking an IT IS_AMS_Mainframe_DB2 Administrator to join our mainframe team in Bengaluru/Mumbai. You will lead DB2 on z/OS, handle performance tuning, capacity planning, and Data Sharing in a Parallel Sysplex environment.

The role requires 7–15 years of experience in DB2, CICS, RACF, MQ, and related mainframe tools, with a focus on stability, security, and optimization across complex workloads.

Qualifications

• Must have: Mainframe Db2 on z/OS with 7–15 years experience.
• DB2 installation, upgrade, patching and configuration.
• Proficient in DB2, VSAM performance tuning and capacity planning.
• Experience in Data Sharing in Parallel Sysplex.
• Knowledge of ACF2/RACF, CICS v5.5 and Mainframe MQ v9.

Responsibilities

• Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements.
• Recommend OS and database performance monitoring, tuning and configuration changes.
• Experience with database physical/logical design, query analysis and optimization.
• Provide database storage management and capacity management recommendations to applications teams.

Skills

Mainframe DB2 administration

DB2 performance tuning

Capacity planning

Data sharing in Parallel Sysplex

ACF2/RACF knowledge

CICS v5.5 knowledge

Mainframe MQ v9 knowledge

Education

15 years of full-time education

50% percentile in 10th/12th/UG/PG

Tools

SMPE

ISV tools: OmegaMon

AdminTool

JCL/JES/Assembler

DSNJU003/DSNJU004/Unload/Load

Job description

TCS has been a great pioneer in feeding the fire of young techies like you. We are a global leader in the technology arena and theres nothing that can stop us from growing together.

What we are looking for

Role: IT IS_AMS_Mainframe_DB2 Administration

Experience Range: 7 to 15 Years

Location: Bengaluru/Mumbai

Must Have:

• 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

Good to Have:

• 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

Essential:

• Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements
• Recommend operating system and database performance monitoring, tuning and configuration changes
• Experience with database physical and logical design, query analysis and optimization
• Provide technical assistance and subject matter expertise to applications groups. Provide database storage management and capacity management recommendations

Minimum Qualification:

• 15 years of full-time education
• Minimum percentile of 50% in 10th, 12th, UG & PG (if applicable)