Work Experience in DB2 DBA
Usage of database catalogs
Managing Archive log files
Managing Re-org, Runstats utility
Backup and recovery methods including point in time recovery.
Backup and recovery using DB2 backup and restore commands.
Ability to use export/import, DB2move, Load utility.
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.
Basic SQL knowledge
Working knowledge of Unix
Knowledge of Tivoli Storage Manager / Tivoli Data protector (TSM / TDP)
Troubleshooting of issues in Tivoli Storage Manager / Tivoli Data protector (TSM / TDP)
* Knowledge of DB2 UDB 9.x (Viper)
* Working Knowledge of HACMP, HADR in DB2 UDB environment.
* Use of problem and change management tools
* Must have excellent team working skills balanced with ability to work alone and a positive attitude.
* Customer focus
* Communication skills
Good English speaking/writing skills
At least 5 years experience in DB2 DBA Administrator or DB2 DBA or DB2 Database administrator
At least 5 years experience in DB2 DBA
At least 2 years experience in Performance tuning
At least 2 years experience in Upgrade
At least 2 years experience in Performance
At least 2 years experience in Backup management