Mainframe DB2 DBA

Role - Mainframe DB2 System Administrator

Exp- 6 to 12 years

Location : Chennai / Hyderabad / Bangalore / Mumbai / Pune / Delhi

Summary of key 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
• Define and manage database security and access permissions in consultation with customer
• Ensure completion of authorized Service Requests, Changes, Problem tickets
• Manage escalations and track Service Delivery and ensure SLA compliance including with vendors
• Review and update the SOP documents on regular basis
• Support in all in-flight and upcoming project activities
• Recommend and perform customer-approved database replication procedures

Years of Experience

L3 : 6+ Years of experience in Mainframe z / OS Db2 v13 Database Administration

Technical requirements

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

Create and maintain database entities, including instances, databases, table spaces and tables

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