Cockroach DB Administrator

Role: Senior Cockroach DB Administrator (CRDB / Distributed SQL / High Availability) Location: Sunnyvale, CA | Austin, TX (100% On-site) Compensation: $59.00/hr on W2 Fulltime ; W2 candidate only . Duration: 12+ Months (Extendable) Position Overview Seeking an enterprise-grade CockroachDB Administrator with 8+ years of database administration experience to deploy, manage, and scale multi-region distributed CockroachDB clusters in mission-critical production settings. This 100% on-site role focuses on maintaining global data consistency, fault tolerance, range/leaseholder balancing, and low-latency throughput. The engineer will automate CRDB cluster provisioning and rolling upgrades on Kubernetes, optimize SQL query execution plans, design multi-region Disaster Recovery (DR) procedures, and participate in production incident response. Key Responsibilities • Multi-Region Cluster Operations: Design, deploy, configure, and operate multi-region CockroachDB production clusters, ensuring cross-datacenter replication, fault tolerance, and zero-downtime maintenance. • Performance Tuning & Query Optimization: Profile distributed SQL queries, resolve range imbalances, eliminate transaction hotspots, and optimize schema designs to minimize latency and maximize throughput. • Incident Diagnostics & Troubleshooting: Troubleshoot complex distributed database issues including network partitions, node failures, leaseholder shifts, replication lags, and lock contention. • Automation & Container Orchestration: Automate provisioning, scaling, patching, and rolling upgrades of CockroachDB clusters running natively on Kubernetes / cloud infrastructure. • Backup, DR & Business Continuity: Establish, test, and maintain multi-region backup and restore pipelines, point-in-time recovery (PITR) procedures, and automated failover/fallback mechanisms. • Observability & Operational Runbooks: Monitor cluster health, replication metrics, and resource utilization using modern observability tooling; create operational SOPs, runbooks, and participate in on-call rotations. Required Skillset • Experience: 8+ years of dedicated professional Database Administration experience, with significant hands-on focus on CockroachDB / Distributed SQL architectures. • CockroachDB Core: Proven expertise deploying, operating, and tuning production CockroachDB clusters across multi-region environments. • SQL & Performance Tuning: Advanced knowledge of SQL execution plans, schema design, transaction isolation levels, indexing strategies, and range balancing. • Containerization & Kubernetes: Strong operational experience running and scaling stateful database workloads on Kubernetes platforms. • HA/DR & Replication: Deep technical understanding of consensus algorithms (Raft), multi-region data replication, backup/restore workflows, and point-in-time recovery. Preferred Qualifications • CockroachDB certifications (e.g., CockroachDB Certified Professional / Admin). • Scripting and automation proficiency (Python, Shell, Go, or Terraform).