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/O performance.
- Collaborate with application development teams to optimize database-intensive applications, stored procedures, and T-SQL code.
- Perform Root Cause Analysis (RCA) for critical performance incidents and implement preventive solutions.
- Lead performance benchmarking, capacity planning, and scalability assessments to support future business growth.
• Drive automation initiatives using PowerShell and T-SQL to improve operational efficiency and reduce manual intervention.
Skills and Qualifications Required:
- 10 years of experience with SQL Server Database Administration and Development with Performance Tuning on Slow running queries with Automation.
- 8 plus years of experience with SQL Performance Tuning & Optimization.
- Experience with Always On Availability Groups / HA-DR.
- Query Optimization & Execution Plan Analysis.
- PowerShell Automation & Scripting.
- SQL Server Upgrades & Migrations
Total Compensation
The base salary for this position ranges between $77500 to $91000 per year. Where the successful candidate may fall within the range depends on relevant education, work and/or management experience and other business-related and job-necessary qualifications. This position is also eligible for Cognizant's discretionary annual performance-based bonus, as well as benefits that support your physical, mental and financial wellbeing.
Working Arrangements:
At Cognizant, we're eager to meet people who believe in our mission and can make an impact in various ways! We strongly encourage you to apply even if you only meet the required skills listed. Consider what transferrable experience and skills make you an outstanding applicant and help us see how you'd be helpful to this role.
Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.
We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role's business requirements, this is a hybrid position requiring 3 days a week in a client or Cognizant office in Brampton, ON.
Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.
Note: The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations
Applications for this position are reviewed by our recruitment team without the use of artificial intelligence screening tools. Applications will be accepted until 7/16/2026.
