DB2 DBA
Ref No.: 18-21349
Location: Cary, North Carolina
Position Type:Contract
Start Date: 03/29/2018
Job Details:
Title: DB2 DBA
Duration: 6 Months
Location: Cary, NC


Job Description:
  • Minimum 7-9 Years of relevant experience.
  • Should be able to L3 Level of activities

Knowledge & Abilities:
  • Experience as a DBA and extensive knowledge of the DB2 9/10
  • Troubleshooting Database & key responsible for Migration & Upgrading activities.
  • Usage of database catalogs, Space management, Use export/import, DB2move, Load utility , Managing Archive log files
  • Manage Managing Re-org, Run stats utility
  • User management
  • Knowledge about upgrades to new release
  • Knowledge about schema objects management
  • Backup and recovery methods including point in time recovery
  • Backup and recovery using DB2 backup and restore commands
  • DB2 node directory / catalog configuration
  • Database performance tuning using DB2dart, DB2explain utilities
  • Trouble shooting database issues using db2diag and notification logs, snapshot, event monitor, db2hc or enabling hmon
  • Troubleshooting of issues in Tivoli Storage Manager / Tivoli Data protector (TSM / TDP) Skills
  • Working knowledge of DB2 DBA UDB
  • Knowledge of DB2 UDB 9.x (Viper)
  • Working Knowledge of HACMP, HADR in DB2 UDB environment
  • Working knowledge of Unix
  • Knowledge of Tivoli Storage Manager / Tivoli Data protector (TSM / TDP)
  • Database design & impl, user creation, operation and recovery,installation and migration/upgrades specific to the z/OS system
  • Experience of mainframe software upgrades
  • Excellent communication and conversation skills (Verbal and Written)
  • Good working knowledge of MS OFFICE (Including MS Project and Visio).
  • Abiding by Change Management, Incident management and Problem Management procedures, including complying with the Service Level Agreements
  • Act on Day to Day House Keeping tasks by using tools & scripts
  • To able to perform in 24 x 7 Environment in shift roaster
  • To able to attend calls on-call basis whenever assigned
  • Create regular reports for Management requirements.
  • Good experience working on ticketing tools like Service Now, Remedy, and Client-Openview etc.
  • Good documentation skill to document the day-to-day events for tracking and review, process documentation, Preparing SOP (Service Operation Procedure) documents, Creating and maintaining technical knowledge base