Oracle Database Architect (Ref: 18675)

Position: Oracle Database Architect (Ref: 18675)
Location: Augusta, ME United States, 04333
Salary: DOE
Duration: 9 Months 25 Days - Contract
Openings: 1
Deadline: 09/11/2026
Description:
Hybrid Mostly Remote

We are seeking an experienced Senior Database Architect / Senior Data Warehouse Developer to serve as a key technical authority and subject-matter expert for enterprise database environments and automated data integration workflows. This role focuses on data modeling, designing robust data repositories, and developing automated ETL pipelines pulling from flat files, relational databases, and APIs. The architect will also play an instrumental role in data modernization, migrations, and mentoring development staff.

Key Responsibilities
Design, implement, and maintain enterprise-class data repositories built on modern Oracle platforms (both on-premises and cloud-hosted environments).
Build, deploy, and monitor fully automated ETL/ELT pipelines ingesting data from diverse sources, including flat files, external databases, and REST APIs.
Develop and maintain dimensional and tabular data models supporting scalable analytics and reporting.
Write, optimize, and maintain complex SQL and PL/SQL code, including stored procedures, functions, views, and automated scheduling scripts.
Implement business intelligence and data reporting solutions utilizing platforms such as Oracle Analytics Cloud (OAC).
Establish disciplined standards for process monitoring, error handling, metadata creation, and technical documentation.
Author architectural diagrams and system blueprints; deliver technical mentorship and guidance to team members across engineering teams.
Partner with technical leadership and business stakeholders to translate complex requirements into high-performing, reliable data architecture.

Qualifications
Bachelors degree in Computer Science, Information Systems, or a related field.
Proven track record as a Database Architect, Senior Data Warehouse Developer, or Senior Oracle DBA.
Deep expertise across modern Oracle ecosystems (on-premises and cloud).
Strong background in dimensional modeling, data warehousing methodologies, and data governance standards.
Prior public sector (local, state, or federal government) experience is highly valued.
Location: Hybrid / Mostly Remote (Requires 1 day/month onsite in New England; candidates must reside in the New England area)
Hours: 40 hours/week, Monday Friday

Required / Desired Skills
Enterprise Oracle Database Design & Architecture (On-Prem & Cloud) Required - 8 Years
Advanced SQL & PL/SQL Development (Procedures, Views, Scripting) Required - 8 Years
Automated ETL Pipeline Development (Flat Files, DBs, APIs) Required - 7 Years
Dimensional Data Modeling (Star/Snowflake Schemas, Warehousing) Required - 7 Years
Oracle Analytics Cloud (OAC) Required - 3 Years
Tabular Data Models & Reporting Optimization Required - 3 Years
System Architecture Diagramming & Technical Mentorship Required - 4 Years
Public Sector / Government IT Project Experience Required - 2 Years