Technical Lead or Architect (.NET Power platform), Toronto

Technical Lead or Architect (.NET Power platform) Toronto, ON | Experience: 5 - 18 years

Roles and Responsibilities

We are seeking a seasoned Technical Lead Solution Architect with a strong foundation in Microsoft technologies. You will be responsible for designing, governing, and delivering end-to-end enterprise solutions that integrate custom .NET applications with the Microsoft Power Platform ecosystem.

This role demands a hands‑on leader who can bridge the gap between complex business requirements and scalable, high‑performance technical solutions.

Install, configure, and maintain Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.

Manage database objects such as tables, indexes, views, stored procedures, and functions.

Implement and maintain backup restore strategies, including automated Azure backups.

Perform query optimization, index tuning, and resolve deadlocks or performance bottlenecks.

Monitor SQL workloads using Azure Monitor, Azure SQL Insights, Log Analytics, and Query Store.

Implement best practices for data security, encryption (TDE, Always Encrypted), and secrets management via Azure Key Vault.

Manage RBAC roles, enforce least‑privilege access, and conduct security auditing.

Ensure compliance with organizational and regulatory standards.

Configure and maintain Azure SQL failover groups, availability zones, and geo‑replication for high availability and disaster recovery.

Validate disaster recovery plans and conduct failover tests.

Automate administrative tasks using PowerShell, Azure CLI, Azure Automation Runbooks, Terraform or ARM Bicep templates, and support CI/CD pipelines for database releases using Azure DevOps or GitHub Actions.

Apply patches and updates across Azure SQL and SQL Server infrastructure.

Troubleshoot connectivity, performance, or configuration issues.

Analyze logs, alerts, and capacity trends to ensure optimal database health.

Equal Opportunity Employer Tata Consultancy Services (TCS) is an equal opportunity employer and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation.

Accessibility Statement Tata Consultancy Services Canada Inc. is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodation during the recruitment and selection process, please inform Human Resources.

#J-18808-Ljbffr