Cockroach DB Professional

Required Experience

• Experience supporting large-scale production database environments.

Role Summary

• We are seeking an experienced Cockroach DB Database Administrator (DBA) to install, configure, administer, monitor, and optimize Cockroach DB (CRDB) environments.
• The ideal candidate should have strong expertise in distributed database technologies, cluster management, performance tuning, backup and recovery, replication, high availability, and database security.

Key Responsibilities : -

• Database Administration
• Install, configure, and maintain Cockroach DB clusters in development, test, and production environments.
• Monitor database performance and ensure high availability and security
• Perform routine database maintenance tasks, including backups, restores, and upgrades.
• Troubleshoot and resolve database-related issues.
• Exposure to Logical and Physical replication.
• Hardware requirement
• Installation
• Basics of CRDB, features of CRDB, adavantages of CRDB over RDBMS and or nosql
• Upgrade (minor version and major) and downgrade
• Setup Local/Single-Node/Multi-Node Cluster
• Create Database, User, Table and Index etc
• Security standards and Auditing
• SQL Tuning with EXPLAIN, Replication & Rebalancing, Fault Tolerance & Recovery
• SwitchOver Physical Cluster Replication (PCR)
• Cluster Patching
• Soft Skills
• Strong analytical and troubleshooting skills.
• Excellent written and verbal communication skills.
• Ability to work independently and in a collaborative team environment.
• Strong documentation and stakeholder management skills.
• Ability to manage multiple priorities in a fast-paced environment
• Good written and verbal communication.
• Location - Pune , Bangalore , Hyderabad , Delhi / NCR