Database Administrator
- Winnipeg, MB, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Working hours
- 36.25 hours per week
- Posting language
- English
- Posted
Original 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.
Key Details
- 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
- Data classification experience
- 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 their application package.
More about this job
Responsibilities
Create and modify database code and SQL scripts, then test and validate database changes. Administer and maintain databases, support security and encryption activities, and contribute to DB2 management and environment tasks as needed.
Requirements
Candidates must have at least three years of database administration experience, hands-on SQL and Microsoft SQL Server experience, familiarity with OLTP and OLAP environments, and experience with SSIS. They must be able to work onsite in Winnipeg 25% to 50% of the time, including the first two weeks, and demonstrate strong troubleshooting, analytical, and documentation skills.
Skills
- SQL
- Microsoft SQL Server
- Database Administration
- SQL Server Integration Services
- OLTP
- OLAP
- Database Code Development
- SQL Scripting
- Database Testing
- Database Validation
- Database Maintenance
- Database Security
- Encryption Key Management
- DB2
- Data Classification
- Test Data Management
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Finance & Accounting
Keywords
- SQL
- Microsoft SQL Server
- Database Administration
- SQL Server Integration Services
- OLTP
- OLAP
- Database Code
- SQL Scripts
- Testing
- Validation
- Database Maintenance
- Database Security
- Encryption
- Key Management
- DB2
- Database Schema Management
- Database Object Management
- Database Sizing
- Database Growth
- Data Classification
- Test Data Management
- SQL Server Management Studio
- TOAD
- RazorSQL
- TeamDesk
- TablePlus
- Knack
- Git
- Bitbucket
- PVCS