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 career 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

📌 PostgreSQL, pgBackRest, Linux, Bash/Senior Consultant Specialist (Pune)
🏢 HSBC
📍 Pune