Oracle Apex & Forms Dev

OP Consulting Group LLC; Harrisburg (Dauphin County); On-site; USD 90,000 - 130,000; Full time

Job summary

OP Consulting Group LLC in Harrisburg, PA seeks a senior Oracle developer to modernize legacy Forms into Oracle APEX and to design UI/UX for enterprise apps. You will implement PL/SQL, security models, and web services, while optimizing performance and ensuring governance.

Strong experience with Oracle 19c, SQL Developer or TOAD, and Agile/Scrum is required. Mentor junior developers and contribute across SDLC phases.

Qualifications

• Bachelor’s degree in Computer Science, IT, or related field.
• 5–7 years of professional Oracle PL/SQL development.
• 5–7 years of Oracle APEX development.
• Strong Oracle RDBMS knowledge (Oracle 19c).
• Experience with SQL Developer and TOAD.
• Experience integrating web services and tuning SQL.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Legacy modernization: document architecture, data, and integrations for migration to Oracle APEX.
• Design and develop modern UI/UX for enterprise apps with APEX.
• Develop and maintain PL/SQL procedures, functions, packages, and queries.
• Implement security, roles, and authorization; integrate web services.
• Performance profiling and tuning across Oracle and SQL Server environments.
• Generate technical and executive documentation; provide weekly status updates.
• Participate in all SDLC phases and support release activities.
• Mentor internal staff and junior developers.

Skills

Legacy Migration

Web Services

SOA Architecture

Agile/Scrum

Analytical Thinking

Communication Skills

Education

Bachelor’s degree in Computer Science, IT, or related field

Tools

SQL Developer

TOAD

Job description

Harrisburg,PA

Key Responsibilities & Duties

• Legacy Modernization: Analyze, understand, and document the architecture, data structures, and integrations of existing Oracle Forms applications to support seamless migration to Oracle APEX.

• UI/UX & Front-End Development: Design and develop modern, responsive APEX user interfaces in collaboration with technical leads, helping establish UI/UX design standards for future enterprise applications.

• Back-End Development & PL/SQL: Develop and maintain PL/SQL stored procedures, functions, packages, and advanced queries. Perform data pulls, scripting, and data analysis to support reporting and system enhancements.

• System Integration & Security: Implement and support application security, roles, and authorization models within integrated Oracle systems. Integrate web services and ensure smooth data flow.

• Performance Tuning: Conduct performance profiling, debugging, and tuning to improve application maintainability and system responsiveness across Oracle and SQL Server environments.

• Documentation & Governance: Generate comprehensive technical, business functional, and system documentation. Provide weekly status updates to management and generate executive reports for stakeholders and IT operations teams.

• SDLC & Support: Participate in all phases of the SDLC—including requirements gathering, analysis, coding, testing, deployment, and post-production support—alongside release management activities.

• Mentorship: Provide technical guidance, knowledge transfer, and mentoring to internal IT staff and junior developers.

Required Qualifications & Experience

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.

• PL/SQL Experience: 5–7 years of professional experience developing in Oracle PL/SQL, including stored procedures, functions, packages, and advanced queries.

• Oracle APEX: 5–7 years of experience designing and developing enterprise applications using Oracle APEX.

• Database Knowledge: Strong command of Oracle RDBMS (Oracle 19c preferred) alongside a solid understanding of data modeling principles.

• Tooling: Strong, hands-on experience using SQL Developer and/or TOAD.

• Performance & Integration: Proven experience integrating web services, debugging, testing, and performance-tuning SQL queries, views, and stored procedures.

• Core Competencies: Exceptional analytical, problem-solving, and written/verbal communication skills.

Preferred Qualifications

• Legacy Migration: Direct experience modernizing legacy Oracle Forms applications to APEX.

• Technical Exposure: Familiarity with XML, HTML, Web Services, Java, PL/SQL APIs, SOA architecture, and Agile/Scrum development methodologies.

• Database Features: Strong working knowledge of advanced Oracle 19c database features.

• Mission-Critical Systems: Experience supporting high-availability, regulatory, or mission-critical enterprise environments.