Overview:

We are seeking a Software Developer (Oracle APEX)

Consultant to act as a Software Developer for the APEX Team in the OSC Division of the Chief Information Officer (CIO).

Responsibilities:

• Work under the guidance of the APEX Team Manager and Supervisor.
• Help OSC management develop APEX Roadmap and Strategy.
• Contribute to the development and establishment of the APEX Operating Model.
• Assess OSC APEX methodologies, practices, and activities and advise APEX Team on how they can be improved.
• Evaluate business functions, analyze business requirements, and assess feasibility, impact, and/or implications of using APEX.
• Guide development of APEX designs that are scalable and meet business requirements.
• Help the APEX team to establish a robust APEX Security Model, including integration with Active Directory for authentication and authorization.
• Assist APEX developers with building of shared components.
• Develop custom APEX applications.
• Prepare documentation associated with the development and implementation of new APEX applications.
• Perform quality assurance checks and post-implementation reviews.
• Collaborate and/or share knowledge with other staff in troubleshooting tasks.
• Keep management, APEX Team, and stakeholders fully informed on the status of work.
• Follow APEX industry best practices throughout the process.
• Hold Knowledge Transfer sessions with OSC Staff.

Experience:

• 60 Months of Experience with using Oracle APEX software, with experience in Oracle APEX 17.x-21.x and Oracle Database 11g-21c.
• 60 Months of Experience with Oracle APEX security, authentication, and authorization schemes.
• 60 Months of Experience with Oracle APEX analysis, design, development, testing, implementation, and maintenance of forms, interactive reports, interactive grids, collections, graphs, dashboards, and generating reports.
• 48 Months of Experience with JavaScript, JSON, Web Services, XML, HTML, and UI/UX.
• 60 Months of Experience with designing, developing, testing, and documenting new applications and supporting/enhancing existing applications on the Oracle APEX platform.
• 60 Months of Experience with creation of dynamic reports in Oracle APEX environment using reporting tools (e.g. BI Publisher).
• 60 Months of Experience with SQL and query performance tuning.
• 60 Months of Experience with PL/SQL (procedures, functions, packages), cursors, triggers, collections, transactional modeling, database normalization, indexing methods, constraints, performance tuning, security, auditing, metadata management.
• 12 Months of Experience with migration of legacy applications to Oracle APEX.

Job Types: Full-time, Contract

Pay: $55.79 - $62.79 per hour

Compensation package:

• 1099 contract

Experience level:

• 5 years

Schedule:

• 8 hour shift
• Monday to Friday

Ability to Relocate:

• Albany, NY: Relocate before starting work (Required)

Work Location: In person