SQL Server Database Developer

Position: SQL Server Database Developer

Location: Mississauga, ON (Onsite)

Employment Type: Full-Time

Total Experience: 8+ years

Job Description:

• Design, develop, and maintain enterprise-scale Microsoft SQL Server databases supporting business-critical applications.
• Develop complex T-SQL queries, stored procedures, functions, views, triggers, and database objects.
• Design and optimize relational data models, including tables, relationships, primary/foreign keys, constraints, and indexing strategies.
• Perform advanced SQL performance tuning, including execution-plan analysis, query optimization, index tuning, statistics management, and identification of blocking/deadlocks.
• Design efficient solutions for high-volume transactional and analytical workloads.
• Develop ETL/data integration processes for loading and transforming data between source systems, staging areas, and target databases.
• Implement incremental loads, CDC/change tracking, data reconciliation, and historical-data processing.
• Perform database performance monitoring and troubleshoot CPU, memory, I/O, locking, blocking, and long-running-query issues.