Short Description: The Georgia Client (Client), Office of Information Technology (Client), is seeking qualified candidates for the temporary contractor staffing position of Db2 Database Administrator in Atlanta, Georgia. Complete Description: Job Responsibilities: Troubleshoot, analyze for root causes for problems, ensure database availability, security and stability, performance tuning and optimization Provides expertise to Application programmer staff technical questions related to Db2 Manages and maintains data in all Production and Test Db2 (Mainframe z/OS) Handles data refreshes from Production to Test environments based on user requirements Performs maintenance of the Db2 environments including image copies, performance monitoring, capacity management, and object upgrades Provides 24×7 on call support and works as needed after normal working hours to implement changes Required Qualifications: Bachelor’s degree in Computer Science or qualifying work experience Experience with z/OS Db2 V10 or higher Experience with Db2 LUW and Linux Two (2) or more years z/OS Db2 DBA including running utilities, performance monitoring, writing and debugging complex DDL and SQL, managing Db2 Packages and security Strong z/OS Db2 object management experience including but not limited to, Referential Integrity, Triggers, Aliases, Stored Procedures, and Universal Client and PBR Experience with all Db2 utilities including Image Copy, Reorg, Recovery, Runstats, Unload/Load, etc. Can perform recovery to Image Copy or RBA Able to provide performance tuning by analyzing Database and O/S performance using Explain, articulate the benefits, and implement the solution Can perform the design and distribution of all Db2 objects with good performance, proper security, and structure matching the needs of the data and its’ access Excellent oral and written communication skills with the ability to communicate technical concepts in terms clients can understand Results oriented with strong attention to detail Self-motivated, conscientious, team player Preferred Qualifications: Experience with IBM ADMIN Tools, REXX , COBOL, ChangeMan, CICS, DB2 Connect, $AVRS, Control-M, CQM, QMF, SPUFI, BCV5, Systemware, Informatica, Connect:Direct, VSAM, SDSF, RMM and TN3270
ddl SQL explain vsam Database administration (DBA) Linux cics COBOL pbr