Database Engineer - NoSQL (5-8 yrs)

We are looking for an experienced AWS/Azure - Cassandra & Scylla DB Engineer to manage and optimize our large-scale NoSQL database clusters. The ideal candidate will have expertise in handling high-performance databases, automation, monitoring, and troubleshooting critical database issues.

Key Responsibilities :

- Act as the subject matter expert for NoSQL databases, specifically Cassandra and ScyllaDB.

- Stay up to date with the latest advancements in the NoSQL space and recommend best practices.

- Review and optimize data models created by application teams to ensure efficiency and scalability.

- Manage Cassandra and Scylla clusters with a focus on capacity management, cost optimization, high availability, and performance.

- Work with large database clusters handling 1M+ IOPS in aggregate.

- Automate database tasks to reduce operational toil, including monitoring, alerting, and provisioning.

- Develop and maintain runbooks for database incident management.

- Implement backup and restore strategies to ensure minimal downtime and data integrity.

- Troubleshoot and resolve issues related to node failures, table data inconsistencies, high load, and connectivity problems.

- Participate in on-call rotation to provide support for production issues.

Mandatory Qualifications :

- Bachelor's/Master's degree in Engineering, Computer Science, or a related field from a reputed institution.

- 5+ years of experience in SQL and NoSQL databases.

- Hands-on experience managing large-scale Cassandra and Scylla clusters, with a deep understanding of :

1. Architecture and storage mechanisms

2. Replication and consistency models

3. Schema design

4. System tables, logs, and database processes

5. CQL and database query optimization

- Expertise in installation, configuration, upgrades, OS patching, certificate management, and scaling of Cassandra and Scylla clusters.

- Experience in setting up and managing backup/restore mechanisms with short RTO and RPO objectives.

- Strong scripting and automation skills using Terraform, Python, or Bash.

- Experience with monitoring tools such as Grafana, Prometheus, New Relic, or Datadog.

- Solid experience working with AWS services, with AWS certification preferred.

Preferred Qualifications :

- Experience with managed Cassandra solutions (e.g., InstaClustr, Datastax Astra).

- Exposure to cloud-native distributed databases such as TiDB, CockroachDB.

- Experience with MySQL and/or PostgreSQL on Linux.

- Hands-on experience working with Azure cloud services.

- Strong problem-solving skills and ability to work in a fast-paced, agile environment.

- Excellent communication and stakeholder management skills.