Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Target Resume Now
About the Role
A Database Engineer at Coast Capital Savings is responsible for tailoring database systems, integrating systems like Salesforce and banking platforms, and crafting links to support decision-making. This role involves troubleshooting and developing data pipelines to enhance data quality and availability.
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.
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.
- Enhanced Criminal 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
Skills
- Oracle 19c
- SQL Server
- AWS
- Azure
- GCP
- Database design
- Data modeling
- SQL scripting
- Oracle HA/DR
- Data Guard
- GoldenGate
- Disaster recovery strategies
- Database monitoring
- Troubleshooting
- Performance tuning
- SQL query optimization
- Stored procedure tuning
- Indexing
- Data pipelines
- ETL processes
- SSIS
- SSRS
- SSAS
- PowerShell
- Python
- SQL
- MySQL
- PostgreSQL
- MongoDB
- Risk assessment
- Change management processes
Location
- Help Headquarters
- Toronto, Ontario
- Surrey, British Columbia
Work Type
- Full Time Regular
- Hybrid Remote
Experience Level
- Minimum of 5 years of Job-related experience
Education Level
- Degree or Diploma Program (min. two years of formal education or equivalent), preferably in Computer Science or related field.
Salary/Compensations
- $96,800.00 - $125,900.00
About the Company
- Coast Capital Savings is 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.
- We are committed to equity, diversity and inclusion.
- 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.
Equal Opportunity
- We strongly encourage applications from Indigenous Peoples, Black, and racialized persons, persons with disabilities, people of diverse sexual and gender identities and women.
- 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.
- If you are a candidate with a disability and require accommodation(s) during any stage of the recruitment process, please contact us at accessibility@coastcapitalsavings.com or 778-391-5836.