Need - Cassandra DBA - San Francisco, CA - Long Term Contract

Overview

On Site
$50 - $55
Accepts corp to corp applications
Contract - Independent
Contract - W2
Able to Provide Sponsorship

Skills

Cassandra DBA
CQL
nodetool
cqlsh
GCP

Job Details

Job Title: Cassandra DBA
Location: San Francisco, CA
Rate: $55/hr on C2C
Overview:
We are seeking a highly skilled and experienced Cassandra Database Administrator (DBA) to join our dynamic team. The Cassandra DBA will be responsible for the installation, configuration, maintenance, optimization, and security of our Apache Cassandra database clusters. This role is critical in ensuring the high availability, performance, and scalability of our mission-critical data infrastructure, supporting applications that handle massive amounts of data with no single point of failure.
Key Responsibilities:
  • Cluster Management:
    • Install, configure, and maintain Apache Cassandra database clusters in both development and production environments.
    • Perform cluster additions, removals, upgrades, and decommissioning of Cassandra nodes and data centers.
    • Configure and install monitoring agents (e.g., OpsCenter) on Cassandra servers.
    • Ensure 24/7 production database availability and participate in on-call rotations for incident and recovery calls.
  • Database Administration & Management:
    • Manage database schemas, tables, indexes, and user permissions.
    • Design and implement robust backup and disaster recovery strategies, including regular backups, recovery procedures, and retention policies.
    • Perform data migration and conversion activities.
    • Troubleshoot and resolve database-related problems, faults, and issues to ensure smooth and uninterrupted database operations.
    • Apply OS and security patches on database servers.
  • Performance Tuning & Optimization:
    • Proactively monitor and analyze Cassandra cluster performance, identifying bottlenecks and implementing optimizations.
    • Tune Cassandra configurations, compaction strategies, and JVM settings for optimal performance.
    • Optimize CQL (Cassandra Query Language) queries and schema design for efficient data retrieval and processing.
    • Conduct capacity planning to ensure databases meet current and future performance and storage demands.
  • Data Modeling & Design:
    • Collaborate with development teams to design efficient database architectures, schemas, and physical structures that align with business requirements and best practices.
    • Provide guidance on best practices for data modeling, partition key selection, clustering columns, and indexing in a NoSQL environment.
  • Security & Compliance:
    • Implement and maintain security measures, including authentication, authorization, encryption, and access controls.
    • Regularly apply security patches and updates to the database systems.
    • Ensure compliance with organizational and regulatory security standards.
  • Automation & Scripting:
    • Automate routine administrative tasks using scripting languages (e.g., Bash, Python, Ansible).
    • Develop custom alerts and monitors for database health.
  • Collaboration & Documentation:
    • Work closely with developers, system administrators, and other stakeholders to address database requirements and provide technical support.
    • Maintain detailed documentation of database configurations, processes, and maintenance activities.
    • Generate regular reports on database health, performance, and usage metrics.
Qualifications:
  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 8+ years of proven experience as a Cassandra DBA, with hands-on experience managing large-scale Apache Cassandra clusters in production environments.
  • Strong understanding of Cassandra architecture, including partitioning, replication, consistency levels, and data distribution.
  • Proficiency in CQL and experience with Cassandra tools such as nodetool, cqlsh, and DataStax OpsCenter.
  • Solid experience with Linux/Unix operating systems and shell scripting.
  • Demonstrated experience with database backup, recovery, and disaster recovery strategies.
  • Proven ability to evaluate database performance, identify bottlenecks, and implement optimizations.
  • Experience with cloud technologies (e.g., AWS, Azure, Google Cloud) and containerization (e.g., Docker) is highly desirable.
  • Familiarity with monitoring tools like Prometheus, Grafana, or equivalent.
  • Strong analytical, problem-solving, and troubleshooting skills.
  • Excellent communication (written and verbal) and interpersonal skills, with the ability to explain complex technical concepts clearly.
  • Ability to work independently and as part of a team, managing multiple tasks and priorities in a fast-paced environment.
Preferred Skills:
  • Experience with other NoSQL databases.
  • Knowledge of automation tools and DevOps practices (e.g., Ansible, Terraform).
  • Familiarity with big data ecosystems and technologies (e.g., Apache Spark, Kafka).
  • ITIL certification.
  • Experience working in an Agile methodology.


Thanks Abhi

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About iCUBE Solutions