What are the responsibilities and job description for the Cockroach DBA position at AceStack?
Role: Cockroach DBA
Location: Sunnyvale, CA or Austin, TX (5x/ week onsite)
Duration: 6 months
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
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