Senior Oracle Data Architect — ETL, OAC & Cloud (On‑Prem)

Chandra Technologies, Inc; Augusta (ME); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Chandra Technologies, Inc. seeks a Senior Developer / Data Architect to lead Oracle-based data repositories and automated ETL workflows. You will design scalable solutions, optimize performance, and work with MDOT on migrations and data modernization.

Responsibilities include mentoring IT staff, creating architecture diagrams, and ensuring robust metadata and documentation. Remote-friendly with monthly on-site in Augusta, ME, and alignment with New England requirements.

Qualifications

• Experience designing enterprise data repositories on Oracle on-prem and cloud.
• Develop automated ETL pipelines from diverse sources.
• Expertise in dimensional modeling and data warehousing.
• Experience with Oracle Analytics Cloud (OAC) and advanced SQL/PLSQL.

Responsibilities

• Serve as daily SME for Oracle tech and tooling used by MDOT and MaineIT.
• Develop, monitor, and maintain automated DB processes and ETL jobs.
• Research and resolve database issues; participate in system migrations and data modernization.
• Mentor junior staff and produce architecture diagrams and documentation.

Skills

Oracle architecture

ETL automation

SQL/PLSQL

Oracle Analytics Cloud (OAC)

Data modeling

Dimensional modeling

Cloud/on-prem Oracle

Mentoring others

Job description

Chandra Technologies, Inc. seeks a Senior Developer / Data Architect to lead Oracle-based data repositories and automated ETL workflows. You will design scalable solutions, optimize performance, and work with MDOT on migrations and data modernization.

Responsibilities include mentoring IT staff, creating architecture diagrams, and ensuring robust metadata and documentation. Remote-friendly with monthly on-site in Augusta, ME, and alignment with New England requirements.