DB2 UDB Database Administrator

DB2 UDB Database Administrator

Job Code: TJ_2618
Job Location: Dublin, Ohio
Zip Code: 43016
Job Category/Title:
Employment Category: Contract - Corp-to-Corp, Contract - Independent, Contract - W2
Position Type: Senior Level
Travel Required: No
Interview Type: In-person
Education: Associate Degree
Experience: 5-10 year(s)
Job Description: Skills:

• DB2 UDB – LUW.
• AIX ,(UNIX is added advantage).
• SAP BASIS.
• TIVOLI STORAGE MANAGER.
• RDBMS Performance Tuning.
• RDBMS Analysis and Design.
• Change Control Management.
• Knowledge of Backup / Recovery.
• Knowledge of DB2 UDB Installation / Service Packs / Hotfixes.
• Experience in Trouble shooting.
• Experience in Performance Tuning.
• Experience in developing SQL and Windows scripts.
• Knowledge in IBM AIX operating systems.
• Change Control Management.

Job Description:

• Verify that backups for the Databases.
• TSM backup verify for QA Systems.
• Performing Backup and Restore.
• Trouble shooting job failures.
• Handling customer requests to perform various DBA activities.
• Monitor DBA team ticketing queue for problems.
• Check CCMS or Solution Manager Alerts and Daily monitoring of the system and data bases.
• Check Information from DB6 Cockpit on SAP GUI.
• The Break fix and Enhancement tasks we perform Include Resolving database issues like:
• Developing scripts for automating daily DBA tasks
• Performance Monitoring
• Review Daily Space Report and add space to database files as needed
• Look for New administrative log and/or DB2DIAG.LOG entries, DB13 LOG
• Verify database logs have been archived successfully
• Check that no DBM and/or DB configuration have changed
• Check important performance measures based on your workload
• Check for automatic actions DB2 has taken on your behalf
• Ensure there is enough free memor
• Manual Verification using Check Points on Table Spaces, Verify total storage on UNIX systems and Database snapshot
• Verify parameters for Virtual Memory, Swap space, Short memory, buffer pool and other Database and SAP memory details.
• Support Various Instances of DB2 Server by performing all above and any other related activities that would be required and play as a Team Member as expected.
Duration: 6 Month(s)
No. of Posts: 1
Job Expiry Date: May 4, 2016
Telecommute: No
Contact Information Login To View