Database Developer: PostgreSQL & Oracle (Hybrid)

Amtex Enterprises Inc; Village of Menands (NY); Hybrid; USD 62,000 - 83,000; Full time

Job summary

Amtex Enterprises Inc. seeks a Database Developer to design, develop, and optimize PostgreSQL and Oracle databases in a hybrid Menands, NY setting. The role covers migration of Oracle to PostgreSQL, performance tuning, and API integration.

You will implement ETL pipelines and collaborate across teams to deliver robust data solutions. The ideal candidate has strong PL/pgSQL/PL/SQL skills, API experience, and a solid command of Unix/Linux scripting, with a Bachelor’s in a related field.

Qualifications

• Experience designing and optimizing PostgreSQL and Oracle PL/SQL code.
• Ability to migrate Oracle code to PostgreSQL with performance focus.
• Proficient in SQL tuning, indexing, and query optimization.
• Experience with RESTful APIs and data exchange formats.
• Familiar with ETL pipelines and Unix/Linux scripting.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL packages, procedures, and functions.
• Develop PostgreSQL objects and PL/pgSQL with robust queries.
• Migrate Oracle PL/SQL code to PostgreSQL while preserving functionality.
• Tune performance and optimize execution plans across Oracle and PostgreSQL.
• Build and support ETL processes and data pipelines.

Skills

PostgreSQL development

PL/pgSQL

SQL optimization

ETL processes

Unix/Linux shell scripting

Git

Agile/Scrum

Education

Bachelor's degree in Computer Science / IT

Tools

Oracle Database (11g/12c/19c)

PostgreSQL

PL/SQL

RESTful APIs

JSON/XML data formats

Explain Plan / EXPLAIN ANALYZE

Job description

Amtex Enterprises Inc. seeks a Database Developer to design, develop, and optimize PostgreSQL and Oracle databases in a hybrid Menands, NY setting. The role covers migration of Oracle to PostgreSQL, performance tuning, and API integration.

You will implement ETL pipelines and collaborate across teams to deliver robust data solutions. The ideal candidate has strong PL/pgSQL/PL/SQL skills, API experience, and a solid command of Unix/Linux scripting, with a Bachelor’s in a related field.