Senior Oracle APEX Developer

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.