Database Architect

RICEFW Technologies Inc; Augusta (ME); On-site; USD 90,000 - 130,000; Full time

Job summary

RICEFW Technologies Inc. seeks a Senior Oracle DBA to lead enterprise data repositories on Oracle databases both on-prem and in the cloud. You will design automated ETL pipelines, implement data refreshes via API calls, and leverage Oracle Analytics Cloud (OAC) to enable robust analytics capabilities.

The role requires mastery of SQL/PLSQL, dimensional modeling, and experience mentoring other IT staff. You will act as a technical advisor to the MDOT and MaineIT teams, delivering scalable and

Qualifications

• Significant Senior DBA-level experience designing and implementing enterprise data repositories with Oracle on-prem and cloud databases.
• Hands-on experience developing fully automated ETL processes from varied sources.
• Experience using API calls to automate data refreshes and data movement.
• Proficient with Oracle Analytics Cloud (OAC) for analytics workloads.
• Strong SQL and PL/SQL skills to develop complex procedures, functions, views, and scripts.

Responsibilities

• Serve as a daily subject‑matter expert for Oracle technologies and toolsets for MDOT and MaineIT.
• Develop, monitor, and maintain automated DB processes and data pipelines from multiple sources.
• Research and resolve database issues; collaborate with MDOT IT staff and vendors.
• Create architectural diagrams and system documentation; mentor junior staff.

Skills

Oracle DBA

ETL automation

SQL/PLSQL

Dimensional modeling

Mentoring

Tools

Oracle Analytics Cloud (OAC)

Job description

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.

Job Description:

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


2. Expertise in dimensional modeling.


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.

Typical Duties:

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 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 & MaineIT. They will work closely with IT vendors and IT leadership and LIV Solve.