Job Description

We are looking for a talented Senior Oracle APEX Developer to join our team at Advansys. The ideal candidate will have extensive experience in developing and enhancing web applications leveraging Oracle APEX, with a strong understanding of database design, PL/SQL programming, and best practices. You will be responsible for creating scalable and efficient applications that meet business requirements while maintaining high standards of code quality and performance.



Design, develop, and maintain Oracle APEX applications.

Collaborate with stakeholders to gather and analyze requirements.

Perform database design and SQL tuning to maximize performance.

Implement security practices to safeguard applications and data.

Conduct application testing and debugging to ensure quality deliverables.

Provide technical guidance and mentorship to junior developers.

Document development processes and application architecture.

Stay up-to-date with the latest Oracle APEX features, tools, and trends.

Requirements



? Core Technical Skills



Advanced knowledge of APEX architecture and components.

Experience in building complex interactive reports, forms, dashboards, and charts.

Expertise in APEX security (authentication, authorization, session state protection).

Familiarity with APEX plug-ins and customizations.

Strong proficiency in writing complex PL/SQL procedures, functions, packages, and triggers.

Performance tuning and optimization of PL/SQL code.

Knowledge of Oracle database concepts (indexes, partitions, constraints).

Oracle REST Data Services (ORDS)

Experience in configuring and deploying ORDS for APEX applications.

Building RESTful web services using ORDS.

Integration of ORDS with external systems and APIs.



? Front-End Development

HTML5, CSS3:

Ability to create responsive and accessible UI.

JavaScript & jQuery:

Strong skills in DOM manipulation, event handling, and dynamic UI.

AJAX:

Implementing asynchronous calls for better user experience.

Familiarity with APEX JavaScript APIs and dynamic actions.

? Additional Skills

SQL Performance Tuning and query optimization.

Version Control (Git, SVN).

Deployment & Migration of APEX applications across environments.

Integration with third-party systems and APIs.

Understanding of Web Security Standards (XSS, CSRF, SQL Injection prevention).



? Soft Skills



Strong problem-solving and analytical skills.

Ability to work independently and mentor junior developers.

Excellent communication and documentation skills.



? Preferred Experience



Working on enterprise-level APEX applications.

Knowledge of Oracle Cloud Infrastructure (OCI) or similar cloud platforms.

Familiarity with CI/CD pipelines for APEX deployments.

Benefits

Competitive salary and performance-based bonuses.

Hybrid working model (office + remote flexibility).

Continuous learning opportunities and professional development.

Exposure to enterprise-grade technologies and global clients.

Collaborative, growth-oriented work culture.

Health and social insurance coverage.

Career advancement within Egypt's leading digital transformation hub.