Cockroach DBA

Ascii Group, LLC; Austin (TX); On-site; USD 74,000 - 105,000; Full time

Job summary

Ascii Group, LLC is seeking a specialist to design, deploy, operate, and scale multi-region CockroachDB clusters from production environments in Austin, TX. You will ensure high availability and data consistency across globally distributed clusters, using observability tools to monitor health, latency, replication, and resources.

The role includes capacity planning and proactive scaling to support future growth.

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 issues, and replication lag.
• Design disaster recovery strategies (multi-region, backup/restore, failover/fallback); automate provisioning, scaling, patching, and upgrades of CRDB clusters; perform rolling upgrades with minimal downtime.

Tools

CockroachDB

Job description

The following requirement is open with our client.

Location : Austin TX (Onsite)

Rate : $65/HR on C2C

Detailed Job Description:

• Design| deploy| operate| and scale multi-region Cockroach DB 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