Senior Database Developer
RSM US LLP•Toronto, ON
•CA$54 - CA$82
About The Position
We are seeking an experienced Senior Database Developer for a temporary engagement to lead a critical initiative involving the redesign and modernization of a legacy system for a financial services client. This role will focus on analyzing existing database architecture, translating complex business logic into scalable solutions, and building high-performance, compliant data models. The ideal candidate will play a key role in delivering robust, auditable, and secure data structures aligned with evolving business needs.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- 8–10 years of experience in SQL Server development/DBA, data modeling, and large-scale database environments (financial services preferred).
- Strong expertise in: Data migration, ETL processes, and integration tools (e.g., SSIS)
- Data analysis, data quality, and data modeling
- Writing and optimizing complex stored procedures (SPROCs)
- SQL database testing and automation techniques
- Proven experience developing high-performance, auditable database solutions.
- Experience implementing data controls, security, and regulatory compliance standards.
Nice To Haves
- Experience with reporting and visualization tools (SSRS, Tableau)
- Exposure to cloud data platforms (Snowflake, Databricks)
- Familiarity with Microsoft full-stack technologies (.NET, C#, ASP.NET, Web API)
- Experience working within DevSecOps frameworks
Responsibilities
- Analyze existing database architecture, decipher complex logic, and assess current data models.
- Partner with business stakeholders and product owners to gather and translate requirements into scalable database solutions.
- Design and develop new data models, schemas, and database objects aligned with business needs and performance standards.
- Build and optimize tables, stored procedures (SPROCs), and controls to ensure data integrity, performance, and auditability.
- Implement data governance controls and ensure compliance with regulatory and internal security requirements.
- Support iterative development, refining database structures in response to evolving requirements.
- Provide guidance and mentorship to team members on data modeling best practices.
- Collaborate cross-functionally within an Agile environment using tools such as Jira and Confluence.
Benefits
- Competitive benefits and compensation package
- Flexibility in schedule
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Career Level
Senior
