- Design, develop, and deploy Oracle APEX applications to meet business requirements.
- Create and manage interactive reports, forms, charts, and dashboards within Oracle APEX.
- Develop custom PL/SQL code to extend the functionality of APEX applications.
- Implement responsive design practices to ensure applications are user-friendly on various devices.
- Design and manage the underlying Oracle database schema, including tables, views, indexes, and constraints.
- Write complex SQL queries to retrieve and manipulate data efficiently.
- Optimize database performance by tuning SQL queries and indexing strategies.
- Develop and maintain database procedures, functions, triggers, and packages using PL/SQL.
- Create user-friendly and visually appealing interfaces using APEX's built-in themes and templates.
- Customize the look and feel of applications by modifying CSS, JavaScript, and HTML.
- Ensure applications are accessible and conform to web standards.
- Integrate APEX applications with other systems and databases using web services (SOAP/REST) or database links.
- Develop APIs to allow other systems to interact with APEX applications.
- Implement single sign-on (SSO) and other authentication mechanisms as required.
- Perform unit testing and debugging of APEX applications to ensure they function as intended.
- Use Oracle APEX's debugging tools to identify and fix issues.
- Participate in code reviews to ensure high-quality deliverables.
- Create and maintain documentation for applications, including technical specifications, user manuals, and design documents.
- Provide training and support to end-users and other developers on using and maintaining APEX applications.
- Work closely with business analysts, project managers, and other stakeholders to gather and understand application requirements.
- Collaborate with other developers to design and implement best practices for APEX development.
- Communicate project status, issues, and risks to project managers and stakeholders.
- Monitor and maintain existing APEX applications, including applying updates and patches.
- Provide technical support to users, troubleshoot issues, and resolve bugs.
- Continuously improve applications based on user feedback and evolving business needs.
- Implement security best practices to protect applications and data, including user authentication, authorization, and encryption.
- Ensure applications comply with organizational policies, industry standards, and regulatory requirements.
- Optimize the performance of APEX applications by refining SQL queries, PL/SQL code, and application design.
- Monitor application performance and make adjustments to improve speed and efficiency.
Bachelor's Degree in Computer Science, Information Technology, Software Engineering, or a related field is often required. Strong analytical and problem-solving skills to troubleshoot and optimize applications.Effective communication skills to collaborate with team members, stakeholders, and end-users.Precision in coding and testing to ensure applications are robust and free of errors.Ability to work well in a team environment, often collaborating with other developers, business analysts, and project managers. Ability to manage multiple tasks and projects simultaneously, meeting deadlines and prioritizing work effectively.Experience with Oracle Database and relational data modelling.Experience to design, develop, deploy, test, and troubleshoot new applications.Experience using Jasper Report to make system reports.Experience using dynamic actions, pages process, application process, utl_smtp, utl_mailPreferred using CSS, JavaScript