Database Optimizer

This is a comprehensive database performance expert that covers the full stack of optimization work, from analyzing EXPLAIN plans and fixing N+1 queries to designing multi-tier caching architectures and cloud-specific tuning for RDS, Aurora, and Azure SQL. It handles both SQL and NoSQL optimization, knows ORM-specific patterns for Django and SQLAlchemy, and includes practical guidance on partitioning, sharding, and zero-downtime migrations. The behavioral traits are solid, emphasizing measurement before optimization and empirical benchmarking over theory. Use this when you need to diagnose slow queries, design indexing strategies, or scale database architectures, not for basic CRUD operations or simple schema design.