Kamal Gupta
Senior Principal DBA at MakeMyTrip |Ex. Database Lead at Optum| MySQL Database | AWS Cloud | Terraform | Azure Cloud Certified | IAC Ansible | Shell Scripting | Django | Python | Mongo | Automation Enthusiast
- Role
- Senior Principal Database Administrator - Senior Manager at MakeMyTrip
- Location
- West Delhi, DL, IN
- LinkedIn followers
- 500 followers
About Kamal Gupta
With 14+ years of deep-rooted expertise in MySQL and a strong command over automation…
Experience
Senior Principal Database Administrator - Senior Manager
Aug 2024 — Present · Gurugram, IN
AWS | Terraform | Ansible | MySQL | Mongo | Django | Python | Shell Cloud Infrastructure & Database Operation AWS Cloud Infrastructure Management: Managed cloud environments on AWS, working with services such as EC2, Route 53, NLB, and Security Groups.Infrastructure as Code (IaC): Automated server provisioning and infrastructure deployment using Terraform for scalability and consistency.Configuration Management & Automation: Leveraged Ansible playbooks for automating software installations, system configurations, and patch management across environments.AWS CLI Automation: Streamlined daily operations and workflow automation using AWS CLI for cloud and database tasks.Database & High Availability Architecture:Designed and maintained MySQL Master-Slave Replication and Group Replication setups.Implemented failover mechanisms using Orchestrator and automated MySQL failover in Group Replication.Deployed ProxySQL for intelligent traffic routing and enhanced database availability.Security & Networking: Administered Security Groups, IAM roles, and policies to ensure robust access controls and secure database operations.Monitoring & Optimization: Deployed monitoring tools and fine-tuned database and cloud infrastructure for improved performance and cost efficiency.Automation via DBSCOPE tool (Django-Based Database Monitoring & Reporting Portal)Developed DBSCOPE, a Django-based web portal for real-time MySQL database monitoring and reporting. The project features interactive, AJAX-driven dashboards for fragmentation, growth, and replication analysis, with a modern, compact UI built using Bootstrap and jQuery. Integrated robust backend logic for live diagnostics, advanced server selection, and dynamic filtering, ensuring a seamless user experience. The solution is architected for modularity and scalability, enabling easy expansion for future reporting needs.Skills used: Django, Python, MySQL, Bootstrap, jQuery, AJAX, REST APIs, Linux, Git, UI/UX design.
Education
Maharaja Agrasen Institute Of Technology, Delhi
Bachelor of Technology (B.Tech.), Information Technology
2007 — 2011
Skills
- Mysql
- C++
- Core Java
- Java
- Windows
- Microsoft Sql Server
- J2ee Application Development
- Sql
- Shell Scripting
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.