
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
Jobseve.online