Database Administrator

Focus Systems Inc.; Winnipeg; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

Focus Systems Inc. is seeking an experienced Database Administrator to support development, testing, validation, and administration of enterprise databases in Winnipeg.

The role requires hands-on SQL expertise, Microsoft SQL Server experience, and strong knowledge of OLTP/OLAP environments. The contractor will perform testing, validation, security tasks, and database administration with a hybrid work arrangement and an initial two weeks onsite.

Qualifications

• At least three (3) years of experience as a database administrator.
• Hands-on experience with SQL and Microsoft SQL Server.
• Experience with Online Transaction Processing and Online Analytical Processing environments.
• Experience with SQL Server Integration Services (SSIS).
• Ability to work 25% to 50% onsite at Winnipeg offices, with initial two weeks onsite.

Responsibilities

• Create and modify database code and SQL scripts in accordance with requirements and specifications.
• Perform testing and validation of database code and changes.
• Administer and maintain databases.
• Support database security activities including encryption setup and key management.
• Assist with data classification and test data management tools.

Skills

SQL

Microsoft SQL Server

OLTP

OLAP

SSIS

Database administration

Tools

SQL Server Management Studio

TOAD

RazorSQL

TeamDesk

TablePlus

Knack

Git

Bitbucket

PVCS

Streams

Job description

Focus Systems is seeking an experienced Database Administrator to support database development, testing, validation, and administration.

If you have strong experience with SQL, Microsoft SQL Server, OLTP and OLAP environments, SSIS, and database administration, this is an opportunity to contribute to the reliability and security of an important enterprise database environment.

• Location: Winnipeg, Manitoba
• Contract: Preferred start November 23, 2026; initial term of approximately six months, with two optional extensions of up to three months each
• Work Arrangement: Hybrid; 25% to 50% onsite, with the first two weeks onsite before a remote work option may be considered. The onsite requirement may increase with reasonable notice.
• Schedule: Full-time, 36.25 hours per week

Role Overview

The Database Administrator will create and modify database code and SQL scripts in accordance with requirements and specifications, perform testing and validation, and administer and maintain databases.

The successful candidate will bring practical database administration experience across Microsoft SQL Server environments, along with the technical judgment needed to support secure, reliable, and well-managed database operations.

Key Responsibilities

• Create and modify database code and SQL scripts in accordance with requirements and specifications
• Perform testing and validation of database code and changes
• Administer and maintain databases
• Support database security activities, including encryption setup and enablement and key management
• Support data classification and test data management tools and technologies
• Contribute to DB2 database, schema, object, maintenance, sizing, growth, standards, and environment-management activities where required

Mandatory Qualifications

• At least three (3) years of experience as a database administrator
• Hands-on experience with SQL and Microsoft SQL Server
• Experience with Online Transaction Processing and Online Analytical Processing environments
• Experience with SQL Server Integration Services
• Ability to work 25% to 50% onsite at WCB offices in Winnipeg, including the first two weeks onsite, and accommodate an increased onsite requirement with reasonable notice

Required Skills and Experience

• Creating and modifying database code and SQL scripts
• Testing and validating database code and changes
• Database administration and maintenance
• Strong technical troubleshooting, analytical, and documentation skills

Preferred Experience and Assets

• DB2 experience, including database, schema, and object management; routine administration and maintenance; sizing and growth; standards; and environment builds
• SQL database encryption setup and enablement, including key management for encrypted databases
• Experience with test data management tools and technologies
• Experience with SQL Server Management Studio
• Experience with database management tools such as TOAD, RazorSQL, TeamDesk, TablePlus, or Knack
• Experience with source code control tools such as Git, Bitbucket, PVCS, or Streams
• Experience with architecture design tools and team collaboration tools

Application Deadline

Please complete your initial application by October 25, at 11:00 PM CST. Only candidates selected to proceed to the next stage will be contacted and invited to complete your application package.