Oracle APEX Developer Location: Harrisburg, PA (Hybrid/Remote as applicable)
Duration: Long-Term Contract
Work Schedule: 37.5 hours/week (7.5 hours/day, Monday-Friday). Additional hours require prior approval.
Job Summary
Seeking an experienced Oracle APEX & PL/SQL Developer to support the modernization and migration of legacy Oracle Forms applications to Oracle APEX on Oracle Database 19c. The ideal candidate will have strong expertise in Oracle APEX development, Oracle PL/SQL programming, database design, application modernization, and performance tuning. This role involves converting legacy systems into modern, secure, scalable applications while supporting mission-critical business processes.
Key Responsibilities
Analyze existing Oracle Forms applications, data structures, and integrations.
Migrate and convert Oracle Forms applications to Oracle APEX.
Design and develop Oracle APEX user interfaces and application components.
Develop and maintain PL/SQL procedures, functions, packages, and complex queries.
Perform data analysis, reporting, scripting, and system enhancements.
Implement application security, roles, and authorization models.
Conduct performance tuning, debugging, testing, and optimization.
Create technical, functional, and system documentation.
Participate in the full SDLC, including requirements gathering, development, testing, deployment, and support.
Support release management, production deployments, and knowledge transfer activities.
Provide regular project status updates and reporting.
Required Skills & Experience
Bachelor's degree in Computer Science or a related field.
5-7+ years of Oracle PL/SQL development experience.
5-7+ years of Oracle APEX development experience.
Strong experience with: Oracle Database (Oracle 19c preferred)
Stored Procedures, Functions, Packages, and Complex SQL Queries
SQL Developer and/or TOAD
Data Modeling
Web Services Integration
Performance Tuning and Query Optimization
Debugging and Testing Oracle Applications
Strong analytical, troubleshooting, and communication skills.
Preferred Qualifications
Experience migrating legacy Oracle Forms applications to Oracle APEX.
Exposure to: XML
HTML
Java
Web Services
PL/SQL APIs
SOA Architecture
Agile/Scrum Methodologies
Experience working with Oracle 19c features.
Experience supporting enterprise, regulatory, or mission-critical applications.
Ability to create comprehensive technical and functional documentation.
Medical, dental, and vision insurance are available to qualified candidates who meet eligibility requirements.