Oracle Apex Full Stack Developer
Posted 4 days ago by 1765433471
Negotiable
Outside
Remote
USA
Summary: The City is seeking a full-time Oracle Apex Full Stack Developer to enhance a financial application that supports key revenue streams. The role requires extensive experience in Oracle SQL and the integration of data for the Oracle Enterprise Resource Planning system. The ideal candidate will have a strong background in developing and maintaining Oracle applications using Oracle Apex. This position is fully remote and emphasizes the need for effective debugging and report generation within the Oracle APEX environment.
Key Responsibilities:
- Design and execute complex Oracle SQL logic for data integration.
- Gather requirements and develop browser-based applications using Oracle Application Express.
- Maintain custom Oracle applications and perform data conversion and migration using SQL and PLSQL.
- Develop External Tables, Joins, Indexes, and sequences; write ad-hoc SQL queries and shell scripts.
- Optimize query performance and tuning using SQL Trace, Explain Plan, and other techniques.
- Debug complex applications and remediate defects in a fast-paced environment.
- Create dynamic reports within the Oracle APEX environment using APEX reporting tools.
- Lead groups to gather requirements, define solution sets, and remediate defects.
Key Skills:
- 10+ years of experience as an Oracle Apex full stack developer.
- Proficient in designing and maintaining custom Oracle applications using Oracle Apex.
- Strong skills in SQL and PLSQL for data conversion and migration.
- Experience with External Tables, Joins, Indexes, and sequences.
- Ability to write ad-hoc SQL queries and shell scripts.
- Expertise in query optimization and performance tuning (PL/SQL).
- 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: undetermined
Industry: IT
Role: Oracle Apex Full Stack Developer
Location: 100% Remote
Duration: 6+ Months
Interview: Phone/MS-Teams/F2F
Work Arrangement: Remote
Description:
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