NextHire Try for free

HSBC

Posted 21 Nov 2026

Senior Consultant Specialist - PostgreSQL

Apply with NextHire Auto Apply fills in the application for you.
Employment
Full time
Team
Software Engineering
Posted
21 Nov 2026

About the role

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.

Similar jobs

See every job

85% of jobs are filled through networking

The AI Outreach Agent writes to recruiters and hiring managers at the companies you pick, from your own Gmail.

Try AI Outreach