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
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 |
|