PostgreSQL Developer Remote Location

Example: PTN_US_9999999_SKIPJOHNSON0413

Role Description

The PostgreSQL Developer Database Engineer will be responsible for designing, developing, optimizing, and supporting enterprise-scale PostgreSQL database solutions. The role requires expertise in database architecture, performance tuning, high availability, data integration, cloud database platforms, and database security.

Responsibilities

Design and maintain scalable PostgreSQL database solutions.

Develop logical and physical data models, including normalization, denormalization, and partitioning strategies.

Develop and optimize complex SQL and PLpgSQL code.

Analyze execution plans and troubleshoot database performance issues.

Implement indexing strategies and database performance tuning.

Design and support high availability, replication, backup, recovery, and disaster recovery solutions.

Administer and monitor PostgreSQL environments using standard PostgreSQL tools.

Support data quality, governance, metadata management, and data lineage initiatives.

Develop and support ETLELT processes, CDC solutions, and event-driven data pipelines.

Integrate PostgreSQL with applications, APIs, and microservices.

Support cloud-hosted PostgreSQL environments and infrastructure automation.

Implement database security, auditing, encryption, and compliance controls.

Required Skills

PostgreSQL

Data Modeling

SQL

PLpgSQL

Common Table Expressions (CTEs)

Window Functions

Stored Procedures

Views

Materialized Views

Execution Plan Analysis

Performance Tuning

B-Tree Indexes

Hash Indexes

GIN Indexes

GiST Indexes

BRIN Indexes

VACUUM Optimization

Statistics Management

Memory Tuning

Streaming Replication

Logical Replication

Failover

Disaster Recovery

Read Replicas

Backup and Recovery

pgAdmin

psql

pg_dump

pg_restore

WAL Management

Metadata Management

Data Lineage

Data Profiling

Data Validation

Data Reconciliation

Skills: PostgreSQL Database Technology

Experience Required: 8-10