We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM.
Senior Database Developer
Summary:
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.
Key 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.
Required Qualifications:
- 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.
Preferred / Nice to Have:
- 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
Core Skills & Attributes:
- Strong analytical and problem-solving skills
- Excellent communication and stakeholder management abilities
- Highly organized with the ability to manage competing priorities
- Experience working in fast-paced, deadline-driven environments
- Collaborative mindset with Agile team experience
At RSM, we offer a competitive benefits and compensation package for all our people. We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients. Learn more about our total rewards at https://rsmcanada.com/careers/life-at-rsm/rewards-and-benefits.html.
RSM does not tolerate discrimination and/or harassment based on race; colour; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the Canadian uniformed service; Canadian Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable provincial employment legislation.
Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please call us at 800-274-3978 or send us an email at [email protected].
At RSM, an employee’s pay at any point in their career is intended to reflect their experiences, performance, and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including, but not limited to, education, skills, work experience, certifications, location, etc. As such, pay for the successful candidate(s) could fall anywhere within the stated range.
Compensation Range: $54 - $82 per hour
