Role Overview:This role involves the design, deployment, operation, and scaling of multi-region CockroachDB clusters in production environments, ensuring high availability, fault tolerance, and data consistency.
Key Responsibilities:- Design, deploy, operate, and scale multi-region CockroachDB clusters in production environments.
- Ensure high availability, fault tolerance, and data consistency for globally distributed clusters.
- Monitor cluster health, latency, replication status, and resource utilization using observability tools.
- Perform capacity planning and proactive scaling for future growth.
- Troubleshoot complex database and infrastructure issues including node failures, network partitions, leaseholder and range imbalance, replication lag, hotspotting, and high latency/throughput bottlenecks.
- Design disaster recovery strategies (multi-region, backup/restore, failover/fallback).
- Implement and test backup, restore, and point-in-time recovery processes.
- Automate provisioning, scaling, patching, and upgrades of CRDB clusters.
- Perform rolling upgrades with zero or near-zero downtime.
- Optimize SQL query performance and database schema efficiency.
- Create operational runbooks, SOPs, and on-call playbooks for CRDB.
- Participate in on-call rotations and incident response for production clusters.
Required Skills:Qualifications:- 8-10 years of experience.
- Must have LinkedIn ID of the candidate.
Preferred Skills: