DBA DB

Job Overview

DBA DB2 support for application development team.

• Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.
• Monitor database performance and recommend improvements for operational efficiency.
• Assist in capacity planning, space management and data maintenance activities for database system.
• Perform database enhancement and modification as per the requirements.
• Perform database recovery and backup tasks on daily and weekly basis.
• Develop and maintain patches for database environments.
• Identify and recommend database techniques to support business needs.
• Assist in implementation of new features and program fixes in databases.
• Maintain database security and disaster recovery procedures.
• Perform troubleshooting and maintenance of multiple databases.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Oversee utilization of data and log files.
• Manage database logins and permissions for users.
• Transition from previous shift and get familiar with the ongoing things.
• Monitoring Dashboards and E-mail alerts.
• Investigating and Troubleshooting any issues or alerts that reports in the dashboards.
• Helping Application Teams with their BAU requests.
• Making sure the changes are scheduled and transition them for the next on-call.
• Follow up on the support tickets, if any.
• Join major incident calls/incident calls as needed and troubleshoot the issues.
• To adhere to quality standards, regulatory requirements and company policies.
• To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions / Reopen Cases.
• To participate or contribute on EN business in creation of proposals to drive Service improvement plans.
• To independently resolve tickets & ensure that the agreed SLA of ticket volume and time are met for the team.
• To provide support for on call escalations /L3 level support and doing incident & problem management.
• Work on value adding activities such Knowledge base update & management, Training freshers, coaching analysts & conducting interviews/participation in hiring drives.

• Rich experience in Q-replication/HADR is preferred.
• TSA experience is an added advantage.
• Experience with any additional RDBMS like Oracle/MSSQL/PostgreSQL and No
  
  SQL databases like Cassandra/Couchbase is highly preffered.
• Knowledge on Tools like puppet/Git Lab is preffered.
• Knowledge on Scripting is value addition.