Oracle Developer

Mbi Llc; Harrisburg (Dauphin County); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology consulting firm located in Harrisburg, PA is seeking a skilled professional to analyze and migrate Oracle Forms applications to Oracle APEX. This role involves developing user interfaces, optimizing database performance, and mentoring IT staff. Candidates must possess a bachelor's degree and have extensive experience in Oracle PL/SQL and APEX. Strong problem-solving and communication skills are essential for success in this dynamic environment.

Qualifications

• 5–7 years of experience developing in Oracle PL/SQL.
• 5–7 years of experience developing applications using Oracle APEX.
• Strong analytical and problem-solving skills.

Responsibilities

• Analyze the architecture of existing Oracle Forms applications.
• Support migration to Oracle APEX applications.
• Develop modern APEX user interfaces.

Skills

Oracle PL/SQL

Oracle APEX

SQL Developer

Data modeling principles

Performance tuning

Problem-solving skills

Education

Bachelor’s degree in computer science or related field

Tools

TOAD

Job description

Responsibilities

• Analyze and understand the architecture, data structures, and integrations of existing Oracle Forms applications.
• Support the migration and conversion of Oracle Forms-based applications to Oracle APEX.
• Design and develop modern APEX user interfaces in collaboration with technical lead.
• Assist in establishing UI/UX design standards for future APEX applications.
• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced queries.
• Perform data pulls, data analysis, and scripting to support reporting and system enhancements.
• Review existing documentation to understand system requirements, architecture, reporting, and functionality.
• Implement and support application security, roles, and authorization models within integrated Oracle systems.
• Conduct performance profiling and tuning to improve maintainability and system responsiveness.
• Generate technical documentation, business functional documentation, and system documentation.
• Participate in all phases of the system development lifecycle including requirements gathering, analysis, coding, testing, deployment, and post-production support.
• Provide mentoring and knowledge transfer to Commonwealth IT staff and other developers.
• Assist with production deployments and release management activities.
• Provide weekly status updates to management.
• Generate reports for executive management, end-users, and Bureau of Information Technology (BIT) staff.

Required Experience

• Bachelor’s degree in computer science or related field.
• 5–7 years of experience developing in Oracle PL/SQL, including:
  • Stored procedures
  • Functions
  • Packages
• 5–7 years of experience developing applications using Oracle APEX.
• Strong knowledge of Oracle RDBMS (Oracle 19c preferred).
• Strong experience using SQL Developer and/or TOAD.
• Understanding of data modeling principles.
• Experience integrating web services.
• Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle (and SQL Server).
• Strong analytical and problem‑solving skills.
• Strong written and verbal communication skills.

Preferred Qualifications

• Prior Commonwealth or Environmental systems experience (preferred but not required).
• Experience modernizing legacy Oracle Forms applications.
• Exposure to XML, HTML, Web Services, Java, PL/SQL APIs.
• Strong understanding of Oracle 19c database features.
• Experience supporting regulatory or mission‑critical systems.
• Ability to produce clear, comprehensive technical and functional documentation.