We are 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