Senior Database Administrator (DBA) — Performance & Load Tuning

MySQL
UNITED STATES
October 20, 2026
Full Time
Apply Now

Job Description

Company: OmegaHires
Location: Spreedly
Workplace Type: Hybrid
Employment Type: Contract

About the Role

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.

What You’ll Do / Key Responsibilities

  • Performance Analysis: Analyze database behavior under extreme stress, identifying performance ceilings and advising on structural fixes.
  • Query Optimization: Deep dive into query execution plan analysis, indexing strategies, buffer pool optimization, and lock/latch contention analysis.
  • Replication Management: Manage and troubleshoot complex replication topologies (Master-Replica, Galera Cluster, or InnoDB Cluster) and diagnose replication lag under load.
  • Monitoring & Diagnostics: Utilize database monitoring tools including Percona Monitoring and Management (PMM), Performance_Schema, sys schema, Slow Query Logs, or Datadog/Grafana DB metrics.
  • Architecture & Scaling: Partner with engineering leadership to implement schema redesigns, connection pooling via ProxySQL/MaxScale, or partition strategies.

Requirements & Qualifications

  • Hands-on DBA Experience: 5+ years of hands-on DBA experience with MariaDB and MySQL in high-concurrency production environments.
  • Deep Technical Expertise: Deep expertise in query execution plan analysis, indexing strategies, buffer pool optimization, and lock/latch contention analysis.
  • Replication Experience: Solid track record in managing replication topologies (Master-Replica, Galera Cluster, or InnoDB Cluster) and diagnosing replication lag.
  • Tooling Proficiency: Proficiency with database monitoring and diagnostic tools such as PMM, Performance_Schema, sys schema, and Slow Query Logs.
  • Structural Optimization: Demonstrated experience identifying performance bottlenecks and implementing structural fixes like schema redesigns and partition strategies.

Preferred / Bonus Qualifications (if applicable)

  • 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 such as AWS Aurora MySQL or GCP Cloud SQL for MySQL.

Related Jobs