DB2 DBA

Reference Code: 08-10927Industry: Information TechnologyJob Type: ContractJob Length: OpenJob Location: Dearborn, MI 48126 Send Us Your Resume apply online with an already posted resume Apply Online TAC Worldwide Companies' contractors are our greatest assets. We are proud of the breadth and depth of our workforce and their unique skills and abilities and we are committed to providing them with challenging and rewarding positions. TWC will work with you to help identify the contract or permanent opportunity that best suits your career goals. DB2 DBA Maintain sufficient level of DBA personnel to provide required support coverage. Recent departures of personnel within the DBA area have reduced staffing levels that prohibits adequate coverage of applications to meet SLA/OLA. Responsibilities will include: * Provide assistance to DA in application table design * Provide on-call support * Define and set-up database utilities * Gather information for corrective actions to maintain database performance and efficiency * Assist in identifying and resolving database problems * Process requests for modifications to existing database structures Required Skills: * 5-7 years working with DB2 * 3-5 years performing DB2 DBA application functions * 3-5 years working with DB2 utilities (IBM or BMC) (reorg, image copy, etc) * 1-2 years working with version 7 of mainframe DB2 software * 1-2 years database design experience * 5-7 years working on mainframe * Use of Omegamon for DB2 * 1-2 years of tuning SQLSecondary Skills: * 3-5 years Mainframe DB2 experience * Xpeditor (using with Stored Procedure a plus) * Working in a Distributed environment * Websphere * DB2 Connect * IBM utilities (IEBGENER, IEBCOPY, etc) * CLIST, Dialog Manager, and REXX * JCL * Mobius * EJES * IMS DB and DC * MQ * Dump reading (with and without abend-aid) * File-Aid * experience with DB2 Version 8Other: * Team player * Able to work independently * Work with other DBMS (Oracle, SQL Server)