Require a minimum of 10 years of dedicated, relevant experience in PostgreSQL Database Administration.
Must possess a strong, authoritative command over both enterprise Linux (RHEL/OEL) and Windows Server environments, actively managing database hosting layers, file system structures, and platform-specific performance variables across both operating systems.

Backup &

Recovery Engineering :
Design, implement, and audit automated logical (pg_dump, pg_dumpall) and physical backup strategies (pg_basebackup, pgBackRest, Barman), enforcing strict Point-In-Time Recovery (PITR) workflows via Write-Ahead Log (WAL) archiving to satisfy strict corporate RPO and RTO objectives.

Capacity &

Cloud Cost Planning :
Handle advanced capacity planning, transaction log growth forecasting, data density mapping, and public cloud financial optimization (right-sizing compute nodes, adjusting Provisioned IOPS/throughput limits, and choosing between serverless and provisioned models).

Monitor, baseline, and troubleshoot cluster health using native analytical extensions (pg_stat_statements, pgstattuple), catalogs (pg_stat_activity, pg_stat_bgwriter), log parsers (pgBadger), and cloud telemetry engines (AWS CloudWatch, Azure Monitor) alongside third-party APM observability suites.

Incident &

Lock Management :
Diagnose and mitigate active production incidents, including replication lag starvation, connection pool exhaustion, spinlock contentions, query regressions, and complex relational deadlocks or transactional blocking queues via recursive pg_locks analysis.

Security &

Compliance Hardening :
Implement and enforce rigorous database infrastructure security protocols, utilizing connection-level encryption (SSL/TLS), Row-Level Security (RLS), Column-Level encryption, strict Role-Based Access Controls (RBAC), advanced extension auditing (pgaudit), vulnerability remediation, and corporate compliance architectures (e.g., SOC2, ISO 27001, HIPAA, GDPR).

Enterprise User Management &

Security Hardening :
Design and maintain robust security architectures by managing user roles, fine-grained privileges, and group inheritances.
Implement strict role-based access control (RBAC), secure authentication methods (SCRAM-SHA-256, LDAP, Active Directory integration), connection-level encryption (SSL/TLS), and advanced runtime extension auditing (pgaudit).
Enforce complex Row-Level Security (RLS) and Column-Level encryption policies to safeguard sensitive data while meeting regulatory compliances (e.g., SOC2, HIPAA, GDPR).

Advanced Table Partitioning &

Lifecycle Management :
Architect and manage horizontal scale-out strategies utilizing Native Declarative Partitioning (Range, List, and Hash methods) for very large tables (VLDB) to maximize query performance and data localization.
Design custom partition maintenance strategiesincluding automated partition creation, data archiving, and historical retention pruningsleveraging tools like pg_partman.
Optimize queries to fully exploit partition pruning mechanisms and handle complex global index considerations across deeply nested table hierarchies.

Advanced Performance &

MVCC Tuning :
Execute advanced performance tuning leveraging a granular understanding of Multi-Version Concurrency Control (MVCC) internal mechanics, table heap page structures (8KB blocks), tuple visibility rules, and index-only scan patterns.
Responsibilities include custom configuration of the Autovacuum daemon (autovacuum_vacuum_scale_factor, autovacuum_vacuum_cost_limit) to proactively eliminate page bloat, transaction ID (XID) wraparound hazards, and unfreezing table locks.

Query &

Execution Plan Optimization :
Drive complex query refactoring and index optimization strategies, interpreting production execution paths through comprehensive logging parameters and deep command parsing (EXPLAIN (ANALYZE, BUFFERS)).
Mitigate query performance degradation by identifying sequential table scans, resolving external disk merge spills by adjusting transactional allocations (work_mem, maintenance_work_mem), replacing subquery anti-patterns, and choosing appropriate advanced indexing structures (B-Tree, GIN, GiST, BRIN, Partial, or Covering Indexes).

High Availability &

Connection Orchestration :
Design, implement, and operate zero-downtime clustering fabrics and automatic failover systems using Streaming Replication (Synchronous/Asynchronous), EDB Enterprise Failover Manager (EFM), Patroni, or repmgr.
Architect low-latency client connection pooling frameworks using PgBouncer (Transaction-mode mapping) or Pgpool-II to support massive enterprise concurrent scaling.

Migrations &

Scale-Out Architecture :
Plan and execute multi-terabyte data migrations, minor engine security rollouts, major version upgrades (via pg_upgrade with - link mode optimization or logical replication), and horizontal partition scale-out designs utilizing Native Declarative Range/Hash Partitioning, foreign data pipelines via Foreign Data Wrappers (FDW), and automated partition handlers (pg_partman).

Multi-Cloud Administration :

Manage, optimize, and secure PostgreSQL instances deployed across physical/virtual infrastructures and managed public cloud databases (AWS RDS for PostgreSQL, Amazon Aurora PostgreSQL, and Azure Database for PostgreSQL Flexible Server).

Production Operations &

RCA :
Provide Tier-3 mission-critical operational production support, leading high-priority Root Cause Analysis (RCA) investigations following production outages, documenting detailed engineering post-mortems, and building script automation via UNIX/Linux Shell scripting (Bash) or Python to deploy self-healing infrastructure patches.

Sybase Administration (Add-on) :

Provide secondary operational overview, maintenance support, or migration mapping assistance for legacy enterprise environments running Sybase (SAP ASE/IQ).

Data Intensity - PostgreSQL Database Administrator

Related