Hello
My name is Suraj Mishra and I am a
Staffing Specialist at Visionary Innovative Technology Solutions LLC. I am
reaching out to you on an exciting job opportunity with one of our clients.
Job Title: Senior Database DBA – MemSQL / SingleStore
Location: New Jersey / Irving, TX / Tampa, FL
Duration: Long term
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.
Thank You,
Suraj Mishra
|
Technical
Recruiter
|
|
|
|
|
|
|
|

  
|
E: sur...@vitsus.com
W: vitsus.com
|
|
|
Visionary Innovative Technology Solutions LLC | 276 Mulberry Street, Plantsville CT 06479
|
|
|
|
|
|
|
|
|
|
|
|
Confidentiality Notice:
This communication & accompanying documents
("this e-mail") contains confidential and/or privileged information
for exclusive use of the individual to whom it is addressed. If you are not the
intended recipient, please immediately notify the company & delete this
e-mail. Any unauthorized use or disclosure of this e-mail is strictly
prohibited. Representations in this e-mail are subject to contract. As an
e-mail user please be cautious of the technical & other vulnerabilities of
the internet which may result in malicious and/or unauthorized access to / use
/ alteration of e-mails/e-mail IDs. Thank you