CockroachDB Database Administrator

Job Title: CockroachDB Database Administrator
Location: Sunnyvale, CA/Austin, TX (Onsite)
Duration: 6 Months

Job Description:
We are seeking an experienced CockroachDB Database Administrator to manage, optimize, and support large-scale distributed CockroachDB environments. The ideal candidate will have strong expertise in deploying and administering multi-region CockroachDB clusters, ensuring high availability, performance, scalability, and disaster recovery in mission-critical production environments.

Key Responsibilities

• Design, deploy, administer, and scale multi-region CockroachDB clusters.
• Ensure high availability, fault tolerance, and data consistency across distributed environments.
• Monitor cluster health, replication, latency, and resource utilization using observability and monitoring tools.
• Perform capacity planning and proactive scaling to support business growth.
• Troubleshoot complex database and infrastructure issues, including:
  • Node failures
  • Network partitions
  • Leaseholder and range imbalances
  • Replication lag
  • Hotspotting
  • Performance bottlenecks and high latency
• Design, implement, and validate disaster recovery strategies, including backup, restore, failover, and point-in-time recovery.
• Automate cluster provisioning, scaling, patching, and upgrades.
• Execute rolling upgrades with minimal or zero downtime.
• Optimize SQL query performance, indexing, and database schema design.
• Develop operational runbooks, SOPs, and support documentation.
• Participate in production support, on-call rotations, and incident response activities.

Required Skills

• 8–10 years of database administration experience.
• Strong hands-on experience with CockroachDB administration in production environments.
• Experience managing distributed, multi-region database clusters.
• Strong understanding of database replication, consistency, fault tolerance, and high availability.
• Experience with backup, recovery, disaster recovery, and performance tuning.
• Expertise in SQL optimization and schema design.
• Experience with monitoring and observability tools.
• Knowledge of automation and scripting for database operations.
• Strong troubleshooting and problem-solving skills.

Preferred Qualifications

• Experience with cloud platforms (AWS, Azure, or Google Cloud Platform).
• Familiarity with Kubernetes, containerized deployments, and Infrastructure as Code.
• Experience supporting mission-critical, high-availability production systems.
• Excellent communication and documentation skills.