CockroachDB Database Administrator

Senior CockroachDB Database Administrator (CockroachDB DBA)We are seeking an experienced CockroachDB Database Administrator (DBA) to design, deploy, administer, and optimize CockroachDB clusters in large-scale production environments. The ideal candidate should have hands-on experience managing distributed SQL databases, ensuring high availability, disaster recovery, performance optimization, monitoring, automation, and production support.The candidate will be responsible for maintaining highly available, fault-tolerant, multi-region CockroachDB clusters while collaborating with infrastructure, cloud, and application teams to ensure database reliability, scalability, and operational excellence.CockroachDB AdministrationDesign, deploy, configure, and manage CockroachDB clusters in production environments.Build and maintain multi-region distributed database clusters.Ensure high availability, fault tolerance, and data consistency across geographically distributed environments.Monitor cluster health, node status, replication, latency, and resource utilization.Perform database capacity planning and cluster scaling.Performance OptimizationMonitor and optimize SQL query performance.Analyze execution plans and identify bottlenecks.Optimize database schema design and indexing strategies.Resolve high-latency and throughput issues.Address hotspotting, leaseholder imbalance, and replication lag.Troubleshooting & Incident ManagementTroubleshoot complex database and infrastructure issues, including: Node failuresNetwork partitionsReplication issuesLeaseholder imbalanceRange imbalanceHigh CPU or memory utilizationStorage issuesPerformance bottlenecksParticipate in incident management and on-call support.Backup & Disaster RecoveryDesign and implement disaster recovery strategies.Configure backup and restore processes.Implement Point-in-Time Recovery (PITR).Validate backup integrity through regular recovery testing.Manage failover and failback procedures.Automation & Database OperationsAutomate provisioning, deployment, upgrades, scaling, and maintenance of CockroachDB clusters.Perform rolling upgrades with minimal or zero downtime.Develop automation scripts using Bash, Python, or similar scripting languages.Improve operational efficiency through Infrastructure as Code (IaC).Monitoring & ObservabilityMonitor database health using observability tools.Configure alerts and dashboards.Track: Cluster healthReplication statusLatencyResource utilizationStorage growthQuery performanceWork with monitoring tools such as Grafana, Prometheus, and Cloud monitoring platforms.DocumentationCreate operational runbooks.Develop Standard Operating Procedures (SOPs).Maintain architecture diagrams and recovery procedures.Document production support processes and troubleshooting guides.Required Technical SkillsDatabase TechnologiesCockroachDBDistributed SQL DatabasesSQL Performance TuningDatabase ReplicationHigh Availability (HA)Multi-region Database DeploymentDatabase ClusteringCloud & InfrastructureAWS / Azure / GCPLinux AdministrationKubernetes (Preferred)DockerNetworking FundamentalsMonitoring & ObservabilityPrometheusGrafanaCloud Monitoring ToolsPerformance MonitoringAlert ManagementAutomationBashPythonShell ScriptingTerraform (Preferred)Ansible (Preferred)Backup & RecoveryBackup & RestorePoint-in-Time Recovery (PITR)Disaster RecoveryFailover / FailbackBusiness Continuity PlanningOperationsProduction SupportIncident ManagementRoot Cause Analysis (RCA)Capacity PlanningPerformance TuningRequired QualificationsBachelor's degree in Computer Science, Information Technology, Engineering, or a related field.8–10 years of database administration experience.Strong hands-on experience with CockroachDB or other distributed SQL databases.Experience managing production database environments.Expertise in SQL performance tuning and database optimization.Experience with Linux system administration.Knowledge of cloud platforms (AWS, Azure, or GCP).Strong troubleshooting and analytical skills.Excellent communication and documentation abilities.Preferred QualificationsExperience with Kubernetes-based database deployments.Knowledge of Infrastructure as Code (Terraform, Ansible).Experience with PostgreSQL or other distributed databases.Experience with CI/CD pipelines and DevOps practices.CockroachDB certification (if available).Experience in mission-critical production support environments.