Title: DB2 Administrator (ZOS) - Mainframe
Experience:6+
Location: Chennai
Detailed JD:
- 6-10 Years of progressive expertise in Database Administration
• Ability to craft and alter of DB2 object according to custom's requirement (Ex: Database, Table space, Table, Index, etc)
• Demonstrable experience with DB2 common command (familiar with other command), Stop/Start Databases, Display command, cancel thread and term utility
• Experience in Online utility: Running Reorgs and Runstats, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities.
• Proficient in Stand-alone utilities: DSNJU003 and DSNJU004, DSNJ003 to change DB2 BSDS, DSNJU004 to print BSDS. Trained with DSN1COP.
• Ability to provide Grants to users for appropriate groups/authorities, familiar with DB2 privileges.
• Working knowledge of SQL, knows to use query to check catalog table and find necessary for system usage
• Validated ability to manage operation on zOS, familiar with JCL used by DB2
- Experience in REXX/CLIST
- Experience in analyzing SQL and suggest improving performance
