Database Engineer

Coast Capital Savings•Toronto, ON

1d•CA$96,800 - CA$125,900•Hybrid

About The Position

A Database Engineer at Coast Capital Savings is the backbone of our data infrastructure, skillfully tailoring database systems to fit our broad range of needs. Tackling the intricacies of integrating distinct systems like Salesforce and various banking platforms and crafting crucial links and streamline processes to support informed decision-making. Through diligent troubleshooting and proactive development of data pipelines, the incumbent will be fundamental in enhancing data quality and ensuring it's readily available for the organization's use. This role is hybrid remote based out of our Toronto office (3610, 181 Bay Street, Toronto, Ontario) or Surrey office (9900 King George Blvd, Surrey, British Columbia). Currently the team meets in office 1 times per month at most based on business needs. This position will require rotating on-call schedule, including off-hours support, to ensure 24/7 production coverage.

Requirements

Minimum of 5 years of Job-related experience
Completion of a Degree or Diploma Program (min. two years of formal education or equivalent), preferably in Computer Science or related field.
Strong experience with Oracle (19c required, 23c nice-to-have) and solid experience with SQL Server as a secondary platform.
Proven experience with cloud platforms, preferably AWS; however, candidates with Azure or GCP experience may also be considered.
Expertise in database design, data modeling, and SQL scripting.
Deep knowledge of Oracle HA/DR, including Data Guard and GoldenGate.
Experience designing, implementing, and testing disaster recovery strategies.
Advanced database monitoring, troubleshooting, and performance tuning.
Strong SQL query optimization and stored procedure tuning.
Expertise in indexing (maintenance, statistics, usage analysis).
Experience building data pipelines and ETL processes.
Exposure to SSIS, SSRS, and SSAS as secondary tools.
Proficiency in automation and scripting using PowerShell, Python, and SQL.
Exposure to MySQL, PostgreSQL, and MongoDB.
Strong troubleshooting, risk assessment, and experience with change management processes.

Nice To Haves

23c Oracle experience

Responsibilities

Lead the analysis and design of existing or proposed systems to build and construct access to databases, ensuring privacy, normalization, and governance that support high availability, disaster recovery, and performance optimization.
Design, implement, and maintain robust data management systems to ensure data accuracy, consistency, reliability, and security.
Develop and manage ETL processes to extract data from source systems, transform it according to business rules from self-gathered system requirements, and load it into appropriate database tables.
Develop and implement data quality standards and procedures.
Develop and execute roadmaps for version upgrades, patches, and releases to ensure Coast stays current with database technologies as part of the application lifecycle management.
Conduct technical assessments of new technology proposals, defining scope and success criteria, and assessing end-to-end impacts.