Jan 2025 – Jun 2025 · 5 mos · Remote

• Manage database installations and configurations, ensuring optimal performance and reliability.
• Lead SQL Server database, Percona PXC, PostgreSQL database and MySQL database installations and configurations, ensuring optimal performance and reliability.
• Engineered robust database replication strategies, ensuring data consistency and minimal latency across distributed systems while maintaining high availability.
• Managed Galera Cluster, SQL Server Always On availability groups, PostgreSQL cluster auto failover manager for high availability, load balancing and scalability.
• Worked with AWS and Azure Database Migration Service, EC2 replica setup and hot backup in S3 Bucket
• Successfully migrated application from on-prem to RDS MySQL
• Engineered robust database replication strategies, ensuring data consistency and minimal latency across distributed systems while maintaining high availability.
• Proficient in optimizing MySQL's configuration(my.cnf) parameters to maximize resource utilization
• Successfully implemented load balancing in MySQL replication using ProxySQL.
• High Knowledge on implementing and managing load balancing in MySQL Replication using MySQL Router
• Highly expertise of database optimization, indexing, and query tuning.
• Utilized PMM (Percona Monitoring and Management) for performance monitoring and slow query identification.
• Adequate knowledge on AWS Database Migration Service (AWS DMS)
• Implementing hot backup in S3 Bucket.
• Created RDS from backup stored in S3 bucket
• Expertise knowledge on RDS Backup and Recovery
• Adequate knowledge on RDS Monitoring and Performance Tuning
• . Designed and implemented backup, restore, and disaster recovery strategies within MongoDB Atlas to ensure data protection.
• Possess knowledge on MySQL load balancing (ProxySQL, MySQL Router) and optimized configurations.
• Excellent knowledge on configuring database performance related metrics using Grafana and PMM monitoring tools.

Sep 2024 – Dec 2024 · 3 mos · On-site

• Configured MySQL, PostgreSQL, Percona PXC, MSSQL servers across environments, enhancing system reliability and performance.
• Managed database upgrades and migrations, ensuring minimal downtime for critical systems.
• Implemented backup strategies, improving data recovery capabilities for enterprise databases.
• Led cross-platform database optimizations, resulting in improved query efficiency.
• Coordinated maintenance operations, achieving seamless system upgrades and continuity.
• Developed automated database maintenance workflows, streamlining routine operations and reducing manual intervention requirements.
• Adequate experience in configuring and managing the High Availability for MySQL Router in a MySQL InnoDB Cluster.
• Possess knowledge on implementing MySQL Router 2.1 and MySQL Router 8.0 as per business requirement.
• Possess adequate knowledge on internals of ACID compliant InnoDB Storage Engine.
• Led cross-functional database optimization projects, implementing best practices for system performance and security across enterprise platforms
• Good knowledge on Configuring HA solution for MySQL Router with Keepalived on MySQL InnoDB Cluster
• Expertise in configuring and managing Percona PXC, MySQL Replication, PostgreSQL pgbadger log analyser tool.
• Adequate knowledge in implementing PostgreSQL cluster auto failover manager.
• Installed, configured and managed MySQL Aurora database clusters in AWS.
• Expertise in implementing load balancing in MySQL Replication using MySQL Router
• Expertise in configuring and managing pgbouncer connection pooler for PostgreSQL
• Adequate knowledge in handling and executing PostgreSQL logical and physical database backups.
• Possess knowledge on MySQL load balancing (ProxySQL, MySQL Router) and optimized configurations.
• Excellent knowledge on configuring database performance related metrics using Grafana and PMM monitoring tools.

Feb 2022 – Aug 2024 · 2 yrs 6 mos · Hyderabad, Telangana, India · On-site

• Configured MySQL, PostgreSQL, Percona PXC, SQL Server, MongoDB servers across environments, enhancing system reliability.
• Database Administration: Extensive experience in administering MySQL, PostgreSQL, SQL Server, MongoDB databases, including server setup, production support, upgrades, migrations, and regular maintenance for MySQL (versions 5.1, 5.5, 5.6, 5.7, 8.0).
• Possess adequate knowledge on internals of ACID compliant InnoDB Storage Engine.
• Expertise in Production support, upgrades, migrations, and regular maintenance for PostgreSQL (versions 15,16,17)
• Adequate knowledge in Production support, upgrades, migrations, and regular maintenance for MSSQL (versions 2017,2019,2022)
• Database Configuration & Optimization:
• Proficient in optimizing MySQL's configuration(my.cnf), PostgreSQL configuration (postgressql.conf, pg_hba.conf, pg_ident.conf), and SQL Server configuration (configurationfile.ini) parameters to maximize resource utilization.
• Experience in configuring and tuning MySQL, PostgreSQL, MSSQL databases for high-performance environments.
• Skilled in MySQL database replication techniques: one-way (Master-Replica), two-way (Master- Master), multi- source replication, GTID based replication and Percona XtraDB Cluster.
• Database Maintenance & Troubleshooting:
• Conducted regular database consistency checks, maintenance procedures, and troubleshooting of live database issues to ensure uptime and optimal performance.
• Utilized PMM (Percona Monitoring and Management) and Pt-query-digest for performance monitoring.
• Possess knowledge on MySQL load balancing (ProxySQL, MySQL Router) and optimized configurations.
• Excellent knowledge on configuring database performance related metrics using Grafana and PMM monitoring tools.
• Automation & Scripting:
• Experience with Ansible for automating MySQL administration tasks through playbooks.
• Automated routine database tasks (backups, monitoring, scaling) using MongoDB Atlas APIs and tools.

