Remote Oracle APEX & Forms Modernization Engineer

Diversified Systems.com; Harrisburg (Dauphin County); Remote; USD 110,000 - 140,000; Full time

Job summary

Diversified Systems is seeking an experienced Oracle Developer to modernize legacy Oracle Forms into Oracle APEX on Oracle Database 19c. This enterprise initiative focuses on secure, maintainable applications for environmental and regulatory systems.

The role requires strong Oracle PL/SQL, Oracle RDBMS expertise, and Agile/Scrum experience. You will design UIs in APEX, develop PL/SQL objects, and participate in all SDLC phases, including documentation and mentoring staff.

Qualifications

• Bachelor's degree in computer science or related field.
• 5-7 years of experience developing in Oracle PL/SQL, including stored procedures, functions, packages, and advanced queries.
• 5-7 years of experience developing applications using Oracle APEX.
• Strong knowledge of Oracle RDBMS (Oracle 19c preferred).
• Experience with SQL Developer and/or TOAD.
• Understanding of data modeling principles.
• Experience integrating web services.
• Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle (and SQL Server).
• Strong analytical and problem-solving skills.
• Strong written and verbal communication skills.

Responsibilities

• Analyze architecture, data structures, and integrations of existing Oracle Forms applications.
• Support the migration and conversion of Oracle Forms-based applications to Oracle APEX.
• Design and develop modern APEX user interfaces in collaboration with technical lead.
• Assist in establishing UI/UX design standards for future APEX applications.
• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced queries.
• Perform data pulls, data analysis, and scripting to support reporting and system enhancements.
• Review existing documentation to understand system requirements, architecture, reporting, and functionality.
• Implement and support application security, roles, and authorization models within integrated Oracle systems.
• Conduct performance profiling and tuning to improve maintainability and system responsiveness.
• Generate technical documentation, business functional documentation, and system documentation.
• Participate in all phases of the system development lifecycle including requirements gathering, analysis, coding, testing, deployment, and post-production support.
• Provide mentoring and knowledge transfer to Commonwealth IT staff and other developers.
• Assist with production deployments and release management activities.
• Provide weekly status updates to management.
• Generate reports for executive management, end-users, and BIT staff.

Skills

Oracle PL/SQL

Oracle APEX

Oracle RDBMS

Agile/Scrum

Data modeling

Web services

Java

Performance tuning

Education

Bachelor's degree in computer science or related field

Tools

SQL Developer

TOAD

Job description

Diversified Systems is seeking an experienced Oracle Developer to modernize legacy Oracle Forms into Oracle APEX on Oracle Database 19c. This enterprise initiative focuses on secure, maintainable applications for environmental and regulatory systems.

The role requires strong Oracle PL/SQL, Oracle RDBMS expertise, and Agile/Scrum experience. You will design UIs in APEX, develop PL/SQL objects, and participate in all SDLC phases, including documentation and mentoring staff.