Senior Database Developer (6 Month, Contract)

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

Benefits offered by this job

Market competitive salary

Career growth and development

Family-oriented environment

Job summary

The Dufresne Group is seeking a Senior Database Developer for its eCommerce Team at the Home Office in Winnipeg, MB. You will manage data infrastructure and assets for eCommerce, leading the planning, design, and implementation of complex data interfaces and OLTP/OLAP databases.

Responsibilities include ETL development, data modeling, performance tuning, and SQL/PLSQL development. A strong Microsoft SQL Server background and ability to collaborate across teams are essential.

Qualifications

• 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 ETL development experience (7+ years).
• Strong background in managing Microsoft SQL Server infrastructure and database architecture.

Responsibilities

• Plan, design, and implement complex data interfaces, transformations, and OLTP/OLAP databases.
• Model, develop, and implement transactional, ETL staging, and analysis databases and cubes.
• Lead continuous improvement to automate and increase efficiency across database and ETL processes.
• Develop SQL/PLSQL code with packages, procedures, functions, triggers, and views; manage source control.
• Implement performance monitoring, tuning, and enforce coding standards; conduct code reviews.
• Train other teams on coding standards and best practices; write clean, efficient code.

Skills

SQL

PL/SQL

ETL

SSIS

SSRS

SSAS

Data modeling

Query tuning

Data governance

Education

Bachelor's degree in computer science or related field

Tools

SQL Server

SSIS

SSRS

SSAS

Job description

Job Category: eCommerce

• Full-Time
• Hybrid

Locations

Showing 1 location

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

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.