Database Administrator & Developer

Becker County; Brantford; On-site; CAD 71,000 - 88,000; Full time

Job summary

Holstein Canada is seeking a skilled Database Administrator and Developer to support an ETL and data migration project and ensure reliable, secure, high-performing SQL Server environments. This role collaborates with SMEs, analysts, developers, and internal teams to understand business rules, data relationships, validation needs, and operational requirements.

The successful candidate will bring strong SQL Server, ETL, reporting, database administration, and documentation skills, along with the

Qualifications

• Strong experience with SQL Server, T-SQL, SSMS, SSIS, SSRS, SSAS, ETL development, and database administration.
• Experience building and maintaining data warehouses.
• Knowledge of backup/recovery, maintenance, performance tuning, indexing, monitoring, and troubleshooting.
• Experience with data migration, mapping, reconciliation, validation, and data quality resolution.
• Knowledge of database security, permissions, access reviews, service accounts, and handling sensitive data.
• Experience with Azure DevOps, Visual Studio, Git, GitHub Copilot, deployments, pipelines, and environment promotion is an asset.
• Ability to quickly learn complex business processes, systems, terminology, and data relationships.
• Strong documentation skills to create clear standards, procedures, and support materials.
• Excellent analytical, troubleshooting, communication, and collaboration skills.

Responsibilities

• Design, develop, administer SQL Server databases, ETL processes, and related solutions.
• Manage backups, recovery testing, maintenance, indexing, monitoring, and health checks.
• Manage Azure DevOps build and release pipelines for SQL Server databases, SSIS, SSAS and SSRS projects, ensuring controlled deployments, validation, and rollback processes
• Write, debug, and optimize complex T-SQL, stored procedures, functions, and database objects.
• Support data mapping, migration, validation, reconciliation, and issue resolution.
• Build and maintain database and BI solutions using SQL Server, SSIS, SSAS, and SSRS.
• Monitor, troubleshoot, and improve database performance, query execution, resource use, and configuration.
• Support database security, access management, permissions, service accounts, and secure data handling.
• Coordinate refreshes, environment updates, deployments, version control, validation, and rollback processes.
• Document business rules, ETL logic, standards, dependencies, procedures, and processes.
• Collaborate with SMEs, analysts, developers, third parties, and internal teams on reliable data solutions.

Skills

SQL Server

T-SQL

SSMS

SSIS

SSRS

SSAS

ETL

Data Warehousing

Database Administration

Azure DevOps

Git

GitHub Copilot

Education

Post-secondary education in Computer Science / IT or related field

Tools

Azure DevOps

Visual Studio

Git

GitHub Copilot

Job description

HOLSTEIN CANADA is Canada’s largest dairy breed association, serving more than 9,000 active dairy producers since 1884. We offer a team-oriented workplace, supportive leadership, and the opportunity to contribute to our future.

Holstein Canada is seeking a skilled Database Administrator and Developer to support a ETL and data migration project and ensure reliable, secure, high-performing SQL Server environments. This role works closely with SMEs, analysts, developers, and internal teams to understand business rules, data relationships, validation needs, and operational requirements.

The successful candidate will bring strong SQL Server, ETL, reporting, database administration, and documentation skills, along with the ability to learn complex systems, troubleshoot issues, and support controlled deployments.

In this role, you will:

• Design, develop, administer SQL Server databases, ETL processes, and related solutions.
• Manage backups, recovery testing, maintenance, indexing, monitoring, and health checks.
• Manage Azure DevOps build and release pipelines for SQL Server database, SSIS, SSAS and SSRS projects, ensuring controlled deployments, validation, and rollback processes
• Write, debug, and optimize complex T-SQL, stored procedures, functions, and database objects.
• Support data mapping, migration, validation, reconciliation, and issue resolution.
• Build and maintain database and BI solutions using SQL Server, SSIS, SSAS, and SSRS.
• Monitor, troubleshoot, and improve database performance, query execution, resource use, and configuration.
• Support database security, access management, permissions, service accounts, and secure data handling.
• Coordinate refreshes, environment updates, deployments, version control, validation, and rollback processes.
• Document business rules, ETL logic, standards, dependencies, procedures, and processes.
• Collaborate with SMEs, analysts, developers, third parties, and internal teams on reliable data solutions.

You offer:

• Post-secondary education in Computer Science, IT, Information Systems, or a related field, or equivalent experience.
• Strong experience with SQL Server, T-SQL, SSMS, SSIS, SSRS, SSAS, ETL development, and database administration.
• Experience building and maintain data warehouses
• Experience with backup/restore, recovery testing, maintenance, performance tuning, indexing, monitoring, and troubleshooting.
• Experience with data migration, mapping, reconciliation, validation, and data quality resolution.
• Knowledge of database security, permissions, access reviews, service accounts, and handling sensitive data.
• Experience with Azure DevOps, Visual Studio, Git, GitHub Copilot, deployments, pipelines, and environment promotion is an asset.
• Ability to quickly learn complex business processes, systems, terminology, and data relationships.
• Strong documentation skills to create clear standards, procedures, and support materials.
• Excellent analytical, troubleshooting, communication, and collaboration skills.
• A proactive, detail-oriented approach with sound judgment, curiosity, adaptability, and a commitment to reliable systems.
• Experience using GitHub Copilot IDE and CLI tools

The salary for this position will be approximately $70,736 - $88,419.

Holstein Canada is committed to a barrier-free recruitment process. To request accommodation, please contact [e-mail].

Holstein Canada does not utilize Artificial Intelligence (AI) in the screening, assessment, or selection of applicants.