APEX Developer REMOTE (701223)

City of Richmond is seeking an experienced APEX developer• Creating database tables, structures, schemas and dictionaries• Ensuring data quality, integrity and security• Preparing documentation for database applications• Creating SQL queries that integrate with other applications• Attending daily remote scrum calls• Preparing APEX applications to support business processes• Creating reports to support business needs

Requirements

Skill

Required / Desired

Amount

of Experience

Candidate

Experience as an Oracle Apex full stack developer, including gathering requirements, developing and implementing browser-based applications

Required

10

Years

using, Application Express (APEX 18 or higher) and Web Technologies.

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

Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, (Cont below)

Required

10

Years

(cont from Above) , Bulk Collect, Creation of global temporary tables and table partitioning

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