MS SQL Server Developer - Data Modeling & Performance Tuning
A
Astra North Infoteck Inc.
📍 Toronto, ON, Canada
Job Description
MS SQL Server Developer - Data Modeling & Performance Tuning Location: Toronto, ON Experience: 8-10 Years Role Overview We are seeking a MS SQL Server Developer with deep hands-on expertise in advanced SQL programming, data modeling, and performance optimization. The ideal candidate will have experience managing large-scale data volumes, developing complex stored procedures/functions, and tuning SQL queries for high-performance database environments. Key Responsibilities 1. Database Design & Data Modeling Design and maintain conceptual, logical, and physical data models for enterprise systems. Create normalized and denormalized schemas, ensuring scalability, data integrity, and performance. Collaborate with architects and application teams to support data architecture decisions. 2. SQL Programming & Development Develop, enhance, and maintain stored procedures, functions, triggers, views, packages, and complex SQL scripts. Implement business logic in the database layer with efficient, r...