Database Architect

Knowledge Services; Augusta (ME); Hybrid; USD 110,000 - 170,000; Full time

Job summary

Knowledge Services is seeking a Database Architect for a contract through the end of June 2027, supporting the State of Maine.

Most work is remote, but you must be local to New England and onsite in Augusta, ME one day a month. Travel costs are not reimbursable.

Qualifications

• Extensive practical experience with modern Oracle platforms and technologies.
• Senior DBA level experience designing and implementing Oracle data repositories (on‑prem and cloud).
• Experience developing automated ETL processes from diverse sources.
• Expertise in dimensional modeling.
• Experience with Oracle Analytics Cloud (OAC).
• Ability to mentor senior and junior IT staff.

Responsibilities

• Serve as SME for Oracle tech and toolsets.
• Develop, monitor, and maintain automated DB processes.
• Research and resolve database issues.
• Mentor MDOT/IT staff and collaborate with teams.
• Support system migrations, expansions, and data modernization.
• Work with IT vendors and business partners.

Skills

Oracle DB

ETL automation

Dimensional modeling

Oracle Analytics Cloud (OAC)

SQL/PLSQL

Mentoring

Job description

Overview

Knowledge Services is seeking a Database Architect for a contract through the end of June 2027 (potential for extension) in support of the State of Maine.

• Applicants will work mostly remotely, but must be local to New England and will be required to be onsite in Augusta, ME one day a month. Travel costs are not reimbursable.
• Please note that we cannot accept any candidates requiring C2C or those requiring sponsorship for a work visa

Responsibilities

Database Architect Overview:

• Serve as a daily subject‑matter expert for all Oracle technologies and toolsets.
• Much of the work will focus on data modeling and developing automated ETL processes that pull data from a variety of data sources. Data assignments will not be limited to these areas.
• Develop, monitor, and maintain a variety of automated DB processes.
• Research and resolve database issues as they arise.
• Will be assigned a variety of database management and maintenance tasks.
• Serve as a trusted technical advisor to the Maine Department of Transportation (MDOT) and serve as a technical mentor to other IT staff.
• Collaborate with other developers, analysts, and DBAs employed by the MDOT and MaineIT.
• Work closely with IT vendors, IT leadership, and MDOT business partners.
• Play a key role in upcoming system migrations, system expansions, and data modernization efforts.

Qualifications

Database Architect Required Skills:

• Has extensive practical experience with the modern Oracle platforms and technologies.
• Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.
• Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.
• Expertise in dimensional modeling.
• Practical experience with Oracle Analytics Cloud (OAC)
• Ability to serve as a technical mentor to both senior and junior IT staff.

Preferred skills:

• Local, State, and/or Federal Government Experience preferred.
• Practical experience utilizing API calls for automated data refreshes.
• Mastery of SQL and PL/SQL and the ability to develop complex procedures, functions, views, and scripts.
• Experience with tabular data models.
• Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust, performant, scalable, reliable, and expandable.
• Demonstrates a disciplined approach to process and error logging.
• Maintains excellent work habits when it comes to coding comments, system documentation, and metadata creation.
• Ability to develop architectural diagrams and system documentation, and train others on the content.
• Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.
• Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.

We are an Equal Opportunity Employer. We do not discriminate on the basis of race, religion, color, sex, age, national origin or disability.

#INDADM