Mainframe DB2 DBA

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 there’s nothing that can stop us from growing together.

What we are looking for

Role : Mainframe DB2 DBA

Experience Range : 7 – 15 Years

Location : Bangalore / 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)