Job Description
Senior SQL Server DBA – Brampton, ON
Cognizant is seeking a Senior SQL Server DBA for a full‑time opportunity in Brampton, ON.
Key Responsibilities (Performance Tuning Focus)
- Lead enterprise‑wide SQL Server performance tuning initiatives across mission‑critical production environments.
- Analyze and troubleshoot complex database performance issues, including blocking, deadlocks, latch contention, memory pressure, and CPU bottlenecks.
- Perform advanced query optimization using execution plans, index analysis, Dynamic Management Views (DMVs), and wait statistics.
- Design and implement indexing, partitioning, and database architecture improvements to support high‑volume workloads.
- Conduct proactive database health assessments and recommend performance improvement opportunities.
- Monitor and optimize SQL Server resource utilization, including CPU, memory, storage, and I/...