Job description:
Job Type: Full Time
Experience: 5 years
Location: Lagos
Company: 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 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.