MYSQL Database Administrator

Job Description Title : Database Administrator Location : Whitefield, Bangalore Experience : 2+ years Qualification : Bachelor/Master Degree in Technology Work Timing : 24X7 Rotational Shifts Roles & Responsibility The MySQL Database Administrator (DBA) is responsible for providing database technical support for ALL client databases in multi-environment (production to non-production). It is extremely important to understand and be aligned to the ITIL process while delivering the Operational support service to our client. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs Reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs Responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems. This role requires a service oriented, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs. Required Skills & Qualification Strong experience in Database Administration in MySQL (version 5.6 & 5.7 ) Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, Slave replication issues, backup & recovery issues, connectivity issues, security issues, etc. Experience in Performance Tuning, Query Optimization and related monitoring and troubleshooting tools. Ability to detect and troubleshoot MySQL related Waits, CPU, Memory, I/O, disk space and other resource contention. Strong work experience on Slave Replication. Strong knowledge of how indexes, index management, integrity checks, configuration, patching. PRB