Job Requirement
- Project Role: Oracle APEX Consultant
- Project Role Description: We are seeking an experienced Oracle APEX Consultant with a strong background in developing and implementing Oracle APEX applications. The ideal candidate should have 5 to 8 years of hands-on experience in Oracle APEX, PL/SQL, and database technologies. The consultant will be responsible for the design, development, and support of Oracle APEX applications tailored to meet the needs of various business processes.
- Work Experience: 5 to 8 years of experience.
- Work location: Chennai – Only work from office.
Technical Expertise – Must Have Skills
- 5-8 years of experience in developing Oracle APEX applications.
- Experience with Oracle APEX versions 18.x, 19.x, 20.x, and beyond.
- Strong proficiency in Oracle PL/SQL, SQL, and database concepts.
- Ability to write efficient, complex SQL queries, stored procedures, and triggers.
- Proficiency in web technologies: HTML, CSS, JavaScript, jQuery, and JSON.
- Experience in customizing Oracle APEX themes, templates, and dynamic actions.
- Expertise in Oracle Database 11g, 12c, 19c.
- Knowledge of Oracle WebLogic Server (preferred).
- Experience with Oracle APEX application optimization and database performance tuning.
- Ability to integrate reporting tools like BI Publisher , Oracle Analytics, Jasper, or Crystal with APEX applications.
- Excellent verbal and written communication skills to work effectively with business users and team members.
- Ability to understand business requirements and translate them into technical specifications.
Good To Have Skills
- Experience with Agile/Scrum methodologies.
- Knowledge of cloud platforms such as Oracle Cloud, AWS, or Azure.
- Oracle 23AI database – vector search
Key Responsibilities
-
Design and Development:
- Design, develop, and enhance Oracle APEX applications.
- Customize existing applications to improve usability, performance, and scalability.
- Translate business requirements into efficient technical solutions.
- Work with Oracle Database 11g, 12c, 19c to manage back-end integrations and develop PL/SQL procedures, functions, and triggers.
- Design efficient data models and ensure optimal database performance.
- Maintain and support existing Oracle APEX applications.
- Troubleshoot issues and perform root cause analysis for system errors or bugs.
- Monitor application performance and ensure scalability, reliability, and performance.
- Design user-friendly, responsive, and modern interfaces using Oracle APEX Universal Theme and CSS/HTML.
- Work closely with business users to gather requirements and ensure a seamless user experience.
- Implement security best practices in Oracle APEX applications (Authentication, Authorization, Session Management).
- Ensure application compliance with security standards (OWASP, etc.).
- Create and maintain technical documentation for Oracle APEX applications.
- Document and communicate best practices, development standards, and workflows
Database Integration:
Application Maintenance:
User Experience:
Security Management:
Documentation:
Professional Attributes
- Ability to work independently on any assigned task.
- Should be a good team player and willing to extend his support to peer team members.
- The candidate should be solution oriented beyond doing the assigned task.
- Should be self-motivated and initiate improvements and best practices.
Educational Qualification
- MCA, B.E, M.Sc (CS) or any other equivalent degree with relevant work experience.
- Oracle APEX Certification