Overview
Skills
Job Details
Ideal Candidate Profile: The ideal candidate is a highly skilled Oracle APEX full-stack developer with deep experience building, optimizing, and maintaining enterprise-grade applications in Oracle environments. They bring a strong command of SQL, PL/SQL, performance tuning, and data integration to support a mission-critical financial system that powers key revenue streams for the City. This candidate thrives in fast-paced environments, independently translating business needs into scalable technical solutions, while maintaining exceptional attention to detail and code quality.
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.
Job Responsibilities:
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