Database Administrator

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. consists of Save-On-Foods and other well-known grocery banners. With nearly 300 retail locations, we proudly employ more than 30,000 team members. We have an exciting opportunity for a full-time Database Administrator to join our IT team in Langley, BC. Reporting to the Manager, Database Admin, you will be responsible for the end-to-end administration of all on-premises and cloud-based databases, including their implementation, configuration, performance tuning, monitoring, troubleshooting, and ongoing maintenance to ensure high availability, security, and optimal performance. You will be responsible for: Providing direct level 2 and 3 database support for development, QA, and production environments running on various versions of Oracle (19c, 23ai, RAC, Exadata), MS SQL Server (SQL 2008-2022), and MySQL. Providing all aspects of database support for Azure-based and in-house 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 on 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 Management Studio, to quickly pinpoint trouble spots and resolve performance issues. Designing and maintaining database backup and recovery strategies, including long-term retention strategy, redundancy plans, and backup encryption. Collaborating with other teams (Architecture, Development, Infrastructure) to develop database systems for new products or enhancements to existing systems. Sharing domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. Providing expert level ETL and scripting to existing and new processes. Developing and maintaining server and database documentation. You have: A Bachelor’s degree in Computer Science or equivalent work experience. 3+ years of IT work experience using database technologies. Experience and knowledge of Oracle in an enterprise environment, Microsoft SQL Server, Transact-SQL and PL/SQL, as well as both Linux and Windows operating systems. An understanding of database structures, principles, and best practices. Analytical skills for troubleshooting incidents and performing root cause analysis. Working knowledge of database table partitioning techniques and processes. An understanding of database encryption technologies and best practices. Solid understanding of operating system, Active Directory, and Network technologies. Rigor in maintaining high code quality, database orchestration, and other engineering best practices. Knowledge of Spark, PostgreSQL, Hadoop, DataBricks, Azure, NoSQL, Snowflake, and Distributed systems is an asset Oracle Certified Professional (OCP) certification in Oracle database an asset. You are: A strong written and verbal communicator. Analytical with strong problem-solving skills. Resilient and able to remain calm under pressure. Organized with strong time management skills. 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. Apply online today! IND6 Compensation Details: $83,394.00 - $104,243.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.