PitchMeAI
Pythian

Cassandra Database Consultant

Pythian · India

  • Hybrid
  • Full-time
  • $120,000 / year
  • India

Job highlights

  • Design and implement new Cassandra deployments.
  • Debug critical production environments.
  • Evaluate existing clusters and recommend best practices.
  • Automate operational procedures and train junior members.
  • Work remotely with a competitive total rewards package.

About the role

About Pythian

At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. Pythian, a multinational company, was founded in 1997 and started by ensuring the reliability and performance of mission-critical databases. We quickly earned a reputation for solving tough data challenges. We were there when the industry moved from on-premises to cloud environments, and as enterprises sought more from their data, we expanded our competencies to include advanced analytics.

Today, we empower organizations to embrace transformation and leverage advanced technologies, including AI, to stay competitive. We deliver innovative solutions that meet each client’s data goals and have built strong partnerships with Google Cloud, AWS, Microsoft, Oracle, SAP, and Snowflake. The powerful combination of our extensive expertise in data and cloud and our ability to keep on top of the latest bleeding edge technologies make us the perfect partner to help mid and large-sized businesses transform to stay ahead in today’s rapidly changing digital economy.

Why You

Are you an experienced Cassandra DBA? Are you passionate about planning, designing and implementing new solutions? Do you enjoy evaluating existing solutions and helping to build automation tooling and processes to improve systems?

Working as a Cassandra Database Consultant at Pythian can hone your skills, helping you grow in your career with a breadth of knowledge in platforms and technologies that few professionals can claim.

If this is you, and you wonder what it would be like to work at Pythian, reach out to us and find out!

Intrigued to see what a life is like at Pythian? Check out #pythianlife on LinkedIn and follow @loveyourdata on Instagram!

Not the right job for you? Check out what other great jobs Pythian has open around the world! Pythian Careers

What You Will Be Doing

  • Focus on project work, debugging performance degradations, audits, and health checks.
  • Design and help implement new Cassandra deployments.
  • Evaluate existing clusters and provide recommendations on best practices.
  • Debug high priority issues on mission critical production environments.
  • Support DSE Enterprise environment, including Search and Analytics.
  • Support Cassandra-related open-source tools, like Cassandra Medusa and Cassandra Reaper.
  • Engage with the Cassandra community through user lists, irc, blog posts, webinars, and open source projects.
  • Contribute to rapid brainstorming, designing and developing of prototypes.
  • Automate and provide documentation on operational procedures.
  • Train and mentor junior team members.
  • Provide performance and forecast reports on the health and load of critical business processes to help ensure the infrastructure has adequate capacity.
  • Participate in company, and team meetings.
  • Continued education in Pythian’s Operations as a Service supported stack.
  • Provide on-call support in your team’s on-call rotational schedule.

What We Need From You

