Oracle Apex & Forms Dev

Oracle Apex & Forms Dev
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.