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 :
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).(ref : hirist.tech)