Inclusion without Exception
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.
Tata Consultancy Services (BSE: 532540, NSE: TCS) is the technology partner of choice for industry-leading organizations worldwide. Since its inception in 1968, TCS has upheld the highest standards of innovation, engineering excellence and customer service.
It has set an aspiration 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 of the Tata Group, TCS is focused on creating long term value for its clients, its investors, its employees, and the community at large. With a highly skilled workforce spread across 56 countries and 194 service delivery centers across the world, the company has been recognized as a top employer in six continents. With the ability to rapidly apply and scale new technologies, the company has built long term partnerships with its clients. Many of these relationships have endured into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today.
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
- Database Administration 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.
- Performance Tuning Monitoring Perform query optimization, index tuning, and resolving deadlocks or performance bottlenecks.
- Monitor SQL workloads using Azure Monitor Azure SQL Insights Log Analytics Query Store Security Compliance Implement best practices for data security, encryption (TDE, Always Encrypted), and secrets management via Azure Key Vault.
- Manage RBAC roles, least-privilege access, and security auditing.
- Ensure compliance with organizational and regulatory standards.
- High Availability Disaster Recovery Configure and maintain Azure SQL failover groups, availability zones, and geo replication.
- Validate disaster recovery plans and conduct failover tests.
- Automation DevOps Automate administrative tasks using Power Shell Azure CLI Azure Automation Runbooks Terraform or ARM Bicep templates Support CICD pipelines for database releases using Azure DevOps or GitHub Actions.
- Maintenance Troubleshooting 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 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.
Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.
