Database Engineer

Location(s): Help Headquarters, Toronto
Job Type: Full Time Regular
myWork Program: Hybrid
Starting Salary Range: $96,800.00 - $125,900.00
Background Screening Requirement:

• Enhanced Criminal Record Check (every 5 years)
• Credit Check (every 5 years)
• Identity Verification (every 5 years)
• Employment Verification
• References

Job Purpose

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.

Accountabilities

• 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.

Skills & Qualifications

• 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.

Equity, Diversity & Inclusion at Coast Capital

Don't meet every single requirement? At Coast Capital, we believe everyone has potential. We are committed to building better, brighter, more inclusive futures for everyone - including our employees. We see the potential in our employees to achieve amazing things and want to invest in your future. If you're excited about this career opportunity and your experience may not perfectly align with every qualification in this job posting, we still encourage you to apply. You may be just the right candidate for this or other opportunities at Coast Capital.

At Coast Capital, we are committed to equity, diversity and inclusion. We strongly encourage applications from Indigenous Peoples, Black, and racialized persons, persons with disabilities, people of diverse sexual and gender identities and women. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences and expertise benefit of our employees, our members, and our community.

Coast Capital is committed to providing an accessible recruitment experience. If you are a candidate with a disability and require accommodation(s) during any stage of the recruitment process, please contact us at View email address on onjobcentre.ca or View phone number on onjobcentre.ca. This contact is intended solely for inquiries or feedback related to accessibility barriers, accommodation requests or alternate format requests. We will work with you to ensure your needs are met. You will only receive a response to inquiries related to these topics.

Why join Coast Capital Savings?

• Purpose is our North Star. We look at everything through our purpose. It informs the advice we provide our members, the experiences and products we create, and the programs we build to support our employees and communities.
• Committed to inclusion and engagement. We have an ongoing focus on equity, diversity, and inclusion and routinely track how we're doing, and what we need to do to keep improving. We foster a culture where everyone can feel safe to be who they really are and thrive.
• A career that grows with you. We believe in developing our people and promoting from within. Many employees have spent decades, and sometimes their entire careers, with Coast Capital and have progressed from the frontlines to senior leadership.
• Work where you're most effective. In 2020 the world changed, and that includes how we work. In response to COVID-19 we launched myWork, which gives employees flexibility in where they work based on the nature of their role.
• Benefits that flex to the needs of you and your family. We offer comprehensive, customizable benefits for you and your family, so you can choose what fits best for you and your lifestyle.
• Retirement options. We also take care of our employees once they retire. That's why we offer the choice of a defined contribution or defined benefit pension plan or RSP's.
• Mortgage and auto financing benefits . Employees save thousands on their mortgages and auto loans with best-in-