Database Administrator - Toronto, Canada - Alcohol and Gaming Commission of Ontario

Alcohol and Gaming Commission of Ontario

Verified Company

Toronto, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

The Alcohol & Gaming Commission of Ontario (AGCO) is responsible for regulating the alcohol, gaming, horse racing and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.

The Information & Information Technology Branch requires an experienced Database Administrator, who will be reporting to the Senior Manager of IT Infrastructure and Operations.

The responsibilities of the Database Administrator include, but not limited to, the following:

Act as a senior specialist in leading the implementation of new database and analytics services as it relates to AGCO projects.
Design, build, and support the database and analytics services in a hybridcloud environment.
Automate code deployment, configuration, and monitoring processes.
Monitor and proactively optimize the availability and performance of database instances and related jobs.
Monitor and proactively manage database connections, locks, and performance trends.
Maintain data access, uptime, and performance. Respond to and resolve issues.
Implement, maintain, and audit data access, performance, and security.
Create and maintain backup and recovery strategy, and regular testing to ensure usability.
Create and maintain documentation which includes build books, operating and maintenance procedures.
Administer, configure, and manage database backup and restore.
Maintain alert, notification, and job schedule.
Develop, maintain, and support data related change management and testing processes.
Develop and maintain DevOps CI/CD processes.
Interact professionally with all levels of staff with excellent communication and interpersonal skills.
Provide guidance and knowledge to team members, and promote efficiency, productivity, innovations, and knowledgesharing across multifunctional teams.
Provide 3rd level support, liaise with vendors and other IT personnel for problem resolution.
Participate in oncall, maintenance work, and incident response outside of normal business hours on an as needed basis.

How do I qualify?:

5+ years of traditional Microsoft SQL Database Administrator experience with 3+ years of Azure database and analytics services experience.
Expert knowledge of Microsoft SQL Server (i.e. SQL, SSAS, SSIS, SSRS) and Azure database and analytics services (i.e. Azure SQL, Azure Synapse, Azure Data Factory, Azure Data Lake, Power Apps, Power BI).
Expert knowledge in performance tuning, query optimization, and scalable database design.
Experience in data preparation for advanced analytics and complex reports development on an Azure platform is an asset.
Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
Experience in migration of database and analytics services to Azure would be a definite asset.
Oracle experience would be a definite asset.
Demonstrated experience on Azure DevOps or similar tools.
Strong technical documentation skills.
Solid understanding of product management, agile principles, and development methodologies.
Fundamental knowledge in cybersecurity.
Excellent communications and interpersonal skills and the ability to interact professionally with all levels of staff.
Flexible selfstarter with the ability to effectively prioritize and execute tasks in a teamoriented agile environment.
Creative thinker with strong troubleshooting skills and sense of urgency for resolving issues.
Ability to provide support on a flexible schedule when needed.
Current certification in related technologies would be a definite asset.

The AGCO is an inclusive and equal opportunity employer
:

_Disability related accommodation during the recruitment process is available upon request._

Additional Information:

Address:

1 Permanent, 90 Sheppard Ave E, Toronto, Toronto Region, Criminal Record Check

Compensation Group:

Excluded
Understanding the job ad definitions
Schedule:
N/A
Category:
Information Technology
Posted on:
Monday, February 13, 2023
Note:

Required security screening checks along with your written consent, will be sent to the Transition and Security Office (TSO), Corporate Talent Programs Branch, Talent and Leadership Division to evaluate the results.

If applicable, the TSO, with your written consent, will request and obtain any additional employment screening checks that were not obtained directly by you.

A record under the Criminal Code and/or other federal offence record(s) does not automatically mean you will be ineligible for the position.

The employment screening check(s) will only be reviewed and evaluated by the TSO for the purpose of making a security clearance decision.

The details of an individual's employment screening check(s) will be considered in specific relation to the duties and responsibilities of the position being filled.

Employment screening check records will be maintained by the TSO and k