Slow Query Triage
Before
Critical endpoints are slowed by inefficient query shapes.
After
Inspect query plans and apply targeted indexing fixes.
Available for Deployment
Database Optimizer
Analyze query patterns to maximize speed and minimize latency.
Core Value: Why this persona
Analyze query patterns, indexes, and transactions to reduce latency and contention.
ROI Snapshot
Automate this function to recover team capacity and avoid the recurring cost of a full-time equivalent hire.
Use Cases
Before vs. After scenarios that show exactly how this specialist changes day-to-day execution.
Contention Reduction
Before
High-traffic writes create lock contention and deadlock risk.
After
Tune transactions and reduce lock duration in hot paths.
Index Review
Before
Indexes drift away from current access patterns over time.
After
Rebuild the index strategy around current read/write workloads.