Lead - Data Platform Engineering

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 We are seeking an experienced Lead Engineer specializing in Database Performance Engineering to optimize and scale our mission-critical MySQL and PostgreSQL systems. In this highly cross-functional role, you will partner closely with application teams, Site Reliability Engineers (SREs), and platform engineers to ensure absolute database reliability, efficiency, and seamless scalability in a high-throughput environment. The Impact You Will Create As a Lead Database Performance Engineer, your work will directly influence the speed, resilience, and scale of our core platforms. You will: Drive massive efficiency gains: Drastically reduce system latency and optimize infrastructure utilization through deep query analysis and architectural redesigns. Future-proof our scale: Pioneer and implement advanced database scaling strategies (sharding, partitioning) that allow our platforms to effortlessly handle exponential data growth and high-throughput workloads. Elevate the engineering culture: Act as the ultimate database authority, mentoring development teams on query best practices, optimal ORM usage, and scalable schema design to prevent performance bottlenecks before they hit production. Ensure unshakeable reliability: Eradicate production incidents related to database contention, locks, and latency, ensuring our customers experience a flawless, high-performing product. Roles & Responsibilities Deep Query Optimization & Tuning Analyze complex SQL queries, execution plans, and performance schema views using tools like EXPLAIN and EXPLAIN ANALYZE. Rewrite inefficient queries, optimize indexing strategies, refine schema designs, and improve data access patterns to drastically reduce response times. Tune database configuration parameters to ensure optimal performance under highly variable and intensive workloads. Architecture, Scaling & Capacity Planning Design and implement robust strategies for scaling databases, including sharding, partitioning, replication, and read/write splitting. Conduct comprehensive capacity planning, performance benchmarking, and stress-testing for upcoming features and architectural shifts. Lead performance reviews for all major new features and ... (truncated, view full listing at source)