Job Application – Senior Database Administrator

Website Save-On-Foods

Job Description:

Reporting to the Manager, Database Administration, you will have broad-ranging responsibilities supporting multiple teams and environments.

Job Responsibilities:

  • Providing all aspects of database support for AZURE based database infrastructure
  • Providing direct level 2 and 3 database support for development, QA, and production environments running on various versions of Oracle (11g, 12c, RAC, Exadata), MS SQL Server (SQL 2005-2019), and MySQL
  • Collaborating with other teams (Architecture, Development, Infrastructure) to develop database systems for new products or enhancements to existing systems
  • Planning and implementing database upgrades, maintenance fixes, and vendor-supplied patches
  • Sharing domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
  • Researching, recommending, and executing improvements to database environments to maximize efficiency, reliability, and performance
  • 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
  • Designing and maintaining database backup and recovery strategies, including long term retention strategy, redundancy plans, and backup encryption
  • Performing database tuning and configuration to ensure optimum performance on all client databases
  • Using native and/or external tools, such as Oracle’s Enterprise Manager and SQL Server DMV, to quickly pinpoint trouble spots and resolve performance issues

Job Requirements:

  • A good understanding of database encryption technologies and best practices
  • Knowledge of Spark, PostgreSQL, Hadoop, DataBricks, Azure, NoSQL, Snowflake, and Distributed systems (asset)
  • Strong understanding of database structures, principles, and best practices
  • Experience managing systems and databases in the cloud (Azure/AWS) (required)
  • Experience with MS-SQL: 2008/2008 R2/2012/2014
  • Experience with Oracle and MSSQL High Availability technology
  • Strong analytical skills for troubleshooting incidents and performing root cause analysis
  • Expert knowledge in Transact SQL and PL/SQL
  • Working knowledge of database table partitioning techniques and processes
  • Rigor in high code quality, database orchestration, and other engineering best practices
  • Experience with Oracle: 11g/12c in an enterprise RAC environment
  • OCP certification in Oracle database (asset)
  • A solid understanding of Operating System, Active Directory, and Network technologies

Job Details:

Company: Save-On-Foods

Job Category: Supermarket

Vacancy Type: Full Time

Job Location: Langley, BC, CA

Application Deadline: N/A

Apply Here