DB2 Administrator (ZOS) - Mainframe

 Job Title - DB2 Administrator (ZOS) - Mainframe
Experience - 5+ Years
Location - Chennai
 

•         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