Cassandra SME

Job Description

Job description

Some careers shine brighter than others.

If you're looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.

HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions.

We are currently seeking an experienced professional to join our team in the role of Senior Consultant Specialist.

In this role, you will:

- 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

To be successful in this role, you should meet the following 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.

You'll achieve more when you join HSBC.

www.hsbc.com/careers

HSBC is committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working and opportunities to grow within an inclusive and diverse environment. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.

Issued by - HSBC Software Development India