Fully Remote Role, applicants across the globe welcome to apply

Company Overview

Our client is delivering high-performance, real-time solutions to their global customer base. Their extensive use of CockroachDB powers a scalable, distributed system, ensuring seamless operations in a high-traffic environment. We’re seeking talented CockroachDB Administrators to join our fully remote team, providing 24/7 support and optimization for our critical database infrastructure.

Job Overview

As a CockroachDB Administrator, you will play a pivotal role in managing, monitoring, and optimizing our CockroachDB clusters to ensure reliability, performance, and scalability, this fully remote role will be part of a team, supporting 24/7 operation. You’ll collaborate with development and DevOps teams, leveraging tools like Terraform and Kafka, and tackle challenges ranging from query optimization to multi-region monitoring. We’re hiring for both mid-level (3+ years experience) and senior-level (5+ years experience) candidates within a single, dynamic job specification.

Key Responsibilities

• Cluster Management & Optimization: Administer and scale CockroachDB clusters, ensuring high availability and performance in a high-traffic betting environment. Design efficient schemas, optimize indexes, and resolve hotspot issues.
• 24/7 Support: Provide round-the-clock monitoring and incident resolution, troubleshooting issues like slow queries, schema change impacts, or cluster failures.
• Change Data Capture (CDC): Configure and maintain CDC workflows (e.g., writing data to Kafka), mitigating challenges like full table re-emission after schema changes.
• Performance Tuning: Regularly identify and optimize bad or slow queries, collaborating with developers to align database performance with application needs.
• Monitoring & Maintenance: Enhance CockroachDB dashboards with additional tools (e.g., Prometheus, Grafana) for multi-region setups, manage jobs, and ensure security through roles and permissions.
• DevOps Integration: Use Terraform for infrastructure-as-code deployments and support containerized environments (e.g., Docker, Kubernetes).
• Leadership (Senior Level): Lead database architecture initiatives, mentor junior team members, and drive best practices adoption.

Required Skills & Qualifications

Mid-Level:

• 3+ years of experience with SQL databases, including at least 3 years with CockroachDB.
• Solid understanding of database replication, consistency, and record-writing flows (e.g., leaseholder interactions).
• Familiarity with DevOps tools (Terraform, monitoring systems) and query optimization.

Senior-Level:

• 5+ years of experience with SQL databases, including at least 5 years with CockroachDB.
• Deep knowledge of CockroachDB internals (e.g., leaseholders, ranges, CDC) and multi-region deployments.
• Proven ability to lead technical initiatives and mentor others.

General Requirements:

• Experience with CDC (e.g., Kafka integration) and troubleshooting schema change impacts.
• Comfortable with a fully remote role and flexible scheduling for 24/7 shift coverage.
• Strong problem-solving skills, with experience resolving critical database issues (e.g., cluster outages, performance bottlenecks).
• Excellent communication skills for cross-functional collaboration.

Nice-to-Have Skills

• Experience in with high-concurrency financial systems.
• Knowledge of other databases (e.g., PostgreSQL, MongoDB) for comparison and migration purposes.
• Familiarity with cloud platforms (AWS, GCP, Azure) and container orchestration (Docker, Kubernetes).

Work Environment

• Location: Fully remote.
• Schedule: Set 7 hour shift to support 24/7 operations; candidates must be adaptable to varying hours, set shift time will be confirmed once you are successful and weekend on call shift work.
• Team: Collaborate with developers, DevOps engineers, and other administrators in a fast-paced, supportive environment.

Shift is from 08:00 to 15:00 America/New_York time.