> Markdown version of [/jobs/ext/565464-senior-database-dba-memsql-singlestore](https://www.wearedevelopers.com/jobs/ext/565464-senior-database-dba-memsql-singlestore). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Database DBA - MemSQL / SingleStore - **Company:** Qode LLC - **Location:** Irving, TX, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Microsoft Azure, Bash Shell, Cloud Computing, Databases, Data Distribution Service, Database Security, Shard (Database Architecture), Linux, Disaster Recovery, Distributed Data Store, Python (Programming Language), Node.Js, Performance Tuning, Prometheus, Datadog, Scripting, System Availability, Grafana, Kubernetes, Splunk, MemSQL - **Published:** June 14, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=fd195c57651005ce ## About the Role Do you have experience in System tuning?, 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., 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. ## Description 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. ## Related Videos - [Our journey with Spring Boot in a microservice architecture](https://www.wearedevelopers.com/videos/511-our-journey-with-spring-boot-in-a-microservice-architecture) - [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Docker exec without Docker](https://www.wearedevelopers.com/videos/1094-docker-exec-without-docker) - [Database Magic behind 40 Million operations/s](https://www.wearedevelopers.com/videos/748-database-magic-behind-40-million-operations-s) - [Discover the open source trio you didn’t expect: .NET and PostgreSQL on Linux](https://www.wearedevelopers.com/videos/2042-discover-the-open-source-trio-you-didn-t-expect-net-and-postgresql-on-linux) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Introducing Redis Agent Memory Server](https://www.wearedevelopers.com/magazine/699-introducing-redis-agent-memory-server) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [SQL Murder Mystery: A game for hobby detectives who want to learn SQL](https://www.wearedevelopers.com/magazine/38-sql-murder-mystery-a-game-for-hobby-detectives-who-want-to-learn-sql)