Projects

Selected case studies.

A snapshot of recent work — each focused on measurable outcomes for performance, recoverability, or compliance.

Cloud · Performance

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.

~60% CPU reductionStable peak-hour latencyLower instance class possible
MSSQL · Forensics

SQL Deadlock Forensics

Deep analysis of recurring deadlocks and index fragmentation across a high-write OLTP workload — extended events, deadlock graph analysis, and targeted index redesign.

Eliminated nightly deadlock stormReduced fragmentation < 5%Stable transactional throughput
PostgreSQL · Automation

PostgreSQL Restore Automation

Built parallel restore workflows using pg_restore jobs and orchestrated scripts to dramatically cut RTO during DR drills, with audit logs at every step.

Restore time ↓ ~70%Repeatable, auditable runsDR drill confidence ↑
Reporting · Mentoring

Audit Reporting & DBA Training

Delivered management-ready audit reports across MSSQL/PostgreSQL estates, plus structured training for junior DBAs covering tuning, backups, and incident response.

Pass-first audit cyclesJunior DBA on-call ready in 90 daysDocumented runbooks