Apex Developer

Damco Solutions; New York (NY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

A leading technology solutions firm is seeking a highly experienced APEX Developer for a hybrid role in Brooklyn, NY. The ideal candidate will have expert knowledge of Oracle APEX and strong skills in SQL and PL/SQL. Responsibilities include developing applications in large teams, creating complex queries, and collaborating with DevOps to troubleshoot issues. The position requires 4+ years of experience, with a focus on current APEX versions, making it suitable for candidates with a strong background in database design and modern UIs.

Qualifications

• 4+ years of experience as an APEX Developer.
• Expert-level knowledge of Oracle APEX and application development.
• Strong proficiency in backend database design and development.

Responsibilities

• Develop APEX applications with multiple developers.
• Create SQL queries, packages, procedures, and functions.
• Collaborate with DevOps to troubleshoot errors.

Skills

Oracle APEX

PL/SQL

REST APIs

HTML

CSS

XML

JSON

Tools

Oracle APEX

Oracle 11g/12c

ORDS

Job description

Location: Hybrid in Brooklyn, NY. Requirement is 3 days onsite. Local candidates only.

Overview

We are seeking a highly experienced APEX Developer who will support our client. The ideal candidate for this role will have expert-level knowledge of APEX with demonstrated application development experience in the newer versions of Oracle APEX. This role will be expected to develop APEX applications in large teams with multiple developers and collaborate with DevOps and Server administrators to investigate and troubleshoot errors. Candidates should have a strong proficiency in backend database design and development, and knowledge of relevant libraries/frameworks to enable the development of modern UIs.

Duties

• Develop APEX applications, working in large teams with multiple developers.
• 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.

Mandatory Qualifications

• 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 know 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
• 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
• 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 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 Oracle APEX database installation and troubleshooting
• Proven ability to work creatively and analytically in a problem-solving environment