Overview
Skills
Job Details
Client is seeking a highly skilled Oracle Apex Developer with expertise in PL/SQL, Power BI, BI Publisher, and GitHub version control to modernize our legacy application currently built on Oracle Forms, Oracle Reports, and PL/SQL. The ideal candidate will be responsible for migrating and enhancing our application using Oracle Apex, integrating modern reporting tools, and ensuring seamless data management.
Key Responsibilities:
Application Modernization: Migrate existing Oracle Forms and Reports applications to Oracle Apex while maintaining functionality and improving performance.
Oracle Apex Development: Design, develop, and implement robust, scalable, and secure applications using Oracle Application Express (Apex).
Database Development: Write, optimize, and maintain complex PL/SQL procedures, packages, triggers, and views.
Reporting & Analytics: Develop interactive reports and dashboards using Apex, Power BI and BI Publisher to improve data visualization and decision-making.
Integration & Performance Optimization: Ensure seamless integration of Apex applications with Oracle databases and optimize database performance, as well as integration with current Oracle Forms application until modernization is completed.
Version Control & Deployment: Implement best practices for version control (GitHub or similar) and CI/CD pipelines to manage Apex applications.
Collaboration: Work closely with business analysts, stakeholders, and other IT teams to gather requirements and deliver solutions aligned with business goals.
Training & Documentation: Provide knowledge transfer, training, and technical documentation to ensure smooth transition and adoption of modernized applications.
Required Qualifications & Skills:
5+ years of experience in Oracle application development, including Apex and PL/SQL.
Strong expertise in Oracle Apex 22.x or later, including Dynamic Actions, RESTful Web Services, and Interactive Reports.
Proficiency in PL/SQL development, including performance tuning and optimization.
Experience with Power BI and BI Publisher for data visualization and reporting.
Hands-on experience in migrating legacy Oracle Forms and Reports applications to modern platforms.
Knowledge of Oracle Database (12c/19c), SQL, and relational database design.
Familiarity with APIs, RESTful web services, and JSON/XML processing in Oracle Apex.
Understanding of security best practices in Apex development, including authentication and authorization mechanisms.
Experience with source control tools, including GitHub, Git, and/or Azure DevOps.
Strong problem-solving skills, ability to work independently, and excellent communication skills.
Preferred Qualifications:
Strong experience in Oracle PL/SQL.
Familiarity with Oracle Forms and Oracle Reports.
Strong development experience in Oracle Apex.
Experience in cloud-based deployment (Oracle Cloud, AWS, or Azure).
Knowledge of JavaScript, HTML, and CSS for Apex UI customization.
Familiarity with Agile development methodologies.
Experience with CI/CD pipeline integration for Apex.
Oracle PL/SQL, Oracle Forms 12c, Oracle Reports 12c, Experience with RESTful web services
Strong expertise in Oracle Apex 22.x or later, including Dynamic Actions, RESTful Web Services, and Interactive Reports.
Proficiency in PL/SQL development, including performance tuning and optimization.
Experience with Power BI and BI Publisher for data visualization and reporting.