Database Developer (Oracle PL/SQL / PostgreSQL)-10+yrs-Ny,NY-Onsite
New York, NY, US • Posted 21 hours ago • Updated 21 hours ago

iMedhas Consulting Services
Dice Job Match Score™
🎯 Assessing qualifications...
Job Details
Skills
- Stored Procedures
- Functions
- Triggers
- Oracle PL/SQL
- materialized views
- Dynamic SQL
- PostgreSQL pgPLSQL
- Table Partitioning
- Query Tuning
- Batch Scheduling.
Summary
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.
- Dice Id: 91143549
- Position Id: 3405-31204-
- Posted 21 hours ago
Company Info
Welcome to iMedhas Consulting Services. We are an IT consulting and services enterprises with precision expertise in Digital Transformations, Big data and Analytics. Through our expert team, we provide greater adaptabilities to disseminate with new technologies to increase the overall productivity, operational efficiency, and productivity of a particular business process of an organization.
The goal is the achievement of higher customer satisfaction and providing lucrative returns on investment to the business. On the other hand, we deliver content management expertise, ERP (SAP) systems integration, EAI, and Information Management services.

Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs