PL​/SQL Developer

Job Description

• The Client is seeking a high-level, seasoned PL/SQL Developer to support mission-critical legacy systems.
• The primary application subject area being financial and project support.
• This role focuses on building and modernizing applications where Oracle PL/SQL is embedded in the database in support of User Interface, integration points to several other applications and other Federal and Statewide applications.
• Development tasks often include generating web-based screens directly from PL/SQL.
• Key Responsibilities Architect, develop, and optimize PL/SQL packages, procedures, functions, and database objects supporting systems.
• Create and maintain dynamic web UI screens from PL/SQL, using SQL Developer. Modernize legacy PL/SQL-driven interfaces and transition or integrate with newer statewide standards.
• Collaborate with analysts, business owners, and technical teams primarily across departments however may interact with other business staff in other agencies.
• This work will require translating policy and program requirements into system functionality.

• Expert-level experience with Oracle PL/SQL (19c).
• Proven track record generating web pages / forms / interfaces directly in PL/SQL.
• Strong SQL tuning, data modeling, and performance optimization skills.
• Ability to review, understand, and enhance legacy codebases common in long-lived systems.

• Experience integrating PL/SQL systems with REST APIs, SOAP services, or enterprise data platforms.
• Comfortable working with Git and enterprise deployment practices.
• Previous experience or knowledge of accounting systems and/or methodologies, governmental experience is preferred but not required.
• Experience with Oracle cloud would be a nice to have skill.
• Soft Skills Strong communication skills; able to explain technical concepts to non-technical State program staff.
• Commitment to teamwork and collaborative problem-solving.
• Ability to balance technical excellence with policy-driven requirements and documentation needs.