Oracle APEX & Forms Modernization Engineer

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

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