Senior Oracle Apex Developer - W2 12+ years

Senior Oracle Apex Developer - W2 12+ years

Posted Today by 1765612090

Negotiable
Outside
Remote
USA

Summary: The City is seeking a full-time Senior Oracle Apex Developer to enhance a financial application that supports key revenue streams. The ideal candidate will have extensive experience in Oracle SQL and Oracle Apex, focusing on the integration of data for the Oracle Enterprise Resource Planning system. This role requires a strong background in developing and maintaining custom Oracle applications and optimizing performance. The position is remote and classified as outside IR35.

Key Responsibilities:

  • Gathering requirements and developing browser-based applications using Oracle Apex.
  • Designing and maintaining custom Oracle applications.
  • Developing scripts in SQL and PL/SQL for data conversion and migration.
  • Creating External Tables, Joins, Indexes, and sequences; writing ad-hoc SQL queries and shell scripts.
  • Optimizing query performance and tuning PL/SQL using various tools and techniques.
  • Debugging complex applications and remediating defects in a fast-paced environment.
  • Creating dynamic reports within the Oracle APEX environment using reporting tools.
  • Leading groups to gather requirements, define solutions, and remediate defects.

Key Skills:

  • 10+ years of experience as an Oracle Apex full stack developer.
  • Proficiency in designing and maintaining custom Oracle applications using Oracle Apex.
  • Strong skills in SQL and PL/SQL for data conversion and migration.
  • Experience with External Tables, Joins, Indexes, and sequences.
  • Ability to optimize queries and tune PL/SQL performance.
  • Experience in debugging complex applications.
  • Ability to create dynamic reports using APEX reporting tools.
  • Leadership skills for gathering requirements and defining solutions.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:

The City seeks a full time Oracle Apex full stack developer to support a robust financial application supporting key revenue streams for the City. Candidate must be experienced with designing and executing complex Oracle SQL logic in the integration of data to support its Oracle Enterprise Resource planning system.

Skill

Required / Desired

Amount

of Experience

Oracle Apex full stack developer, including gathering requirements, developing and implementing browser-based applications using, Application Express

Required

10

Years

Experience designing and maintaining custom Oracle applications using Oracle Apex;

Required

10

Years

Experience in developing scripts in SQL, PLSQL for data conversion, data migration

Required

10

Years

Experience in developing External Tables, Joins, Indexes and sequences. Ability to write ad-hoc SQL queries and code shell scripts as needed.

Required

10

Years

Query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect

Required

10

Years

Experience debugging complex applications and remediating defects in a fast paced environment.

Required

10

Years

Effective creation of dynamic reports within the Oracle APEX environment, using APEX reporting tools

Required

10

Years

Ability to lead groups/gather requirements/define solution sets and remediate defects

Required

10

Years