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.
À propos de Cognizant
Cognizant (NASDAQ : CTSH) est un AI Builder et une entreprise de services numériques (ESN) élaborant des solutions complètes d’IA maximisant les investissements pour des résultats concrets. Sa profonde expertise des métiers, des processus et des technologies lui permet d’intégrer dans les systèmes technologiques le contexte unique de chaque organisation de l’ingénierie à la production à l’échelle. Son objectif : améliorer l’efficacité des équipes, créer de la valeur et permettre aux grandes entreprises de rester performantes dans un monde qui évolue rapidement. Pour en savoir plus : cognizant.ai ou @cognizant.
Renseignments suppplémentaires sur l'emploi
Les informations relatives à la rémunération du poste à pourvoir dépendent de la date de publication de l’offre de poste. Cognizant se réserve le droit de modifier ces informations à tout moment, sous réserve des lois applicables.
Cognizant est un employeur soucieux de l'égalité des chances entre candidats. Votre candidature sera étudiée indépendamment de votre race, couleur, sexe, religion, croyances, orientation sexuelle, identité de genre, origine, handicap, informations génétiques, grossesse, statut d'ancien militaire ou de toute autre critère jugé discriminant par les lois européennes ou françaises.
Vous êtes porteur d'un handicap, vous pouvez-nous contacter par courriel [email protected] si vous souhaitez préciser les aménagements nécessaires pour le poste ou les entretiens à venir.
Les candidats peuvent être invités à participer à des entretiens en face à face ou par vidéoconférence. En outre, les candidats peuvent être amenés à présenter une carte d'identité valide lors de chaque entretien.
