Oracle APEX Developer

Job Title: Oracle APEX Developer
Location: Brooklyn, NY - Hybrid
Company: PruTech Solutions, Inc.

About Us:

Established in 1997, PruTech is committed to innovative problem-solving, solution creation, and fostering strong client partnerships. Serving a diverse array of industries, from government to finance, retail, and manufacturing, PruTech operates from strategic locations including New York City, Washington DC, North Carolina, and boasts a nearshore office in Mexico City and multiple offshore offices in India.

With over two decades of experience in Information Technology and system integration, PruTech offers a comprehensive suite of services to meet evolving technological needs:

• Project-based system integration
• Custom software solutions
• Package implementations
• Consulting and advisory services
• Big data and analytics
• Nearshore and offshore services

At PruTech, we are dedicated to shaping the future of technology and driving success for our clients through innovative solutions and strategic partnerships.

JOB DESCRIPTION:

APEX Developer

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