Overview
Skills
Job Details
We are seeking a highly skilled Oracle Apex Developer with expertise in PL/SQL, Power BI, and BI Publisher 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 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 completed.
version Control & Deployment: Implement best practices for version control 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 (Git, Azure DevOps, or similar).
Strong problem-solving skills, ability to work independently, and excellent communication skills.
Strong Experience in Oracle PL/SQL
Familiarity with Oracle Forms, Oracle Reports
Strong development experience 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 applications.