Technical Lead (Postgre SQL)

Role

Technical Lead (Postgre SQL)

Location

Onsite-Hybrid (Dallas or Jersey)

Duration

6+ Months

Only W2

The Role

We need a hands-on Technical Lead to own our PostgreSQL data warehouse end to end. You will lead onshore and offshore development and PROD support teams, make architectural decisions, resolve upstream and downstream data issues, and work directly with business stakeholders to deliver reliable analytical reporting.

What You’ll Do

Lead

Guide offshore development and PROD teams through sprint planning, code reviews, release readiness, and incident management.

Architect

Recommend and decide on data models (star/snowflake, Data Vault, ODS), partitioning, and performance strategy. Set standards for PL/pgSQL, ETL, logging, and reconciliation.

Build

Develop complex PL/pgSQL procedures and functions, and optimize high-volume batch and incremental ETL/ELT pipelines. Build the analytical reporting layer (aggregates, materialized views, reporting datasets).

Own data quality

Triage upstream issues (late or bad feeds, schema changes), manage downstream impact on reports and extracts, and deliver root-cause fixes with proactive checks and alerts.

Partner with the business

Translate requirements into solutions and communicate risks and status clearly to senior stakeholders.

Required (Expert Level)

PostgreSQL core

Internals (MVCC, WAL, autovacuum, query planner), PL/pgSQL (dynamic SQL, exception handling, cursors), advanced SQL (recursive CTEs, window functions, MERGE/ON CONFLICT, JSONB), triggers, materialized views, COPY bulk loading

Performance tuning

EXPLAIN (ANALYZE, BUFFERS), pg_stat_statements, indexing (B-tree, GIN, GiST, BRIN, partial), declarative partitioning with pg_partman, bloat management, config tuning

Extensions

postgres_fdw, file_fdw, pg_cron, pg_trgm, pgcrypto, pg_repack

HA and DR

Streaming and logical replication, Patroni/repmgr, PgBouncer/pgpool-II, pgBackRest/Barman, PITR, pg_upgrade

Security and monitoring

RBAC, row-level security, pgaudit, pgBadger, Prometheus/Grafana, and managed Postgres (AWS RDS/Aurora, Azure, Cloud SQL/AlloyDB)

Data warehousing and ETL

Dimensional modeling, SCD types, CDC, reconciliation frameworks, orchestration (Airflow or equivalent), Oracle-to-PostgreSQL migration (Ora2Pg)

Leadership

Proven record leading offshore dev and PROD teams, strong stakeholder management, and a calm, ownership-driven approach to production incidents