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.