Programmer

Programmer/ PL/SQL Developer

Location: Augusta, ME

Onsite Flexibility: Hybrid

Contract Details:

• Position Type: Contract
• Start: As Soon As Possible

Job Summary:

Our client is seeking a high-level, seasoned PL/SQL Developer to support mission-critical legacy systems for the Department of Transportation (DOT). The primary application subject area is 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 DOT 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 DOT and may span into working with other State agencies and key areas within IT in areas such as database, network, server, and firewall.

Key Responsibilities:

• Architect, develop, and optimize PL/SQL packages, procedures, functions, and database objects supporting DOT 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 DOT 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 technical, security, and administrative standards, including documentation expectations and contract-aligned deliverables.
• Participate in code reviews, knowledge transfer, and improvement of shared development practices.

Education Requirements:

• 5 to 8 years of experience in PL/SQL development

Required Skills:

• 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
• 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

Preferred Skills:

• 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

Benefits:

• Medical, Vision, and Dental Insurance Plans
• 401k Retirement Fund

About GTT:

GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada. We look forward to helping you land your next great career opportunity!

Job Number: 26-03078

Hashtags: