PostgreSQL, pgBackRest, Linux, Bash/Senior Consultant Specialist

HSBC Holdings

Pune District

On-site

INR 3,500,000 - 6,000,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

HSBC Holdings in India seeks an experienced Senior Consultant Specialist to lead PostgreSQL database administration across Dev/UAT/Prod. You will ensure high availability, performance, and robust backup/recovery, while collaborating with application teams.

The role requires deep PostgreSQL internals knowledge, strong SQL/data modeling, and extensive DevOps tooling experience. Excellent communication and on-call support are essential.

Qualifications

  • 10+ years of software engineering experience with backend focus.
  • Strong PostgreSQL administration in production.
  • Expertise with backups, DR, and high availability.

Responsibilities

  • Administer and maintain PostgreSQL databases across environments.
  • Ensure high availability, reliability, and performance.
  • Design backup, restore, and disaster recovery procedures.
  • Configure and support replication and failover.
  • Performance tuning at multiple levels.
  • Monitor health, capacity, and security; runbooks and alerts.
  • Manage schema changes, releases, migrations with minimal downtime.
  • Support incidents, RCA, and preventive actions.

Skills

PostgreSQL administration
Linux
Bash/Python
pgBackRest
Monitoring (Prometheus/Grafana)
CI/CD tooling
DevOps tools (Jira/Confluence)
SQL & data modeling
Backup/DR procedures
Incident management

Education

Bachelor's degree in Computer Science or related

Tools

pgBackRest
WAL archiving
PITR
Git
Prometheus
Grafana
Datadog
CloudWatch
Repmgr/Patroni
Linux shell

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:
  • Administer and maintain PostgreSQL databases across Dev/UAT/Prod environments.
  • Ensure high availability, reliability, and performance of mission‑critical databases.
  • Design and manage backup, restore, and disaster recovery procedures (RPO/RTO aligned).
  • Configure and support replication and failover (streaming replication, logical replication, Patroni/repmgr or equivalent).
  • Perform proactive performance tuning at query, index, schema, and configuration levels.
  • Monitor database health, capacity, and security posture; implement alerts and runbooks.
  • Manage schema changes, releases, and migrations with zero/low downtime approaches.
  • Support production incidents, RCA, and preventive actions.
  • Implement and enforce security controls: roles/privileges, encryption, audit/compliance.
  • Partner with application teams on SQL optimization, data modeling, and access patterns.
  • Automate repetitive DBA tasks using scripting and infrastructure tooling.
  • Maintain operational documentation and ensure audit readiness.
To be successful in this role, you should meet the following requirements:
  • 10+ years of software engineering experience, with a strong backend focus.
  • Mandatory Technologies: PostgreSQL 12+ (or as applicable), Linux, Bash/Python, pgBackRest, psql, pg_stat_statements, Monitoring stack (Prometheus/Grafana or equivalent), Git, CI/CD tooling, Ticketing and runbook platforms, Devops Tools - Jira, Confluence
  • Strong hands‑on PostgreSQL administration experience in production environments.
  • Deep understanding of PostgreSQL internals: MVCC, WAL, vacuum/autovacuum, checkpoints, locks.
  • Performance tuning expertise (EXPLAIN/ANALYZE, indexing strategy, bloat management, partitioning).
  • Strong SQL and data modeling skills.
  • Experience with backup/recovery tools (pgBackRest, WAL archiving, PITR).
  • HA/DR implementation experience (replication/failover).
  • Linux administration fundamentals and shell scripting.
  • Monitoring/observability experience (Prometheus/Grafana/Datadog/CloudWatch or similar).
  • Incident management and on‑call production support experience.
  • Good communication and cross‑team collaboration skills

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Unix Infra, Veritas clustering, Patching/Consultant Specialist
Unix Infra, Veritas clustering, Patching/Consultant Specialist

HSBC Holdings • Hyderabad

On-site
INR 1,800,000 - 3,000,000
Senior PostgreSQL SRE
Senior PostgreSQL SRE

Barclays • Pune District

On-site
INR 3,500,000 - 6,000,000
Python Backend / API/ Senior Consultant Specialist
Python Backend / API/ Senior Consultant Specialist

HSBC Holdings • Pune District

On-site
INR 2,800,000 - 4,200,000
Devops/ cloud / Consultant Specialist
Devops/ cloud / Consultant Specialist

HSBC Holdings plc • Hyderabad

On-site
INR 1,500,000 - 2,000,000
Tech Production Support/Senior Consultant Specialist
Tech Production Support/Senior Consultant Specialist

HSBC Holdings • Pune District

On-site
INR 2,500,000 - 4,000,000
Tech Production Support/Senior Consultant Specialist
Tech Production Support/Senior Consultant Specialist

Mployee.me • Pune District

On-site
INR 2,500,000 - 4,000,000
GCP PySpark And BigQuery Consultant SpecialistConsultant Specialist
GCP PySpark And BigQuery Consultant SpecialistConsultant Specialist

HSBC • Pune District

On-site
INR 2,400,000 - 3,400,000
PostgreSQL, Python/Senior Consultant Specialist
PostgreSQL, Python/Senior Consultant Specialist

HSBC • Pune District

Hybrid
INR 3,500,000 - 7,000,000
Devops GCP Docker Kubernetes Consultant Specialist
Devops GCP Docker Kubernetes Consultant Specialist

HSBC Holdings plc • Pune District

On-site
INR 1,000,000 - 1,800,000
Consultant Specialist
Consultant Specialist

HSBC Holdings plc • Hyderabad

On-site
INR 90,000 - 130,000