Senior Database Architect / Developer (MSSQL)

Join to apply for the Senior Database Architect / Developer (MSSQL) role at CI Financial

Join to apply for the Senior Database Architect / Developer (MSSQL) role at CI Financial

At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to grow through stretching themselves, where they can work on innovative products and projects, and where employees are supported and engaged in doing so.

Job Overview

We distinguish ourselves in the Canadian clearing broker industry by owning our entire technology stack in-house. Our Toronto-based team is a close-knit, collaborative group with a clear vision and goal. We are seeking a skilled and detail-oriented Senior Database Architect / Developer (MSSQL)to join our team. The ideal candidate will be responsible for managing and optimizing our Microsoft SQL Server databases and leveraging SQL Server Integration Services (SSIS) for efficient data integration and transformation. This role involves collaborating with DBAs and enforcing best practices for database management.

Key Responsibilities

• Data Purging : Remove old or irrelevant data to maintain database efficiency.
• Index Optimization : Create or modify indexes to improve query performance.
• Stored Procedure Optimization : Optimize stored procedures to enhance performance and efficiency.
• Code Reviews : Conduct thorough reviews of stored procedures to ensure quality and performance.
• Standards Implementation : Implement standards, deployments, and changes to the data model.
• Consultation : Act as a consultant for changes to the data model, providing expert advice and guidance.
• Normalization : Structure the database to reduce redundancy and improve data integrity.
• Archiving : Move infrequently accessed data to separate storage to optimize database performance.
• SSIS Integration : Utilize SSIS for data integration, transformation, and workflow automation.

What You Will Bring

Communication Skills :

Technical Skills :

Preferred Experience :

Why Join Us?

We are focused on building a diverse and inclusive workforce. If you are excited about this role and are not confident you meet all the qualification requirements, we encourage you to apply to investigate the opportunity further.

Please submit your resume in confidence by clicking “Apply”. Only qualified candidates selected for an interview will be contacted. CI Financial Corp. and all of our affiliates (“CI”) are committed to fair and accessible employment practices and provide reasonable accommodations for persons with disabilities. If you require accommodations in order to apply for any job opportunities, require this posting in an additional format, or require accommodation at any stage of the recruitment process please contact us at accessible.recruitment@ci.com, or call 416-364-1145 ext. 4747.

Seniority level

Seniority level

Not Applicable

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Referrals increase your chances of interviewing at CI Financial by 2x

Sign in to set job alerts for “Database Architect” roles.

Senior DBA / Database Architect (Toronto)

Data Architect – Data Ingestion, ETL, Cloud

Richmond Hill, Ontario, Canada 1 week ago

Senior Manager, Microsoft - Data Architect

Senior Manager, Microsoft - Data Architect

Enterprise Data Architect (1 year contract)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr