Role: RIC - Programmer Analyst 4 (774768)Location: 900 E Broad Street, Richmond VA(Web Cam Interview Only.) 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. SkillRequired / DesiredAmountof Experience Oracle Apex full stack developer, including gathering requirements, developing and implementing browser-based applications using, Application ExpressRequired10YearsExperience designing and maintaining custom Oracle applications using Oracle Apex;Required10YearsExperience in developing scripts in SQL, PLSQL for data conversion, data migrationRequired10YearsExperience in developing External Tables, Joins, Indexes and sequences. Ability to write ad-hoc SQL queries and code shell scripts as needed.Required10YearsQuery optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk CollectRequired10YearsExperience debugging complex applications and remediating defects in a fast paced environment.Required10YearsEffective creation of dynamic reports within the Oracle APEX environment, using APEX reporting toolsRequired10YearsAbility to lead groups/gather requirements/define solution sets and remediate defectsRequired Apply tot his job