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.
