Senior Oracle Apex Developer

LingaTech, LLC; Harrisburg (Dauphin County); Remote; USD 96,000 - 152,000; Full time

Job summary

LingaTech, LLC is seeking a skilled Oracle developer to modernize legacy Oracle Forms into Oracle APEX on Oracle 19c, focusing on performance, security, and maintainability. The role involves Agile practices and cross-team collaboration.

You will design UI/UX standards, write PL/SQL, and support SDLC activities while guiding IT staff and ensuring successful deployments for mission-critical applications.

Qualifications

• 5 years of experience developing in Oracle PL/SQL, including stored procedures, functions, packages, and advanced queries.
• 5 years of experience developing applications using Oracle APEX.
• Strong knowledge of Oracle RDBMS, preferably Oracle 19c environments.
• Hands-on experience with SQL Developer and/or TOAD for database development and administration.
• Solid data modeling and relational database design understanding.
• Experience integrating applications with web services.
• Experience performance tuning, debugging, and testing SQL queries, views, and procedures in Oracle/SQL Server environments.

Responsibilities

• Analyze existing Oracle Forms applications to understand architecture, data structures, workflows, and system integrations.
• Convert and migrate legacy Oracle Forms applications into Oracle APEX solutions.
• Design and develop modern Oracle APEX user interfaces in collaboration with technical leadership.
• Help establish UI/UX standards and development best practices for future APEX applications.
• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced SQL queries.
• Perform data extraction, analysis, and scripting to support reporting and system enhancements.
• Review and interpret technical and functional documentation to understand business and system requirements.
• Implement and maintain application security, roles, and authorization models within Oracle environments.
• Conduct performance profiling, tuning, and optimization to improve application responsiveness and maintainability.
• Create and maintain technical, functional, and system documentation.
• Participate in all phases of the SDLC including requirements analysis, development, testing, deployment, and production support.
• Provide mentoring, knowledge transfer, and technical guidance to internal IT staff and development teams.
• Support production deployments and release management activities.
• Provide regular status updates and communicate progress to leadership.
• Generate reports and deliverables for executive stakeholders, technical teams, and end users.

Skills

Oracle PL/SQL

Oracle APEX

Oracle RDBMS

SQL Developer

TOAD

Data modeling

Web services

Performance tuning

Debugging & testing

Tools

SQL Developer

TOAD

Job description

Location: Harrisburg, PA Position Type: Remote Contract Length: Long-term with annual extensions

Position Overview

This role supports a large-scale enterprise modernization initiative focused on transforming legacy Oracle Forms applications into modern Oracle APEX solutions running on Oracle Database 19c. The position plays a key role in improving system performance, security, and maintainability while supporting mission-critical regulatory applications through modern development and Agile practices.

Duties

• Analyze existing Oracle Forms applications to understand architecture, data structures, workflows, and system integrations.
• Convert and migrate legacy Oracle Forms applications into Oracle APEX solutions.
• Design and develop modern Oracle APEX user interfaces in collaboration with technical leadership.
• Help establish UI/UX standards and development best practices for future APEX applications.
• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced SQL queries.
• Perform data extraction, analysis, and scripting to support reporting and system enhancements.
• Review and interpret technical and functional documentation to understand business and system requirements.
• Implement and maintain application security, roles, and authorization models within Oracle environments.
• Conduct performance profiling, tuning, and optimization to improve application responsiveness and maintainability.
• Create and maintain technical, functional, and system documentation.
• Participate in all phases of the SDLC including requirements analysis, development, testing, deployment, and production support.
• Provide mentoring, knowledge transfer, and technical guidance to internal IT staff and development teams.
• Support production deployments and release management activities.
• Provide regular status updates and communicate progress to leadership.
• Generate reports and deliverables for executive stakeholders, technical teams, and end users.

Required Skills

• 5 years of experience developing in Oracle PL/SQL, including stored procedures, functions, packages, and advanced queries.
• 5 years of experience developing applications using Oracle APEX.
• Strong knowledge of Oracle RDBMS, with preference for Oracle 19c environments.
• Strong hands-on experience using SQL Developer and/or TOAD for database development and administration.
• Solid understanding of data modeling principles and relational database design.
• Experience integrating applications with web services.
• Experience performing performance tuning, debugging, and testing of SQL queries, views, and stored procedures within Oracle (and SQL Server) environments.

Preferred Skills

• Previous experience supporting government or public-sector environments.
• Experience modernizing and converting legacy Oracle Forms applications.
• Exposure to XML, HTML, web services, Java, PL/SQL APIs, SOA architecture, and Agile/Scrum development methodologies.
• 2 years of experience working with and demonstrating strong understanding of Oracle 19c database features