IT IS_AMS_Mainframe_DBAdministration

Position: IT IS_AMS_Mainframe_DB2 Administration
Location: Bengaluru

Role : IT _Mainframe_DB2 Administration

Experience : 7 to 15 years

Location :
Bangalore/Mumbai

Skill Set : 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 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 Omega Mon and Admin Tool
- Application related performance tuning;
Write, modify, and debug database specific SQL queries
- DBA related utilities like Unload, Load, DSNJU
003, DSNJU
004,Reorg, Runstats, image copy
- REXX, CLIST, JCL, JES and Assembler knowledge

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