JobScans.in

Job description

**Job description** **Role :Oracle APEX** **Location : PAN INDIA** **Ecperience : 7-12 years** **Required Technical Skill Set** - **Oracle APEX (SQL, PL/SQL)** - **Forms, Reports & Interactive Grids** - **Workflow Automation & Process Design** - **Oracle Visual Builder Cloud Service (VBCS)** - **REST APIs & ORDS Integration** - **Oracle Integration Cloud (OIC)** - **Fusion ERP APIs & SaaS Extensions** - **Oracle Database & Data Modelling** - **SQL Performance Tuning** - **Oracle Cloud Infrastructure (OCI)** - **Autonomous Database** - **End-to-End Application Development & Integration** **Must-Have** - **Design, develop, and maintain scalable Oracle APEX applications, including custom forms, interactive reports, dashboards, and workflow-driven business solutions to meet enterprise requirements.** - **Strong expertise in Oracle APEX development using SQL and PL/SQL.** - **Experience in building Forms, Reports, Interactive Grids, and workflow-based applications.** - **Proficiency in Oracle Visual Builder Cloud Service (VBCS) for UI development and Fusion SaaS extensions.** - **Hands-on experience with REST APIs, ORDS, Oracle Integration Cloud (OIC), and web service integrations.** - **Good understanding of Oracle Fusion ERP data structures, APIs, and cloud integration patterns.** - **Strong knowledge of Oracle Database concepts, data modelling, and SQL performance tuning.** - **Exposure to Oracle Cloud Infrastructure (OCI) and Autonomous Database environments.** - **Experience delivering end-to-end application solutions across applications, integration, and database layers.** **Good-to-Have** **Exposure to OCI services** **Experience with DevOps and version control** **Knowledge of Fusion ERP data structures** **Responsibility of / Expectations from the Role** - **Design, develop, and maintain scalable Oracle APEX applications, including custom forms, interactive reports, dashboards, and workflow-driven business solutions to meet enterprise requirements.** - **Leverage strong SQL and PL/SQL expertise to develop efficient database objects, stored procedures, packages, and optimized queries that support high-performance application processing.** - **Build intuitive and responsive user interfaces using Oracle Visual Builder Cloud Service (VBCS), ensuring a seamless user experience across desktop and mobile platforms.** - **Develop and enhance workflow automation capabilities by translating business processes into automated, configurable, and auditable application workflows.** - **Integrate Oracle APEX and VBCS applications with Oracle Fusion Applications and third-party systems using REST APIs, ORDS services, and Oracle Integration Cloud (OIC).** - **Collaborate with functional stakeholders, business users, and solution architects to gather requirements, perform impact analysis, and propose effective technical solutions.** - **Design and implement Fusion SaaS extensions and custom applications that complement Oracle Cloud solutions while adhering to Oracle-recommended extension frameworks.** - **Perform application troubleshooting, root-cause analysis, performance tuning, and defect resolution across application, integration, and database layers to ensure system stability.** - **Contribute to database design, data modelling, and optimization activities, including query tuning, indexing strategies, and management of Oracle Cloud and Autonomous Database environments.** - **Prepare technical documentation, conduct knowledge-sharing sessions, support testing and deployment activities, and ensure adherence to development standards, security guidelines, and best practices throughout the application lifecycle** **Role:** **IT & Information Security - OtherIndustry Type:** **IT Services & ConsultingDepartment:** **IT & Information SecurityEmployment Type:** **Full Time, PermanentRole Category:** **IT & Information Security - OtherEducationUG:** **Any Graduate, B.Tech / B.E. in Any SpecializationKey SkillsSkills highlighted with are preferred keyskillsOracleVbcsOracle Application Express ApexPLSQLApex**