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

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

Company: Save-On-Foods

Job Category: Supermarket

Vacancy Type: Full Time

Job Location: Langley, BC, CA

Application Deadline: N/A

Jobseve.online

Report Job