PostgreSQL & Oracle DB Engineer – Hybrid, 12-Month Project

Amtex Enterprises; Village of Menands (NY); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Amtex Enterprises in Menands, NY is seeking a Database Developer skilled in PostgreSQL and Oracle to design, develop, and optimize cross-DB data solutions in a hybrid environment. The role covers migration of PL/SQL to PostgreSQL, performance tuning, API integration, data pipelines, and collaboration with application teams, QA, and DevOps.

This 12-month contract offers DOE compensation and requires face-to-face interview at client expense.

Qualifications

• Proven experience with PostgreSQL development and PL/pgSQL.
• Strong Oracle DB (11g/12c/19c) and PL/SQL skills.
• Experience migrating Oracle to PostgreSQL and performance tuning.
• Familiarity with RESTful APIs, ETL, and data integration.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL packages, procedures, and views.
• Migrate Oracle PL/SQL code to PostgreSQL while preserving functionality.
• Tune queries, optimize execution plans, indexing, and partitioning.
• Develop and support RESTful APIs for data services.
• Build and maintain ETL processes and data pipelines.
• Collaborate with developers, QA, DevOps, and analysts.
• Prepare deployment scripts and SOPs for production changes.

Skills

PostgreSQL

PL/pgSQL

PL/SQL

SQL

Data modeling

ETL

APIs integration

Unix/Linux scripting

Git

Agile/Scrum

Tools

PostgreSQL

Oracle Database

RESTful APIs

Explain Plan / EXPLAIN ANALYZE

ETL tools

Git

CI/CD

AWS

Job description

Amtex Enterprises in Menands, NY is seeking a Database Developer skilled in PostgreSQL and Oracle to design, develop, and optimize cross-DB data solutions in a hybrid environment. The role covers migration of PL/SQL to PostgreSQL, performance tuning, API integration, data pipelines, and collaboration with application teams, QA, and DevOps.

This 12-month contract offers DOE compensation and requires face-to-face interview at client expense.