Mainframe Systems Specialist

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

DB2 keywords :

IBM DB2 system admin, IBM DB2 v12, DB2 DBA on z / OS, Mainframe DB2 system programmer, Mainframe DB2 system administrator, IRLM, LISTDEF, REORG, RECOVER, RUNSTATS, QUIESCE, IRLM, DSNJU003, DSN1LOGP, DSN1SDMP

Exp Range : 7 TO 12

Location : Chennai / Bangalore / Hyderabad