Oracle APEX Developer

Description

Summary: The Oracle APEX Developer will design, develop, test, and maintain Oracle APEX applications, translating business requirements into scalable, intuitive, and compliant solutions. Highlights: 1. Develop interactive APEX pages, forms, reports, dashboards, and workflows 2. Design and develop PL/SQL packages, procedures, functions, and triggers 3. Integrate APEX applications with REST APIs, web services, and external systems **Job Title: Oracle APEX Developer (Contract – 1 Year)** **Location: Muscat (Onsite)** **Engagement Type: Full\-Time Contract (12 Months)** **Role Overview** The Oracle APEX Developer will be responsible for the **design, development, testing, and maintenance** of Oracle APEX applications in alignment with defined business and system requirements. The role operates within a structured delivery model, working under the guidance of the **Solution Architect and Functional Analysts** to translate **BRDs and SRSs into scalable, intuitive, and compliant solutions**, adhering to the organization standards, data governance policies, and security frameworks. **Key Responsibilities** **Application Development** * Develop interactive **APEX pages, forms, reports, dashboards, and workflows** * Build intuitive and user\-centric interfaces aligned with business processes * Implement reusable components and modular application structures **Database \& Backend Development** * Design and develop **PL/SQL packages, procedures, functions, and triggers** * Optimize SQL queries and database objects for **performance and scalability** * Ensure data integrity and adherence to enterprise data models **Integration \& Interoperability** * Integrate APEX applications with: * **REST APIs and web services** * External databases and enterprise systems * Handle data exchange using **JSON/XML formats** * Support integration with enterprise platforms (HRMS, Finance, etc.) **UI/UX \& Responsiveness** * Implement **responsive APEX designs** compatible with desktop and mobile devices * Apply UI best practices to enhance usability and accessibility **Security, Validation \& Controls** * Implement **data validation, exception handling, and error management** * Configure **role\-based access controls and security policies** * Ensure compliance with ministry data governance and security standards **Testing \& Quality Assurance** * Perform **unit testing and peer code reviews** * Collaborate with QA teams to resolve **functional and integration defects** * Ensure quality and stability across releases **Agile Delivery \& Collaboration** * Participate in: * Requirement clarification sessions * Sprint planning and backlog refinement * Work closely with architects, analysts, testers, and stakeholders * Provide timely updates and adhere to sprint commitments **Deployment \& Knowledge Transfer** * Support **deployment preparation and release activities** * Maintain technical documentation of developed modules * Contribute to **knowledge transfer and handover sessions** **Required Qualifications** * Bachelor’s degree in Computer Science, IT, or related discipline * **5\+ years of Oracle development experience** * **Minimum 3\+ years hands\-on Oracle APEX experience** * Strong expertise in: * Oracle APEX (latest versions preferred) * PL/SQL and SQL performance tuning * Experience in API integration (REST/SOAP) * Preferably bilingual (English/Arabic) Work Location: In person