Role : IT ISAMSMainframe_DB2 Administration Experience : 7 to 15 years Location : Bangalore/Mumbai Keywords : z/OS Db2 v13 Database Administration 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 workplace
Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9
Experience in SMPE and ISV tools installation and migration Positive-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 1. SN Responsibility of / Expectations from the Role 1 Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements 2 Recommend operating system and database performance monitoring, tuning and configuration changes 3 Experience with database physical and logical design, query analysis and optimization 4 Provide 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