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 [email protected] or 778-391-5836. 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.
