GAURAV KUMAR SINGH
MySql Database Administrator
Summary
Dedicated and experienced MySQL Administrator with 4 years of expertise in database management within the telecommunications sector. Adept at ensuring high availability, scalability, and data consistency while optimizing queries and providing robust backup and monitoring solutions.
Overview
4
4
years of professional experience
1
1
Language
Work History
Administrator, Database Administrator
AT&T
01.2022 - Current
- Dedicated and experienced MySQL, with 4 years of expertise in database management within the telecommunications sector
- Adept at ensuring high availability, scalability, and data consistency while optimizing queries and providing robust backup and monitoring solutions
- SUMMARY
- Managed and administered MySQL database systems for critical telecommunications applications, ensuring high availability and data consistency
- Implemented MySQL InnoDB clustering to enhance system resilience and fault tolerance, reducing downtime by 30%
- Configured and maintained Group Replication, facilitating real-time data synchronization across multiple database nodes for improved redundancy
- Collaborated with the development team to optimize complex SQL queries, resulting in a 20% improvement in application performance
- Developed and maintained Bash scripts for daily and monthly backup processes, automating data protection and enhancing disaster recovery readiness
- Utilized tools such as PMM monitoring, Grafana, and Kibana for real-time performance monitoring, issue detection, and reporting
- Implemented ProxySQL and HAProxy for database load balancing, enhancing query distribution and system reliability
- Collaborated with AWS and Azure cloud platforms for database deployment and migration, optimizing resource utilization
- Supported data streaming initiatives using Kafka CDC, enabling real-time data synchronization and analytics
- Got client appreciation many times for exceptional performance in projects, commitment, and willingness to meet the deadlines
- Rakuten Symphony
- Managed running MySQL database on Docker and Kubernetes
- Creating HA and fault tolerant database on Kubernetes cluster
- Collaborated with the development team to optimize complex SQL queries, resulting in a 20% improvement in application performance
- Utilized tools such as PMM monitoring, Grafana, and Kibana for real-time performance monitoring, issue detection, and reporting
- Projects
- Database innodb cluster monitoring, DR setup with asynchronous replication between servers
- Drillish:- Database installation , backup , innodb cluster installation on Kubernetes pods
- CDC kafka for data streaming.
Senior Database Administrator
PlanetCast Media Services
10.2021 - 01.2022
- Database modeling, creating db form ER diagram
- Creating procedures for business requirements.
AWS Aurora db Administrator
MySQL, Path Infotech Pvt. Ltd
08.2020 - 10.2021
- Performed MySQL server installation, upgradation on windows and various Linux servers
- Performed various types of database backups and created script for automated backup on daily basis
- Solved performance issues of client server by performance tuning and database optimization
- Created scripts to monitor database server
- Projects
- IDBI: - Database server installation and upgradation
- Daily and monthly health checkup
- HDFC: - Daily db server monitoring, weekly and monthly db health checkup
- 2 | Page
- ACHIEVEMENTS
- Taught more than 100 students in technical field and gave practical knowledge about Electrical Engineering
- Successfully completed the AWS Certified Solutions Architect Associate Training
- Organised table tennis tournaments in college and also coached students in TT
- Successfully completed Beginner Python Tutorial and django framework on Udemy.
Education
K.V AMC CBSE
Skills
MySql Database Administrator
Accomplishments
- Qualification School/College Board/Uni Year
- Percentage
- B.tech (Electrical
- Dr.K.N Modi AKTU2015
- Engineering)
- Institute Of Engg.7%& Technology
- Intermediate
- K.V AMC CBSE 20106%
- LUCKNOW
Timeline
Administrator, Database Administrator
AT&T
01.2022 - Current
Senior Database Administrator
PlanetCast Media Services
10.2021 - 01.2022
AWS Aurora db Administrator
MySQL, Path Infotech Pvt. Ltd
08.2020 - 10.2021
K.V AMC CBSE
Similar Profiles
Eonna SmithEonna Smith
Telephone Sales Representative at AT&TTelephone Sales Representative at AT&T
Ryan JonesRyan Jones
Retail Sales Representative at AT&TRetail Sales Representative at AT&T
LYNNAE O. GARNERLYNNAE O. GARNER
Retail Sales Consultant at AT&TRetail Sales Consultant at AT&T
Jake DalatiJake Dalati
AT&T Store Manager at AT&TAT&T Store Manager at AT&T
Del AhlinDel Ahlin
Sr Windows Server Administrator, SR Database Administrator, Webops ADMINISTRATOR at SMX ContractorSr Windows Server Administrator, SR Database Administrator, Webops ADMINISTRATOR at SMX Contractor