LOG IN
SIGN UP
Canary Wharfian - Online Investment Banking & Finance Community.
Sign In
Forgot password?
Don't have an account?
or
Join Canary Wharfian
By signing up, you agree to our Terms & Conditions and Privacy Policy.
or

Postgres Database Administrator/Senior Consultant Specialist

ExperiencedNo visa sponsorship
HSBC logo

at HSBC

Other

Posted a month ago

No clicks

**Postgres Database Administrator/Senior Consultant Specialist** Manage PostgreSQL databases in enterprise environments, ensuring high availability, performance, and security. Key responsibilities include: - Day-to-day DBA operations (incident, problem, change, release support) - Database availability and KPI/SLA monitoring - On-call support and major incident leadership - Performance tuning, query optimization, and indexing strategy - HA/DR solutions implementation (streaming/logical replication) - Backup and restore management, DR runbooks design and testing - Upgrades and migrations, extension management - Observability and monitoring implementation (Prometheus/Grafana, logs) - Change/incident management experience - Audit, vulnerability remediation, and data release support Bring at least 5 years of hands-on PostgreSQL administration experience, deep knowledge in: - Backup/restore, PITR, WAL management, replication, failover concepts, and HA tooling - Performance tuning, indexing, autovacuum, and bloat control - Upgrades and migrations - Monitoring/observability and change/incident management - Relevant certifications (cloud, Linux, or database-related) Achieve more in an inclusive, diverse environment with opportunities for growth. Apply now.

Compensation
Not specified

Currency: Not specified

City
Not specified
Country
India

Full Job Description

Some careers shine brighter than others.

If youre 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).

Youll 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

Postgres Database Administrator/Senior Consultant Specialist

Compensation

Not specified

City: Not specified

Country: India

HSBC logo
Other

a month ago

No clicks

at HSBC

ExperiencedNo visa sponsorship

**Postgres Database Administrator/Senior Consultant Specialist** Manage PostgreSQL databases in enterprise environments, ensuring high availability, performance, and security. Key responsibilities include: - Day-to-day DBA operations (incident, problem, change, release support) - Database availability and KPI/SLA monitoring - On-call support and major incident leadership - Performance tuning, query optimization, and indexing strategy - HA/DR solutions implementation (streaming/logical replication) - Backup and restore management, DR runbooks design and testing - Upgrades and migrations, extension management - Observability and monitoring implementation (Prometheus/Grafana, logs) - Change/incident management experience - Audit, vulnerability remediation, and data release support Bring at least 5 years of hands-on PostgreSQL administration experience, deep knowledge in: - Backup/restore, PITR, WAL management, replication, failover concepts, and HA tooling - Performance tuning, indexing, autovacuum, and bloat control - Upgrades and migrations - Monitoring/observability and change/incident management - Relevant certifications (cloud, Linux, or database-related) Achieve more in an inclusive, diverse environment with opportunities for growth. Apply now.

Full Job Description

Some careers shine brighter than others.

If youre 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).

Youll 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