Database Architect-SQL/PL-SQL

Novalink Solutions LLC; Virginia (MN); On-site; USD 140,000 - 220,000; Full time

Job summary

Novalink Solutions LLC is seeking an experienced Senior Developer / Data Architect focused on Oracle platforms. The role centers on data modeling, automated ETL, and robust data repositories across on-prem and cloud environments.

You will drive technical solutions, mentor IT staff, and contribute to system migrations and data modernization efforts with MDOT and partners. Strong SQL/PLSQL and OAC skills are essential.

Qualifications

• Extensive Senior DBA-level experience with Oracle on-prem and cloud databases.
• Develop automated ETL from various flat-file and DB sources.
• Experience using API calls for automated data refreshes.
• Experience with Oracle Analytics Cloud (OAC).
• Mastery of SQL and PL/SQL; able to develop complex procedures and scripts.
• Ability to translate complex business requirements into scalable technical solutions.
• Disciplined approach to coding comments, docs, and metadata.
• Ability to mentor senior and junior IT staff.
• Develop architectural diagrams and system docs; train others.
• Proven ability to research technical options for evolving needs.

Responsibilities

• Serve as daily SME for all Oracle technologies and toolsets.
• Focus on data modeling and automated ETL across multiple data sources.
• Develop, monitor, and maintain automated DB processes.
• Research and resolve database issues; perform maintenance tasks.
• Collaborate with MDOT/IT partners; mentor staff; support migrations and data modernization.

Skills

Oracle DB design

ETL automation

OAC

SQL/PLSQL

Dimensional modeling

Mentoring

Architecture diagrams

Documentation

Data migration

API integration

Tools

Oracle Database

Oracle Analytics Cloud

Job description

Augusta, United States | Posted on 09/04/2026

We would be looking for an experienced Senior Developer / Data Architect who:

• 1. Has extensive practical experience with the modern Oracle platforms and technologies. This includes the following:
  
  
  
  • 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.
  
  
  • Practical experience utilizing API calls for automated data refreshes.
  
  
  • Practical experience with Oracle Analytics Cloud (OAC)
  
  
  • Mastery of SQL and PL/SQL and the ability to develop complex procedures, functions, views, and scripts.
  
  
  
  


• 3. Experience with tabular data models.


• 4. Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust, performant, scalable, reliable, and expandable.


• 5. Demonstrates a disciplined approach to process and error logging.


• 6. Maintains excellent work habits when it comes to coding comments, system documentation, and metadata creation.


• 7. Ability to serve as a technical mentor to both senior and junior IT staff.


• 8. Ability to develop architectural diagrams and system documentation, and train others on the content.


• 9. Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.


• 10. Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.

This individual will 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. However, data assignments will not be limited to these areas. They will be expected to develop, monitor, and maintain a variety of automated DB processes. They will be expected to research and resolve database issues as they arise. They will be assigned a variety of database management and maintenance tasks. They will serve as a trusted technical advisor to the Maine Department of Transportation (MDOT) and serve as a technical mentor to other IT staff. They will collaborate with other developers, analysts, and DBAs employed by the MDOT and MaineIT. They will work closely with IT vendors, IT leadership, and MDOT business partners. They will play a key role in upcoming system migrations, system expansions, and data modernization efforts.

Requirements

Top 3 Skills:

• Developing automated ETL.


• Designing & implementing enterprise class data repositories built upon Oracle on prem and cloud hosted DB's.


• Expertise in dimensional modeling and ability to act as a technical mentor.