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.
Over Cognizant
Cognizant (NASDAQ: CTSH) is een bouwer van AI-oplossingen en een leverancier van technologiediensten. Wij slaan de brug tussen AI-investeringen en ondernemingswaarde door het bouwen van full-stack AI-oplossingen voor onze klanten. Onze diepgaande kennis van sectoren, processen en engineering stelt ons in staat om de unieke context van een organisatie te verankeren in technologische systemen. Deze systemen versterken het menselijk potentieel, realiseren tastbare resultaten en geven wereldwijde ondernemingen een voorsprong in een snel veranderende wereld. Ontdek hoe op cognizant.ai of @cognizant.
Aanvullende arbeidsinformatie
De informatie over de beloning is correct op de datum van deze vacature. Cognizant behoudt zich het recht voor om deze informatie op elk moment te wijzigen, met inachtneming van de toepasselijke wetgeving.
Van sollicitanten kan worden verwacht dat zij gesprekken bijwonen, persoonlijk of via een videogesprek. Daarnaast kan van kandidaten worden gevraagd om tijdens elk gesprek een geldig, door de overheid uitgegeven identiteitsbewijs (zoals een identiteitskaart of paspoort) te tonen.
Cognizant is een werkgever die gelijke kansen biedt. Je sollicitatie en kandidatuur worden niet beoordeeld op basis van ras, huidskleur, geslacht, religie, levensovertuiging, seksuele geaardheid, genderidentiteit, nationale afkomst, handicap, genetische informatie, zwangerschap, veteranenstatus of enige andere eigenschap die wordt beschermd door federale, regionale of lokale wetgeving.
