PostgreSQL, WAL Archiving, Streaming Replication/Senior Consultant Specialist

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.

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

In this role, you will:

• 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.
• Develop and maintain backup, restore, and failover strategies, including experience with EDB Failover Manager (EFM).
• 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.

To be successful, you will:

• 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. PostgreSQL certification is a plus.
• Experience with Kubernetes, Docker, and CI/CD pipelines. Knowledge of other databases like MySQL, Oracle, or NoSQL databases is a bonus.

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