AWS RDS Optimization
Diagnosed and resolved sustained CPU saturation on large MariaDB RDS instances. Reworked indexes, query patterns, and parameter groups to bring CPU under sustainable thresholds.
A snapshot of recent work — each focused on measurable outcomes for performance, recoverability, or compliance.
Diagnosed and resolved sustained CPU saturation on large MariaDB RDS instances. Reworked indexes, query patterns, and parameter groups to bring CPU under sustainable thresholds.
Deep analysis of recurring deadlocks and index fragmentation across a high-write OLTP workload — extended events, deadlock graph analysis, and targeted index redesign.
Built parallel restore workflows using pg_restore jobs and orchestrated scripts to dramatically cut RTO during DR drills, with audit logs at every step.
Delivered management-ready audit reports across MSSQL/PostgreSQL estates, plus structured training for junior DBAs covering tuning, backups, and incident response.