Database Administrator - Cockroach DB

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 :

- 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.

Installation and Configuration :

- Basics of CRDB, features of CRDB, advantages 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.

Skills :

- Cockroach DB, Database Administration, SQL Tuning, Cluster Management.

Skills

SQL, Troubleshooting, Database Performance Tuning, DBA, DBA Support, Database Installation, Database Maintenance, System Configuration, Cluster Management