Database Administrator

LCBO (Liquor Control Board of Ontario); Toronto; On-site; CAD 75,000 - 130,000; Full time

Benefits offered by this job

Health/Dental Benefits

Employee & Family Assistance Program

Defined Benefit Pension

Discounts on products and services via

Workperks

Job summary

LCBO is seeking an experienced Database Administrator to join a collaborative team responsible for enterprise database platforms across Oracle, SQL Server, PostgreSQL, MySQL, Db2, and more. You will ensure security, performance, and high availability across production and non-production environments.

Reporting to the Senior Manager, Infrastructure, you will implement patches, tune queries, manage backups, and contribute to modernization and cloud initiatives while supporting 24x7 on-call

Qualifications

• Bachelor's degree in Computer Science, IT, Engineering, or equivalent experience.
• Minimum 5 years in a DBA/DBE role.
• Hands-on with Oracle, SQL Server, PostgreSQL, MySQL, Db2.
• Experience across Linux/UNIX/Windows.
• Strong backup, recovery, high availability knowledge.
• Security, access management, encryption, auditing.
• Incident, change, problem, and release management experience.
• Willingness to participate in 24x7 on-call rotation.

Responsibilities

• Administer and support production and non-production database environments across multiple technologies.
• Perform routine maintenance, patching, upgrades, and lifecycle activities.
• Monitor availability, capacity, performance, and health; identify risks.
• Tune performance, indexing, storage, and configuration improvements.
• Manage backup, restore, replication, recovery, and high-availability processes.
• Support incident, problem, change, and release management per LCBO standards.
• Collaborate with teams to provide reliable database support for critical systems.
• Provide input for new database implementations and cloud services.
• Maintain standards, runbooks, and diagrams; ensure security compliance.
• Participate in on-call rotation for production incidents.

Skills

Database administration

Monitoring

Security

Incident management

Performance tuning

Education

Bachelor's degree in Computer Science, IT, Engineering

Tools

Oracle

SQL Server

PostgreSQL

MySQL

Db2

Job description

Location

100 Queens Quay East, 9th Floor, Toronto

Job Details

Number of Openings: 1

Pay: $74,671.00 - $130,424

Job Posting Description: Database Administrator This position is onsite #LI-Onsite

Job Description

Are you an experienced Database Administrator looking to join a collaborative and supportive team that strives for operational excellence? Reporting to the Senior Manager, Infrastructure, you will be responsible for the administration, maintenance, security, performance, and support of LCBO’s enterprise database platforms across production and non-production environments. In this role, you will support a broad and business-critical database landscape, including Oracle, SQL Server, PostgreSQL, MySQL, Db2, and other relational and non-relational technologies. You will help ensure database environments are stable, secure, recoverable, patched, and optimized to support critical business systems and transformation initiatives. If you are a hands-on database professional who enjoys solving complex technical problems, supporting high-availability environments, and contributing to modernization and operational excellence, this is the role for you.

About the Role

• Administer and support production and non-production database environments across multiple technologies, including Oracle, SQL Server, PostgreSQL, MySQL, Db2, and other relational and non-relational platforms.
• Perform routine database maintenance, patching, upgrades, feature packs, and lifecycle activities to keep database platforms current, secure, and supportable.
• Monitor database availability, capacity, performance, and overall health; proactively identify risks and implement corrective actions.
• Tune database performance, including query optimization, indexing strategies, storage usage, and configuration improvements.
• Manage database backup, restore, replication, recovery, and high-availability processes to meet business continuity, disaster recovery, RPO, and RTO requirements.
• Support incident, problem, change, and release management processes in accordance with LCBO operational standards.
• Collaborate with application, infrastructure, security, cloud, vendor, and project teams to provide reliable database support for business-critical systems.
• Provide technical input and recommendations for new database implementations, migrations, upgrades, modernization initiatives, and cloud-based database services.
• Implement and maintain database standards, operational procedures, technical documentation, runbooks, and logical and physical database diagrams.
• Support database security, access management, privileged access controls, audit requirements, vulnerability remediation, and compliance with LCBO security practices.
• Assist with license management and ensure database platform usage aligns with licensing and support requirements.
• Develop or maintain automation scripts and repeatable processes to reduce manual effort, improve consistency, and increase operational efficiency.
• Participate in rotational 24x7 on-call support for critical database platforms and production incidents.

