What are the responsibilities and job description for the Oracle Apex Developer position at InvestM Technology LLC?
Title: Oracle Apex Developer
Duration: 12 months
Location: Brooklyn, NY
Visa: USC/GC/EAD (no layers)
Key Responsibilities:
- Expert-level knowledge of Apex is required with demonstrated application development experience in the newer versions of Oracle Apex – at least version 18.2 or higher.
- The candidate should also have experience developing Apex applications in large teams with multiple developers working in parallel.
- Strong knowledge of relevant JavaScript libraries/frameworks typically used and supported by Oracle Apex is also necessary to enable the development of modern UIs.
- Should also have a strong proficiency in backend database design and development with Oracle 11g/12c or higher including creating packages, procedures, functions, materialized views and complex SQL queries.
Mandatory Qualifications:
- Expert-level knowledge and understanding of Oracle Apex
- Hands-on experience in using HTML and CSS to customize the look & feel and behavior of Oracle Apex applications
- Strong knowledge of APEX Universal Theme and know how to use it for various UI requirements
- Strong understanding of the out-of-the-box CSS available in Oracle Apex and how to utilize them
- Demonstrated experience in newer versions of Oracle Apex – at least version 21.3 or above
- 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 on integrate with CSS class and JavaScript event inside SQL, and know 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.
Desired Qualifications:
- Knowledge of Oracle Forms and Reports and OBIEE reporting tool is a plus
- 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 a plus
- 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
