Cary, NC

8 - 10 years

Posted 224 days ago

  by    Emily Russo

This job is no longer available.

?We are looking for DB2 DBA for our client in Cary, NC

Job Title: DB2 DBA

Job Location: Cary, NC

Job Type: Contract ? 12 Months / Contract to Hire / Direct Hire

Job Description:

Skills and Experience:


  • 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
  • TroubleshootingDatabase & 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
  • snapshot, event monitor, db2hc or enabling hmon
  • notification logs,
  • 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
  • HP-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.