Chaitanya Reddy

MySQL Database Administrator

Seasoned DBA with 9+ years of hands-on experience in designing, implementing, and maintaining high-performance database systems.
Demonstrated expertise in optimizing database performance and ensuring data security.

[Link]@[Link] +13092052737 United States [Link]/in/chaitanya-tr

SKILLS
Cultivated professional expertise in complex Database Administration, setting up new database systems size ranging from 200MB
to 12 TB ground up in Financial, Banking & Telecom domains.

Expert in installing, administrating, troubleshooting & maintaining MySQL 5.5/5.6/5.7/8.0, MariaDB 10.4,10.5,MSSQL 2016/2019,
PostgreSQL 13,Singlestore 8.0.1/8.0.19.

Collaborate extensively with stakeholders – Development, Technical, Functional teams, Architects, Operations & Product Owners
for new implementations, change orders & incident management.

Experienced in installing and administering Databases with complex architecture like Cross data center replication in multi- Master
replication/Master-Slave/Galera/XtraDB Clusters / Neo4j clustering casual/autonomous/Singlestore Clusters /Multi-Subnet Always-
ON on Linux & Windows VM’s.

Well versed in SQL/GQL queries, automation/scripting using Unix shell to automate the Database monitoring health checks and
send notifications based on the severity.

Recovered database with 99.99% data without data losses using Native backup utility,MySQL Dump, XtraDB, MEB backup, backups
from S3 and Bin-log recovery.

Expertise in database design, indexing, normalization, and implementing database schemas that optimize query performance.

Automated the Singlestore Installation and patching using the Ansible/Shell.

Proficient in AWS services such as RDS, EC2, S3, DMS, and IAM, with hands-on experience in setting up, configuring, and managing
cloud databases.

Knowledgeable in data warehousing concepts and ETL processes, ensuring efficient data migration and transformation

Experienced in creating and managing PostgreSQL databases, performing backups, and writing basic SQL queries for data
manipulation. Proficient in user role management, monitoring performance, and ensuring data integrity through constraints and
indexing.

Hands-on experience on dockers/containers. Automated the deployment using the Liquibase and Git.

TECHNICAL SKILLS
DATABASE MySQL 5.5-8.0|MariaDB 10.3-10.5 OS Windows|RHEL|Rocky Linux
|PostgreSQL 13|MSSQL 2014-
2019|Singlestore 8

Cloud AWS|Azure Tools

CloudWatch|PMM|Monyog|MEM|Rundeck|MaxScale|GIT
|Percona|Anisble |Zabbix |Terraform|Liquibase|Docker
|Confluence

Scripting Shell|T-SQL|GQL|Basic Python Additional Redis|Postgre|Neo4j|Ocenabase

Language Databases

CERTIFICATES
Azure Associate Database Administrator (DP-300).

Page 1 of 3
WORK EXPERIENCE
Site Reliability Engineer
Persolkelly/DBS
03/2023 - 09/2024, singapore
Achievements/Tasks
Installed and worked on Singlestore 8.0/8.1/8.5 MySQL 5.6/5.7/8.0, MariaDB Server 10.5/10.6 and SQL Server 2019.
Managed cloud-based databases using AWS RDS , EC2 , S3 , and DMS including database migration to cloud environments and
ensuring high availability through automated backups and replication
Performed In-place and side-by-side Upgradations on MYSQL.
Implemented HA solutions like cross data center clustering for MYSQL.
Recovering and Restoring databases from backup in disaster situations on MYSQL/MariaDB.
Automated Singlestore/Mariadb upgrades using bash scripting.
Successfully worked on a POC and migrated MYSQL from version 5.6 to 5.7 and 5.7 to 8, focusing on performance improvements,
feature enhancements, and ensuring smooth data migration.
Implemented STIG policies for hardening MySQL Mariadb and Singlestore databases, ensuring compliance with security standards.
Configured and automated the database monitoring using the Shell scripting and configured the alerting.
Monitored database performance and health using CloudWatch , setting up alerts and metrics to proactively address issues before
they impact performance.

Database Administrator
COPART(CITC)
12/2021 - 03/2023, Hyderabad/India
Achievements/Tasks
Installed MySQL 5.6/5.7/8.0 MariaDB Server 10.3/10.4/10.5 and SQL Server 2019.
Managed the Migration of SQL Server 2017 to SQL Server 2019 & MariaDB server from 10.3 to 10.4.
Analyzing the slow log report on daily and weekly basis, thereby optimizing the low performing queries.
Experience in building and managing the HA cluster’s like Percona XtraDB, Galera, Availability Groups on SQL 2019 and configured
MaxScale for the load-balancing of the clusters like XtraDB & Galera .
Automated backups and Alerts using Rundeck, Monyog and PMM .
Fixing the corruption issue in MyIASM/INNODB storage engine tables and troubleshooting performance issues using Percona
utilities.

Database Administrator
Vodafone
03/2020 - 12/2021, Pune/India
Achievements/Tasks
Performed Installation of SQL Server 2016 and MySQL Server 5.5/5.6.
Troubleshooting performance issues to improve the performance on MS SQL/ MySQL.
Recovering and Restoring databases from backup in disaster situations on MS SQL/MySQL.
Implemented HA solutions like Master-Master, Master-Slave Replication. Refreshes from Production backup to Stage and
Development environments on MS SQL/MySQL.
Documentation of SOP’s and POC with respect to DBA activities. ·

Database Administrator
WIPRO/PNC BANK
06/2018 - 03/2020, Hyderabad/india
Achievements/Tasks
Involved in Installing MySQL Server 5.5/5.6/5.7 and SQL Server 2012/2014/2016 .
Managed the Migration of SQL Server 2008R2 databases to SQL Server 2012/2014/2016/2017 and MySQL databases from 5.5 to 5.7.
Recovering and Restoring databases from backup in disaster situations on MS SQL/MySQL ·
Monitoring and troubleshooting SQL Server performance using DPA (Database performance analyser) and MySQL Server
performance using OEM and MEM .
Implemented and Maintaining Log shipping, Mirroring, Replication & Always on.

Page 2 of 3
WORK EXPERIENCE
Database Administrator
WIPRO/GSMC SHARED SERVICES
07/2015 - 06/2018,
Achievements/Tasks
Orchestrated SQL Server installations, migrations, and upgrades, ensuring seamless transitions and system integrity.
Implemented database backup, restoration, and disaster recovery strategies, enhancing data protection and business continuity.
Managed high availability solutions such as database mirroring, log shipping, and availability groups, ensuring system uptime and
reliability.
Conducted database maintenance tasks including index management, consistency checks, and troubleshooting of maintenance
plans.

Page 3 of 3