Some careers have more impact than others.

If you’re looking for a career where you can make a real impression, join HSBC and discover how valued you’ll be.

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

Business: CTO Data Technology

Principal 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 internalPerform 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.