Database Administrator

Location Address:

Number of Openings:

Pay:

Job Posting Description:

Database Administrator

This position is onsite #LI-Onsite

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

Required Skills

• 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 a comprehensive suite of benefits including:

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

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.

Please submit your resume via Workday by 11:59pm on the deadline date.  We appreciate your interest and advise that only those selected for an interview will be contacted.

Your personal information is being collected under the authority of the Liquor Control Board of Ontario Act, 2019, SO 2019, c 15, Sch 21, Section 3 and in compliance with the Freedom of Information and Protection of Privacy Act for the purpose of processing your job application. When you select “Easy Apply”, your personal information will be collected through LinkedIn and shared with the LCBO in accordance with the LinkedIn User Agreement.

If you wish to apply without sharing your personal information with LinkedIn, please visit the LCBO Careers website. If you have any questions regarding the LCBO’s collection and use of personal information, please refer to the LCBO Customer Privacy Notice, or contact the Freedom of Information and Privacy Office at:

Freedom of Information and Privacy Office

100 Queens Quay East, 9th Floor

Toronto, Ontario M5E 0C7

Telephone: 416 864-2462

E-mail: [email protected]    

Work Hours:

Union / Non-Union:

Job Posting End Date:

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