Database Developer (Oracle PL/SQL / PostgreSQL)-10+yrs-Ny,NY-Onsite

Job Summary

We are looking for a skilled Database Developer with strong expertise in Oracle PL/SQL or PostgreSQL pgPLSQL to design, develop, and optimize complex database solutions. The ideal candidate will have hands-on experience in database object development, performance tuning, batch scheduling, and managing time-series data aligned with business requirements.

Roles & Responsibilities

• Understand business requirements and translate them into effective database designs.

• Design and develop complex database objects such as Stored Procedures, Functions, Packages, and Triggers.

• Work extensively with file handling using DB scripts, External Tables, and DB Links.

• Implement and manage Table Partitioning, Materialized Views, and Ref Cursors.

• Use Collections and Dynamic SQL for advanced database operations.

• Perform SQL query optimization and tuning for high-performance applications.

• Manage and schedule database batch jobs.

• Handle and manage time-series data effectively.

• Ensure database performance, scalability, and reliability.

Required Qualifications

• Strong experience in Oracle PL/SQL or PostgreSQL pgPLSQL.

• Expertise in developing and managing complex database objects.

• Experience with Table Partitioning, Materialized Views, DB Links, and External Tables.

• Strong knowledge of query tuning and performance optimization techniques.

• Experience in database job scheduling and batch processing.

• Understanding of time-series data management.

• Good analytical and problem-solving skills.

Education

• Bachelor’s degree in Computer Science, Engineering, or related field.

Key Skills

Oracle PL/SQL, PostgreSQL pgPLSQL, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views, Query Tuning, Dynamic SQL, Batch Scheduling.