Oracle Apex & Forms Dev

OP Consulting Group LLC
Harrisburg, PA, United States
8 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

HTML Java (Programming Language) Application Programming Interfaces (APIs) Data Analysis Software Documentation Profiling Databases Data Structures Software Debugging Design of User Interfaces Information Technology Operations Microsoft SQL Server
+23 more
Oracle Databases Oracle (Applications) Oracle Forms Oracle SQL Developer Performance Tuning Systems Development Life Cycle Release Management Oracle Apex Service-Oriented Architecture SQL Stored Procedures PL-SQL SQL Databases Data Streaming Systems Integration Web Services Extensible Markup Language (XML) Apex Code Enterprise Software Applications Software Security Backend Information Technology Toad (Software) Front End Software Development

Job description

  • 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.

Requirements

  • 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…