The Database Administrator will focus on:

1. Installing and maintaining databases
2. Managing backup and recovery processes, system storage, data security and confidentiality
3. Developing database architecture
4. Planning and coordinating data migration between systems
5. Monitoring technical performance of corporate data systems
6. Setting up database encryption
7. Setting up database replication
8. Identifying and resolving data abnormalities
9. Liaising with client departments and applications staff on the delivery of business technology solutions
10. Researching, evaluating and recommending technology solutions related to database and performance measurement tools
11. Managing the deployment of SSIS data pipeline packages

The position requires the following technical qualifications:

1. Considerable experience with on premise SQL Database environments
2. Thorough knowledge of the principles and techniques associated with database design and management.
3. Ability to analyze and evaluate various data and information requirements and to prepare recommendations regarding the advisability and feasibility of incorporating changes or additions to the corporate data model.
4. Ability to establish standards and procedures to ensure the integrity, security, availability and recovery of all data.
5. Ability to serve as project manager for a variety of infrastructure and database projects, establish project schedules, assign and guide the work of team members, and monitor progress.
6. Experience with data modeling
7. Experience with building data pipelines and ETL processes using SSIS is as asset.
8. Experience with database replication, mirroring, and encryption
9. Experience with setting up new Microsoft SQL servers and databases.
10. Thorough knowledge of software development methods, practices, and procedures.
11. Ability to prepare technical design and write technical specifications.

In addition, this position requires the ability to:

1. Establish and maintain effective working relationships with a variety of internal contacts.
2. Provide advice and assistance on matters related to the work.
3. Communicate effectively orally and in writing.
4. Perform assigned duties with minimal supervision, although direction will be given.
5. Maintain confidentiality.

This work will be performed virtually (3 days) and in person (2 days) using online meeting technologies.