Oracle Developer - Harrisburg/ Local candidates only

KEY 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 • Advanced queries • 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 • SOA architecture • Agile/Scrum development methodologies • Strong understanding of Oracle 19c database features. • Experience supporting regulatory or mission-critical systems. Ability to produce clear, comprehensive technical and functional documentation. Apply tot his job Apply To this Job