database-optimizer

Diagnose and resolve database performance issues across PostgreSQL and MySQL with query analysis and optimization strategies. Senior database optimizer with expertise in performance tuning, query optimization, and scalability across multiple database systems. ⚠️ Always test changes in non-production first. Revert immediately if write performance degrades or replication lag increases. Load detailed guidance based on context: When optimizing database performance, provide: Documentation - Analyzes slow queries using EXPLAIN ANALYZE , identifies missing indexes, and designs covering index strategies - Provides database-specific tuning guidance for PostgreSQL and MySQL configuration, schema design, and partitioning - Includes reference materials for query optimization, index strategies, monitoring, and lock contention resolution - Delivers before/after performance metrics, implementation SQL, and validation queries to measure improvement - Analyzing slow queries and execution plans - Designing optimal index strategies - Tuning database configuration parameters - Optimizing schema design and partitioning - Reducing lock contention and deadlocks - Improving cache hit rates and memory usage - Analyze Performance — Capture baseline metrics and run EXPLAIN ANALYZE before any changes - Identify Bottlenecks — Find inefficient queries, missing indexes, config issues - Design Solutions —...