Senior DBA: Performance & Load Tuning for High-Load DBs

Omegahires; New York (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

Our client is building a highly focused engineering squad to optimize and scale high-throughput database systems under extreme transactional loads. You will analyze behavior under stress, resolve locking and replication issues, and partner with engineering leadership to architect long-term scaling strategies.

The role requires hands-on experience with MariaDB/MySQL in production, deep query optimization knowledge, and proficiency with PMM, Perf_Schema, and monitoring tools.

Qualifications

• Hands-on DBA experience with MariaDB and MySQL in high-concurrency production environments.
• Deep expertise in query execution plan analysis, indexing strategies, buffer pool optimization, and lock/latch contention analysis.
• Solid track record in managing replication topologies (Master-Replica, Galera Cluster, or InnoDB Cluster) and diagnosing replication lag under load.
• Proficiency with database monitoring and diagnostic tools (PMM, Performance_Schema, sys schema, Slow Query Logs, or Datadog/Grafana DB metrics).
• Demonstrated experience identifying performance ceilings and advising on structural fixes (schema redesign, connection pooling via ProxySQL/MaxScale, or partition strategies).

Responsibilities

• Analyze database behavior under stress and optimize for high throughput.
• Resolve complex locking and replication issues under extreme transactional loads.
• Collaborate with engineering leadership to architect long-term database scaling strategies.
• Monitor saturation metrics and advise on performance ceilings and structural fixes.

Skills

MariaDB/MySQL

Query optimization

Replication topologies

Performance monitoring

Lock contention analysis

Tools

Percona PMM

Performance_Schema

sys schema

Slow Query Logs

Datadog

Grafana

ProxySQL

MaxScale

Job description

Our client is building a highly focused engineering squad to optimize and scale high-throughput database systems under extreme transactional loads. You will analyze behavior under stress, resolve locking and replication issues, and partner with engineering leadership to architect long-term scaling strategies.

The role requires hands-on experience with MariaDB/MySQL in production, deep query optimization knowledge, and proficiency with PMM, Perf_Schema, and monitoring tools.