CockroachDB Database Administrator

Job Title: CockroachDB Database Administrator / Site Reliability Engineer (SRE)

Location: Delhi NCR, Bangalore, Pune, Hyderabad, Kochi

Experience: 5+ Years

Employment Type: Full-Time

Job Summary We are seeking an experienced

CockroachDB Administrator / SRE to manage, operate, and optimize mission-critical CockroachDB clusters in distributed production environments. The ideal candidate will have strong expertise in distributed database architecture, cloud infrastructure, automation, performance tuning, and high-availability systems. The role involves ensuring reliability, scalability, security, and operational excellence of globally distributed CockroachDB deployments. Key Responsibilities Cluster Administration & Operations

• Design, deploy, configure, and maintain multi-region CockroachDB clusters.
• Ensure high availability, fault tolerance, and data consistency across geographically distributed environments.
• Monitor database health, replication status, cluster performance, and resource utilization.
• Perform capacity planning and implement proactive scaling strategies. Performance Optimization
• Analyze and optimize SQL queries, indexes, and schema designs.
• Identify and resolve performance bottlenecks related to throughput, latency, and resource consumption.
• Monitor and mitigate hotspotting, leaseholder imbalance, and range distribution issues.
• Implement best practices for database tuning and workload optimization. Incident Management & Troubleshooting
• Diagnose and resolve complex production issues including: + Node failures + Network partitions + Replication lag + Leaseholder/range imbalances + Cluster connectivity issues + High latency and throughput bottlenecks
• Participate in incident response and root cause analysis activities.
• Develop preventive measures to improve cluster resilience. Disaster Recovery & Business Continuity
• Design and implement backup, restore, and Point-in-Time Recovery (PITR) strategies.
• Establish disaster recovery procedures for multi-region deployments.
• Conduct regular DR drills, failover, and fallback testing.
• Ensure compliance with RPO and RTO objectives. Automation & Infrastructure Management
• Automate cluster provisioning, upgrades, patching, monitoring, and maintenance activities.
• Develop Infrastructure-as-Code solutions using Terraform, Ansible, or similar tools.
• Perform rolling upgrades with minimal or zero downtime.
• Integrate CockroachDB operations with CI/CD pipelines. Documentation & Governance
• Create and maintain operational runbooks, SOPs, troubleshooting guides, and on-call playbooks.
• Document architecture, deployment procedures, and operational standards.
• Ensure adherence to security, compliance, and database governance requirements. Required Skills & Experience Must-Have Skills
• 5+ years of experience in Database Administration, SRE, or Production Support roles.
• Hands-on experience with CockroachDB in production environments.
• Strong understanding of distributed database architectures and consensus protocols.
• Experience managing multi-region and high-availability database deployments.
• Expertise in SQL performance tuning, indexing, and query optimization.
• Experience with backup, recovery, replication, and disaster recovery planning.
• Knowledge of Linux system administration and troubleshooting.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Proficiency in scripting using Python, Shell, or Go.
• Experience with monitoring tools such as Prometheus, Grafana, Datadog, or similar. Good-to-Have Skills
• Experience with Kubernetes and containerized database deployments.
• Knowledge of Terraform, Ansible, or Infrastructure-as-Code tools.
• Experience with distributed systems troubleshooting and networking concepts.
• Familiarity with CI/CD pipelines and DevOps practices.
• Understanding of database security and compliance standards. Preferred Qualifications
• Bachelor's degree in Computer Science, Information Technology, or related field.
• CockroachDB certifications or relevant cloud/database certifications are preferred.
• Experience supporting large-scale, mission-critical production environments. Key Competencies
• Strong analytical and problem-solving skills.
• Excellent troubleshooting and debugging capabilities.
• Ability to work in 24x7 production support environments.
• Effective communication and stakeholder management skills.
• Strong documentation and process-oriented mindset.

Location: Delhi NCR | Bangalore | Pune | Hyderabad | Kochi

Experience: 5+ Years

Notice Period: Immediate to 30 Days Preferred.