# Senior Database DBA - MemSQL / SingleStore

> Qode · New Jersey, United States (Hybrid) · Full-time · Posted 2026-06-12

**Workplace:** hybrid

## Description

Job Title: Senior Database DBA – MemSQL / SingleStore

Location: New Jersey / Irving, TX / Tampa, FL

**Role Overview**

We are seeking a Senior MemSQL / SingleStore Cluster Administrator to own and manage mission-critical, large-scale distributed database platforms. This role requires a pure Database Administrator (DBA) with deep expertise in handling petabyte-scale data, complex distributed clusters, and real-time latency-sensitive workloads.

Core Technical Expectations

Experience handling petabytes of data ingested every 15 minutes in large-scale environments.

Strong expertise managing large MemSQL / SingleStore clusters (multi-node, multi-TB to multi-PB).

Deep understanding of data distribution across aggregators and leaf nodes.

**Expertise in:**

-   Partitioning and shard key strategy
-   Data skew mitigation
-   Hot partition resolution
-   Worker node and leaf node optimization

Strong table-level knowledge including:

-   Index strategy
-   Thread management
-   Connection pooling
-   Memory limits
-   Query plan optimization

Strong understanding of different MemSQL/SingleStore versions and corresponding architectural/feature changes.

**Key Responsibilities**

End-to-end ownership of large MemSQL/SingleStore clusters (design, build, upgrade, operate, decommission).

Architect and maintain High Availability (HA) and Disaster Recovery (DR) setups including:

-   Redundancy levels
-   Availability groups
-   Cross-region replication

**Plan and execute:**

-   Cluster expansion
-   Downsizing
-   Online partition rebalancing
-   Leaf node management with minimal/no downtime

Proactively monitor cluster health, throughput, latency, and capacity; define and maintain SLAs.

Perform advanced performance tuning:

-   Schema design
-   Shard key design
-   Index strategy
-   NUMA and memory tuning
-   Workload management

Implement backup/restore strategies and regularly test DR & failover.

Lead incident response and perform deep root cause analysis.

Enforce database security best practices:

-   Authentication & authorization
-   Encryption
-   Auditing
-   Network controls

Drive automation using scripting (Python/Bash) and Infrastructure as Code.

Maintain documentation, operational runbooks, and standards.

Evaluate new MemSQL/SingleStore features and lead version upgrades and migrations**.**

**Required Experience & Skills**

10+ years of total database engineering/administration experience.

4–5+ years of deep, production-grade experience administering MemSQL/SingleStore clusters at scale.

Strong hands-on experience with:

-   Aggregators & leaf nodes
-   Licensing and memory limits
-   Cluster expansion & partition rebalancing
-   Replication & failover/failback
-   **Proven ability to diagnose:**

  

-   Locking issues
-   Data skew
-   Hot partitions
-   Bad execution plans
-   **Strong Linux system tuning knowledge:**

  

-   CPU/NUMA affinity
-   Disk & I/O optimization
-   Networking
-   ulimits & OS-level tuning
-   **Experience with monitoring & alerting tools:**

  

-   Prometheus / Grafana
-   Datadog
-   Splunk
-   ELK
-   Strong SQL expertise and scripting (Python/Bash).
-   Experience in Cloud/Container environments (AWS/Azure/GCP, Kubernetes) is highly preferred.

Excellent communication skills with ability to lead production calls and explain technical trade-offs clearly.

## Apply

[Apply at Qode](https://apply.workable.com/qodeworld/j/A226F773AF/apply)

---
Powered by [Workable](https://www.workable.com)