Job ID: 788519
Oracle Apex full stack developer
Client: State of Virginia RIC
Duration: 12 Months
Location: 100% Remote
Specific Skills required for this position:
- Oracle Apex full stack
- Designing and maintaining custom Oracle applications using Oracle Apex
- Developing scripts in SQL, PLSQL for data conversion, data migration
Job Summary:
- 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 Skills:
- Oracle Apex full stack developer, including gathering requirements, developing and implementing browser-based applications using, Application Express
- Experience designing and maintaining custom Oracle applications using Oracle Apex;
- Experience in developing scripts in SQL, PLSQL for data conversion, data migration
- Experience in developing External Tables, Joins, Indexes and sequences. Ability to write ad-hoc SQL queries and code shell scripts as needed.
- Query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect
- Experience debugging complex applications and remediating defects in a fast paced environment.
- Effective creation of dynamic reports within the Oracle APEX environment, using APEX reporting tools
- Ability to lead groups/gather requirements/define solution sets and remediate defects