Job Description

Role Overview

We're seeking an experienced PostgreSQL Architect/DBA to lead the

end-to-end database lifecycle

--from

initial conceptual design and logical modeling

through

physical architecture, implementation, performance tuning, and production readiness

. This role will partner closely with application architects, DevOps, and security to establish a

scalable, secure, highly available

PostgreSQL foundation aligned to business SLAs.

Key Responsibilities

Discovery & Planning

Translate business requirements into a data architecture strategy (OLTP/OLAP, mixed workloads, read/write patterns, SLAs). Produce

Conceptual, Logical, and Physical Data Models

; define normalization/denormalization approach. Capacity planning including growth projections, storage layout (tablespaces), and IOPS/throughput requirements.

Architecture & Design

Design

schema structures

, indexing strategies (BTREE, GIN/GiST, BRIN), partitioning, constraints, and referential integrity. Establish

HA/DR architecture

: streaming replication, quorum commit, synchronous/asynchronous replicas,

Patroni/Pgpool-II

or equivalent,

backup/restore

and RTO/RPO targets. Define

security architecture

: roles, least-privilege access, pg_hba.conf, SSL/TLS, key rotation, auditing, and

row-level security

where applicable. Plan

environment topology

(Dev/UAT/Prod),

multi-region

options, and

network zoning

.

Implementation & Enablement

Install, configure, and harden PostgreSQL (parameters such as shared_buffers, work_mem, effective_cache_size, autovacuum, checkpoint_timeout, etc.). Set up

monitoring & observability

(pg_stat_statements, auto_explain, logs, exporters for Prometheus/Grafana, or cloud-native tools). Establish

backup strategy

(e.g.,

pgBackRest

,

barman

) and test

restore

scenarios; document SOPs. Define

migrations & release process

(DDL governance, migration tooling such as

Flyway/Liquibase

).

Performance & Reliability

Query optimization, execution plan analysis, and indexing improvements for critical workloads. Design

partitioning and vacuum strategies

; tune autovacuum; manage bloat. Load/perf testing with realistic datasets; proactively address bottlenecks (locks, hotspots, I/O saturation).

Collaboration & Governance

Partner with application teams to define

API/data access patterns

, caching strategy, and transaction boundaries. Create

documentation

(runbooks, standards, guardrails) and conduct

knowledge transfer

to Dev/Ops teams. Contribute to

data governance

(naming conventions, versioning, retention, GDPR/PII handling).

Required Skills & Qualifications

7-10 years

in database engineering;

5+ years

hands-on with

PostgreSQL

in production. Deep knowledge of

PostgreSQL internals

: planner/optimizer, VACUUM/ANALYZE, WAL/Checkpoints, locking, MVCC. Proven experience designing for

high availability

(streaming replication, failover orchestration such as

Patroni

,

Pgpool-II

, or cloud-native HA). Strong

performance tuning

skills: query plans, index design, partitioning, memory/I/O parameters, bloat control. Expertise in

backup/restore

,

point-in-time recovery (PITR)

, and DR playbooks. Solid SQL and

PL/pgSQL

; proficiency with migration tools (

Flyway/Liquibase

). Experience with

Linux

administration for DB nodes (filesystems, storage, kernel params). Hands-on with

monitoring/observability

(pg_stat_statements, auto_explain, Prometheus/Grafana, or equivalent). Security fundamentals:

TLS

,

role management

,

row-level security

, audit logging, and compliance best practices. * Familiarity with

CI/CD

for database changes, Git workflows, and automation scripting (

Bash/Python

).