Oracle Database Architect

Austincc; Augusta (ME); Hybrid; USD 110,000 - 165,000; Full time

Benefits offered by this job

Job summary

Austincc is seeking an experienced Oracle Database Architect to lead enterprise data architecture, data warehousing, and automated data integration workflows. This hybrid role focuses on on-prem and cloud Oracle environments, analytics, and mentoring staff.

Responsibilities include designing data repositories, ETL pipelines, data models, and BI solutions with Oracle Analytics Cloud. The position requires collaboration with leadership and stakeholders across engineering teams.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or 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, and data governance.
• Public Sector / Government IT Project Experience is valued.
• Location: Hybrid / Mostly Remote with 1 day onsite per month in New England.

Responsibilities

• Design, implement, and maintain enterprise-class data repositories on Oracle platforms (on‑prem and cloud).
• Build, deploy, and monitor automated ETL/ELT pipelines from diverse sources.
• Develop dimensional and tabular data models for analytics and reporting.
• Write and optimize SQL/PL/SQL code, procedures, views, and jobs.
• Implement BI and reporting using Oracle Analytics Cloud.
• Establish standards for monitoring, error handling, and metadata.

Skills

Oracle DB Design

SQL/PLSQL

ETL Development

Dimensional Modeling

Oracle Analytics Cloud

Reporting Optimization

System Architecture

Govt IT Experience

Education

Bachelor's degree

Job description

You are viewing a preview of this job. Log in or register to view more details about this job.

Position: Oracle Database Architect (Ref: 18675)

Location: Augusta, ME United States, 04333

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

• Bachelor's 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