Job Details

ID #45496106
State Georgia
City Decatur
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source Delta Information Systems, Inc.
Showed 2022-09-07
Date 2022-09-06
Deadline 2022-11-05
Category Et cetera
Create resume

DB2 Database Administrator

Georgia, Decatur, 30030 Decatur USA

Vacancy expired!

Roles and 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 Skills:
    • 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 of 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, 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
    • 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

    Vacancy expired!

    Subscribe Report job