PostgreSQL Developer / Database Engineer

Position: PostgreSQL Developer / Database Engineer

Location: Hartford, CT / Hybrid

Duration: 6 Month Contract

Rate: $70/hr

Role Description: The PostgreSQL Developer / Database Engineer will be responsible for designing, developing, Eligible to workimizing, 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 Eligible to workimize 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 Eligible to workimization " 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