Senior Database DBA - MemSQL / SingleStore
Qode
Job Description
Job 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.
Vacancy posted 16 days ago
Similar jobs that could be interesting for youBased on the Senior Database DBA - MemSQL / SingleStore in New Jersey vacancy
$95k - $100k
Tata Consultancy Services is seeking an experienced PostgreSQL DBA to manage, maintain, and optimize PostgreSQL environments across... ...and disaster recovery. This role requires hands-on experience in database administration, high availability solutions, and cloud integration...SeniorDatabase- A technology services provider is seeking a Senior Database Administrator to manage and maintain crucial databases. This role involves ensuring high performance and security across multiple platforms, providing ongoing support, and implementing database upgrades. The ideal...SeniorDatabase
- Tata Consultancy Services Limited is seeking an experienced Postgres Database Administrator for their Mount Laurel, NJ location. This role involves managing and optimizing PostgreSQL environments, ensuring data integrity and business continuity through effective backup...SeniorDatabase
- A national recruiting company is seeking a DBA to manage and maintain over 50 MySQL Database instances. The ideal candidate should have at least 5 years of database administration experience, strong skills in MySQL and Linux, and the ability to work collaboratively with...SeniorDatabaseLocal area
- A prominent IT solutions company is seeking an SAP BRIM - Database Administrator for its Middletown, PA office. This full-time role involves managing databases for SAP BRIM and S/4HANA while ensuring performance, security, and compliance with regulations. Candidates should...SeniorDatabaseRemote jobFull timeWork at officeWork from homeFlexible hours
- Parsippany-Troy Hills, New Jersey, United States As the Sr. DBA you will be responsible for coordinating changes to computer databases, including testing and implementation of the database while applying best practices for database management systems. This is a “hands...SeniorDatabaseContract workWork at office
- TechDigital Group is looking for an experienced Database Administrator focusing on Mainframe and DB2 in Holmdel Township, New Jersey. The ideal candidate will have over 10 years of experience, proficient in VSAM, DB2, and COBOL data structures. Responsibilities include...SeniorDatabase
- Title: MYSQL Database Administrator Infrastructure Location: Berkeley Heights, NJ (5 Days Onsite) Job Description: We are seeking aMYSQL Database Administrator Infrastructure Resourcehaving 8+ years ofprofessional experience in responsible for the design, implementation...SeniorDatabase
- Digital Technologies, LLC is seeking a Senior Database Administrator to support legacy and cloud-based database environments. This position... ...system stability. The ideal candidate should have over 5 years of DBA experience with strong skills in RDBMS, indexing strategies,...SeniorDatabase
- ...Business Suite (EBS), and complex Oracle database upgrades, including end-to-end migrations... ...Local Candidates Only. You will serve as a senior technical authority, driving... ...Qualifications 20+ years of hands‑on Oracle DBA experience. Extensive experience upgrading...SeniorDatabaseLocal area
- Servsys Corporation is seeking an experienced Database Administrator to manage Oracle (19c+) and PostgreSQL (14+) environments. The role includes optimizing queries, managing database provisioning, and ensuring robust monitoring practices. The ideal candidate will have...SeniorDatabaseLocal area
- Cortes 23 is looking for a Senior SQL Database Administrator to manage their database infrastructure. This role involves designing, installing, configuring, and maintaining SQL Server databases while ensuring the security and integrity of data. The ideal candidate will...SeniorDatabaseRemote job
- eGrove Systems Corporation is looking for a DATABASE ADMINISTRATOR in East Brunswick Township, New Jersey. The ideal candidate will have 15 years of experience in database administration with strong knowledge of SQL Server and Oracle. Responsibilities include daily database...SeniorDatabase
- ...Preference for local resource Job type: W2 Key Responsibilities Database Administration Administer, configure, and maintain Oracle (19c+)... ...documentation Required Qualifications 8+ years of hands-on DBA experience with Oracle (11g/19c) and PostgreSQL (12+) Deep expertise...SeniorDatabaseLocal area
- Job Title: Senior Database Administrator Job ID: 2023-12227 Job Location: Alpharetta, GA or Berkeley Heights, NJ Job Travel Location(s):... ...Networker, db2top, CA7 scheduler and shell scripting, and routine DBA activities. Skills and Experience Required Required 5 years...SeniorDatabase
$83 - $93 per hour
Sunrise Systems, Inc. is seeking a Senior Database Administrator in Newark, NJ. This role demands extensive experience with Oracle Exadata and E-Business Suite, focusing on database upgrades, cloud migrations, and performance tuning. The ideal candidate will lead modernization...SeniorDatabaseHourly pay- A recruitment agency is seeking a Senior Database Administrator (Sr. DBA) in Parsippany-Troy Hills, NJ. This hands-on role involves coordinating database changes, optimizing SQL Server performance, and ensuring operational readiness. Candidates must have over 7 years of...SeniorDatabaseContract workWork at office
- ...management firm located in Florham Park, NJ, is seeking a SQL Server Database Administrator. The role involves managing database operations,... ...'s degree in a related field and at least 5 years of SQL Server DBA experience. Familiarity with equity market data is a plus. This...SeniorDatabase
- Senior Database Administrator ( DBA ) to join a fast-paced, multi-tasking, collaborative infrastructure team supporting both legacy and cloud-based database environments. This role requires deep RDBMS experience (SQL Server, Oracle, AWS RDS, DMS) and the ability to work...SeniorDatabasePermanent employmentContract workLocal area
- Tech Mirrors is seeking a Senior Database Administrator for a 12+ month contract based in Newark, NJ. The ideal candidate will manage complex... ...Required qualifications include 20+ years of hands-on Oracle DBA experience, deep expertise with Oracle Exadata, and strong communication...SeniorDatabaseContract workLocal area
- ...can become the best version of yourself and thrive professionally and personally. What you’ll do We are seeking a Senior SQL Database Administrator (DBA) to manage our database infrastructure. The ideal candidate will ensure the security, integrity, and performance of...SeniorDatabaseRemote job
- A leading tech firm in Newark, NJ seeks a Senior Oracle Database Administrator with over 20 years of experience. This role focuses on driving architectural decisions, leading complex database migrations, and mentoring teams. Key responsibilities include modernizing database...SeniorDatabase
$128k - $216k
Fiserv in Berkeley Heights is seeking a Senior Oracle Database Engineer responsible for implementing new technologies and supporting operations on multiple Oracle databases in a high-availability environment. Candidates must have over 8 years of experience and proficiency...SeniorDatabase$189.59k
Intuitive Technology Partners, Inc. is seeking a full-time Database Architect based in Iselin, New Jersey or remote in the United States. The role involves executing service delivery and technology roadmaps while providing expert guidance on Oracle databases and ERP systems...SeniorDatabaseFull timeRemote work$95k - $100k
Job Description Experienced Postgres Database Administrator to manage, maintain, and optimize PostgreSQL environments across on-premises... ...strategies from on‑premises to cloud platforms. Familiarity with Oracle DBA, RMAN, Goldengate, Exadata. Proficiency in backup, recovery,...Database- ...with deep organizational insights, all aimed at elevating our civilian and military aviation partners. Job Summary: The Senior Database Administrator provides advanced database engineering, administration, sustainment, and modernization support for FAA operational...SeniorDatabaseWork at officeLocal area
- Iconectiv,-Llc. is looking for a Sr. Software Engineer with expertise in Oracle Database to work in a hybrid model from Bridgewater, NJ. Responsibilities include developing software that aligns with customer needs and business objectives, while ensuring high quality and...SeniorDatabase
- GAR Technologies Inc. is seeking a Senior Software Developer located in Mount Laurel, NJ, with responsibilities including Oracle Cloud Infrastructure management and database optimization. The role involves understanding scripts in Python and JSON, and installation/configuration...SeniorDatabase
- ...Hoboken NJ Onsite. Our client is interested in hiring a Teradata DBA who can use Data Modeling, SQL, and Microstrategy. Please let... ...visually and code comments) Code changes to support scripts that are database agnostic and make changes to components of GIDS references to...DatabaseContract workLocal areaImmediate startRemote work
- Job Title: Open-Source DBA Job ID: 2024-13154 Job Location: Berkeley Heights, NJ or Alpharetta, GA (100% Onsite) Job Travel Location... ...other tools to ensure resource sizing is sufficient Identify database bottlenecks, provide remediation steps, implement database backup...DatabaseWork experience placement
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Database DBA - MemSQL / SingleStore. Be the first to apply!
Related searches
- senior compensation manager New Jersey
- senior vice president of operations New Jersey
- senior manager creative operations New Jersey
- senior storage engineer New Jersey
- senior hvac project manager New Jersey
- senior principal cloud computing engineer New Jersey
- senior cybersecurity engineer New Jersey
- senior financial analyst fp&a New Jersey
- senior manager accenture New Jersey
- senior marketing project manager New Jersey