Ai/database Administrator

Discover your full potential. At Tetra Tech, we are collaborating with industry-leading experts for a sustainable future for our world. We combine consulting and engineering with advanced analytics and technology to solve the world’s most complex challenges. Our innovation hubs across the globe will enable you to share ideas and best practices while growing your professional network. Wherever you are in your career journey, you will benefit from working with world-class engineers, scientists, and technical specialists.

**Your Role**:
We are currently seeking a **Junior** **AI/Database Administrator (Co-op)**for our Pickering, Ontario office. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

**Responsibilities**:

- Databases - design and implement a database to track and monitor a predetermined set of data points
- MS Access
- MSSQL, SQL, SQL Server
- Knowledge of Oracle in an asset

- Programming - utilize programming languages to create complex functions for use in databases
- VBA, VB.NET
- C++, Java is an asset

- API Integration - develop, consume, and manage RESTful APIs to support scalable data-driven systems and connect distributed services
- Excel - track and monitor predetermined set of data points in a spreadsheet with greater than 1,000 rows or columns using macros, Visual Basic, and advanced formulas
- Word - creating, manipulating, organizing and formatting large, complex documents
- Powerpoint - creating, manipulating, organizing and formatting large, complex presentation

**Qualifications**:

- Recent graduate with University/College Degree completed or 4th year student
- AI Integration - familiarity with Large Language Models (LLMs) and their practical use through APIs; experience with the OpenAI API is considered an asset
- 1 year of related experience in database operation - working or previous co-ops is considered an asset
- Previous AI experience is considered an asset
- Access - demonstrate proficiency in Access queries, programming/coding, form building and reporting
- Excel - advanced formulas, macro’s, advanced analytics (trending/splicing, graphing etc.)
- Word - Organize and format a large, complex document
- Powerpoint - Organize and format a large, complex presentation
- Must be able to work as part of a multi-disciplined team

**This is a co-op role with flexibility in duration (4 months, 6 months or 1 year)**

** Additional Information**

A requirement of working for Tetra Tech is that you are at least 18 years of age and legally entitled to work in Canada. (A copy of a valid work permit may be required.)

If you are considered for the position, clearance on all applicable background checks (which may include criminal, identity, educational and security) and professional reference checks is required. Some Tetra Tech positions require an enhanced level of background assessment, which is dictated by law. These positions require advanced criminal record checks that must also be conducted from time to time after commencement of employment.

**About Tetra Tech**:
Tetra Tech combines the resources of a global, multibillion-dollar company with local, client-focused delivery in more than 600 locations around the world. Our reputation rests on the technical expertise and dedication of our employees—30,000 associates working together to provide smart, scalable solutions for challenging projects. We are proud to be home to leading technical experts in water, environment, infrastructure, resource management, energy, and international development.

Please no phone calls or agencies.