Jayabharath Reddy N
Bengaluru
Summary
Senior Database Reliability Engineer with 8+ years of experience in designing, optimizing, and managing MySQL, PostgreSQL, and MongoDB databases on AWS, GCP cloud and on-premises environments.
Expertise in high availability (HA), performance tuning, backup & recovery, replication, and disaster recovery (DR) strategies. Skilled in cloud-native database solutions such as Amazon RDS, Aurora, Google Cloud SQL.
Proficient in database automation, monitoring, and infrastructure as code (IaC) using Ansible, Terraform, and Kubernetes.
Strong experience in query optimization, indexing strategies, and partitioning for handling large-scale, high-traffic applications. Adept at implementing security best practices, access control, and compliance standards to ensure data integrity.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Database Reliability Engineer
SMARSH INDIA PRIVATE LIMITED
07.2022 - Current
- Configured and deployed AWS RDS Instances for MySQL and PostgreSQL database engines.
- Automated database provisioning, backups, and monitoring using Terraform, AWS Lambda, and CloudWatch, improving operational efficiency.
- Configured role-based access control (RBAC) to ensure users had only the necessary permissions for database access.
- Executed database migrations from on-prem Oracle to Amazon RDS PostgreSQL by using AWS Database Migration Service (DMS) and Schema Conversion Tool.
- Implemented Full and Incremental backups by using Percona XtraBackup for on-prem MySQL databases.
- Managed Point-in-Time Recovery (PITR) and binlog-based backups to ensure minimal data loss in disaster scenarios.
- Implemented MySQL replication (asynchronous, semi-synchronous, and GTID-based replication) to ensure data consistency across multiple regions.
- Tuned replication performance by optimizing binlog settings, parallel replication threads, and log file sizes.
- Optimized MySQL/PostgreSQL database configurations to improve throughput and response times.
- Analyzed slow queries using EXPLAIN, EXPLAIN ANALYZE, and query profiling tools (ptquery-digest, MySQL Slow Query Log, pg_stat_statements).
- Implemented query optimization and indexing strategies to improve performance, reducing CPU/memory consumption and preventing unnecessary instance scaling.
- Designed and implemented table partitioning strategies in MySQL and PostgreSQL to improve query performance and manage large datasets efficiently.
- Worked on MongoDB Installation and Configuration.
- Implemented MongoDB backups.
- Configured MongoDB Replication.
- Worked on MongoDB version upgrade from 3.6 to 4.4 version.
- Right-sized Amazon RDS and EC2 instances using performance metrics and AWS Compute Optimizer, ensuring optimal resource utilization.
- Monitored database costs using AWS Cost Explorer, CloudWatch, and Trusted Advisor, identifying areas for optimization and implementing proactive cost controls.
Database Engineer
GRAB GRECO LLP
02.2019 - 07.2022
- Configurations and administration of MySQL, PostgreSQL, and MongoDB instances.
- Creating and managing cloud infrastructure by using Terraform.
- Configured, managed and ensured databases security and integrity.
- Led the migration of large-scale MySQL databases from AWS RDS to Google Cloud SQL
(GCP CSQL), ensuring minimal downtime and data integrity. - Designed and implemented automated MySQL backup strategies using mysqldump, MyDumper, MySQL Shell, Percona XtraBackup and AWS RDS snapshots.
- Managed AWS RDS Multi-AZ and Read Replica deployments, improving database availability and read performance.
- Tuned replication performance by optimizing binlog settings, parallel replication threads, and log file sizes.
- Developed and executed database upgrade plans to maintain compatibility with latest MySQL and PostgreSQL versions.
- Implemented Percona tools like pt-online-schema-change, pt-table-checksum, pt-table-sync ..etc.
- Implemented Innotop for MySQL Real-time monitoring.
- Configured and managed HAProxy for MySQL reads distribution use cases.
- Implemented comprehensive PostgreSQL backup strategies using pg_basebackup, WAL archiving, and pgBackRest to ensure data durability and disaster recovery
- Worked on PostgreSQL patroni for High Availability setup.
- Worked on various PostgreSQL tools like pgCenter, pgBadger and pg_repack.
- Worked on PMM (Percona Monitoring Management) Configuration & Setup.
- Provided on-call 24/7 database support and troubleshooting.
- Proactively monitored database performance, identified bottlenecks, and implemented solutions to improve query efficiency and scalability.
Database Administrator
Endurance International Group
01.2019 - 02.2019
Database Administrator
IMI Mobile
12.2017 - 01.2019
MySQL DBA
Netxcell Limited
12.2016 - 12.2017
Education
B.Tech - Electrical Engineering
JNTU Anantapur (Affiliated College)
Chittoor, India06-2014
Skills
- Databases : MySQL, PostgreSQL, MongoDB and SQL Server
- Operating Systems : Linux, Windows
- Cloud : AWS, GCP
- Scripting Languages : Bash, Python
- Container Technology : Docker, Kubernetes SCM Tools : GIT, Bit Bucket
- Monitoring Tools : PMM, Prometheus, Grafana, Datadog
Certification
AWS Certified Cloud Practitioner (CLF-C02)
Languages
English
Bilingual or Proficient (C2)
Hindi
Upper intermediate (B2)
Timeline
Senior Database Reliability Engineer
SMARSH INDIA PRIVATE LIMITED
07.2022 - Current
Database Engineer
GRAB GRECO LLP
02.2019 - 07.2022
Database Administrator
Endurance International Group
01.2019 - 02.2019
Database Administrator
IMI Mobile
12.2017 - 01.2019
MySQL DBA
Netxcell Limited
12.2016 - 12.2017
B.Tech - Electrical Engineering
JNTU Anantapur (Affiliated College)
Similar Profiles
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
Saurabh Kumar SinghSaurabh Kumar Singh
Sr. Solution Specialist at Noventiq Services India Private Limited(Former Softline Services India Private Limited)Sr. Solution Specialist at Noventiq Services India Private Limited(Former Softline Services India Private Limited)
DEBAJIT HAZARIKADEBAJIT HAZARIKA
SENIOR ENGINEER-PRODUCT SUPPORT at GAINWELL COMMOSALES INDIA PRIVATE LIMITED (FORMERLY TRACTORS INDIA PRIVATE LIMITED)SENIOR ENGINEER-PRODUCT SUPPORT at GAINWELL COMMOSALES INDIA PRIVATE LIMITED (FORMERLY TRACTORS INDIA PRIVATE LIMITED)