Oracle Apex Developer

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. Preferred Qualifications: • 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. Additional Skills and Information: • 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.