Oracle/PL/SQL Programmer

About the role

Location: Augusta, Maine (Remote 100%); Duration: 9 Months; Agency: OIT; Client: State of Maine; Work Mode: REMOTE; Interview Mode: Teams; Special Requirement: Candidates must be in Eastern or Central Time Zones; Citizenship: USC or GC only.

Responsibilities

• Monitor and validate scheduled and ad hoc data loads, reconcile source and target results, investigate discrepancies, and resolve data-quality issues.
• Investigate production incidents, analyze application and database behavior, identify root causes, correct defects, and verify solutions do not introduce unintended impacts.
• Translate business needs, operational concerns, and user-reported issues into clear technical requirements and workable solutions.
• Review and fully understand assigned tasks, applicable requirements, dependencies, expected outcomes, and acceptance criteria before beginning development work; seek clarification when requirements are incomplete, inconsistent, or ambiguous.
• Analyze design specifications and proposed solutions, identify technical risks or limitations, and provide constructive feedback regarding alternative designs, implementation methods, and performance considerations.
• Develop and execute appropriate unit, integration, system, regression, and data-validation tests; testing must confirm technical functionality, data accuracy, error handling, and compliance with defined requirements.
• Create and maintain accurate system, program, operational, support, and user documentation.
• Participate effectively in reviews of system designs, database designs, source code, test plans, implementation procedures, and deployment activities.
• Assist technical and business users in understanding application functionality, warehouse data, data relationships, and reporting capabilities.
• Manage assigned work independently, organize priorities, meet established deadlines, and coordinate effectively with other team members.
• Identify and communicate risks, dependencies, technical concerns, and blockers promptly, including their potential effects on scope, schedule, system performance, and data quality.
• Communicate incident status, technical findings, recommended solutions, implementation progress, and resolution details clearly to customers, stakeholders, and technical team members.

Requirements

• Minimum of seven (7) years of progressively responsible application development, database programming, and production-support experience.
• At least five (5) years of hands‑on experience with Oracle databases, SQL, and PL/SQL.
• Experience with data warehouses, ETL processes, production data loads, performance analysis, defect correction, and data‑quality validation.

Skills

• Advanced proficiency in Oracle relational database technologies.
• PL/SQL development, including packages, procedures, functions, triggers, and complex stored program units.
• Writing, analyzing, and optimizing complex SQL queries.
• Use of Oracle SQL Developer or comparable Oracle development and diagnostic tools.
• Troubleshooting existing application code and identifying root causes of defects.
• SQL and PL/SQL performance analysis, including identifying inefficient queries, execution‑plan issues, indexing opportunities, and database‑related performance bottlenecks.
• ETL processing, data integration, data transformation, and batch data‑loading operations.
• Data‑warehouse concepts, including dimensional data structures, source‑to‑target mappings, data reconciliation, and reporting dependencies.
• Production support and incident investigation involving SQL, PL/SQL, ETL processes, and data‑warehouse workloads.
• Unit, integration, system, regression, and data‑validation testing.
• Source‑code management, controlled deployments, and standard software‑development lifecycle practices.

Preferred Skills

• Data‑warehouse concepts, including dimensional data structures, source‑to‑target mappings, data reconciliation, and reporting dependencies.