Associate Database Administrator | MYSQL | AWS

Bengaluru, Karnataka, India

Master of Computer Applications - MCA, Computer Science
Visvesvaraya Technological University, VTUs Regional Office, Mysore
Bachelor of computer science, Computer Science
Gulbarga University
Join Abhinesh and 10k+ other professionals on
Tal is the app where bosses meet engineers & builders directly, without middlemen
Download Tal BossAssociate Database Administrator | MYSQL | AWS
Hands-on Database Administrator focused on supporting large-Scale MySQL databases systems. Expert in MYSQL with 3+ years of experience. Motivated and detail oriented with unsurpassed abilities in project Management, teamwork, and crafting of high quality database solutions.
Bengaluru
Senior Database Administrator at Datavail, May 2022 - Present · 4 yrs 3 mos, Bengaluru, Karnataka, India, * Installed, configured, upgraded, and managed multiple MySQL instances (versions 5.x), including major upgrades from 5.6 to 5.7 and 5.7 to 8.0. * Applied quarterly MySQL database patching for on-premises and AWS RDS environments; prepared patching calendars and coordinated with application teams for smooth implementation. * Administered and managed Development, QA, and Production database environments. * Maintained and updated monthly database inventory reports. * Developed and periodically updated Standard Operating Procedures (SOPs) for various DBA activities. * Utilized DB tools such as Percona Monitoring (PMM), Xtrabackup, and MySQL Utilities to efficiently perform DBA tasks. * Managed database users and privileges to ensure secure access. * Performed database and table refreshes from Production to DEV, QA, and UAT environments. * Created data extracts for analysis and shared insights with internal teams. * Set up and administered MySQL replication, including Source-Replica and Source-Source configurations. * Configured and maintained MySQL Enterprise Backup (MEB) for reliable data protection. * Monitored and verified scheduled maintenance jobs (backups), analyzing and resolving errors as needed. * Monitored system resources such as disk space, CPU, memory utilization, and lock waits to identify and resolve performance bottlenecks. * Monitored alerts using Oracle Enterprise Manager (OEM) and Nagios; configured new servers and integrated them into the monitoring inventory. * Managed database clustering and performed data recovery using point-in-time recovery (PITR) with binary logs.
Master of Computer Applications - MCA, Computer Science, Visvesvaraya Technological University, VTUs Regional Office, Mysore
Bachelor of computer science, Computer Science, Gulbarga University