Senior MS SQL Developer-Data Modelling, MySQL

JOB TITTLE-Senior MS SQL Developer

LOCATION-TORONTO-HYBRID

CONTARCT -LONG TERM CONTRACT

JOB DESCRIBTION-

Experience: 8+YEARS

Primary Skills: Data Concepts & Data Modelling E2||MySQL E4

Role Descriptions: Senior MS SQL Developer with strong handson expertise in advanced SQL programming| data modeling| and performance optimization. The ideal candidate should have extensive experience working with large data volumes| developing complex stored proceduresfunctions| and tuning SQL queries for highperformance database environments.Key ResponsibilitiesDatabase Design Data ModelingDesign 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.SQL Programming DevelopmentDevelop| enhance| and maintain stored procedures| functions| triggers| views| packages| and complex SQL scripts.Implement business logic in the database layer with efficient| reusable| and well-structured SQL code.Assist in code reviews and SQL development best practices.Large Data Volume ProcessingBuild and optimize ETLELT logic to handle large-scale datasets efficiently.Write and tune queries to support highvolume transactional and analytical systems.Ensure data accuracy| quality| and consistency across processes.Advanced Querying OptimizationWrite highly optimized| complex SQL queries for reporting| analytics| and application workloads.Analyze execution plans and tune longrunning queries using indexing strategies| statistics updates| and schema refinements.Identify performance bottlenecks and implement proactive database optimizations.Performance Tuning MaintenanceMonitor and optimize database performance| including indexing| partitioning| query tuning| and resource utilization.Identify and resolve locking| blocking| deadlocks| and longrunning processes.Recommend improvements to database design| configurations| and operational processes.Required SkillsAdvanced proficiency in MS SQL Server development.Strong experience with data modeling (ER design| schema design).Expertise in stored procedures| functions| triggers| and complex SQL programming.Experience handling large data volumes in enterprise environments.Strong command of advanced SQL queries and performance tuning techniques.Understanding of query plans| indexing strategies| and database optimization methods.Experience with SQL Server tools like SSMS| Profiler| Query Store| Execution Plan Analysis| etc.

Job Type: Fixed term contract

Pay: $50.00-$55.00 per hour

Work Location: Hybrid remote in Toronto, ON (Toronto District)