Oracle APEX Developer – Remote (PA) Modernization Specialist

1 Alpha Consulting; Harrisburg (Dauphin County); Remote; USD 69,000 - 90,000; Full time

Job summary

1 Alpha Consulting LLC is seeking an experienced Oracle Developer to modernize and migrate legacy Oracle Forms applications to Oracle APEX for the Pennsylvania DEP environment. This remote Pennsylvania role supports a 37.5-hour week and requires strong PL/SQL and APEX skills.

The role involves designing modern UIs, developing PL/SQL components, and ensuring security and performance across Oracle systems. Collaboration with stakeholders and ongoing post-production support are key aspects.

Qualifications

• Bachelor’s degree in computer science or a related field.
• At least five years of experience developing in Oracle PL/SQL, including stored procedures, functions, packages, and advanced queries.
• At least five years of experience developing applications using Oracle APEX.
• Strong knowledge of Oracle RDBMS with Oracle Database 19c experience preferred.
• Experience using SQL Developer and/or TOAD.
• Understanding of data modeling principles.
• Experience with web services integration.
• Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle and SQL Server.
• Strong analytical and problem-solving skills.
• Excellent written and verbal communication; able to work remotely within two-hour Harrisburg radius.

Responsibilities

• Analyze the architecture, data structures, integrations, and functionality of existing Oracle Forms applications.
• Support migration of Oracle Forms-based apps to Oracle APEX.
• Design and develop modern Oracle APEX user interfaces in collaboration with the technical lead.
• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced queries.
• Perform data pulls, data analysis, and scripting to support reporting and enhancements.
• Review documentation to understand system requirements, architecture, reporting, and functionality.
• Implement and support security, roles, and authorization models within Oracle systems.
• Conduct performance profiling and tuning for maintainability and responsiveness.
• Debug and test SQL queries, views, and stored procedures in Oracle and SQL Server.
• Create comprehensive technical, business functional, and system documentation.
• Participate in all SDLC phases in Agile/Scrum environments; mentor Commonwealth IT staff.

Skills

Oracle PL/SQL development

Oracle APEX development

SQL Developer

TOAD

Data modeling

Web services integration

Performance tuning

Debugging SQL

Oracle Database 19c

Communication skills

Agile/Scrum

Remote work readiness

Education

Bachelor’s degree in computer science or related field

Tools

Oracle APEX

SQL Developer

TOAD

Job description

1 Alpha Consulting LLC is seeking an experienced Oracle Developer to modernize and migrate legacy Oracle Forms applications to Oracle APEX for the Pennsylvania DEP environment. This remote Pennsylvania role supports a 37.5-hour week and requires strong PL/SQL and APEX skills.

The role involves designing modern UIs, developing PL/SQL components, and ensuring security and performance across Oracle systems. Collaboration with stakeholders and ongoing post-production support are key aspects.