We are seeking an experienced Lead Engineer specializing in database performance engineering to optimize and scale mission-critical MySQL and PostgreSQL systems. This role focuses on deep query analysis, performance tuning, architecture improvements, and production troubleshooting in high-scale environments.

You will work closely with application teams, SREs, and platform engineers to ensure database reliability, efficiency, and scalability.

• Deep Query Optimization: Analyze complex SQL queries and execution plans to identify inefficiencies. You will be responsible for rewriting queries, suggesting architectural changes, and implementing indexing strategies that drastically reduce latency.
• System Profiling & Bottleneck Analysis: Use advanced profiling tools to diagnose issues related to CPU, I/O, locking contention, and memory pressure.
• Analyze slow or inefficient queries using tools such as EXPLAIN, EXPLAIN ANALYZE, query plans, and performance schema views
• Optimize SQL queries, indexes, schema design, and data access patterns
• Identify and resolve performance bottlenecks across application, database, and infrastructure layers
• Tune database configuration parameters for optimal performance under varying workloads
• Conduct capacity planning and performance benchmarking
• Design strategies for scaling databases (sharding, partitioning, replication, read/write splitting)
• Implement monitoring and alerting for database performance metrics
• Troubleshoot production incidents related to database latency, locks, deadlocks, and resource contention
• Collaborate with developers to enforce best practices in query design and ORM usage
• Lead performance reviews for new features and schema changes
• Document performance guidelines and mentor engineering teams