Database Administrator

4 weeks ago

Toronto ON, Canada Alcohol and Gaming Commission of Ontario Full time €92,902 - €116,123

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

    4 weeks ago

    Toronto, ON, 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

    4 weeks ago

    Toronto, ON, 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

    3 weeks ago

    Toronto, ON, 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 &...

  • Database Administrator

    3 weeks ago

    Toronto, ON, 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 &...

  • Development Database Administrator

    3 weeks ago

    Toronto, ON, Canada The Mabin School Full time

    Database Administrator / IT Helpdesk Duration : 20 hrs / week over 3-4 days / week About The Mabin School:  The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada’s first independent Ashoka Changemaker School, and are recognized for instilling the...

  • Database Administrator

    4 weeks ago

    Toronto, ON, Canada The Mabin School Full time

    Database Administrator / IT HelpdeskDuration: 20 hrs / week over 3-4 days / weekLocation: Toronto, ONPlease note this is a hybrid role. About The Mabin School: The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada’s first independent Ashoka Changemaker...

  • Database Administrator

    4 weeks ago

    Toronto, ON, Canada The Mabin School Full time

    Database Administrator / IT HelpdeskDuration: 20 hrs / week over 3-4 days / weekLocation: Toronto, ONPlease note this is a hybrid role. About The Mabin School: The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada’s first independent Ashoka Changemaker...

  • Database Administrator

    2 weeks ago

    Toronto, ON, Canada The Mabin School Full time

    Database Administrator / IT HelpdeskDuration: 20 hrs / week over 3-4 days / weekLocation: Toronto, ONPlease note this is a hybrid role. About The Mabin School: The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada’s first independent Ashoka Changemaker...

  • Database Administrator

    2 weeks ago

    Toronto, ON, Canada The Mabin School Full time

    Database Administrator / IT HelpdeskDuration: 20 hrs / week over 3-4 days / weekLocation: Toronto, ONPlease note this is a hybrid role. About The Mabin School: The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada’s first independent Ashoka Changemaker...

  • Database Administrator

    2 months 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

    1 week ago

    Toronto, Canada Red Label Vacations Full time

    **Reports to**:Director, IT **Department**:IT **Location**:Hybrid**: - **Head Office, Toronto, ON/ Canada & work from home **Summary**: As DBA you'll be the first respondent to database problems that arise and carry out periodic maintenance and troubleshooting. To ensure success as a database administrator, you should be an excellent problem-solver and...

  • Database Administrator

    3 days ago

    Toronto, Canada Rang Healthcare Full time

    Job Title: Database Administrator Duration: 04 Month Contract Location: 125 Sir William Hearst, Toronto, ON M3M 0B5 (Position is 3 days onsite in a week) Must haves: Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database Experience with database development, e.g., stored procedure, PL/SQL,...

  • Database Administrator

    3 weeks ago

    Toronto, ON, Canada The Mabin School Full time

    Database Administrator / IT Helpdesk Duration : 20 hrs / week over 3-4 days / week Location : Toronto, ON Please note this is a hybrid role. About The Mabin School:  The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada’s first independent Ashoka...

  • Oracle Database Administrator

    3 weeks ago

    Toronto, ON, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for a seasoned Oracle DBA - this is a hybrid contract assignment based in Toronto:Typical Day in Role: • Review Vendor/Developer Specs and DB architecture • Discussions to agree and finalize deployment specifics • Data Sizing - estimate storage, retention, backups, RAID level, LUN requirements etc. • Prepare database...

  • Database Administrator

    3 weeks 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

    3 weeks 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

    4 weeks 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

    2 months 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

    6 days ago

    Toronto, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade: - Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; - Prepare and implement database changes according to design; - Promote database changes through Development,...

  • SQL Database Administrator

    2 weeks ago

    Toronto, ON, Canada Net2Source Inc. Full time

    Job Title: SQL Administrator Location; Toronto, ON Duration: 12 months Database Skills: Experience with one or more database technologiesProficiency with SQL and experience writing SQL scriptsExperience designing data architecture for new databasesExperience in monitoring and enforcing database rulesExperience cleaning, transforming and joining...