CockroachDB DBA

Prophecy Technologies

$120K — $150K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8-10 years of experience in database management and operations.
  • Proficient in deploying and managing CockroachDB clusters.
  • Strong troubleshooting skills for complex database issues.
  • Experience with disaster recovery strategies and backup processes.
  • Familiarity with SQL performance optimization and database schema efficiency.

Responsibilities

  • Design, deploy, operate, and scale multi-region CockroachDB clusters.
  • Monitor health, latency, replication status, and resource use of clusters.
  • Conduct capacity planning and proactive scaling for growth.
  • Troubleshoot complex database and infrastructure issues.
  • Implement and test backup, restore, and point-in-time recovery processes.
  • Automate provisioning, scaling, and upgrades of CockroachDB clusters.
  • Create operational documentation such as runbooks and SOPs.

Benefits

  • Opportunity to work with cutting-edge database technology.
  • Engagement in multi-region infrastructure design and scaling.
  • Involvement in high availability and disaster recovery strategies.
  • Chance to automate processes, enhancing operational efficiency.
  • Opportunity to participate in on-call rotations, enhancing skill sets.
Full Job Description
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:
  • CockRoachDB

Qualifications:
  • 8-10 years of experience.
  • Must have LinkedIn ID of the candidate.

Preferred Skills:
  • N/A

Similar Jobs

More Jobs at Prophecy Technologies

More Information Technology Jobs

Find similar CockroachDB DBA jobs: