> Markdown version of [/jobs/ext/2748796-database-architect](https://www.wearedevelopers.com/jobs/ext/2748796-database-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Database Architect

- **Company:** vTech Solution Inc
- **Location:** Augusta, ME, United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Cloud Computing, Software Documentation, Databases, Extract Transform Load (ETL), Data Transformation, Data Stores, Dimensional Modeling, Metadata, Oracle Databases, Oracle (Applications), PL-SQL, SQL Databases, Data Logging, Oracle Service Cloud, Web Api
- **Published:** September 6, 2026
- **Apply:** https://www.careerjet.com/jobad/us48f49bdf200b6e1b2ee514bc5ef70aae

## About the Role

* Bachelor s degree in a related field.
 * Significant senior DBA-level experience with Oracle on-premises and cloud-hosted databases.
 * Expertise in SQL, PL/SQL, and developing complex database scripts.
 * Proven experience in developing automated ETL processes.
 * Strong knowledge of dimensional modeling and tabular data models.
 * Experience with Oracle Analytics Cloud (OAC).
 * Ability to capture complex business requirements and translate them into scalable technical solutions.
 * Demonstrated disciplined approach to coding standards, documentation, and error logging.
 * Eligibility to work in the New England area, with ability to attend monthly onsite meetings in Augusta, ME.

Preferred Skills & Certifications:

 * Experience developing architectural diagrams and technical training materials.
 * Proven ability to independently research and implement evolving technical solutions.
 * Prior experience mentoring IT staff at various levels.

## Description

The Database Architect - DOT Apps is a senior-level role responsible for designing, developing, and maintaining enterprise-class Oracle database solutions both on-premises and in the cloud. This position involves creating automated ETL processes, dimensional modeling, and serving as a technical mentor while collaborating with various IT teams and stakeholders. The role primarily supports the Maine Department of Transportation s data modernization and system migration initiatives, working mostly remotely with occasional onsite presence in Augusta, ME. Responsibilities:

 * Design and implement enterprise-class data repositories using Oracle on-premises and cloud platforms.
 * Develop fully automated ETL processes from diverse data sources including flat files and databases.
 * Utilize API calls for automated data refreshes.
 * Develop complex SQL and PL/SQL procedures, functions, views, and scripts.
 * Perform dimensional modeling and develop tabular data models.
 * Create architectural diagrams, system documentation, and metadata.
 * Serve as a subject-matter expert and trusted technical advisor on Oracle technologies.
 * Mentor senior and junior IT staff and provide technical training.
 * Research and resolve database issues and maintain automated database processes.
 * Collaborate with developers, analysts, DBAs, IT vendors, leadership, and business partners.
 * Support system migrations, expansions, and data modernization efforts.


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Web APIs you might not know about](https://www.wearedevelopers.com/videos/281-web-apis-you-might-not-know-about)
- [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata)
- [Project Fugu: Extending the web](https://www.wearedevelopers.com/videos/832-project-fugu-extending-the-web)
- [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros)
- [Tomorrow's cloud data platforms - fully managed database-as-a-service (DBaaS)](https://www.wearedevelopers.com/videos/254-tomorrow-s-cloud-data-platforms-fully-managed-database-as-a-service-dbaas)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology)