Job Title: Oracle PL/SQL Developer

Duration (Contract): 8 Months

Client Location: Harrisburg, PA

Location Preference: Onsite

Job Description:

As an Oracle PL/SQL Developer, you will support the modernization of legacy Oracle applications by migrating Oracle Forms solutions to Oracle APEX on Oracle Database 19c. This role involves application development, database programming, performance tuning, system enhancement, and collaboration with technical teams to deliver secure, scalable, and maintainable enterprise solutions.

Key Responsibilities:

• Analyze existing Oracle Forms applications, data structures, and system integrations.
• Support the migration and modernization of legacy applications to Oracle APEX.
• Design and develop Oracle APEX applications and modern user interfaces.
• Develop and maintain PL/SQL stored procedures, packages, functions, and complex queries.
• Perform data analysis, data extraction, and scripting to support reporting and application enhancements.
• Implement application security, user roles, and authorization controls.
• Conduct performance tuning, debugging, and optimization of database objects and applications.
• Participate in all phases of the SDLC, including requirements, development, testing, deployment, and support.
• Create and maintain technical, functional, and system documentation.
• Support production deployments, release management, and knowledge transfer activities.

Required Skills, Experiences, Education, and Competencies:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 5–7 years of hands-on experience developing Oracle PL/SQL solutions, including stored procedures, functions, packages, and advanced SQL queries.
• 5–7 years of experience developing enterprise applications using Oracle APEX.
• Strong knowledge of Oracle Database, preferably Oracle 19c.
• Experience with Oracle SQL Developer, TOAD, or similar database development tools.
• Strong understanding of data modeling, relational database design, and database architecture principles.
• Experience integrating web services and supporting enterprise application integrations.
• Hands-on experience with SQL query optimization, performance tuning, debugging, and testing.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent written and verbal communication skills with experience working in Agile/Scrum development environments.