Database Administrator

2 weeks ago

Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

Friday, May 10, 2024

Term: Permanent, Full-Time

Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch

Application Deadline: May 24, 2024

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.

In this role, the successful candidate will:

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

The ideal candidate will have:

  • 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.
  • Extensive experience in developing, deploying, managing, migrating, and supporting real-time mission critical database applications hosted in an Azure and on-premises hybrid cloud.
  • 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 successful candidate must be eligible to work in Canada and will be subject to a criminal background check.

The AGCO is an inclusive and equal opportunity employer.

The AGCO has the responsibility to lead by example in advancing racial equity and to build a diverse, inclusive, accessible and respectful workplace where every employee has a voice and the opportunity to fully contribute. To this effect, you are encouraged to reflect upon the diversity you would bring to the role within your application including, but not limited to, individuals identifying with one or more of the under-represented groups identified within Ontario’s Human Rights Code.

Disability related accommodation during the recruitment process is available upon request.

  • 90 Sheppard Ave E, North York, ON M2N, Canada
#J-18808-Ljbffr

  • Database Administrator

    1 week ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    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 require a multifaceted professional who is...

  • Database Administrator

    1 week ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    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 require a multifaceted professional who is...

  • Database Administrator

    1 week ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    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 require a multifaceted professional who is...

  • Database Administrator

    1 week ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...

  • Database Administrator

    1 week ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...

  • Database Administrator

    7 days ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...

  • Database Administrator

    1 month ago

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

  • Database Administrator – Oracle

    1 month ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...

  • Database Administrator – Oracle

    1 month ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...

  • Database Administrator – Oracle

    1 month ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...

  • Database Administrator

    5 days ago

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

  • Database Administrator

    5 days ago

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

  • Database Administrator

    6 days ago

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

  • Database Administrator

    1 month ago

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

  • Database Administrator

    5 days ago

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

  • Database Administrator

    5 days ago

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

  • Oracle Database Administrator

    3 weeks ago

    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...

  • Oracle Database Administrator

    4 weeks ago

    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...

  • Oracle Database Administrator

    4 weeks ago

    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...

  • Database Administrator

    1 month ago

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