Conduct performance tuning of SQL queries for automated job primarily backup and mirroring.
Support database setup for Power BI and SQL reporting dashboards used by internal users.
Assist in setup and ongoing maintenance of big data environment for our research team.
Prep monthly report on database utilization, capacity usage, tracking sheet for issues
Support IT Roadmap project assignments
Assist in the design and management of secure solutions for both current and future state data systems.
Setup, configure and support of Microsoft Fabric for enterprise use and data governance.
Create ETL between on prem databases and the Dataverse for CRM, ERP and Microsoft SaaS.
Develop a technology data model and schema to support new systems
Setup and configure cloud based database setup from MS SQL to Azure.
Automate database processes, tasks, and procedures using SQL, Azure and Power Automate.
Support role-based access to safeguard the security and integrity of databases and applications.
Collaborate with business units to collect requirements for new applications
Requirements
Post-secondary degree – Bachelor of Science, Computing /Engineering, or a related field
3-5 years of relevant experience in database management and data engineering.
SQL Expertise: Knowledge of data extraction from legacy systems (e.g., SQL Server, e-data), cloud databases and Dataverse for Azure Cloud.
Write queries for reporting dashboards; develop stored procedures to perform business processes, automate tasks using jobs and agents.
ETL Tools (SQL SSIS): Hands on experience supporting SSIS packages to extract data from ERP systems and load into Azure Fabric and Databricks for analytics.
Working knowledge of star schema.
Cloud Data Services (Azure Cloud): Configure backups and proactive monitoring agents and jobs.
Soft Skills (Communication): Ability to communicate effectively through MS Teams, Email and SP collaboration tools.
Benefits
Virtual First – work from home anywhere across Canada with a budget to set up your home office.
A workplace where your hard work is not just valued, but actively celebrated.
Healthcare benefits from Day One to support your physical and mental wellbeing, including a $2,500 benefit for Psychologist, Social Worker or Psychotherapist services
Work/Life Balance: In addition to 20 days annual vacation, we close between Christmas Day and New Year’s Day, observe 13 holidays per year and offer Friday afternoon closures.
A modern, defined benefit (DB) pension plan: We care about your future and offer a pension plan with a 5% match from Day One
Employee Family Assistance Program (EFAP): We understand that life can be unpredictable and challenging and EFAP supports you and your family during difficult times.
Senior Go engineer building cross - platform endpoint agents and cloud microservices. Protecting Blackpoint Cyber customers through scalable cybersecurity software.
Senior Backend Engineer building distributed C/C++ vector databases for VAST Data’s AI infrastructure. Optimizing high - throughput, real - time analytics across massively scalable data systems.
Unreal Engine C++ developer building peer - to - peer XR streaming applications for Mawari’s decentralized 3D content platform. Developing UE4/5 plugins, SDK integrations, and real - time content delivery components.
Junior Java Developer completing paid Cúram training for PLATO, Canada’s Indigenous - owned software testing and technology services company. Building digital services for a multi - year government project.
.NET Developer maintaining legacy Windows and cloud applications for Capgemini, a global business and technology transformation partner. Improving automation, security, and technical debt across agile teams.
Backend Engineer building GitLab Duo Chat’s Python agentic runtime. Developing secure AI features and APIs for GitLab’s DevSecOps orchestration platform.