IT IS_AMS_Mainframe_DB2 Administration

Tata Consultancy Services; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced IT AMS Mainframe DB2 Administrator in Bengaluru. The role targets professionals with 7 to 15 years of hands-on DB2 on z/OS, with responsibilities spanning installation, upgrades, patches and performance tuning.

You will work on data sharing in Parallel Sysplex, manage SMPE/ISV tools, and apply expertise in ACF2/RACF, CICS, MQ and related mainframe utilities. Strong analytical skills and ability to guide capacity planning are essential.

Qualifications

• Experience in Mainframe Db2 v12/v13 on z/OS.
• DB2 installation, upgrade, patching and configuration.
• Proficiency in DB2 and VSAM performance tuning and capacity planning.
• Data Sharing setup in Parallel Sysplex environment.
• Knowledge of ACF2/RACF, CICS v5.5, Mainframe MQ v9.
• Experience with SMPE and ISV tools installation and migration.

Responsibilities

• 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.

Skills

Mainframe DB2

DB2 Installation

DB2 Tuning

Data Sharing

ACF2 RACF

SMPE/ISV tools

Job description

Role : IT IS_AMS_Mainframe_DB2 Administration

Experience : 7 to 15 years

Desired Competencies (Technical/Behavioral Competency)

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
• SN

Responsibility of / Expectations from the Role

• 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