GA--DB2 Database Administrator at Atlanta, Georgia, USA |
Email: [email protected] |
From: priya, Anveta INC [email protected] Reply to: [email protected] Hi Team, GA DHS - DB2 Database Administrator (716700) Location : Atlanta, GA 30334, (Web Cam Interview Only)-( Remote) Duration : Long term Client : State of Georgia The Georgia Department of Human Services (DHS), Office of Information Technology (OIT), is seeking qualified candidates for the temporary contractor staffing position of Db2 Database Administrator in Atlanta, Georgia. 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 24x7 on call support and works as needed after normal working hours to implement changes. Required Qualifications: Bachelors degree in computer science or qualifying work experience. Experience with z/OS Db2 V10 or higher Experience with Db2 LUW and Linux 2+ 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 PBG and PBR Experience with all Db2 utilities including Image Copy, Reorg, Recovery, Run stats, 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 Skill Required / Desired Amount of Experience Bachelors degree in computer science or qualifying work experience Required z/OS Db2 DBA including running utilities, performance monitoring, writing, and debugging complex DDL and SQL, managing Db2 Packages and security Required 2 Years Experience with z/OS Db2 V10 or higher Required 2 Years Experience with Db2 LUW and Linux Required 2 Years Experience with IBM ADMIN Tools, JCL, REXX , TSO, IBM PDTOOLS, ISPF, COBOL, Serina Changeman, CICS, DB2 Connect Highly desired Experience with $AVRS, Control-M, CQM, QMF, SPUFI, BCV5, Systemware, Informatica, Connect:Direct, VSAM, SDSF, RMM and TN3270 Highly desired Strong z/OS Db2 object management experience including but not limited to, Referential Integrity, Triggers, Aliases, Stored Procedures, and Universal Required 2 Years Experience with all Db2 utilities including Image Copy, Reorg, Recovery, Run stats, Unload/Load, etc. Required 2 Years Excellent oral and written communication skills with the ability to communicate technical concepts in terms clients can understand. Required Results oriented with strong attention to detail. Required Keywords: zos Georgia |
[email protected] View all |
Tue Aug 01 21:56:00 UTC 2023 |