Oracle APEX & Forms Developer

JPS Tech Solutions Pvt Ltd; Harrisburg (Dauphin County); On-site; USD 100,000 - 140,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd is seeking an experienced Oracle APEX & Forms Developer to modernize legacy Oracle Forms into secure, scalable Oracle APEX solutions on Oracle Database 19c. The role emphasizes PL/SQL expertise, hands-on APEX development, and migrating applications with performance, security, testing, and production support.

Responsibilities include analyzing existing forms, designing modern interfaces, ensuring security models, and contributing to SDLC with production releases and

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5–7 years of Oracle PL/SQL development experience.
• 5–7 years of Oracle APEX development experience.
• Strong PL/SQL knowledge: procedures, functions, packages, complex queries.
• Experience with Oracle RDBMS, preferably 19c.
• Experience with web services integration.
• Experience with query performance tuning and troubleshooting.
• Excellent written and verbal communication skills.

Responsibilities

• Analyze existing Oracle Forms applications—architecture, data, business logic, integrations, reporting.
• Support conversion of legacy Oracle Forms to Oracle APEX.
• Design and develop modern APEX interfaces with leads and teams.
• Contribute to UI/UX standards and reusable practices for APEX apps.
• Develop and maintain complex PL/SQL objects and SQL queries.
• Perform data analysis, data extraction, scripting, and reporting.
• Review documentation to understand requirements and behavior.
• Implement and maintain security, roles, permissions, and authorization models.
• Perform SQL and app performance analysis, debugging, and optimization.
• Create technical, functional, and system documentation.
• Participate in SDLC phases: requirements, development, testing, deployment, production support.
• Support releases, deployment activities, and release management.

Skills

Oracle PL/SQL

Oracle APEX

SQL & performance tuning

Security & authorization modeling

Debugging & testing

Communication skills

Education

Bachelor's degree in CS/IT or related field

Tools

Oracle SQL Developer

TOAD

Job description

JOB SUMMARY

We are seeking an experienced Oracle APEX & Forms Developer to support the modernization of legacy Oracle Forms applications into secure, scalable, and maintainable Oracle APEX solutions running on Oracle Database 19c. The ideal candidate will bring strong Oracle PL/SQL expertise, hands‑on APEX development experience, and the ability to support application migration, performance optimization, security, testing, and production activities.

KEY RESPONSIBILITIES

• Analyze existing Oracle Forms applications, including architecture, data structures, business logic, integrations, and reporting functionality.
• Support the conversion and modernization of legacy Oracle Forms applications into Oracle APEX.
• Design and develop modern APEX interfaces in collaboration with technical leads and project teams.
• Contribute to UI/UX standards and reusable development practices for APEX applications.
• Develop and maintain complex PL/SQL stored procedures, functions, packages, and SQL queries.
• Perform data analysis, data extraction, scripting, and reporting activities to support application enhancements.
• Review existing technical and functional documentation to understand application requirements and system behavior.
• Implement and maintain application security, roles, permissions, and authorization models.
• Perform SQL and application performance analysis, debugging, and optimization.
• Develop technical, functional, and system documentation.
• Participate throughout the SDLC, including requirements analysis, development, testing, deployment, and production support.
• Support production releases, deployment activities, and release management processes.
• Provide knowledge transfer and technical guidance to internal developers and IT staff.
• Prepare status updates and technical reports for project and management stakeholders.
• Develop and maintain reports for business users, management, and technical teams.

REQUIRED QUALIFICATIONS

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5–7 years of experience developing Oracle PL/SQL applications.
• 5–7 years of experience developing applications using Oracle APEX.
• Strong experience with PL/SQL, including stored procedures, functions, packages, and complex SQL queries.
• Strong knowledge of Oracle RDBMS, preferably Oracle Database 19c.
• Hands‑on experience with Oracle SQL Developer and/or TOAD.
• Understanding of relational database and data modeling principles.
• Experience integrating applications with web services.
• Experience with SQL query, view, and stored procedure performance tuning and troubleshooting.
• Strong debugging, testing, analytical, and problem‑solving capabilities.
• Excellent written and verbal communication skills.

PREFERRED QUALIFICATIONS

• Experience modernizing or migrating legacy Oracle Forms applications to Oracle APEX.
• Prior experience supporting Commonwealth, government, environmental, regulatory, or other mission‑critical systems.
• Exposure to XML, HTML, Java, Web Services, PL/SQL APIs, and SOA architecture.
• Experience working in Agile/Scrum development environments.
• Strong knowledge of Oracle 19c database capabilities.
• Experience supporting enterprise application modernization initiatives.
• Ability to create clear and comprehensive technical and functional documentation.

***Local candidates preferred for this position***

JOB SUMMARY

We are seeking an experienced Oracle APEX & Forms Developer to support the modernization of legacy Oracle Forms applications into secure, scalable, and maintainable Oracle APEX solutions running on Oracle Database 19c. The ideal candidate will bring strong Oracle PL/SQL expertise, hands‑on APEX development experience, and the ability to support application migration, performance optimization, security, testing, and production activities.

KEY RESPONSIBILITIES

• Analyze existing Oracle Forms applications, including architecture, data structures, business logic, integrations, and reporting functionality.
• Support the conversion and modernization of legacy Oracle Forms applications into Oracle APEX.
• Design and develop modern APEX interfaces in collaboration with technical leads and project teams.
• Contribute to UI/UX standards and reusable development practices for APEX applications.
• Develop and maintain complex PL/SQL stored procedures, functions, packages, and SQL queries.
• Perform data analysis, data extraction, scripting, and reporting activities to support application enhancements.
• Review existing technical and functional documentation to understand application requirements and system behavior.
• Implement and maintain application security, roles, permissions, and authorization models.
• Perform SQL and application performance analysis, debugging, and optimization.
• Develop technical, functional, and system documentation.
• Participate throughout the SDLC, including requirements analysis, development, testing, deployment, and production support.
• Support production releases, deployment activities, and release management processes.
• Provide knowledge transfer and technical guidance to internal developers and IT staff.
• Prepare status updates and technical reports for project and management stakeholders.
• Develop and maintain reports for business users, management, and technical teams.

REQUIRED QUALIFICATIONS

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5–7 years of experience developing Oracle PL/SQL applications.
• 5–7 years of experience developing applications using Oracle APEX.
• Strong experience with PL/SQL, including stored procedures, functions, packages, and complex SQL queries.
• Strong knowledge of Oracle RDBMS, preferably Oracle Database 19c.
• Hands‑on experience with Oracle SQL Developer and/or TOAD.
• Understanding of relational database and data modeling principles.
• Experience integrating applications with web services.
• Experience with SQL query, view, and stored procedure performance tuning and troubleshooting.
• Strong debugging, testing, analytical, and problem‑solving capabilities.
• Excellent written and verbal communication skills.

PREFERRED QUALIFICATIONS

• Experience modernizing or migrating legacy Oracle Forms applications to Oracle APEX.
• Prior experience supporting Commonwealth, government, environmental, regulatory, or other mission‑critical systems.
• Exposure to XML, HTML, Java, Web Services, PL/SQL APIs, and SOA architecture.
• Experience working in Agile/Scrum development environments.
• Strong knowledge of Oracle 19c database capabilities.
• Experience supporting enterprise application modernization initiatives.
• Ability to create clear and comprehensive technical and functional documentation.

***Local candidates preferred for this position***