Job description :

A Cassandra/Aerospike DBA (Database Administrator) is responsible for the administration, maintenance, and optimization of Cassandra/Aerospike databases within an organization.

They play a crucial role in ensuring the availability, performance, and scalability of the Cassandra/Aerospike database environment.

Responsibilities :

Database Administration :

- Install, configure, and maintain Cassandra/Aerospike database clusters in both development and production environments.

- Manage database schemas, tables, indexes, and user permissions.

- Perform database backups, recovery, and restoration activities.

Performance Monitoring and Tuning :

- Monitor the performance and health of Cassandra/Aerospike clusters.

- Identify and resolve performance bottlenecks, slow queries, and resource utilization issues.

- Optimize database configurations, query performance, and data modeling for improved efficiency and scalability.

Capacity Planning :

- Monitor database growth and plan for future capacity needs.

- Estimate storage requirements and work with infrastructure teams to ensure adequate resources are provisioned.

- Scale up or scale out the database infrastructure as needed to accommodate data growth.

Data Replication and High Availability :

- Configure and manage Cassandra/Aerospike replication strategies to ensure data availability and durability.

- Implement data replication across multiple data centers and handle replication challenges, such as consistency and latency.

Security and Access Control :

- Implement and enforce database security measures, including authentication, authorization, and encryption.

- Set up user roles and permissions to control access to databases and data.

- Regularly review and update security configurations to address emerging threats and vulnerabilities.

Database Monitoring and Alerting :

- Set up database monitoring tools to proactively identify performance issues, errors, and anomalies.

- Create and configure alerts to notify relevant teams of critical database events.

- Respond to database alerts and take appropriate actions to resolve issues.

- Collaborate with development and DevOps teams to design and implement data models and deployment strategies.

- Create and maintain technical documentation and standard operating procedures (SOPs).

- Automate operational tasks using scripts and tools (e.g., Ansible, Bash, Python).