Senior Database Engineer / Senior Consultant Specialist

Join HSBC as a Senior Database Engineer / Senior Consultant Specialist and own the health, performance, and reliability of a multi-database ecosystem across relational, graph, and cloud-hosted platforms.

Responsibilities:

• Design, implement, and maintain PostgreSQL and Cassandra databases, including schema design, indexing strategies, query optimisation, and high-availability configurations.
• Administer and develop on TigerGraph, including graph schema modelling, GSQL query development, and cluster management.
• Manage BigQuery datasets, including table partitioning, clustering, cost optimisation, and access control.
• Monitor database performance across all platforms, proactively identifying and resolving bottlenecks, deadlocks, and slow queries.
• Own backup, recovery, and disaster recovery strategies for all managed databases.
• Enforce data security policies, user access controls, and compliance requirements.
• Collaborate with backend engineering and data teams on data modelling and query design.
• Maintain database documentation, runbooks, and capacity planning reports.
• Support data migration and transformation pipelines across systems.

Requirements:

• 7+ years of overall IT experience, with strong Database Administration expertise.
• Hands-on DBA experience including performance tuning, replication, vacuuming, and partitioning.
• Hands-on experience with TigerGraph, including graph modelling, GSQL development, and cluster operations.
• Strong experience with Cassandra (data modelling, query optimisation, and operational support).
• Working knowledge of BigQuery (partitioning/clustering, cost optimisation, and access control/IAM).
• Strong understanding of database security, access controls, backup strategies, and disaster recovery.
• Solid experience with GCP services such as Cloud SQL, GCS, IAM, and networking.
• Operational familiarity with Kubernetes/GKE and exposure to CI/CD and/or Liquibase for database change automation.