Technical Lead (Postgre SQL)

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. 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.

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