MemSQL DBA | Irving, TX (Hybrid) | Contract

Overview

Hybrid
Depends on Experience
Contract - Independent
Contract - W2
No Travel Required

Skills

Apache Cassandra
SQL
Scripting
Python
Database Architecture
Database Security
Continuous Integration
DevOps

Job Details

Job Description:
We are seeking a skilled and experienced MemSQL DBA to join our team. The ideal candidate will be responsible for managing and optimizing MemSQL clusters, ensuring high availability, scalability, and performance. This role requires close collaboration with developers, system administrators, and other stakeholders to align database architecture with business goals.

Responsibilities:

  • Install, configure, and maintain MemSQL databases.

  • Monitor, diagnose, and resolve database issues related to performance, availability, and security.

  • Manage MemSQL clusters with minimal downtime, ensuring proper replication, backup, and recovery.

  • Analyze and optimize query performance using indexing, sharding, and partitioning strategies.

  • Collaborate with developers to tune SQL queries and optimize schema design.

  • Design and implement disaster recovery and high-availability solutions.

  • Ensure database security through access control, encryption, and auditing.

  • Generate reports on database performance, availability, and capacity.

  • Maintain documentation on configurations, benchmarks, and troubleshooting procedures.

Required Skills & Qualifications:

  • Proven experience as a DBA specializing in MemSQL or similar distributed SQL databases.

  • Strong understanding of MemSQL architecture, including sharding, replication, and high availability.

  • Expertise in SQL query optimization and performance tuning.

  • Experience with cloud environments (AWS, Google Cloud Platform, or Azure).

  • Knowledge of backup, recovery, and disaster recovery strategies.

  • Familiarity with monitoring tools (e.g., Prometheus, Grafana).

  • Strong communication and collaboration skills.

Preferred Skills:

  • Experience with NoSQL/NewSQL databases (Cassandra, CockroachDB, etc.).

  • Familiarity with DevOps practices and CI/CD pipelines.

  • Scripting skills (Python, Bash) for automation.

  • Knowledge of Docker and Kubernetes for database orchestration.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About GLOBAL IT CON LLC