APEX Developer

JSM Consulting Inc.; New York (NY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

JSM Consulting Inc. is seeking a senior Oracle APEX developer for a NYC government project in Brooklyn, NY. The role requires 4+ years of hands-on Apex development and strong UI, REST API, and database design skills.

Hybrid work is preferred with 3 onsite days weekly; in-person interviews will be conducted. Expect collaboration across a large development team and adherence to established coding standards. Candidate should be proficient in Oracle 11g/12c, PL/SQL, JSON/XML, and related web

Qualifications

• Expert Oracle APEX knowledge (21.3+).
• HTML/CSS customization for Apex apps and UI theming.
• Strong UI skills using Oracle APEX Universal Theme.
• REST APIs development using ORDS.
• Oracle SQL/PLSQL development and database design.
• JavaScript libraries like jQuery and Oracle JET.
• Knowledge of XML/JSON/DOM structures.
• Experience with Oracle databases 11g/12c+.
• Ability to collaborate with DevOps and server admins.
• Adherence to architecture standards and best practices.

Responsibilities

• Develop and maintain Oracle APEX applications (21.3+).
• Customize UI with HTML/CSS; apply Universal Theme across pages.
• Design and optimize Oracle databases and write complex SQL/PLSQL.
• Develop and consume REST APIs using ORDS.
• Collaborate with DevOps to troubleshoot deployment issues.
• Follow coding standards defined by the architecture team.
• Work in a large, multi-developer Oracle APEX team.

Skills

Oracle Apex

HTML/CSS

JavaScript

REST APIs

PL/SQL

Oracle Database

XML/JSON/DOM

jQuery

Oracle JET

ORDS

Tools

ERWIN

REST API tools

Job description

RATE : OPEN
Client: NYC Government Client
Location: Brooklyn NY 11201
35hours per week
Interview Type: in-person interviews.
" Hybrid preferred. 3-days onsite.
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. Must be able to collaborate with DevOps and Server administrators to investigate and troubleshoot errors. Follow architecture team's coding standards and best practices.
4+ years' experience minimum.
Mandatory Skills/Experience

• 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
  

Desirable Skills/Experience

• 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