Lead Analyst/Associate Consultant - Cassandra Database Administrator
Position Description
Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 consultants and professionals across the globe, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com.
Job Title: Lead Analyst/Associate Consultant - Cassandra Database Administrator
Position: Lead Analyst/Associate Consultant
Experience: 8-10 Years
Category: Software development / Engineering
Shift: General Shift
Main location: Bangalore
Position ID:
Employment Type: Full Time
Education Qualification: Bachelor's degree in computer science or related field or higher with minimum7 years of relevant experience.
Position Description: We are looking for an experienced and passionate Cassandra Database Administrator to join our dynamic product development team. In this role, you will be a cornerstone of our database infrastructure, ensuring the reliability, scalability, and performance of our production Cassandra clusters. The ideal candidate is a hands-on expert with a proven track record in managing large-scale production databases, possessing deep insights into performance tuning, data modeling, and administration. You will be a key contributor to the overall design and implementation of our product, bringing your database expertise to the forefront of our innovation.
Your future duties and responsibilities
Administration
o Design and deploy new Cassandra clusters, ensuring they are built for high availability, fault tolerance, and optimal performance.
o Own the health and stability of all development, testing, and production Cassandra database environments.
o Manage and maintain the entire lifecycle of our Cassandra clusters, including setup, configuration, and decommissioning.
o Implement and manage robust backup and recovery strategies to ensure data integrity and availability.
o Automate routine administrative tasks through scripting and other automation tools.
Performance
o Proactively monitor database performance, identify bottlenecks, and lead performance tuning efforts.
o Analyze and optimize queries, data structures, and cluster configurations for maximum efficiency.
Design & Modeling
o Collaborate with the development team on data modeling and schema design to ensure optimal database performance and scalability.
o Provide expert guidance on data architecture and best practices for using Cassandra effectively.
Support
o Act as the primary point of contact for all Cassandra-related issues, providing timely troubleshooting and resolution.
Required qualifications to be successful in this role
Must-Have Skills:
o Proven hands-on experience managing production Cassandra environments.
o Deep expertise in Cassandra performance tuning, including compaction strategies, caching, and JVM tuning.
o Strong understanding of Cassandra data modeling principles and best practices.
o Solid experience with Cassandra administration, including installation, configuration, and monitoring.
o Excellent problem-solving skills and the ability to perform under pressure.
Good-to-Have Skills:
o Experience with other NoSQL databases (e.g., MongoDB, Redis).
o Familiarity with cloud platforms (AWS, GCP, Azure) and managing Cassandra in a cloud environment.
o Knowledge of containerization and orchestration technologies like Docker and Kubernetes.
o Experience with data migration and ETL processes.
o Contributions to open-source projects, especially in the database space.
CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.

Keyskills: Cassandra Database Administration Data Modeling Performance Tuning