Database Administrator

Project Role : Database Administrator
Project Role Description : Design, implement and maintain databases. Install database management systems (DMBS). Develop procedures for day-to-day maintenance and problem resolution.
Must have skills : Apache Cassandra
Good to have skills : NA
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education
Job Summary: We are looking for a seasoned Cassandra / DataStax Database Administrator (DBA) with over 6 years of experience in database administration. The ideal candidate will have deep expertise in managing Apache Cassandra or DataStax Enterprise (DSE) environments, along with strong proficiency in Linux systems and scripting (Bash, Python, etc.). You will be responsible for ensuring the performance, availability, and scalability of distributed database systems in mission-critical environments. Key Responsibilities: • Design, deploy, and maintain Cassandra or DataStax clusters in production and non-production environments. • Perform data modeling, replication strategy design, and capacity planning. • Monitor and tune database performance using tools like OpsCenter, Prometheus, Grafana, etc. • Implement and manage backup, restore, and disaster recovery strategies. • Automate operational tasks using shell scripts, Python, or Ansible. • Troubleshoot and resolve complex database issues and performance bottlenecks. • Collaborate with development, DevOps, and infrastructure teams to support application needs. • Ensure database security, compliance, and adherence to best practices. • Maintain detailed documentation of database configurations, procedures, and policies. • Participate in 24x7 on-call support rotation for production systems. Required Skills: • 6+ years of experience in Database Administration, with at least 3+ years in Cassandra or DataStax Enterprise. • Strong understanding of Cassandra architecture, internals, and distributed systems. • Proficiency in Linux/Unix system administration. • Hands-on experience with scripting languages such as Bash, Python, or Perl. • Experience with monitoring and alerting tools (e.g., OpsCenter, Prometheus, Grafana). • Solid understanding of CQL (Cassandra Query Language) and performance tuning. Preferred Qualifications: • Experience with DataStax tools like DSE Search, DSE Graph, and DSE Analytics. • Exposure to CI/CD pipelines and infrastructure as code (Terraform, Ansible). • Relevant certifications in Cassandra, DataStax, or Linux administration.