Senior Database Developer (6 Month, Contract)

The-Dufresne-Group-; Winnipeg; Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Market competitive salary

Career growth and development

Family-oriented working environment

Canada’s Best Managed Companies

Job summary

The Dufresne Group is seeking a Senior Database Developer for the eCommerce team at the Home Office, located at 147 Commerce Drive, Winnipeg, MB. You will manage data infrastructure and assets, lead design and implementation of complex data interfaces, and develop OLTP/OLAP databases to support ecommerce operations.

You will focus on SQL and PL/SQL development, ETL processes, data modeling, and performance tuning, with a strong emphasis on data integrity and security.

Qualifications

• Bachelor’s degree in computer science or related field preferred.
• Experience with SQL Server 2019+ and SSIS/SSRS/SSAS required.
• 7+ years of ETL development experience.
• Strong technical background in SQL Server infrastructure, architecture, security and data integrity.
• Experience with data models, reporting, data marts, analytic cubes, and visualization.
• Ability to communicate complex technical info to non-technical stakeholders.

Responsibilities

• Plan, design, and implement complex data interfaces and OLTP/OLAP databases.
• Model and implement transactional, ETL staging, and analytics databases and cubes.
• Lead continuous improvement projects to automate and increase efficiency of data processing.
• Develop SQL code with emphasis on performance, using functions, procedures, views, and triggers.
• Manage SQL code in a source control system and enforce coding standards.
• Train other teams on code implementation and best practices.
• Write clean, fast code with data integrity through constraints and rules.

Skills

Analytical thinking

Technical communication

Project management

Data solutions

Data modeling

SQL tuning

ETL development

Education

Bachelor’s degree in computer science or related field

Tools

SSIS

SSRS

SSAS

SQL Server

Job description

Job Category: eCommerce

Requisition Number: SENIO002586

• Posted : July 31, 2026
• Full-Time
• Hybrid

Locations

Showing 1 location

The Dufresne Group Home Office
147 Commerce Drive
Winnipeg, MB R3P1A2, CAN

Description

The Dufresne Group is currently seeking a Senior Database Developer for our eCommerce Team within our Home Office located at 147 Commerce Drive in Winnipeg, MB.

As a Senior Database Developer you will be responsible for managing data infrastructure and assets for eCommerce. You will lead the planning, design, and implementation of complex data interfaces, transformations, and OLTP and OLAP databases.

The Dufresne Group is committed to investing in our team members; we offer:

• Market competitive salary;
• Career growth and continuous development;
• Respectful and family-oriented working environment with strong company values;
• The opportunity to work for one of Canada’s Best Managed Companies.

As the Senior Database Developer you will:

• Plan, design, and implement complex data interfaces, transformations, and OLTP and OLAP databases.
• Model, develop, and implement transactional, ETL staging, and analysis/reporting databases, data structures, and cubes to satisfy business and technical requirements.
• Complete continuous improvement projects to further automate, fix issues, and increase efficiency across database, ETL, and business line processing.
• Focus on SQL and PL/SQL application development using packages, store procedures, functions, triggers, and views.
• Manage SQL code in a source control system.
• Implement database performance monitoring and tuning.
• Establish and enforce SQL development coding standards and best practices. Lead/participate in SQL code reviews.
• Train other development teams on the implementation of the code.
• Write clean, fast code that is free of bloat and unnecessary overhead.
• Ensure accuracy and integrity of data through the development of constraints and validation rules.

As a successful candidate you will have the following:

• Bachelor’s degree in computer science or related field is preferred. A combination of education and experience will be considered.
• Experience with: SQL Server 2019 or above, SSIS, SSRS, SSAS.
• Extensive (ideally at least 7 years of) experience developing ETL.
• A strong technical background and substantial experience in managing and administering Microsoft SQL Server infrastructure.
• Demonstration of a deep understanding of database architecture, performance, security, and integrity, data access and table maintenance, developing and administering ETL processes using SSIS and other tools, SQL coding and performance tuning, and proactive monitoring and alerting.
• Experience utilizing and interpreting data models, developing reporting, data marts, analytic cubes, and visualization.
• Strong analytical and critical thinking skills.
• Ability to clearly articulate complex technical information to non-technical stakeholders and collaborate effectively with cross-functional teams.
• Ability to manage multiple projects and priorities while meeting deadlines and maintaining high-quality work.
• Ability to find innovative solutions to data management challenges, especially when dealing with complex or ambiguous situations.
• Ability to evaluate and interpret data-related requirements, anticipate issues, and propose effective, scalable solutions.
• Commitment to staying current with database/reporting/Microsoft SQL Server tools and technologies and the direction of the general database industry.
• A Criminal Record Check will be required.