SQL Developer

Tata Consultancy Services; Montreal (administrative region); On-site; CAD 120,000 - 150,000; Full time

Job summary

Tata Consultancy Services in Canada is seeking a senior database administrator with deep expertise in Microsoft SQL Server, Azure SQL Database, and Azure SQL Managed Instance to manage on-premises and cloud databases. You will lead performance tuning, migrations, and DR planning while mentoring L1/L2 teams in a fast-paced environment.

Ideal candidates have extensive production incident experience, strong communication skills, and a proven track record of optimizing cost and performance across

Qualifications

• Extensive experience as a senior database administrator with MS SQL Server and Azure SQL platforms.
• Expertise in performance tuning, Query Store, execution plans, and DMVs.
• Experience with Always On, replication, clustering, and disaster recovery.
• Automation skills with PowerShell, T-SQL, and Azure CLI.
• Proven ability to manage migrations, upgrades, and cost optimization.
• Strong communication and incident-management capabilities.

Responsibilities

• Administer and support SQL Server across on-premises and Azure environments.
• Lead performance diagnostics and tuning using Query Store, DMVs, and extended events.
• Optimize T-SQL, indexing, and capacity management.
• Detect bottlenecks, establish baselines, and validate improvements.
• Govern Azure automatic tuning and database advisor recommendations.
• Design and support high availability and disaster recovery.
• Plan and execute migrations, upgrades, patching, and cloud adoption.
• Manage Azure SQL service tiers, scaling, and geo-replication.
• Implement security, encryption, auditing, and compliance controls.
• Automate provisioning, health checks, and reporting; mentor teams.
• Own incidents, root-cause analysis, and stakeholder communications.
• Maintain runbooks, dashboards, and knowledge articles; support change readiness.

Skills

SQL Server expertise

Azure SQL Database

Azure SQL Managed Instance

SQL Server on Azure VMs

Query Store

Performance tuning

T-SQL optimization

Indexing

Blocking/deadlocks

Automation

PowerShell

Azure CLI

Incident management

Tools

MS SQL Server

Azure SQL

DMVs

Extended Events

PerfMon

SQL Profiler

Job description

Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.

TCS has been serving the Canadian marketplace for more than 35 years and today is the technology partner of choice for many of the country's leading organizations. As one of the largest IT services providers in Canada and globally, TCS is aiming to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence.

Rooted in the heritage and values of the Tata Group, TCS is focused on creating long-term value for its clients, investors, employees, and the communities it serves. With a highly skilled workforce supporting customers from coast to coast, TCS has consistently been recognized as a Top Employer by the Top Employers Institute, including a recent top ranking at the country level.

TCS also sponsors 14 of the world's most prestigious marathons and endurance events, including the TCS Toronto Waterfront Marathon, reflecting its commitment to health, sustainability, and community empowerment.

Job Description :-

Your responsibilities:

• Administer and support SQL Server across on-premises, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
• Lead performance diagnostics and tuning using Query Store, execution plans, Dynamic Management Views, Extended Events, wait statistics, PerfMon, SQL Profiler, and Azure monitoring.
• Optimize complex T-SQL, stored procedures, indexing, statistics, partitioning, memory, TempDB, parallelism, locking, blocking, deadlocks, CPU, storage I/O, and transaction logs.
• Detect query-plan regressions and workload bottlenecks, establish performance baselines and capacity forecasts, and validate measurable improvements.
• Govern Azure SQL automatic tuning and Database Advisor recommendations, including production safeguards and rollback readiness.
• Design and support high availability and disaster recovery using Always On availability groups, failover groups, clustering, replication, log shipping, backup, restore, and point-in-time recovery.
• Plan and execute database migrations, upgrades, patching, consolidation, modernization, and cloud adoption with minimal disruption.
• Manage Azure SQL service tiers, elastic pools, scaling, geo-replication, private connectivity, firewall rules, and cost-performance optimization.
• Implement least-privilege access, Microsoft Entra authentication, managed identities, encryption, auditing, vulnerability remediation, secrets management, and compliance controls.
• Automate provisioning, configuration, health checks, maintenance, backup validation, and reporting with PowerShell, T-SQL, Azure CLI, and infrastructure-as-code practices.
• Own P1/P2 incidents, outages, root-cause analysis, corrective actions, vendor escalations, and stakeholder communications.
• Maintain standards, runbooks, recovery procedures, dashboards, and knowledge articles; mentor L1/L2 teams and support change and release readiness.

Essential skills/knowledge/experience:

• Senior years of relevant database administration experience, with strong L3 MSSQL and Azure DBA expertise.
• Advanced hands-on experience with Microsoft SQL Server, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
• Deep knowledge of Query Store, performance monitoring, execution-plan analysis, T-SQL optimization, indexing, blocking, deadlocks, and capacity management.
• Proven experience with Always On, replication, clustering, backup and recovery, database migrations, upgrades, and patching.
• Automation capability using PowerShell, T-SQL, Azure CLI, and infrastructure-as-code practices.
• Strong production incident, outage, root-cause analysis, change management, and stakeholder communication experience.
• Experience with Azure SQL automatic tuning, Database Advisor, elastic pools, geo-replication, and cost optimization.
• Knowledge of Microsoft Entra authentication, managed identities, encryption, auditing, vulnerability remediation, and compliance evidence.
• Ability to mentor support teams, improve runbooks, and reduce recurring incidents through preventive engineering and automation.
• Good communication skills and experience working through major outage situations.