Programmer 5
Share
Job Location:
Augusta, ME - USA
Monthly Salary:
Not Disclosed
Posted on:
4 hours ago
Vacancies:
1 Vacancy
Job Summary
Work Location: Hybrid. Must be able to report onsite in Augusta once a week. Client is not interested in candidates willing to relocate.
Top Skills:
5 to 8 years of experience
PL/SQL - Generate web-based screens
Expert level with Oracle PL/SQL (19C)
Ability to review understand and enhance legacy codebases
5 to 8 years of experience
PL/SQL - Generate web-based screens
Expert level with Oracle PL/SQL (19C)
Ability to review understand and enhance legacy codebases
Job Description:
The State of Maine is seeking a high-level seasoned PL/SQL Developer to support mission-critical legacy systems for the Maine Department of Transportation (MaineDOT). 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 MaineDOT applications and other Federal and Statewide applications. Development tasks often include generating web-based screens directly from PL/SQL.
The successful candidate will join a collaborative and service-oriented technical environment and play a key part in supporting enterprise applications used across in support of MaineDOT and may span into working with other State agencies and key areas within MaineIT in areas such as database network server and firewall.
The State of Maine is seeking a high-level seasoned PL/SQL Developer to support mission-critical legacy systems for the Maine Department of Transportation (MaineDOT). 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 MaineDOT applications and other Federal and Statewide applications. Development tasks often include generating web-based screens directly from PL/SQL.
The successful candidate will join a collaborative and service-oriented technical environment and play a key part in supporting enterprise applications used across in support of MaineDOT and may span into working with other State agencies and key areas within MaineIT in areas such as database network server and firewall.
Key Responsibilities
Architect develop and optimize PL/SQL packages procedures functions and database objects supporting MaineDOT 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 MaineDOT departments however may interact with other business staff in other State agencies. This work will require translating policy and program requirements into system functionality.
Ensure compliance with State of Maine technical security and administrative standards including documentation expectations and contract-aligned deliverables.
Participate in code reviews knowledge transfer and improvement of shared development practices.
Architect develop and optimize PL/SQL packages procedures functions and database objects supporting MaineDOT 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 MaineDOT departments however may interact with other business staff in other State agencies. This work will require translating policy and program requirements into system functionality.
Ensure compliance with State of Maine technical security and administrative standards including documentation expectations and contract-aligned deliverables.
Participate in code reviews knowledge transfer and improvement of shared development practices.
Required Skills & Experience
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.
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.
Preferred Qualifications
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.
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.
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.
