Job Description
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
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
Numbers & Facts
| Location | Jersey City, NJ |
| Industry | Computer/IT Services |
| Salary | $55–$60 Per Hour |
| Company Size | 500 to 999 employees |
| Website | https://www.apolisrises.com/ |
Benefits
Paid Sick Days, Employee Referral Program, Employee Events, Retirement / Pension Plans
About Company
Since 1996, RJT has provided successful SAP, Oracle, and IT consulting solutions and staffing services to clients around the world. The new Apolis brings you the same personalized service fortified with a greater array of IT solutions, global expertise, and cost-management strategies.
We are a global IT consultancy that seamlessly integrates experts and leading-edge solutions into your organization so you can focus on what really matters.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesResume Builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Resume Builder