Oracle Developer at Soft Alliance & Resources Limited

Job Summary: 

• We are looking for an experienced Oracle PL/SQL Developer with expertise in Oracle E-Business Suite (EBS) and Oracle APEX to design, develop, and maintain database applications. The ideal candidate will have strong experience with PL/SQL programming, EBS customizations, APEX development, performance tuning, and integrations. 

Key Responsibilities: 

PL/SQL Development & Database Management: 

• Design, develop, and optimize PL/SQL stored procedures, functions, triggers, and packages. 
• Perform query optimization and performance tuning for complex SQL queries. 
• Develop and maintain ETL processes for data migration and integration. EBS Customizations & Support: 
• Develop and customize Oracle EBS R12 components, including Forms, 
• Reports, Workflows, and Concurrent Programs using PL/SQL. 
• Work with Oracle API’s and Interfaces to integrate EBS with other systems. 
• Troubleshoot and resolve issues related to EBS modules such as Financials, Procurement, Inventory, and HRMS. 

APEX Development: 

• Develop web applications using Oracle APEX (Application Express). 
• Design and implement APEX pages, dynamic actions, interactive reports, and RESTful web services. 
• Enhance UI/UX using JavaScript, CSS, and APEX plugins. Integration & Performance Optimization: 
• Develop and maintain Oracle RESTful web services and APIs for external system integrations. 
• Work with Oracle Workflow, BI Publisher, and OAF (Optional). 
• Optimize database performance through indexing, partitioning, and materialized views. 

Documentation & Support: 

• Prepare technical documentation for developed applications. 
• Provide support and troubleshooting for production issues. 
• Collaborate with business users, functional consultants, and other developers.

Required Skills & Qualifications: 

•  5years+ of experience as an Oracle PL/SQL Developer.
• Strong experience with Oracle EBS R12 (form, reports,, interface, customization)
• Expertise in Oracle APEX development (Interactive Reports, Dynamic Actions, RESTful APIs
• Hands-on experience with Oracle SQL tuning and performace optimization 
• Knowledge of BI Publisher, Workflow builder and unix shell scripting (a plus)
• Experience with Web Services (REST/SOAP) and Oracle integration tools.
• Strong understanding of Oracle database architechure, schema design, and data modeling 
• Good communication skills and ability to work with cross-functional teams