Results-driven Database Administrator with over 5 years of experience in PostgreSQL, Oracle, MySQL, and SQL Server environments. Demonstrated expertise in performance tuning and designing high availability architectures, alongside effective disaster recovery planning and enterprise-scale database migrations. Possesses a strong analytical mindset and excels in problem-solving while optimizing system performance. Proven ability to thrive in dynamic, high-pressure settings through both collaborative teamwork and independent projects.
· Managed enterprise-scale MySQLenvironments with a focus on availability, backup, and performance optimization.
· Led migrations of critical MySQL systems to upgraded OS/database stacks, enhancing reliability and throughput.
· Implemented Percona XtraBackupfor hot backups, with cron-based scheduling and restoration testingfor DR readiness.
· Designed replication-based HAusing native MySQL Replication, and integrated monitoring via pt-heartbeatand custom alerting scripts.
· Architected and maintained production-grade PostgreSQL clusters with emphasis on stability, replication, and performance.
· Deployed robust HA/DR setups using Patroni, pgBackRest, and etcd, ensuring automatic failover and backup consistency.
· Established proactive monitoring via pg_stat_statements, Prometheus, and Grafana, enabling real-time anomaly detection.
· Developed DR testing procedures and recovery workflows, validating point-in-time recovery (PITR) strategies under multiple failure scenarios.
· Proficient in administering Microsoft SQL Server environments with a strong focus on performance optimization and system reliability.
· Successfully optimized backup processes using open-source T-SQL APIs, reducing storage usage and execution time.
· Implemented automated alert mechanismsthrough Database Mail to proactively notify stakeholders of critical events. D
· eveloped and scheduled SQL Agent Jobs for maintenance, monitoring, and failover readiness. Experienced in troubleshooting performance issues using SQL Profiler, Extended Events, and DMVs.
Administered Microsoft SQL Server in both production and development environments, emphasizing performance tuning.
Skilled in utilizing SSMS, SQL Profiler, and Database Tuning Advisor for comprehensive performance assessment.
· Managed SQL Agent Jobs, configured Database Mail, and implemented log shipping and backup/restore strategies using Maintenance Plans.
Proficient at resolving issues with blocking and deadlocks to improve overall system efficiency.