Postgres Database Administrator/Senior Consultant Specialist
HSBC · Pune, India · 7d ago
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