About the role:
Your responsibility as a Lead Cassandra database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.
Requirement:
6+ Years of experience in Configure, install, and manage Cassandra clusters.
Manage node addition and deletion in Cassandra clusters.
Monitor Cassandra clusters and implement performance monitoring.
Configure multi-DC Cassandra clusters.
Optimize Cassandra performance, including query optimization and other related optimization tools and techniques.
Implement and maintain Cassandra security and integrity controls, including backup and disaster recovery strategies.
Upgrade Cassandra clusters.
Utilize cqlsh, Grafana, and Prometheus for monitoring and administration.
Design and create database objects such as data table structures (Cassandra column families/tables).
Perform data migration, backup, restore & recovery for Cassandra.
Resolve performance issues, including blocking and deadlocks (as applicable in Cassandra's distributed context).
Implement and maintain security and integrity controls including backup and disaster recovery strategies for document management systems and MySQL databases (if these are part of the Cassandra Administrator's broader scope, otherwise this point might be less relevant for a pure Cassandra role).
Translate business requirements into technical design specifications and prepare high-level documentation for database design and database objects.
Extensive work experience on query optimization, script optimization, and other related optimization tools and techniques.
Strong understanding of Cassandra database architecture.
Experience with backup and recovery procedures specific to Cassandra.
Knowledge of database security best practices.
Experience with data migration and transformation.
Ability to work under pressure and meet deadlines.