While we understand you might not have everything on the list, to be successful you are likely to have skills and experience such as:

  • A Bachelor's or Master's degree in Computer Science or equivalent practical experience.
  • Over 3 years of experience with NoSQL databases such as Cassandra, Solr, Scylla, CockroachDB. Cassandra experience preferred.
  • Proficiency in DSE Enterprise environment, including Search and Analytics
  • Proficiency in Cassandra-related open-source tools, like Cassandra Medusa and Cassandra Reaper.
  • Proficiency in at least one programming language (e.g., Shell, Java, Go, C#, C++, Ruby, Python, Ansible), with Shell and Python being preferred.
  • Experience with cloud platforms (AWS, GCP, Azure)
  • Experience with web applications, distributed systems and databases.
  • Familiarity with multiple orchestration and configuration management systems.
  • Understanding of continuous integration and automation practices.
  • Knowledge of multiple monitoring, alerting and metric collection systems.
  • An understanding of current IT service standards, such as ITIL.
  • Exceptional oral and written communication skills.
  • A self-motivated and directed approach to working in a demanding, fast-paced environment.
  • Meticulous attention to detail.
  • Strong active listening skills.
  • Robust analytical, evaluative, and problem-solving capabilities.
  • Highly effective multitasking and organizational skills.

What You Will Receive

Love your career: Competitive total rewards package. Blog during work hours; take a day off and volunteer for your favorite charity.

Love your work/life balance: Flexibly work remotely from your home, there’s no daily travel requirement to an office! All you need is a stable internet connection.

Love your coworkers: Collaborate with some of the best and brightest in the industry!

Love your development: Hone your skills or learn new ones with our substantial training allowance; participate in professional development days, attend training, become certified, whatever you like!

Love your workspace: We give you all the equipment you need to work from home including a laptop with your choice of OS, and an annual budget to personalize your work environment!

Love yourself: Pythian cares about the health and well-being of our team. You will have an annual wellness budget to make yourself a priority (use it on gym memberships, massages, fitness and more). Additionally, you will receive a generous amount of paid vacation and sick days, as well as a day off to volunteer for your favorite charity.

Hiring Disclaimer

The successful applicant will need to fulfill the requirements necessary to obtain a background check.Accommodations are available upon request for candidates taking part in any aspect of the selection process.

AI Disclaimer

Pythian may utilize Enterprise Generative Artificial Intelligence (AI) tools or features throughout its hiring process. These tools help us manage high volumes of applications efficiently and may be employed to review applications, analyze resumes, and assist with other recruitment steps. While Pythian uses AI in its hiring process, it does not substitute for human judgment. Our Talent Acquisition Team reviews all AI-generated recommendations, and the system is subject to regular bias audits to ensure fairness and compliance with all applicable employment and human rights laws. All final hiring decisions are made by, and remain the responsibility of, human decision-makers. By applying for this position, you consent to Pythian’s use of these AI tools in the evaluation of your application. You have the right to request a human review of any solely AI-driven decision or to request an accommodation. Should you require further details regarding the processing of your data, please reach out to us.

Key skills/competency

  • Cassandra Database Consulting
  • NoSQL Databases
  • DSE Enterprise
  • Performance Tuning
  • System Design
  • Automation
  • Cloud Platforms (AWS, GCP, Azure)
  • Programming Languages (Shell, Python)
  • Distributed Systems
  • Problem-Solving

Skills & topics

  • Cassandra
  • Database Consultant
  • NoSQL
  • DSE Enterprise
  • Performance Tuning
  • System Design
  • Automation
  • Cloud Platforms
  • Shell Scripting
  • Python
  • Distributed Systems
  • AWS
  • GCP
  • Azure
  • ITIL

How to get hired

  • Tailor your resume: Highlight your Cassandra, NoSQL, and cloud platform experience. Quantify achievements in performance tuning and system design.
  • Showcase your skills: Emphasize proficiency in DSE Enterprise, Cassandra-related tools (Medusa, Reaper), and programming languages like Shell and Python.
  • Demonstrate problem-solving: Provide examples of debugging complex issues in distributed systems and web applications.
  • Highlight collaboration: Mention experience with CI/CD, configuration management, and mentoring junior team members.
  • Prepare for remote work: Be ready to discuss your home office setup and ability to work independently and effectively.

Technical preparation

Master Cassandra data modeling and query optimization.,Practice DSE Enterprise features: Search, Analytics.,Build automation scripts in Shell/Python.,Review cloud deployment and monitoring strategies.

Behavioral questions

Describe a complex Cassandra issue you solved.,How do you prioritize urgent production issues?,How do you mentor junior database professionals?,Explain your approach to system design documentation.

Frequently asked questions

What are the core responsibilities of a Cassandra Database Consultant at Pythian?
As a Cassandra Database Consultant at Pythian, you will focus on project work, debugging performance issues, conducting audits, and health checks. You'll design and implement new Cassandra deployments, evaluate existing clusters, and debug high-priority issues in production environments. Support for DSE Enterprise, Cassandra-related open-source tools, and community engagement are also key aspects of the role.
What experience is essential for the Cassandra Database Consultant role at Pythian?
Pythian requires over 3 years of experience with NoSQL databases, with a strong preference for Cassandra. Proficiency in DSE Enterprise, Cassandra-related open-source tools (Medusa, Reaper), and at least one programming language (Shell, Python preferred) are crucial. Experience with cloud platforms (AWS, GCP, Azure) and distributed systems is also highly valued.
Is this a remote position, and what are the benefits of working at Pythian?
Yes, this is a fully remote position, allowing you to work from home with a stable internet connection. Pythian offers a competitive total rewards package, flexible work-life balance, opportunities for professional development, a home office budget, and a wellness budget. You'll also collaborate with top industry professionals.
How does Pythian utilize AI in its hiring process for the Cassandra Database Consultant role?
Pythian may use Enterprise Generative AI tools to efficiently manage application volumes, review resumes, and assist with recruitment steps. However, human judgment remains central, with the Talent Acquisition Team reviewing all AI recommendations. The system undergoes regular bias audits, and final hiring decisions are always made by humans. You have the right to request a human review or accommodation.
What kind of projects can I expect as a Cassandra Database Consultant at Pythian?
You can expect a variety of project work, including designing and implementing new Cassandra deployments, performance tuning, health checks, and audits. You will also be involved in debugging critical issues on production environments and contributing to the development of automation tooling and processes.
Does Pythian offer opportunities for professional growth for a Cassandra Database Consultant?
Absolutely. Pythian offers substantial training allowances, professional development days, and opportunities to attend training and become certified. The role itself provides exposure to a wide range of platforms and technologies, fostering significant career growth.