Technical Lead or Architect (.NET Power platform

Technical Lead or Architect (.NET Power platform)

Toronto, ON |

Experience:

5 - 18 years

• 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 Power Shell, Azure CLI, Azure Automation Runbooks, Terraform or ARM Bicep templates, and support CI/CD pipelines for database releases using Azure Dev Ops or Git Hub 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.

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

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.