Hybrid Senior Oracle APEX Developer

at Advansys

• Job title: Senior Oracle APEX Developer
• Job type: Full Time
• Experience level: Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Cloud, JavaScript, jQuery, Oracle, SQL, Subversion
• Location requirements: Hybrid, Nasr City, Egypt

About the role

• Senior Oracle APEX Developer creating scalable and efficient web applications for Advansys. Collaborating with stakeholders and providing mentorship while ensuring code quality and performance.

Responsibilities

• 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.