Database Engineer

Location(s):Help Headquarters Toronto

Job Type:Full TimeRegular

myWork Program: Hybrid

Starting Salary Range:$96800.00-$125900.00

Background Screening Requirement:

• EnhancedCriminal Record Check (every 5 years)
• Social Media Check (every 5 years)
• Credential Verification (every 5 years)
• Softcheck (every 5 years)
• Credit Check (every 5 years)
• Identity Verification (every 5 years)
• Employment Verification
• References
• Education Verification

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 its readily available for the organizations use.

This role is hybrid remote based out of our Toronto office (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

Dont meet every single requirement At Coast Capital we believe everyone has potential. We are committed tobuilding better brighter more inclusive futuresfor everyone including our employees. We see the potential in our employees to achieve amazing things and want to invest in your future. If youre 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 or . 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.