Jun 2016 – Feb 2022 · 5 yrs 8 mos · Hyderabad, Telangana, India · On-site

• Feb 2022 - Aug 2024
• Managed MySQL, PostgreSQL, SQL Server, Percona PXC , MongoDB database installations and configurations, ensuring optimal performance and reliability.
• Optimize queries and configurations, resulting in improved database efficiency and speed.
• Deployed AWS RDS and GCP CSQL instances with Terraform, streamlining cloud database operations.
• Streamlined database deployment processes by architecting infrastructure-as-code solutions using Terraform for AWS RDS and Google Cloud SQL implementations
• . Managed and optimized MongoDB Atlas clusters for high availability and performance in a cloud-based environment.
• Adequate knowledge in handling and executing PostgreSQL logical and physical database backups using pg_dump, pg_dumpall, pg_basebackup, PGBackRest, and PITR ensuring data integrity
• Proficient in optimizing MySQL's configuration(my.cnf), PostgreSQL configuration (postgressql.conf, pg_hba.conf, pg_ident.conf), and SQL Server configuration (configurationfile.ini) parameters to maximize resource utilization
• Adequate knowledge in handling and executing PostgreSQL logical and physical database backups using pg_dump, pg_dumpall, pg_basebackup, PGBackRest, and PITR ensuring data integrity.
• Expertise in configuring and managing PostgreSQL pgbadger log analyser tool.
• Adequate experience in Setting up InnoDB Cluster and MySQL Router.
• High Knowledge on implementing and managing load balancing in MySQL Replication using MySQL Router
• Expertise in implementing and managing pgAdmin(GUI) for PostgreSQL
• Designed and implemented high-availability database architectures, integrating AWS RDS and GCP SQL, MySQL platforms with automated monitoring and failover systems.
• ossess knowledge on MySQL load balancing (ProxySQL, MySQL Router) and optimized configurations.
• Excellent knowledge on configuring database performance related metrics using Grafana and PMM monitoring tools.

Mar 2014 – Dec 2015 · 1 yr 9 mos · On-site

• Installed and configured MySQL, PostgreSQL, and MSSQL servers across various environments (on-premise, cloud).
• Configured and maintained one-way and two-way (Master-Master) replication topologies for MySQL.
• Optimized database performance through advanced monitoring and tuning techniques, implementing robust backup strategies and disaster recovery protocols.
• Led migration projects from on-premise databases to AWS and GCP cloud environments, ensuring smooth transitions and minimal downtime.
• Expertise in implementing and managing PostgreSQL partitioning.
• Successfully implemented load balancing in MySQL replication using ProxySQL.
• Expertise in implementing load balancing in MySQL Innodb Cluster using MySQL Router
• Proficient in handling Active/Passive Failover Cluster for MSSQL Server.
• Implemented robust security frameworks and access control mechanisms across database environments, ensuring data protection and compliance standards
• Streamlined database performance through advanced monitoring tools and automated maintenance protocols, substantially reducing system response times
• Adequate knowledge in implementing SQL Server Full, Differential, Transaction log, Tail log, and Copy-only backup.

Apr 2012 – Mar 2014 · 1 yr 11 mos · On-site

• Installed and configured MySQL and MSSQL servers, enhancing database performance and reliability.
• Implemented and troubleshot replication setups, ensuring seamless data synchronization.
• Managed backup and recovery with Percona and MEB Tools, safeguarding data integrity.
• Optimized replication processes, leading to improved system uptime and reduced data loss.
• Orchestrated MySQL and MSSQL database infrastructure, implementing robust replication architectures and optimizing backup strategies using Percona tools
• Streamlined database recovery procedures by implementing automated backup solutions, reducing system downtime and enhancing data security
• Implemented cross-platform database monitoring system to detect and resolve replication issues, enhancing system reliability and minimizing data inconsistencies
• Created custom database health monitoring scripts, enabling proactive identification and resolution of potential performance bottlenecks
• Coordinated with development teams to optimize database queries and indexing strategies, improving application response times

Dec 2010 – Mar 2012 · 1 yr 3 mos

• Configured and upgraded MySQL versions 5.1 and 5.5, enhancing database performance.
• Implemented backup and recovery with MySQLdump and Holland, ensuring data integrity.
• Executed Point-in-Time Recovery using mysqlbinlog, minimizing data loss risks.
• Optimized MySQL database performance through strategic version upgrades and implemented robust backup solutions using MySQLdump and Holland Backup Manager
• Executed point-in-time recovery procedures using mysqlbinlog while maintaining comprehensive database documentation and standard operating procedures
• Developed automated backup verification systems and implemented disaster recovery protocols to ensure data integrity and minimal downtime

Jun 2008 – Nov 2009 · 1 yr 5 mos · On-site

• Executed test cases to ensure software functionality met requirements, identifying critical defects.
• Contributed ideas in technical discussions, aligning team efforts with project goals.
• Applied analytical skills to improve software quality, achieving measurable results.
• Collaborated on technical calls, enhancing team communication and project alignment.
• Ensured software reliability through detailed testing, positively impacting user experience.