Senior Database Administrator

Pattison Food Group; City of Langley; On-site; CAD 96,000 - 121,000; Full time

Benefits offered by this job

Competitive salary

Pension plan

Free parking

Employee discounts

Career development

Job summary

Pattison Food Group Ltd., a Jim Pattison business, is seeking a Senior Database Administrator to join our Langley, BC IT team. You will maintain and optimize enterprise databases, ensuring reliability and performance across Oracle, MS SQL Server, PostgreSQL and MySQL environments.

This role requires 10+ years IT experience, including 5+ years as a DBA for mission‑critical production systems, plus strong Azure/AWS cloud skills, Oracle 19c RAC, and PL/SQL/T‑SQL expertise.

Qualifications

• 10+ years IT experience with minimum 5 years in a DBA role on mission-critical production environments.
• Proven enterprise database management experience in Azure and/or AWS.
• Experience with Oracle 19c+ in RAC environments.
• Experience with MS-SQL 2008/2012/2014/2019/2022.
• Strong troubleshooting and root cause analysis skills.
• Solid knowledge of encryption technologies and best practices.

Responsibilities

• Provide level 2/3 database support for development, QA, and production environments.
• Plan and implement database upgrades, maintenance fixes, and patches.
• Design and maintain backup and recovery strategies with long-term retention.
• Research and implement improvements to maximize efficiency, reliability, and performance.
• Collaborate with Architecture/Development/Infrastructure on new products and enhancements.
• Mentor peers and share domain expertise; provide on-call support when required.

Skills

Oracle RAC

Oracle 19c+

MS SQL Server

Azure

AWS

PL/SQL

T-SQL

Performance tuning

Disaster recovery

Backup & recovery

ETL scripting

Mentoring

Education

Bachelor’s degree in Computer Science/Applied Mathematics/Engineering

Tools

Oracle Enterprise Manager

SQL Server DMVs

Azure

AWS

Exadata

Job description

About Pattison Food Group

Come join Pattison Food Group Ltd., a Jim Pattison business, and Canada's largest Western-based provider of food and health products. Pattison Food Group Ltd. is a certified Great Place to Work® and consists of Save-On-Foods and other well-known grocery banners. With nearly 300 retail locations, we proudly employ nearly 30,000 team members.

We have an exciting opportunity for a full-time Senior Database Administrator to join our IT team in Langley, BC. Reporting to the Manager, Database Admin, you will be responsible for maintaining and enhancing the organization's enterprise database environment, ensuring the reliability and performance of systems that support critical business functions. In this role, you will serve as a subject matter expert within a complex enterprise environment, leveraging your expertise in Oracle database administration, performance tuning, high availability, and disaster recovery to support mission-critical business systems and drive continuous improvement across the database landscape.

Responsibilities

• Providing direct level 2 and 3 database support for development, QA, and production environments running on various versions of Oracle (19c or above, RAC, Exadata), MS SQL Server (SQL 2005-2023), PostgreSQL and MySQL.
• Providing all aspects of database support for Azure based database infrastructure.
• Researching, recommending, and executing improvements to database environments to maximize efficiency, reliability, and performance.
• Performing database tuning and configuration to ensure optimum performance across all client databases.
• Planning and implementing database upgrades, maintenance fixes, and vendor-supplied patches.
• Using native and/or external tools, such as Oracle’s Enterprise Manager and SQL Server DMVs, to quickly pinpoint trouble spots and resolve performance issues.
• Designing and maintaining database backup and recovery strategies, including long term retention strategies, redundancy plans, and backup encryption.
• Collaborating with internal teams (Architecture, Development and Infrastructure) to develop database systems for new products or enhancements to existing systems.
• Sharing domain and technical expertise, providing technical mentorship and training to peers and team members.
• Providing expert level ETL and scripting to existing and new processes.
• Developing and maintaining server and database documentation.
• Providing on-call support outside of working hours for business-critical systems as required.

Qualifications

• A bachelor’s degree in Computer Science, Applied Mathematics, Engineering, or equivalent work experience.
• 10+ years of progressive IT experience, including a minimum of 5 years in a Database Administrator role supporting mission-critical production environments, high availability, disaster recovery, performance tuning, and database lifecycle management.
• Proven experience managing Enterprise database platforms and infrastructure within Azure and/or AWS cloud environments.
• Experience with Oracle: 19c and above in an enterprise RAC environment.
• Experience with MS-SQL: 2008/2008 R2/2012/2014/2019/2022.
• Experience with Oracle and MS SQL server high availability technology.
• Expert knowledge in Transact SQL and PL/SQL.
• Strong understanding of database structures, principles, and best practices.
• Strong analytical skills for troubleshooting incidents and performing root cause analysis.
• Working knowledge of database table partitioning techniques and processes.
• A good understanding of database encryption technologies and best practices.
• A solid understanding of operating system, Active Directory, and Network technologies.
• Knowledge of Spark, PostgreSQL, Hadoop, Databricks, Azure, NoSQL, Snowflake, and Distributed systems are considered assets.
• Oracle Certified Professional (OCP) certification is considered an asset.

You are:

• A strong communicator and effective cross-functional partner.
• Detail-oriented and committed to delivering reliable, secure, and high-performing solutions.
• An analytical problem solver with strong troubleshooting skills.
• Highly organized and able to effectively manage multiple priorities in a fast-paced environment.

What we offer

• In addition to a highly competitive salary, we offer a great range of benefits, a company pension plan, free parking, exclusive team member offers, and opportunities for development and career progression.

If you're looking to join a team that puts people first, you're in the right place.

IND6 Compensation Details: $96,443.00 - $120,554.00 The compensation offered for this position will take into consideration location, education, skills, experience and other factors.

Pattison Food Group is a Jim Pattison business and Canada's largest Western-based provider of food and health products. Headquartered in British Columbia, Canada, we have been in business since 1915. We proudly employ nearly 30,000 team members who are committed to achieving long-term growth and share a passion for giving back to the communities where we do business. Together, we leverage each other's collective strengths to enhance efficiencies across our respective organizations. Our largest and signature company is Save-On-Foods. With 11 retail banners operating nearly 300 food and drug retail locations that are uniquely positioned to cater to the needs of their communities across Western Canada and the Yukon Territory, four wholesale businesses catering to the diverse needs of their customer bases across Canada, several food and pharmacy production facilities focused on high-quality distinct offerings, an industry-leading loyalty program, a world-class set of proprietary consumer brands, and an award-winning restaurant, Pattison Food Group businesses are proud to be recognized as leaders in customer service and innovation.