What are the responsibilities and job description for the Cockroach DBA position at People Consultancy Services (PCS)?
New Position Open:
Only 1 round interview
Cockroach DataBase Administrator
Sunnyvale, CA - onsite
Contract
Role Descriptions:
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 Hot spotting 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