IMS Database Administrator

IMS-DB2 DBA on Mainframe(Z/OS)

4 - 7+ Years exp

Must be a production support DBA with good in problem solving & analytical Skills, with hands on experience in following:

IMS DBA experience:

• IMS DB support experience with version 13 onwards.
• DB Objects Experience in creating and modifying DBD, PSB, ACB, FMT.
• Experience with administration of IMS Full Function, HALDB, Fastpath databases.
• Good knowledge on DBRC, Restore, Reorg, Load IMS DB.
• Experience in database initialization, forward recovery & building secondary index and pointer checker, checkpoint restart, Fast path, DEDB etc
• Strong Knowledge of Troubleshooting skills on IMS administration.
• Usage of IMS utilities (including IBM, BMC)
• Working Knowledge of RACF as it relates to IMS.
• Working Knowledge of IMS exit points and routines
• z/OS TSO, ISPF, JCL
• Tools FileManager, ADBUS
• Basic knowledge on VSAM,CICS, IMS DC

DB2 DBA on Mainframe(Z/OS):

• DB Objects – Experience in creating and modifying DB2 objects - Database, Storage Group, Tablespace, Tables, Views, Indexes, etc.
• Experience with DB2 commands: - Stop/Start Databases, Display command, Cancel thread and Term & Display utility, others.
• Hands on experience on DB2 utilities: Reorg and Runstat, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities.
• Ability to bind/rebind the Plans/Packages and Granting required accesses to Packages/Plans/Collections.
• Experience in Database Monitoring.
• Experience in Database replication – IBM DB2 Data Propagator
• DB2 administration - Strong Troubleshooting skills
• DB2 privileges and RACF
• z/OS – TSO, ISPF, JCL.
• Tools – DB2 Admin tool, QMF, FileManager, Changeman, ESP.

Nice to have:

• REXX development experience
• Teradata experience

Candidate should have:

• Good communication skill
• Provide 24X7 on call support on rotational basis.