DBA DB2

DBA DB2 support for application development team.Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.Rich experience in Q-replication/HADR is preferred.TSA experience is an added advantage.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.Expeirence with any additional RDBMS like Oracle/MSSQL/PostgreSQL and NoSQL databases like Cassandra/Couchbase is highly prefferedKnowledge on Tools like puppet/GitLab is prefferedKnowledge on Scripting is value additionRoles and Responsibilities1. Transition from previous shift and get familiar with the ongoing things2. Monitoring Dashboards and E-mail alerts.3. Investigating and Troubleshooting any issues or alerts that reports in the dashboards4. Helping Application Teams with their BAU requests.5. Making sure the changes are scheduled and transition them for the next on-call6. Follow up on the support tickets, if any.7. Join major incident calls/incident calls as needed and troubleshoot the issues."" " (1.) To adhere to quality standards, regulatory requirements and company policies (2.) To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions / Reopen Cases (3.) To participate or contribute on EN business in creation of proposals to drive Service improvement plans. (4.) To independently resolve tickets & esnure that the agreed SLA of ticket volume and time are met for the team. (5.) To provide support for on call escalations /L3 level support and doing incident & problem management (6.) Work on value adding activities such Knowledge base update & management, Training freshers, coaching analysts & conducting interviews/participation in hiring drives.