PostgreSQL Developer / Database Engineer

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 PL/pgSQL 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 ETL/ELT 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

• PL/pgSQL

• 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