Oracle Developer

Job description:

Job Type: Full Time
Experience: 5 years 
Location: Lagos

CompanySoft 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 performance 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 architecture, schema design, and data modeling 
  • Good communication skills and ability to work with cross-functional teams

Method of Application

To apply send an email to Jackie via jodili@softalliance.com, cc: hr@softalliance.com with the opening as the email subject.