APEX Developer

About This Role

Serve as a highly experienced APEX Developer for a client in Brooklyn, NY, developing APEX applications within large teams and collaborating on troubleshooting. This role requires expert-level knowledge of APEX with a focus on newer versions and strong backend database design skills.

Responsibilities

• Develop APEX applications, working in large teams with multiple developers
• Use JavaScript libraries/frameworks supported by Oracle APEX to develop modern UIs
• Create packages, procedures, functions, materialized views, and complex SQL queries
• Collaborate with DevOps and Server Administrators to investigate and troubleshoot errors
• Follow architecture team's coding standards and best practices

Requirements

• 4+ years of experience as an APEX Developer
• Expert-level knowledge and understanding of Oracle APEX
• Demonstrated experience in newer versions of Oracle APEX – at least version 21.3 or above
• Strong knowledge of APEX Universal Theme and how to use it for various UI requirements
• Hands-on experience in using HTML and CSS to customize the look & feel and behavior of Oracle APEX applications
• Strong understanding of the out-of-the-box CSS available in Oracle APEX and how to utilize them
• Extensive knowledge of JavaScript libraries/frameworks used with Oracle APEX – jQuery and Oracle JET
• Proficient in developing and consuming REST APIs and with Oracle Rest Data Services (ORDS)
• Good understanding of the structure of XML, JSON, DOM
• Proficient in Oracle 11g/12c or higher databases
• Oracle Database Design and development (SQL & PL/SQL) with respect to Application Development
• Strong working knowledge in PL/SQL coding and Application Express API
• Strong working skills to integrate with CSS class and JavaScript event inside SQL, and how to write application process for the JavaScript event to meet functionality requirements
• Good understanding of Views, MVs, DB links and refresh methods
• Experience in creating and remodeling legacy data models for Human Resource Management Systems
• Ability to analyze and resolve complex infrastructure resource and application deployment issues

Qualifications

• 4+ years of experience as an APEX Developer

Nice to Have

• Knowledge of Oracle Forms and Reports and OBIEE reporting tool
• Knowledge in database migration, performance tuning and optimization in 12c environment
• Good knowledge of ERWIN or another data modelling tool
• Experience in ETL, data load process, delta load process and data migration
• Good knowledge of JSON files development and storage using standards and best practices in Oracle 12c
• Experience in APEX Custom Plug-in development
• Experience in Oracle APEX database installation and troubleshooting
• Proven ability to work creatively and analytically in a problem-solving environment

Skills

* Required skills