Database Performance Engineer

As a Database Performance Engineer at our company, your main role will be to optimize and scale mission-critical MySQL and PostgreSQL systems through deep query analysis, performance tuning, and architecture improvements in high-scale environments. You will collaborate closely with application teams, SREs, and platform engineers to ensure the reliability, efficiency, and scalability of databases in a high-throughput environment. Key Responsibilities: - Analyze complex SQL queries and execution plans to identify inefficiencies and suggest architectural changes - Use advanced profiling tools for system profiling and bottleneck analysis related to CPU, I/O, locking contention, and memory pressure - 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 - Design strategies for scaling databases through sharding, partitioning, replication, and 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 Qualifications Required: - 7 years of hands-on experience working with MySQL and PostgreSQL in high-scale, high-throughput environments - Proficiency in SQL optimization, query analysis, and diagnosing complex bottlenecks - Deep understanding of indexing strategies, joins, transactions, concurrency control, storage engines, locking behavior, and isolation levels - Experience with performance tuning and diagnostic tools such as pt-query-digest and pgstatstatements - Strong grasp of Linux system performance mechanics and their interaction with database engines - Proven ability to troubleshoot critical production issues, lead technical initiatives, and drive consensus among diverse engineering teams The Preferred Qualifications include experience managing and scaling databases across varied environments, deep theoretical and practical knowledge of database internals, familiarity with distributed systems and NoSQL databases, proficiency in automation and scripting, and a track record of architecting massive-scale database performance improvements in a fast-paced product company. Please note that the required education for this role is any degree. As a Database Performance Engineer at our company, your main role will be to optimize and scale mission-critical MySQL and PostgreSQL systems through deep query analysis, performance tuning, and architecture improvements in high-scale environments. You will collaborate closely with application teams, SREs, and platform engineers to ensure the reliability, efficiency, and scalability of databases in a high-throughput environment. Key Responsibilities: - Analyze complex SQL queries and execution plans to identify inefficiencies and suggest architectural changes - Use advanced profiling tools for system profiling and bottleneck analysis related to CPU, I/O, locking contention, and memory pressure - 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 - Design strategies for scaling databases through sharding, partitioning, replication, and 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 Qualifications Required: - 7 years of hands-on experience working with MySQL and PostgreSQL in high-scale, high-throughput environments - Proficiency in SQL optimization, query analysis, and diagnosing complex bottlenecks - Deep understanding of indexing strategies, joins, transactions, concurrency control, storage engines, locking behavior, and isolation levels - Experience with performance tuning and diagnostic tools such as pt-query-digest and pgstatstatements - Strong grasp of Linux system performance mechanics and their interaction with database engines - Proven ability to troubleshoot critical production issues, lead technical initiatives, and drive consensus among diverse engineering teams The Preferred Qualifications include experience managing and scaling databases across varied environments, deep theoretical and practical knowledge of database internals, fam