Database Developer PostgreSQL/Oracle - THEMESOFT

OpenTalent; Village of Menands (NY); Hybrid; USD 110,000 - 160,000; Full time

Job summary

OpenTalent is seeking a Database Developer specializing in PostgreSQL and Oracle to design, implement, and optimize database objects, PL/pgSQL, and SQL queries. The role involves migration of Oracle code to PostgreSQL, performance tuning, data integration, and API development to support enterprise applications.

You will collaborate with application teams, QA, DevOps, and business analysts to deliver robust, scalable database solutions in a hybrid setup in Menands, NY.

Qualifications

• Experience with PostgreSQL development and Oracle PL/SQL
• Strong SQL and query optimization skills
• Experience designing database objects and schemas

Responsibilities

• Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and views for Oracle and PostgreSQL
• Migrate Oracle PL/SQL code to PostgreSQL and optimize performance
• Tune queries, optimize execution plans, indexing, and partitioning across Oracle and PostgreSQL
• Develop and support RESTful APIs for database services and data integration
• Build and maintain ETL processes and data pipelines
• Collaborate with developers, QA, DevOps, architects, and analysts
• Create deployment scripts and SOPs for changes and releases

Skills

PostgreSQL development

PL/pgSQL

Oracle PL/SQL

query optimization

database design

Tools

Oracle

PostgreSQL

Job description

Database Developer (PostgreSQL/Oracle)

Location: Menands NY 12204 (Hybrid)

Key Responsibilities: Database Development: Design, develop, and maintain robust Oracle PL/SQL packages, stored procedures, functions, triggers, views, and complex SQL queries, PostgreSQL database objects, including functions, procedures, triggers, and views using PL/pgSQL.

Database Migration & Conversion: Analyze Oracle database objects, map dependencies, and assist in migrating Oracle PL/SQL code to PostgreSQL while ensuring functionality and performance.

Performance Tuning: Troubleshoot slow-running SQL queries, optimize execution plans, indexing strategies, partitioning, and database performance across Oracle and PostgreSQL environments.

API Development & Integration (Preferred): Design, develop, consume, and support RESTful APIs for seamless integration between databases and enterprise applications. Collaborate with application teams to expose database services through APIs.

Data Integration: Build, maintain, and support ETL processes and data pipelines to ensure accurate and efficient data movement across systems.

Cross-Functional Collaboration: Work closely with application developers, QA engineers, DevOps teams, architects, and business analysts to deliver secure, scalable, and high-quality database solutions.

Documentation & Deployment: Prepare technical documentation, deployment scripts, release procedures, and standard operating procedures (SOPs) for database changes and production deployments. Required Skills & Qualifications Technical Skills Solid experience in PostgreSQL development, including PL/pgSQL, database design, and query optimization.