MySQL Database Performance Analysis and Optimization Specialist
Budget: ₹12,500 – ₹37,500 INR
We are experiencing database performance issues in a production environment, primarily around slow and complex queries with pagination, filtering, and joins on large tables. The system is already live, so changes must be carefully analyzed, measurable, and safe for production.
Scope of Work
• Review existing database schema, table structures, and relationships.
• Analyze slow-running queries, especially those involving:
• Large datasets
• JOIN-heavy queries
• Search and pagination logic
• Date-based filtering
• Identify performance bottlenecks caused by missing or inefficient indexes, suboptimal query patterns, or server-level constraints.
Environment
• Production database with high read volume
• Performance-sensitive APIs
• Changes must be optimized, documented, and production-safe
Scope of Work
• Review existing database schema, table structures, and relationships.
• Analyze slow-running queries, especially those involving:
• Large datasets
• JOIN-heavy queries
• Search and pagination logic
• Date-based filtering
• Identify performance bottlenecks caused by missing or inefficient indexes, suboptimal query patterns, or server-level constraints.
Environment
• Production database with high read volume
• Performance-sensitive APIs
• Changes must be optimized, documented, and production-safe