Database Architect

Database Architect

Location: Augusta, ME

Onsite Flexibility: Hybrid majority remote; required onsite in Augusta, ME one day per month. Only candidates in the New England area will be considered.

Contract Details

• Position Type: Contract
• Pay Rate: $80.00 $80.01 / Hour (USD)
• Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Job Summary

We are looking for an experienced Senior Developer / Data Architect to 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. This individual will be expected to develop, monitor, and maintain a variety of automated database processes, research and resolve database issues as they arise, and 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 as a technical mentor to other IT staff. They will collaborate with other developers, analysts, and DBAs employed by the MDOT and MaineIT, and 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.

Key Responsibilities

• Serve as a daily subject-matter expert for all Oracle technologies and toolsets.
• Focus on data modeling and developing automated ETL processes that pull data from a variety of data sources.
• Develop, monitor, and maintain a variety of automated database processes.
• Research and resolve database issues as they arise.
• Perform a variety of database management and maintenance tasks.
• Serve as a trusted technical advisor to the Maine Department of Transportation (MDOT).
• 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.

Required Skills

• Developing automated ETL processes from a variety of flat-file and database sources.
• Designing and implementing enterprise class data repositories built upon Oracle on-premises and cloud-hosted databases.
• Expertise in dimensional modeling and ability to act as a technical mentor.
• 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 utilizing API calls for automated data refreshes.
• Practical experience with Oracle Analytics Cloud (OAC).
• Mastery of SQL and PL/SQL, including 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.
• Disciplined approach to process and error logging.
• Excellent work habits when it comes to coding comments, system documentation, and metadata creation.
• Ability to serve as a technical mentor to both senior and junior IT staff.
• Ability to develop architectural diagrams and system documentation, and train others on the content.
• Proven ability to independently research technical options to find suitable solutions for evolving technical needs.
• Ability to work independently towards project and/or assignment goals with limited day-to-day oversight and/or prompting.

Benefits

• Medical, Vision, and Dental Insurance Plans
• 401k Retirement Fund

About the Client

This Augusta-based public sector organization delivers justice, education, and economic development services across Maine. Operating at a statewide level, the client supports a broad range of government functions and employs professionals across information technology, data management, business analysis, and database administration disciplines who collaborate with agency partners, IT vendors, and state leadership.

About GTT

GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada.

Job Number: 26-13094 Industry: Software Engineering

#LI-Remote #LI-GTT #gttjobs