| Location | Harrisburg, PA |
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.
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.
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.