Database Administrator

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).