Remote Oracle APEX & Forms Developer - Harrisburg Area

i-Link Solutions; Harrisburg (Dauphin County); Remote; USD 90,000 - 130,000; Full time

Job summary

i-Link Solutions is seeking a skilled Oracle PL/SQL/APEX developer to join a remote role within the Harrisburg region. You will analyze existing Oracle Forms architectures, migrate to Oracle APEX, and design modern interfaces while establishing UI/UX standards and producing thorough documentation.

The position requires 5–7 years in Oracle PL/SQL and APEX, strong SQL Server/Oracle performance tuning experience, and the ability to mentor Commonwealth IT staff during all SDLC phases.

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 written and verbal communication skills.

Responsibilities

• Analyze and understand architecture, data structures, and integrations of existing Oracle Forms applications.
• Support migration from Oracle Forms to Oracle APEX.
• Design and develop modern APEX UIs with technical lead.
• Establish UI/UX design standards for future APEX apps.
• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced queries.
• Perform data pulls, data analysis, and scripting for reporting and enhancements.
• Review documentation to understand requirements, architecture, and functionality.
• Implement and support application security, roles, and authorization models.
• Conduct performance profiling and tuning for maintainability and performance.
• Generate technical and functional documentation.
• Participate in all SDLC phases including requirements, 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.
• Provide weekly status updates to management.
• Generate reports for executive, end-users, and BIT staff.

Skills

Oracle PL/SQL

Advanced queries

Data modeling

Analytical thinking

Documentation

Communication

Web services

Education

Bachelor's degree in computer science or related field

Tools

SQL Developer

TOAD

Oracle APEX

Oracle RDBMS

Job description

i-Link Solutions is seeking a skilled Oracle PL/SQL/APEX developer to join a remote role within the Harrisburg region. You will analyze existing Oracle Forms architectures, migrate to Oracle APEX, and design modern interfaces while establishing UI/UX standards and producing thorough documentation.

The position requires 5–7 years in Oracle PL/SQL and APEX, strong SQL Server/Oracle performance tuning experience, and the ability to mentor Commonwealth IT staff during all SDLC phases.