Database Administrator (DBA) — Performance & Load Tuning

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 that needs a Senior Database Administrator (DBA) specializing in Performance & Load Tuning to optimize and scale our high-throughput database systems under extreme transactional loads. In this role, you will analyze database behavior under stress, resolve complex locking and replication issues, monitor deep saturation metrics, and partner with engineering leadership to architect long-term database scaling strategies.

Qualifications & Required Skills:

• 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 (Percona Monitoring and Management (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).

Preferred Skills:

• Experience implementing database sharding architectures or large-scale data partitioning.
• Experience with database proxies such as ProxySQL or MariaDB MaxScale for query routing and read-scaling.
• Familiarity with Bash, Python, or Go for database performance automation and stress-testing scripts.
• Familiarity with cloud-managed relational databases (e.g., AWS Aurora MySQL or GCP Cloud SQL for MySQL).