Job Overview
DBA DB2 support for application development team.
Responsibilities
- 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.
Preferred Qualifications
- Rich experience in Q-replication/HADR is preferred.
- TSA experience is an added advantage.
- Experience with any additional RDBMS like Oracle/MSSQL/PostgreSQL and NoSQL databases like Cassandra/Couchbase is highly preffered.
- Knowledge on Tools like puppet/GitLab is preffered.
- Knowledge on Scripting is value addition.
#J-18808-Ljbffr