Postgres Database Administrator/Senior Consultant Specialist

HSBC Holdings plc; Pune District; On-site; INR 2,400,000 - 3,600,000; Full time

Job summary

HSBC Software Development India is seeking an experienced Senior Consultant Specialist to lead PostgreSQL operations in a enterprise production environment. You will own availability, performance, capacity, and service health, while guiding incident management and major recovery efforts.

Role involves implementing backup/restore, PITR, and WAL strategies, along with replication, monitoring, and security controls. Collaboration with application teams, SRE/Platform, and vendors is essential.

Qualifications

• Hands-on PostgreSQL administration in enterprise production environments (5+ years).
• Backup/restore with pg_basebackup, pgBackRest; PITR and WAL management.
• Replication (streaming, logical); HA tooling (Patroni, repmgr).
• Performance tuning (EXPLAIN/ANALYSE, indexing, autovacuum).
• Upgrades and migrations; security controls and encryption basics.

Responsibilities

• Run and improve day-to-day PostgreSQL operations (incidents, problems, changes, releases).
• Own database availability, performance, capacity, and service health KPIs/SLAs.
• Provide on-call support and lead major incidents in technical recovery.
• Diagnose and resolve performance issues; implement monitoring and alerting.
• Design and operate HA/DR solutions; plan upgrades and migrations.

Skills

PostgreSQL administration

Incident management

Performance tuning

Monitoring & observability

Infrastructure as Code

CI/CD

On-call support

Tools

Patroni

repmgr

pgBackRest

pg_basebackup

Terraform

Prometheus

Grafana

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:

• Run and improve day-to-day DBA operations for PostgreSQL (incident, problem, change, and release support).
• Own database availability, performance, capacity, and service health KPIs/SLAs.
• Provide on-call support (where applicable) and lead major incidents in technical recovery
• Diagnose and resolve performance issues (query tuning, indexing strategy, vacuum/analyze, bloat management).
• Establish performance baselines and proactive monitoring/alerting. Design, implement, and operate HA/DR solutions (e.g., streaming replication, logical replication, load balancers).
• Define and test backup/restore and DR runbooks; conduct regular restore tests and DR exercises.
• Plan and execute upgrades and migrations with minimal downtime. Implement security controls: role-based access, least privilege, encryption in transit/at rest (where supported), secrets management.
• Support audit requirements (logging, retention, evidence collection) and vulnerability remediation. Automate provisioning and configuration using Infrastructure as Code (e.g. Terraform) and CI/CD patterns.
• Support schema changes, data fixes, and controlled releases (including rollback planning). Manage partitioning strategies, archiving, retention, and data growth planning.
• Provide guidance on data modelling and operational readiness for new applications. Partner with application teams, SRE/Platform, and vendors to deliver improvements. Produce clear technical documentation and communicate risk/impact to stakeholders.

To be successful in this role, you should meet the following requirements:

• Strong hands-on PostgreSQL administration in enterprise production environments (typically 5+ years, adjust as needed).
• Deep knowledge of:
• Backup/restore (pg_basebackup, pgBackRest), PITR, WAL management
• Replication (streaming/logical), failover concepts, HA tooling (Patroni/repmgr)
• Performance tuning (EXPLAIN/ANALYSE, indexing, autovacuum tuning, bloat control)
• Upgrades and migrations (major/minor version upgrades, extension management)
• Monitoring/observability (e.g., Prometheus/Grafana, pg_stat_statements, logs).
• Change/incident management experience in controlled environments.
• Relevant certifications (cloud, Linux, or database-related).

You’ll achieve more when you join HSBC.

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