Database Administrator

2 weeks ago


Toronto, Canada AGCO Full time

**Term**: Permanent, Full-Time
**Division/Branch**: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch

**Application Deadline**: May 24, 2024

**Level**: Level 10
**Salary Range**: Min: $92,902 to Max: $116,123
**Work Location**: Head Office, Toronto, ON; Hybrid

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 Digital Platforms and Cybersecurity 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.
- 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 knowledge-sharing across multi-functional teams.
- Provide 3rd level support, liaise with vendors and other IT personnel for problem resolution.
- Participate in on-call, maintenance work, and incident response outside of normal business hours on an as needed basis.
- 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 self-starter with the ability to effectively prioritize and execute tasks in a team-oriented 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.



  • Toronto, Canada iPartner Staffing Full time

    3 days per week in the office Expert Oracle and Microsoft SQL Database administration experience Demonstrated experience with DACPAC Experience with Azure build automation using Ansible, Terraform, Packer and VSTS Description The Services and Deliverables to be provided by the Vendor will include the following: - Participate in the review of...


  • Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...


  • Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...


  • Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...


  • Toronto, Canada Institutional Shareholder Services Full time

    Let's be Brilliant Together! - Advance your career with the leading provider of corporate governance and responsible investment solutions. Institutional Shareholder Services (ISS) empowers investors and companies to build sustainable financial and social value by providing high quality data, analytics, and insight. Our clients rely on ISS’ expertise and...


  • Toronto, Canada Systematix Full time

    We are Systematix and we are looking for 4 experienced Sybase Database Administrators for our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension. The work can be done 100% remotely. Position Details: Title: Sybase...


  • Toronto, Canada Systematix Full time

    We are Systematix and we are looking for 4 experienced Sybase Database Administrators for our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension. The work can be done 100% remotely. Position Details: Title: Sybase...


  • Toronto, Canada Information Services Corporation Full time

    Company Name: Information Services Corporation Location: Toronto, Ontario Requisition ID: JR0000349 Status: Full-time Permanent Job Close Date: November 30, 2023 We are ESC, an experienced provider that delivers solutions uniting public records data, customer authentication, corporate services, collateral management, asset recovery, and accounts...


  • Toronto, Canada Systematix Full time

    We are Systematix and we are looking for4 experienced Sybase Database Administratorsfor our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension.The work can be done 100% remotely.Position Details: Title:Sybase...


  • Toronto, Canada Canadian Institute for Health Information Full time

    **Category** - Data Governance **City** - Toronto, Ottawa, Ontario, Canada - Database Administrator - Who we are - We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we...


  • Toronto, Ontario, Canada Ombudsman Ontario Full time

    Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency under the Ministry of the Attorney General, responsible for overseeing alcohol, gaming, horseracing, and cannabis retail in Ontario, guided by honesty, integrity, and public interest.Position: Database AdministratorReporting to: Senior Manager of IT Infrastructure and OperationsLocation:...


  • Toronto, Canada CareRx Full time

    Job Details Description CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We...


  • Toronto, Canada Drake International Full time

    Title: Database AdministratorLocation: Toronto, ON, Canada (Hybrid)Type: Long Term ContractIntroduction:Join a rock-solid organization as our client’s next Database Administrator and sit at the center of projects that drives decisions. You’ll help one of Canada's most trusted government organizations work on the latest project, and be rewarded with...


  • Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience wit


  • Toronto, Canada Interac Corp. Full time

    Database Administrator At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like...


  • Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ HybridCandidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...


  • Toronto, Canada Ombudsman Ontario Full time

    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...


  • Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions...


  • Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...


  • Toronto, Canada TekStaff IT Solutions Full time

    This is a 6 month contract located in Toronto, ON/ Hybrid Candidate Requirements/Must-Have skills: 1) 10+ years of working experience as a Database Administrator 2) 5-7+ years of hands-on experience with Oracle Installation - Database upgrades/migrations 3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c &...