Job description

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  Consultant Specialist.

BusinessWholesale Technology

Global Liquidity under Global Payments Solutions (GPS) IT is a critical part in HSBC. The liquidity services comprise of a suite of global applications that help corporate treasury department to manage their company liquidity. Key services that we cater to are pooling, cash concentration, intercompany loans, cash flow forecasting, liquidity investment solutions. Global Liquidity Services are both vendor products and in-house built products, running on SaaS models, public clouds and internal clouds.

One of the four Service Pillars is the "Data Analytics and Dashboarding". The Liquidity Data Service functions as a reporting and billing engine, the vision is for it to become the data repository for all Liquidity Data, which will allow for internal analytics and expose to client to provide dashboard services. This role will be part of Data Analytics and Dashboarding team, working with the global liquidity business, operations, and various teams related to achieve product excellence and serve global Liquidity customers effectively.

Principal responsibilities

We are seeking an experienced PostgreSQL Engineer with expert-level knowledge in logical and physical replication to join our team. The ideal candidate should have a strong background in database administration, replication strategies, and automation using DevOps tools like Ansible and Jenkins. Experience with Google Cloud and other cloud platforms is a plus.

  • Design, implement, and manage PostgreSQL replication (logical and physical) for high availability and disaster recovery.
  • Optimize database performance, tuning, and query optimization.
  • Automate database deployment and management using Ansible, Jenkins, and scripting (Bash/Python).
  • Develop and maintain backup, restore, and failover strategies.
  • Work closely with development and infrastructure teams to ensure database scalability and reliability.
  • Monitor database health, security, and troubleshoot replication issues.
  • Implement best practices for high availability (HA) and disaster recovery (DR) solutions.
  • Work with Google Cloud (Cloud SQL for PostgreSQL, GKE, GCP networking, IAM, monitoring) and other cloud platforms.
Requisitos
  • 10+ years of hands-on experience with PostgreSQL administration and replication (logical & physical).
  • Strong expertise in WAL archiving, streaming replication, and logical decoding.
  • Proficiency in database performance tuning, indexing strategies, and query optimization.
  • Experience in automating database tasks using Ansible, Jenkins, and scripting.
  • Solid knowledge of database security, auditing, and access control mechanisms.
  • Familiarity with Google Cloud (Cloud SQL, IAM, VPC, GKE) and other cloud platforms (AWS, Azure) is a plus.
  • Strong troubleshooting and problem-solving skills.
  • Experience with monitoring tools like Prometheus, Grafana, or ELK Stack is a plus.

HSBCKL/XA*

About HSBC Technology China

We develop, implement and support software and IT services and processes that allow HSBC to remain at the forefront of high-quality banking systems.

 You’ll achieve more when you join HSBC. 

HSBC is an equal opportunity employer 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. We encourage applications from all suitably qualified persons irrespective of, but not limited to, their gender or genetic information, sexual orientation, ethnicity, religion, social status, medical care leave requirements, political affiliation, people with disabilities, color, national origin, veteran status, etc., We consider all applications based on merit and suitability to the role.

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 (GuangDong) Limited***