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 and Gaming Commission of Ontario (AGCO) is a regulatory agency that reports to the Ministry of the Attorney General.

The AGCO is responsible for regulating the alcohol, gaming, horseracing, and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.

The Cybersecurity and Digital Platforms Branch is looking for an experienced
Database Administrator to join their team.

Reporting to the Senior Manager of IT Infrastructure and Operations, the Database Administrator will act as a senior specialist in leading the implementation of new database and analytics services as it relates to AGCO projects.

Also, the position will design, build and support such services in a hybrid-cloud environment to ensure availability, performance and integrity and security of business data.

Work Location:
Head Office, Toronto, ON; Hybrid

OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism: We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

Visit the
OPS Anti-Racism Policy and the
OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's
Human Rights Code.

Refer to the "How to apply" section if you require a disability-related accommodation.

Automate code deployment, configuration, and monitoring processes.
Monitor and proactively optimize the availability and performance of database instances and related jobs.
Maintain data access, uptime, and performance. Respond to and resolve issues.
Implement, maintain, and audit data access, performance, and security.
Create and maintain database backup strategy, and regular testing to ensure usability.
Create and maintain documentation which includes build books, operating and maintenance procedures.
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?:

A minimum of 5 years of Oracle Database Administrator experience.
A minimum of 3 years of traditional Microsoft SQL Database Administrator ((i.e. SQL, SSAS, SSIS, SSRS) experience with 3 years of Azure database and analytics services ((i.e. Azure SQL, Azure Synapse, Azure Data Factory, Azure Data Lake, Power Apps, Power BI) experience; demonstrated experience on Azure DevOps or similar tools.
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.
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.
Disability related accommodation during the recruitment process is available upon request._

Additional Information:

Address:

1 English 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:
Friday, May 10, 2024
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