Ramesh Kumar Reddy P

Database Reliability Engineer

Hyderabad

Summary

Highly skilled Database Administrator & Database Reliability Engineer with 10+ years of experience in cloud infrastructure development and seamless database migrations from on-premises to cloud. Extensive expertise in Oracle, PostgreSQL, AWS RDS, and Google Cloud SQL, coupled with a strong background in Agile Scrum-based projects. Proficient in shell scripting, Terraform (IAC), and performance tuning, ensuring database reliability, automation, and optimized performance in cloud and hybrid environments.

Overview

years of professional experience

Certifications

Work History

Database Administrator - III

RealPage India Private Ltd

09.2018 - Current

Managed PostgreSQL databases, including Master-Slave setups and switchover failovers using repmgr in On-Prem server
Handled AWS RDS for PostgreSQL and MySQL configured Data Migration Services.
Have a good experience at handing databases in Google Cloud VM and Cloud SQL.
Have working experience on GCP Big Query
Develop and maintain comprehensive database reliability documentation, ensuring clear guidelines for automation, incident response, and performance optimization.
Implementation of Terraform and scripting to streamline database provisioning, backups, and monitoring.
Maintain database security, encryption, and access controls in line with industry best practices and compliance requirements.
Migrated Oracle databases from CentOS to RHEL and upgraded PostgreSQL databases across multiple versions from V9 to V10/V12/V14.
Good experience at troubleshooting application slowness and understand the complex queries to improve the performance of application.
Configured infrastructure in AWS using Terraform and Cloud Formation and securing AWS RDS in Private subnets without exposing to Internet.
Interacting with product team on regular basis to understand their requirements to create better path for new launching products.

Technology Analyst

Infosys Ltd

01.2015 - 09.2018

Setup Oracle RAC database and implementation of SCAN listeners.
Implementation of RMAN backups and creation of databases using RMAN backups.
Implementation of Dataguard and perform Switch over and failover tasks.
Performing logical backups and restore like schema and table export and import from prod to non- prod vice versa.
Implementation Of ODA servers and perform disk replacements.
Performing PSU patching on quarterly basis and apply CPU patch when we received any kind of
Oracle internal errors like ORA-00600/ORA-007445 etc
Upgradation of Oracle home from 11g to 12c.
Implementation of logging collector in PostgreSQL database to track all queries running in Database.
Troubleshoot application queries and improve the performance of those queries.
Having good experience at Implementation of Data guard and performing switch over and
failover task.
Having good experience at Implementation of Daily RMAN backup jobs using shell script.
Having good experience at implementation of Quarterly patching, and migrating Oracle database
from CentOS to RHEL.

Education

Bachelor of Technology (B. Tech) - Computer Science and Engineering

Jawaharlal Nehru Technological University (JNTU)

AndhraPradesh , India

Skills

Linux, Windows

Oracle, PostgreSQL

PGWatch, OEM, Cloud Watch

Shell Scripting, Terraform

AWS RDS, EC2, VPC, Security groups,S3

GCP VM, Cloud SQL , BigQuery

UC4, Commvault,Actifio

Performance tuning

Database design

Capacity planning

MySQL, DB2

Disaster recovery

Certification

AWS Certified Solutions Architect Associate

Timeline