Role : IT IS_AMS_Mainframe_DB2 Administration

nExperience : 7 to 15 years

nLocation : Bangalore/Mumbai

nKeywords : z/OS Db2 v13 Database Administration

n

nDesired Competencies (Technical/Behavioral Competency)

nMust-Have

n

n

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

n

nGood-to-Have

n

n
- Database DR, Cloning, Backup/Recovery, HA and Point In Time Recovery (PITR) expertise
n
- Experience with Database ISV Tools and Products like OmegaMon and AdminTool
n
- Application related performance tuning; Write, modify,



and debug database specific SQL queries
n
- DBA related utilities like Unload, Load, DSNJU003, DSNJU004,Reorg, Runstats, image copy
n
- REXX, CLIST, JCL, JES and Assembler knowledge
n

n

n

n

n
1. SN
n

nResponsibility of / Expectations from the Role

n1

nDefine and provide guidance for database creation, configuration, upgrade, patches and refresh requirements

n2

nRecommend operating system and database performance monitoring, tuning and configuration changes

n3

nExperience with database physical and logical design, query analysis and optimization

n4

nProvide technical assistance and subject matter expertise to applications groups. Provide database storage management and capacity management recommendations

📌 IT IS_AMS_Mainframe_Administration (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru