Prismberry Technology

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)