Senior Database Developer – Contract

The Dufresne Group

Senior Database Developer responsible for managing data infrastructure and assets at The Dufresne Group. Leading technical planning, design, and implementation for eCommerce databases in a hybrid work environment.

Posted 7/31/2026contractWinnipeg • 🇨🇦 CanadaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL and PL/SQL application development, including ETL processes and database performance tuning. Proficient in managing Microsoft SQL Server infrastructure and implementing data solutions that ensure accuracy, integrity, and efficiency.

Highest-signal resume keywords

SQL Server 2019ETL DevelopmentSSISDatabase Performance TuningData Modeling

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL DevelopmentPL/SQL Application DevelopmentETL ProcessesDatabase ArchitecturePerformance MonitoringData StructuresData AnalysisData IntegritySQL Coding StandardsData Visualization

Soft Skills

Analytical ThinkingCollaborationProject ManagementProblem SolvingCommunication

Tools & Technologies

SQL Server Integration ServicesSQL Server Reporting ServicesSQL Server Analysis ServicesSource Control SystemsSQL Agent Jobs

Industry Keywords

OLTPOLAPData MartsAnalytic CubesContinuous Improvement

Tech Stack

Tools & technologies

ETLMS SQL ServerSQLSSIS

About the role

Key responsibilities & impact

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
Automate complex processes using SQL agent jobs, SQL Server Integration Services, etc
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

Requirements

What you’ll need

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

Benefits

Comp & perks

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