About You

• Bachelors' degree in Computer Science, Information Technology, Engineering, or an equivalent combination of education and business experience.
• Minimum 5 years of experience in a Database Administrator, Database Engineer, or related technical role.
• Hands-on experience administering enterprise database platforms such as Oracle, SQL Server, PostgreSQL, MySQL, or Db2, including troubleshooting, query analysis, and performance tuning.
• Knowledge of relational database concepts, database architecture, backup and recovery, high availability, replication, and disaster recovery practices.
• Experience supporting databases across multiple operating systems, including Linux, UNIX, AIX, and Windows.
• Experience with database patching, upgrades, monitoring, lifecycle planning, capacity management, and operational support.
• Experience with database security, access management, privileged accounts, encryption, audit requirements, and compliance practices.
• Excellent service management skills, including incident, change, problem, and release management.
• Maintain standard operating procedures, technical diagrams, support guides and operational runbooks.
• Willingness to participate in rotational 24x7 on-call support (one week per month).

Preferred Skills

• Experience with NoSQL or in-memory database technologies such as MongoDB, Redis, Cassandra, or equivalent platforms.
• Experience deploying, configuring, or supporting databases in public, private, or hybrid cloud environments.
• Exposure to cloud database services such as Azure SQL, Amazon Web Services RDS, Google Cloud SQL, or similar managed database platforms.
• Experience with automation or scripting tools such as PowerShell, Python, Bash, Ansible, Terraform, or Jenkins.
• Experience supporting database modernization, migration, consolidation, or platform transformation projects.
• Experience with enterprise monitoring, observability, backup, recovery, and disaster recovery tools.
• Knowledge of software development lifecycle, quality assurance, release management, and deployment practices.
• Experience working in environments with security and compliance standards such as PCI, NIST, CIS, SOX, or similar frameworks.
• Experience with Db2, Teradata, Oracle Enterprise Manager, SQL Server Always On, Oracle Data Guard, or similar enterprise database capabilities.
• Experience supporting large retail, supply chain, financial, warehouse, or other mission-critical business systems.

We Offer

• Health/Dental Benefits
• Employee & Family Assistance Program
• Defined Benefit Pension
• Discounts on products and services via Workperks

Company Culture

There is a world of opportunities at the LCBO… Join an organization where you can be challenged while achieving your true potential. A place where you can make a positive impact supporting Ontario business and communities. Discover a safe, healthy, diverse, inclusive, and accountable workplace where your wellbeing is our top priority.

At the LCBO, your contributions are respected and valued. Be part of our journey as we invest in people and technology to transform an organization. There really is a world of opportunities at the LCBO. We foster a culture of inclusion and belonging, so everyone feels valued, respected, and heard.

The LCBO is an equal opportunity employer and committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility of Ontarians with Disabilities Act.

If contacted for an interview or employment opportunity, please advise if you require an accommodation.

Contact Information

Freedom of Information and Privacy Office 100 Queens Quay East, 9th Floor Toronto, Ontario M5E 0C7 Telephone: [phone] E-mail: [e-mail]

Work Hours

36.25

Job Posting End Date

October 20, 2026

Additional Company Information

The LCBO (Liquor Control Board of Ontario) is an Ontario government enterprise and one of the world’s largest buyers and retailers of beverage alcohol. Through more than 650 retail stores, catalogues, special order services and more than 389 LCBO Convenience Outlets (LCOs), which provide cost effective, convenient and socially responsible access for rural consumers, the LCBO offers nearly 24,000 products annually to consumers and licensed establishments from more than 80 countries.

For job searches in a specific location, please use the search field on the careers site.