DB Administrator

All You need is :

• 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.