Cassandra DBA

Job description-:
• Install, configure, and maintain DATASTAX and Apache Cassandra clusters across multiple environments.
• Monitor and optimize cluster performance, including capacity planning and troubleshooting.
• Manage and tune Cassandra configuration parameters to ensure optimal performance.
• Implement and maintain data replication, backup, and recovery strategies.
• Conduct regular health checks and performance audits of the Cassandra clusters.
• Collaborate with development teams and database architects to design and implement Cassandra data models and schemas.
• Define and enforce best practices for data modeling and schema design.
• Perform schema changes and migrations while ensuring minimal downtime and data consistency. • Design scalable and efficient data models that optimize performance and ensure data integrity.
• Analyze existing data models and propose improvements for enhanced performance and scalability.
• Conduct thorough testing and validation of data models to ensure optimal performance and usability.
• Implement and enforce security measures to protect data stored in Cassandra.
• Set up and manage user accounts, roles, and permissions.
• Monitor and audit user activity to ensure compliance with security policies.
• Set up monitoring tools and dashboards to track cluster performance, utilization, and health.
• Configure alerts and notifications for critical events or potential issues.
• Respond promptly to alerts and troubleshoot any database related problems.

Qualifications and Skills:

• Proven experience as a Cassandra Administrator supporting large production Cassandra environments (DATASTA and Apache)
• Strong knowledge of Cassandra database architecture, concepts, and administration.
• Proficiency in Cassandra cluster setup, configuration, and monitoring.
• Experience with data modeling, schema design, and query optimization in Cassandra.
• Understanding of distributed systems and principles of high availability.
• Proficient in scripting languages for automation and monitoring tasks
• Knowledge on aws Infrastructure which will give enhanced performance and cost saving based on requirement (EC2 Instances, EBS volumes, EFS, instance types, IAM, Lifecycle Manager, network load balancer, AMI etc.. )
• Experience with Cost Optimization in cloud resources (Infrastructure monitoring on cloud, as every service is cost effective should be tuned accordingly for cost saving)
• AWS certification is desired