Overview
Hybrid
Up to $75
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Oracle
APEX
SQL
Job Details
Job Title: Oracle APEX Full Stack Developer
Job ID - 774768
Employment Type: Long-term Contract
Location - Richmond, VA (remote)
Employment Type: Long-term Contract
Location - Richmond, VA (remote)
Job Overview:
The City is seeking a highly skilled and experienced Oracle APEX Full Stack Developer to support and enhance a robust financial application critical to the City s revenue operations. The ideal candidate will have extensive expertise in designing, developing, and maintaining custom Oracle APEX applications, as well as integrating complex data into the City s Oracle Enterprise Resource Planning (ERP) system. This role requires exceptional SQL/PLSQL skills, performance optimization abilities, and experience delivering high-quality solutions in a fast-paced environment.
Key Responsibilities:
- Lead the design, development, and maintenance of custom Oracle APEX applications to support financial and operational needs.
- Gather and analyze business requirements, define technical solutions, and implement browser-based applications using Oracle APEX.
- Develop and maintain complex SQL and PL/SQL scripts for data conversion, migration, and integration with ERP systems.
- Create and optimize External Tables, Joins, Indexes, and Sequences; develop ad-hoc SQL queries and shell scripts as required.
- Perform query optimization and application performance tuning using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, and Bulk Collect.
- Debug and remediate defects in complex applications to ensure stability and reliability.
- Design and implement dynamic reports using Oracle APEX reporting tools.
- Collaborate with stakeholders, lead requirement-gathering sessions, and manage solution delivery.
Required Qualifications:
- Experience as an Oracle APEX Full Stack Developer, including requirement gathering, design, and implementation of browser-based applications.
- Experience designing and maintaining custom Oracle APEX applications.
- Experience in SQL and PL/SQL development for data conversion, migration, and integration.
- Experience with External Tables, Joins, Indexes, Sequences, and shell scripting.
- Experience in query optimization, performance tuning, and debugging using advanced Oracle tools and techniques.
- Experience creating dynamic reports within the Oracle APEX environment.
- Strong leadership and communication skills to lead requirement sessions and define solution sets.
Preferred Qualifications:
- Experience working in government or public sector financial systems.
- Familiarity with Oracle ERP system integrations.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.