dba

Title: Cassandra and Postgres Database Administrator (DBA)

Location: Pune / Hyderabad / Mohali

Job Summary:

As a Cassandra and PostgreSQL Database Administrator (DBA), the role involves designing, configuring, and maintaining Cassandra clusters as the primary requirement, while also managing PostgreSQL databases to ensure their optimal performance and reliability. Expertise in PostgreSQL, particularly in GCP environments, will be considered a significant advantage. Responsibilities include managing database schemas, optimizing configurations, and troubleshooting production incidents. Expertise in both NoSQL (Cassandra) and relational databases (PostgreSQL) will support business objectives and operational capabilities.

Responsibilities:

Cassandra Database Administration:

• Design, configure, and maintain Cassandra clusters deployed in HSBC.
• Install, configure, and manage multi-node Cassandra clusters both on-premise and cloud, both public and internal.
• Perform database backups, recovery, and restoration activities.
• Manage database schemas, tables, indexes, and user permissions.
• Diagnose and troubleshoot production incidents and resolve performance bottlenecks, including slow queries and resource utilization issues.
• Optimize database configurations, query performance, and data modeling for improved efficiency and scalability.
• Execute repairs in case of data inconsistency and perform JVM tuning and garbage collection optimization.
• Estimate storage requirements and collaborate with infrastructure teams to ensure adequate resources are provisioned.
• Regularly review and update security configurations to address emerging threats and vulnerabilities.
• Set up database monitoring tools to proactively identify performance issues, errors, and anomalies.
• Respond to database alerts and take appropriate actions to resolve issues.

PostgreSQL Database Administration:

• Collaborate with teams to integrate PostgreSQL databases into the infrastructure and ensure their optimal performance.
• Perform PostgreSQL database backups, recovery, and restoration activities.
• Optimize PostgreSQL configurations and query performance for transactional workloads.
• Design and implement PostgreSQL data models and SQL scripts for transactional workloads.
• Manage PostgreSQL databases in GCP environments (preferred).
• Diagnose and troubleshoot PostgreSQL production incidents and resolve performance bottlenecks.

Requirements:

Cassandra:

• 5+ years of experience in Cassandra database administration.
• Expertise in installing, configuring, and monitoring Cassandra clusters.
• Experience in creating column families, bootstrapping, decommissioning, removing, replacing, and repairing nodes.
• Proficiency in creating keyspaces, tables, and secondary indexes in Cassandra.
• Strong experience in performance tuning Apache Cassandra clusters to optimize writes and reads.
• Hands-on experience with Cassandra data modeling and CQL scripting.
• Proven ability to evaluate database performance, isolate bottlenecks, and implement optimizations in transactional settings.
• Experience in managing and monitoring 24x7 production database environments.

PostgreSQL:

• 5+ years of experience in PostgreSQL database administration.
• Expertise in installing, configuring, and monitoring PostgreSQL databases.
• Proficiency in PostgreSQL data modeling and SQL scripting.
• Strong experience in performance tuning PostgreSQL databases to optimize writes and reads.
• Hands-on experience with PostgreSQL in GCP environments (preferred).
• Proven ability to evaluate database performance, isolate bottlenecks, and implement optimizations in transactional settings.

Preferred Skills:

• Experience with Datastax Enterprise Service (DSE).
• Familiarity with cloud environments like GCP.
• Strong troubleshooting and analytical skills.

Company Description: Bits in Glass - India

• Industry Leader:
• Bits in Glass(BIG) has been in business for more than 20 years. In 2021 Bits in Glass joined hands with Crochet Technologies, forming a larger organization under the Bits In Glass brand to better serve customers across the globe.
• Offices across three locations in India: Pune, Hyderabad & Chandigarh.
• Specialized Pega partner since 2017, delivering Pega solutions with deep industry expertise and experience.
• Proudly ranked among the top 30 Pega partners, Bits In Glass has been one of the very few sponsors of the annual PegaWorld event.
• Elite Appian partner since 2008, delivering Appian solutions with deep industry expertise and experience.
• Operating in the United States, Canada, United Kingdom, and India.
• Dedicated global Pega CoE to support our customers and internal dev teams.
• Employee Benefits:
• Career Growth: Opportunities for career advancement and professional development.
• Challenging Projects: Work on innovative, cutting-edge projects that make a global impact.
• Global Exposure: Collaborate with international teams and clients to broaden your professional network.
• Flexible Work Arrangements: Support for work-life balance through flexible working conditions.
• Comprehensive Benefits: Competitive compensation packages and comprehensive benefits including health insurance, and paid time off.
• Learning Opportunities- Great opportunity to upskill yourself and work on new technologies like AI-enabled Pega solutions, Data engineering, Integration, cloud migration etc.
• Company Culture:
• Collaborative Environment: Emphasizes teamwork, innovation, and knowledge sharing.
• Inclusive Workplace: Values diversity and fosters an inclusive environment where all ideas are respected.
• Continuous Learning: Encourages professional development through ongoing learning opportunities and certifications.
• Core Values:
• Integrity: Commitment to ethical practices and transparency in all business dealings.
• Excellence: Strive for the highest standards in everything we do.
• Client-Centric Approach: Focus on delivering the best solutions tailored to client needs.

Job Types: Full-time, Permanent

Pay: ₹1,500, ₹2,500,000.00 per year

Benefits:

• Health insurance
• Paid time off
• Provident Fund
• Work from home

Work Location: In person