Postgres Database Administrator/Senior Consultant Specialist

HSBC Global Services Limited; Pune District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

HSBC Software Development India is seeking an experienced Sr. Consultant Specialist to run and improve PostgreSQL DBA operations.

You will own database availability, performance, and DR readiness, and lead major incidents with a focus on security, upgrades, and automation. The role requires strong hands-on PostgreSQL administration in enterprise environments, replication and monitoring skills, and relevant certifications.

Qualifications

• 5+ years of PostgreSQL administration in enterprise production environments.
• Experience with backups, PITR, WAL management.
• Experience with replication (streaming, logical) and HA tooling.
• Monitoring/observability using Prometheus/Grafana.
• Knowledge of upgrades/migrations and security controls.

Responsibilities

• Run and improve day-to-day PostgreSQL DBA 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.
• Design, implement and operate HA/DR solutions and backups/restores.
• Plan upgrades/migrations with minimal downtime and ensure security controls.

Skills

PostgreSQL administration

Incident & change management

Performance tuning

Data backup & recovery

Security controls

Education

Relevant certifications (cloud, Linux, DB)

Tools

pgBackRest

Patroni

repmgr

pg_basebackup

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 Sr. 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