This role involves designing, developing, and enhancing enterprise applications using the Oracle APEX development framework. The position requires expertise in PL/SQL, JavaScript, CSS, and HTML to create modern, responsive APEX applications. The focus includes implementing complex business logic, improving UI/UX, integrating REST APIs, and optimizing application performance. Additionally, the role leverages cutting-edge Generative AI and Agentic AI technologies such as AI Agents, AI Tools, Retrieval-Augmented Generation (RAG), vector search, and AI-assisted development to enhance application capabilities.
Key Responsibilities
- Develop complex PL/SQL packages, procedures, functions, SQL queries, and implement intricate business logic.
- Build responsive and modern user interfaces using CSS, JavaScript, HTML, Dynamic Actions, and APEX components.
- Create interactive dashboards, reports, forms, Interactive Grids, charts, and custom application components tailored to business needs.
- Develop and consume REST APIs and JSON-based integrations utilizing APEX and Oracle REST Data Services (ORDS).
- Integrate Generative AI and Agentic AI features within APEX applications to enhance functionality.
- Work with AI Agents, AI Tools, RAG, vector search, and AI-assisted development techniques where applicable.
- Develop AI-enabled business processes using PL/SQL and JavaScript within the APEX environment.
- Optimize application performance by fine-tuning SQL, PL/SQL, and APEX components.
- Support application testing, deployment, troubleshooting, and resolve production issues efficiently.
- Adhere to coding standards, security protocols, performance best practices, and overall application development guidelines.
Required Qualifications
- Advanced proficiency in Oracle APEX development, including strong skills in SQL and PL/SQL.
- Solid experience with JavaScript, HTML, CSS, and APEX Dynamic Actions for building responsive user interfaces.
- Expertise in developing and integrating REST APIs, handling JSON data, and implementing AJAX callback processes.
- Knowledge of APEX security features, authentication mechanisms, and performance optimization techniques.
- Familiarity with Generative AI, large language model (LLM) integration, AI Agents, and AI Tools.
- Understanding of Retrieval-Augmented Generation (RAG), vector search technologies, and AI-assisted application development.
Preferred Qualifications and Additional Skills
- Experience with Oracle E-Business Suite (EBS) R12.2 is considered an advantage.
- Knowledge of ABP Framework, .NET, or ASP.NET Core development frameworks will be beneficial.
- Exposure to AI-driven development tools and frameworks to further enhance enterprise application capabilities.
This position offers an exciting opportunity to work at the intersection of traditional enterprise application development and emerging AI technologies, driving innovation and efficiency within Oracle APEX environments.