PostgreSQL Developer / Database Engineer

Role : PostgreSQL Developer / Database Engineer

Location: Hartford, CT (Hybrid)

Duration: 6 Months

Experience: 8-10 Years

Role Overview:

We are looking for an experienced PostgreSQL Developer / Database Engineer with strong expertise in database design, development, performance tuning, and administration. The candidate will be responsible for building scalable PostgreSQL solutions, optimizing complex SQL queries, managing replication and disaster recovery, and supporting cloud-based database environments.

Key Responsibilities:

• Design and maintain scalable PostgreSQL databases.

• Develop complex SQL queries, PL/pgSQL, stored procedures, and functions.

• Perform query optimization, indexing, and performance tuning.

• Manage replication, backups, recovery, failover, and disaster recovery.

• Handle data modeling, partitioning, and database architecture.

• Support ETL/ELT, CDC, and data integration pipelines.

• Implement database security, monitoring, and compliance controls.

Must-Have Skills:

• Strong PostgreSQL database development and administration.

• Advanced SQL, PL/pgSQL, CTEs, and Window Functions.

• Query execution plan analysis and performance tuning.

• Indexing: B-Tree, GIN, GiST, BRIN, and Hash.

• Streaming & Logical Replication, WAL Management.

• Backup & Recovery, Failover, and Disaster Recovery.

• PostgreSQL tools: pgAdmin, psql, pg_dump, pg_restore.

• Data Modeling, Data Quality, and Data Lineage.