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