> Markdown version of [/jobs/ext/2771140-database-architect-oracle-data-warehouse](https://www.wearedevelopers.com/jobs/ext/2771140-database-architect-oracle-data-warehouse). 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 Oracle / Data Warehouse - **Company:** Propertyvalue Quantum Technologies Llc - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $124,800.0 - **Contract:** Permanent contract - **Skills:** Adaptable Database Systems, Application Programming Interfaces (APIs), Bioinformatics, Cloud Computing, Software Documentation, Databases, Data Architecture, Extract Transform Load (ETL), Data Transformation, Data Systems, Database Design, Dimensional Modeling, IT Management, Metadata, Oracle (Applications), Oracle Warehouse Builder, PL-SQL, SQL Databases, Data Logging, Software Troubleshooting, Oracle Service Cloud, Software Coding, Web Api - **Published:** September 7, 2026 - **Apply:** https://www.dice.com/job-detail/441bf482-52be-488d-b603-15399a0df21e ## About the Role * Extensive experience with Oracle platforms and technologies. * Senior DBA-level experience designing and implementing enterprise Oracle data repositories. * Experience with Oracle on-premises and cloud-hosted databases. * Strong experience developing automated ETL processes from flat-file and database sources. * Experience using APIs for automated data refreshes. * Experience with Oracle Analytics Cloud (OAC). * Mastery of SQL and PL/SQL. * Strong ability to develop complex procedures, functions, views, and scripts. * Expertise in dimensional modeling. * Experience with tabular data models. * Strong data architecture, database design, and data modeling capabilities. * Ability to translate complex business requirements into technical solutions. * Strong troubleshooting, research, analytical, and problem-solving skills. * Experience with technical documentation, metadata creation, coding standards, and error/process logging. * Ability to develop architectural diagrams and system documentation. * Ability to work independently with limited supervision. * Strong communication and collaboration skills. * Ability to provide technical mentoring to IT staff. Preferred Skills * Local, State, and/or Federal Government experience. * Proven experience serving as a technical mentor. * Experience supporting data modernization, system migration, and system expansion initiatives. * Experience working collaboratively with business partners, vendors, developers, analysts, DBAs, and IT leadership. Equal Opportunity Employer : We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law. ## Description The State of Maine is seeking an experienced Senior Developer / Data Architect to serve as a subject-matter expert for Oracle technologies, database architecture, data modeling, and automated ETL processes. The role will focus on designing and implementing enterprise-class Oracle data repositories, developing automated ETL and database processes, supporting Oracle Analytics Cloud (OAC), and contributing to data modernization, migrations, and system expansions. The resource will work independently while collaborating with developers, analysts, DBAs, IT leadership, vendors, and MDOT business partners., * Design and implement enterprise-class data repositories using Oracle on-premises and cloud-hosted databases. * Develop and maintain fully automated ETL processes using data from various flat-file and database sources. * Develop automated data refresh processes utilizing API calls. * Work with Oracle Analytics Cloud (OAC) and related Oracle technologies. * Develop complex SQL and PL/SQL procedures, functions, views, and scripts. * Perform dimensional modeling and develop scalable data models. * Design and work with tabular data models. * Translate complex business requirements into robust, performant, scalable, reliable, and expandable technical solutions. * Develop, monitor, maintain, and troubleshoot automated database processes. * Research and resolve database and technical issues. * Perform database management and maintenance activities. * Maintain disciplined process and error logging. * Create and maintain coding comments, system documentation, metadata, and architectural diagrams. * Independently research technical options and recommend solutions for evolving technical requirements. * Serve as a technical subject-matter expert and trusted advisor for Oracle technologies and data solutions. * Provide technical mentoring to both senior and junior IT staff. * Train team members on architectural diagrams, systems, processes, and technical solutions. * Collaborate with MDOT and MaineIT developers, analysts, DBAs, vendors, IT leadership, and business partners. * Support upcoming system migrations, system expansions, and data modernization initiatives. * Work independently toward project and assignment goals with limited day-to-day oversight. ## Related Videos - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [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) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [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) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)