Cockroach DBA

METRIX IT SOLUTIONS INC; Austin (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

METRIX IT SOLUTIONS INC is seeking a senior database engineer to design, deploy, and manage multi-region CockroachDB clusters in production. The role focuses on high availability, data consistency, and scalable capacity planning for global deployments.

You will monitor cluster health using observability tools, troubleshoot complex issues, and automate provisioning, scaling, patching, and upgrades with rolling upgrades to minimize downtime.

Qualifications

• Experience with CockroachDB or large-scale distributed databases.
• Ability to design multi-region deployments and disaster recovery strategies.
• Strong knowledge of SQL tuning and query optimization.
• Familiarity with observability, monitoring, and incident response.

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, replication lag, and hotspotting.
• Automate provisioning, scaling, patching, and upgrades of CRDB clusters.
• Perform rolling upgrades with minimal downtime and optimize SQL performance.
• Create runbooks, SOPs, and on-call playbooks for CRDB; participate in on-call rotations and incident response.

Skills

CockroachDB

Distributed databases

High availability

SQL performance

Observability tools

Tools

Kubernetes

Job description

• 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