Oracle Apex full Stack Developer - Fully REMOTE
Posted 3 days ago by 1765520912
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 ideal candidate will have extensive experience in Oracle SQL and data integration for the Oracle Enterprise Resource Planning system. This role requires a strong background in developing and maintaining Oracle applications using Oracle Apex. The position is fully remote but requires availability during specific hours.
Key Responsibilities:
- Design and implement browser-based applications using Oracle Apex.
- Maintain custom Oracle applications and develop scripts in SQL and PL/SQL for data conversion and migration.
- Optimize queries and tune performance 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 requirement gathering sessions and define solution sets.
Key Skills:
- 10 years of experience as an Oracle Apex full stack developer.
- Proficiency in designing and maintaining custom Oracle applications.
- Expertise in SQL and PL/SQL scripting for data management.
- Experience with query optimization and performance tuning.
- Ability to debug applications and resolve defects efficiently.
- Strong skills in creating dynamic reports using Oracle APEX.
- 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
RIC - Programmer Analyst 4
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.
Required/Desired Skills
| 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 |
Questions
| No. | Question |
|---|---|
| Question1 | Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment? |
| Question2 | Please list candidate's email address. |
| Question3 | Remote but must be fully available between the hours of 9 am 6 pm EST |
| Question4 | Please list the city/state where the candidate is located. |