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
