Cassandra Admin DBA - Bangalore
Location: Bengaluru
• Experience: Mid Level
• Openings: 1
Job description
1. Job Details
Job Title: Cassandra Administrator / Database
Administrator (Cassandra Admin DBA)
Job Location: Bangalore
Work Model: Work from Office
2. Candidate Expectations
Total Experience and Relevant Experience: 3+ Years
Candidate Location: Bangalore
- Skills
– Mandatory: Cassandra database administration, Troubleshooting, Linux/Unix
administration and shell scripting
Candidate Industry: IT Services / Product Engineering
/ Cloud and Infrastructure Services / Database Operations.
3. Education and Certification
Qualification:
Bachelor's degree in Computer
Science, Information Technology, or a related discipline, as per client policy..
4. Detailed Job Description
Role Overview:
The Cassandra Admin DBA will be responsible for managing,
maintaining, monitoring, and optimizing Apache Cassandra database environments.
The role involves ensuring high availability, scalability, performance, data
consistency, security, and reliability of database clusters supporting
business-critical applications.
Key Responsibilities:
- Database
Administration: Install, configure, administer, and maintain Apache
Cassandra clusters across development, testing, staging, and production
environments.
- Cluster
Management: Manage node additions and removals, cluster expansion,
data distribution, replication strategies, and cluster health.
- Performance
Optimization: Monitor database performance, analyze latency and
throughput, identify bottlenecks, and optimize queries, data models,
compaction, and resource utilization.
- Backup
and Recovery: Implement and manage backup, restoration, and disaster
recovery procedures; regularly validate recovery readiness.
- Monitoring
and Troubleshooting: Monitor cluster health, logs, disk utilization,
CPU, memory, read/write latency, and other performance indicators;
troubleshoot database issues and perform root-cause analysis.
- High
Availability: Maintain fault-tolerant database environments and
support availability, replication, and recovery requirements.
- Security
and Access Management: Implement authentication, authorization,
role-based access controls, encryption, and database security best
practices.
- Data
Replication and Consistency: Manage replication factors, consistency
levels, and data repair operations to maintain data integrity across nodes
and data centres.
- Maintenance
and Upgrades: Perform patching, version upgrades, configuration
changes, and routine maintenance while minimizing application downtime.
- Linux
and Scripting: Use Linux/Unix commands and shell scripts to automate
database administration, monitoring, and operational tasks.
- Capacity
Planning: Forecast storage and infrastructure requirements based on
data growth, workload patterns, and application demands.
- Incident
and Change Management: Handle production incidents, participate in
on-call support where required, document resolutions, and follow
change-management procedures.
- Documentation
and Collaboration: Maintain operational runbooks, database
configurations, incident reports, and standard operating procedures;
coordinate with application, DevOps, infrastructure, and engineering
teams.
Key Deliverables:
- Stable,
reliable, and highly available Cassandra clusters.
- Improved
database performance and operational efficiency.
- Effective
backup, recovery, and disaster recovery readiness.
- Timely
resolution of database incidents and performance issues.
- Accurate
documentation and adherence to database security standards.
5. Key Skills
Mandatory Key Skills: Apache Cassandra, Cassandra Cluster Administration, Cassandra Architecture, CQL (Cassandra Query Language), Data Modelling, Cluster Installation and Configuration
Mandatory Key Skills: Apache Cassandra, Cassandra Cluster Administration, Cassandra Architecture, CQL (Cassandra Query Language), Data Modelling, Cluster Installation and Configuration
Good to Have Skills: Data Modelling, Cluster
Installation and Configuration, Shell Scripting and Automation, Database
Security