Senior Database DBA – MemSQL / SingleStore-Hybrid with Multiple location

We are seeking a Senior SingleStore (MemSQL) Database Administrator to manage and optimize large-scale distributed database environments supporting mission-critical applications. The ideal candidate will have extensive experience with SingleStore/MemSQL cluster administration, performance tuning, high availability architectures, and petabyte-scale data platforms.

---

Key Responsibilities

< data-start=574 data-end=627>Database Administration & Cluster Management

• Design, deploy, administer, and maintain large-scale SingleStore (MemSQL) clusters.
• Manage distributed database environments handling multi-terabyte to petabyte-scale datasets.
• Monitor cluster health, performance, availability, and capacity utilization.
• Perform cluster expansion, node provisioning, partition rebalancing, and infrastructure scaling.
• Lead database upgrades, migrations, patching, and lifecycle management.

< data-start=1062 data-end=1095>Performance Optimization

• Design and optimize shard keys, partitioning strategies, and data distribution models.
• Identify and resolve data skew, hot partitions, and query bottlenecks.
• Optimize indexing strategies, execution plans, memory utilization, and workload distribution.
• Perform advanced SQL tuning and database performance analysis.
• Configure connection management, thread allocation, and resource governance.

< data-start=1499 data-end=1545>High Availability & Disaster Recovery

• Design and maintain highly available database architectures.
• Implement replication, failover, failback, and disaster recovery solutions.
• Manage cross-region replication and business continuity strategies.
• Develop and test backup, recovery, and disaster recovery procedures.

< data-start=1829 data-end=1865>Infrastructure & Automation

• Automate operational tasks using Python, Bash, and Infrastructure-as-Code methodologies.
• Collaborate with cloud and platform engineering teams on Kubernetes and cloud deployments.
• Maintain operational documentation, runbooks, and support procedures.
• Implement monitoring, alerting, and observability solutions.

< data-start=2186 data-end=2216>Security & Governance

• Enforce database security standards including authentication, authorization, encryption, and auditing.
• Implement compliance and access control policies.
• Support security reviews and vulnerability remediation activities.

---

Required Skills & Qualifications

• 10+ years of database administration and engineering experience.
• 4+ years of hands-on experience administering SingleStore (MemSQL) clusters in production environments.
• Strong expertise in:
  • Aggregator and Leaf Node architecture
  • Partitioning and shard key design
  • Cluster expansion and rebalancing
  • Replication and failover management
  • Query performance tuning
  • Index optimization
  • Memory and resource management
• Strong SQL development and troubleshooting skills.
• Experience diagnosing:
  • Data skew
  • Hot partitions
  • Locking/contention issues
  • Inefficient execution plans
• Strong Linux administration and performance tuning experience.
• Excellent problem-solving and incident management skills.