Senior Oracle Data Architect – Remote, Monthly Onsite

vTech Solution; Augusta (ME); Hybrid; USD 120,000 - 170,000; Full time

Job summary

vTech Solution seeks a Database Architect - DOT Apps to design, develop, and maintain Oracle databases on premises and in the cloud, supporting Maine DOT modernization. You will build automated ETL, perform dimensional modeling, and mentor IT teams while collaborating with stakeholders.

The role offers mostly remote work with occasional onsite in Augusta, ME, and requires strong SQL/PLSQL skills, OAC experience, and the ability to translate business needs into scalable solutions for data

Qualifications

• 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.

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.

Skills

Oracle architecture

SQL

PL/SQL

ETL automation

Dimensional modeling

Tabular data models

Oracle Analytics Cloud (OAC)

Requirements gathering

Documentation & standards

Mentoring

Team collaboration

Education

Bachelor's degree in a related field

Tools

Oracle databases

Cloud platforms

APIs

Job description

vTech Solution seeks a Database Architect - DOT Apps to design, develop, and maintain Oracle databases on premises and in the cloud, supporting Maine DOT modernization. You will build automated ETL, perform dimensional modeling, and mentor IT teams while collaborating with stakeholders.

The role offers mostly remote work with occasional onsite in Augusta, ME, and requires strong SQL/PLSQL skills, OAC experience, and the ability to translate business needs into scalable solutions for data