Apex Developer

Apex DeveloperBrooklyn, NY - Hybrid35 hrs./week Duration: 12 plusHybrid in Brooklyn, NY. Requirement is 3 days onsite. Local candidates only.OverviewWe 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.DutiesDevelop 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.Mandatory Qualifications4+ years of experience as an APEX DeveloperExpert-level knowledge and understanding of Oracle APEXDemonstrated experience in newer versions of Oracle APEX – at least version 21.3 or aboveStrong knowledge of APEX Universal Theme and know how to use it for various UI requirementsHands-on experience in using HTML and CSS to customize the look & feel and behavior of Oracle APEX applicationsStrong understanding of the out-of-the-box CSS available in Oracle APEX and how to utilize themExtensive knowledge of JavaScript libraries/frameworks used with Oracle APEX – jQuery and Oracle JETProficient in developing and consuming REST APIs and with Oracle Rest Data Services (ORDS)Good understanding of the structure of XML, JSON, DOMProficient in Oracle 11g/12c or higher databasesOracle Database Design and development (SQL & PL/SQL) with respect to Application DevelopmentStrong working knowledge in PL/SQL coding and Application Express APIStrong 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 requirementsGood understanding of Views, MVs, DB links and refresh methodsExperience in creating and remodeling legacy data models for Human Resource Management SystemsAbility to analyze and resolve complex infrastructure resource and application deployment issuesDesirable QualificationsKnowledge of Oracle Forms and Reports and OBIEE reporting tool is a plusKnowledge in database migration, performance tuning and optimization in 12c environmentGood knowledge of ERWIN or another data modelling toolExperience in ETL, data load process, delta load process and data migration a plusGood knowledge of JSON files development and storage using standards and best practices in Oracle 12cExperience in APEX Custom Plug-in developmentExperience in Oracle APEX database installation and troubleshootingProven ability to work creatively and analytically in a problem-solving environment