Job description:
DB2 LUW DBA JOB DESCRIPTION:
Responsible for DB troubleshooting, database activities like export/ import, DB2move, Load utility, Backup and recovery, DB2 node directory / catalog configuration. Database performance tuning using DB2dart, DB2explain utilities etc.
Trouble shooting database issues using db2diag and notification logs, snapshot, event monitor, db2hc or enabling HMON
Supporting Configure and maintain High Availability Disaster Recovery (HADR) environment
Database performance tuning using db2dart, db2explain, db2advis db2top, db2pd utilities.
Backup and recovery methods including point in time recovery.
Install, configure, monitor, upgrade, Migrating and maintain DB2 LUW databases in production/Dev/QA environments
Instance and database creation and configuration.
Extensive experience automating database maintenance and monitoring with shell scripts including automating system event logging, alert notification, and Reporting using the DB2 utilities and Command Line Processor (CLP).
Working experience on SAP db2 environment (Preferred)
Knowledge on OS clustering environment
Exposure on DR test & strategies like Failover Clustering
Very good knowledge of Linux/AIX/Window
Should have very good communication skills and Knowledge on ITIL Methodologies like Change, Incident, Problem, and Service Management using Service Now is preferred.
Working knowledge of Backup tools like Netbackup