Senior Oracle Apex Developer

Role & responsibilities

Design, develop, and maintain complex Oracle APEX applications and components (interactive reports, forms, charts, dynamic actions). • Translate business requirements into scalable technical designs, data models, and APEX architectures. • Develop high-quality SQL and PL/SQL (packages, procedures, functions, triggers) with strong attention to performance and maintainability. • Implement RESTful API integrations (consume and expose) within APEX; build secure web service calls and handle JSON/XML payloads. • Design and implement Oracle APEX Workflow-driven processes (approvals, escalations, SLAs), including workflow modelling, task assignments, notifications, and audit trails. • Utilize Oracle APEX Collections and PL/SQL Collections for multi-row operations and wizard-like flows. • Customize UI using JavaScript, HTML, and CSS; create reusable templates, themes, and dynamic actions. • Optimize queries, indexes, and application performance; perform thorough performance tuning across SQL, PL/SQL, and APEX pages. • Ensure code quality through reviews, unit/integration testing, and documentation. • Collaborate with DBAs, BAs, QA, and product owners; provide production support and root-cause analysis. • Mentor junior developers and contribute to standards, tooling, and best practices.