Associate Consultant
HCLTech
Madurai, Tamil Nadu, India
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 To validate analyses (eg. Root Cause Analysis ,Trend Analysis) and reports to facilitate performance in tasks to be presented to key business stakeholders To ensure positive customer feedback and satisfaction thorugh active participation in customer meetings to understand any issues faced To validate Change Order Implementation Plan and Human Error Compliance and participate in Capacity planning To perform value addition activities (such as mentoring administratorsorteam members, preparing SOPs, maintaining effective documentation simultaneously and Knowledge sharing.) In addition act as a liaison to the business segment, facilitating effective communication and presentation to key business stakeholders as and when required. To ensure on-time resolution and quality compliance of escalated ticketsorincident as per the agreed SLA