Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- 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.
Job Requirements
- 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_mail
- Preferred using CSS, JavaScript
