MySQL DBA: Replication, Backup, Performance Monitoring

Yashwanth S

+91-914-***-**** ***************@*****.***

github.com/Yashu-sk linkedin.com/in/yashwanth-sk Portfolio Bengaluru, India 560040 CAREER OBJECTIVE

Database engineer with MySQL experience across performance optimization, replication, backup, and monitoring, plus exposure to cloud-managed databases (Amazon EC2/RDS). Seeking an Associate DBA role to contribute to high-availability, secure, and well-tuned MySQL environments. EDUCATION

SJB Institute of Technology Dec 2022 – Jun 2026

BE – Information Science and Engineering — CGPA: 8.8/10 — Bengaluru Swami Vivekananda PU College Jun 2022

12th Standard (PCMB) — Percentage: 94% — Pavagada

EXPERIENCE

Associate Database Engineer – Mydbops Jun 2026 – Sep 2026

Administration: Managed dozens of MySQL servers across multiple client environments via Linux/SSH, including client onboarding and user/privilege management.

Replication & HA: Set up and troubleshot source-replica, master-master, GTID, and binlog-based replication, fixing lag and broken replication and performing failovers.

Backup & Recovery: mysqldump, XtraBackup, binlog point-in-time recovery, and restore testing.

Upgrades & Monitoring: Performed in-place MySQL version upgrades; monitored servers with PMM

(OS usage, uptime, replication lag).

Summer Intern – Sasken Technologies Limited Jun 2025 – Jul 2025

Developed backend modules and 15+ RESTful APIs using Java/J2EE for enterprise systems with 1,000+ daily users, improving integration efficiency by 30%.

Optimized database queries and refactored code, contributing to 40% faster response time; took part in debugging, code reviews, and Agile sprints. PROJECTS

Database Performance Monitoring & Optimization System (MySQL)

Designed a normalized MySQL database with primary/foreign keys and complex SQL queries

(JOINs, subqueries, aggregates) for transactional reports; optimized with indexing, EXPLAIN plan analysis, and views/stored procedures, with exposure to cloud databases (Amazon RDS). Malware Analysis Tool (Web-Based Security Application)

Developed a web-based malware analysis tool in JavaScript with file upload handling, script analysis, and real-time dashboards showing threat severity, file metadata, and mitigation recommendations. TECHNICAL SKILLS

Databases & Cloud: MySQL, MariaDB, Amazon RDS, Amazon EC2 MySQL Administration: Replication (Source-Replica, Master-Master, GTID, Binlog), Failover, In-place Version Upgrades, User & Privilege Management.

Backup & Recovery: mysqldump, Percona XtraBackup, Binlog Point-in-Time Recovery (PITR) Performance Tuning: Indexing, Query Optimization, EXPLAIN Plans, Views, Stored Procedures Monitoring & OS: PMM, Percona Toolkit, Linux/SSH, Bash Scripting Programming & Concepts: Java, J2EE, RESTful APIs, JavaScript, C, Git, DBMS, OS, Networking CERTIFICATIONS

Becoming a Production MySQL DBA – Udemy AWS Certified Cloud Practitioner – In Progress Java Masterclass – Udemy (2024)

Contact this candidate