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.

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

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.

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

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

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

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.

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

Global Technical Talent is a subsidiary of Chenega Corporation (www.Chenega.com) with over 1.3 billion US$ in revenue and 5800 US employees. We provide Total Talent Solutions, Global staffing, SOW, RPO, Direct Sourcing, and Global Payroll with physical offices in US, Canada, and India. GTT Digital headquartered in Toronto specializes in providing high-tech digital and banking talent to some of the nation’s largest financial institutions. As a leader in the staffing industry for over 22 years, we have become one of the largest staffing firms in the New England region, working with Fortune 500 clients and cutting-edge, technology-driven recruiting infrastructure.

We are a Native American-owned, economically disadvantaged corporation that highly values diverse and inclusive workplaces. Our clients and partners are among the most successful and innovative organizations in the world. Our top clients are Fortune 500 banking, insurance, and financial services firms, some of the nation’s largest life sciences, biotech, utility, and retail companies, and prestigious educational institutions in the Ivy League tier.

There is always a new opportunity for success when you look through all of the open job opportunities on our website’s career page. Just click on this link: https://bit.ly/gttcareers

Awards

SIA’s Fastest Growing Staffing Firm: 2023 and 2015
SIA’s Best Staffing Firm to Work for: 2019 -2023
Inc 5000 Fastest Growing Private Company: 2023, 2022, 2016, 2015
Randstad Preferred Supplier: 2020 - 2023
TechServe Alliance Excellence Award. 2019
NH Business Magazines Fast 5 fastest growing companies
Ernst & Young Entrepreneur of the Year Finalist: 2015