Percona - Database Support Engineering

Support Engineer delivering enterprise MySQL/PostgreSQL/MongoDB solutions for Fortune 500 companies where downtime costs thousands per minute. Successfully saved 200+ databases from the dreaded ’table full’ error.

Business Challenge #

Provide rapid expert intervention for mission-critical databases experiencing performance degradation, replication issues, or emergency failures that threaten business continuity.

Technical Expertise #

Emergency Response

  • Diagnosed and resolved 200+ critical database incidents
  • Maintained <2 hour response SLA for P1 issues
  • Prevented data loss through rapid corruption recovery

Performance Engineering

  • Query optimization improving response times by 50-300%
  • Scaling strategies for high-traffic AWS deployments
  • Proactive monitoring preventing emergency situations Knowledge Transfer
  • Developed automation scripts reducing manual tasks
  • Created operational runbooks for client teams
  • Mentored 15+ engineering teams on best practices

Technologies Mastered #

  • Databases: MySQL (5.6-8.0), MongoDB (3.x-5.x), AWS Aurora RDS
  • Monitoring: Prometheus, PMM, Custom alerting solutions
  • Automation: Python/Bash scripts for common operations
  • Platforms: AWS, Docker, Bare metal

Business Impact #

  • Availability: Prevented millions in potential downtime losses
  • Performance: Enabled business growth through optimized queries
  • Knowledge: Empowered client teams with sustainable practices
  • Efficiency: Automated solutions saving 100+ hours monthly
  • Stress Reduction: Prevented countless 3am wake-up calls

Key Insights #

  1. Monitoring prevents emergencies: Proactive metrics beat reactive fixes
  2. Query optimization multiplies value: One optimized query outperforms hardware upgrades
  3. Documentation saves critical time: Clear runbooks enable rapid resolution
  4. Backup testing is mandatory: Theoretical recovery plans fail in practice