Database Architect

Tata Consultancy Services Limited; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Tata Consultancy Services Canada Inc. is seeking an experienced Database Architect to define enterprise database strategies on Azure, design migration approaches, and lead cloud transformation initiatives across complex environments.

You will architect solutions, mentor teams, and collaborate with security, infrastructure, and business stakeholders to ensure scalable, secure data platforms. Strong Azure skills and SQL expertise are essential for success in this role.

Qualifications

• Experience with Azure SQL Database, Azure SQL MI, and SQL Server architecture at an enterprise scale.
• Ability to design migration strategies for legacy to cloud-native databases.
• Knowledge of data modeling, performance tuning, and security/governance in cloud environments.

Responsibilities

• Architect enterprise-scale database solutions on Azure.
• Guide platform choices and tradeoffs between Azure SQL options and other databases.
• Create migration roadmaps from on‑premises/legacy systems to Azure.
• Lead modernization efforts from monolithic apps to cloud-native architectures.
• Define HA/DR, security, governance, and performance standards.

Skills

Azure SQL Database

Azure SQL Managed Instance

SQL Server Administration

Performance Tuning

Data Modeling

Azure Migration Services

High Availability / DR

T-SQL & Indexing

Cloud Governance

CI/CD & IaC

Education

Bachelor's or Master's in CS/IT

Tools

DMS (Azure Database Migration Service)

Azure DevOps

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.

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.

w

Job Description :-

Database Architect :-

Experience Required

Senior years of experience in database architecture, database modernization, cloud migration, and enterprise data platform design.

Job Summary

We are seeking an experienced Database Architect with deep expertise in Azure SQL Database and Azure SQL Managed Instance (SQL MI). The successful candidate will be responsible for defining enterprise database strategies, making architecture decisions on platform selection, designing migration approaches for legacy and modern applications, and leading cloud transformation initiatives across complex environments.

Key Responsibilities

• Architect and design enterprise-scale database solutions on Azure.
• Provide expert guidance on when to use Azure SQL Database, SQL Managed Instance, Azure PostgreSQL, SQL Server, or other database platforms and explain associated tradeoffs.
• Create database migration strategies for legacy, hybrid, and cloud-native applications.
• Design migration roadmaps from on-premises SQL Server, Oracle, and legacy databases to Azure.
• Lead modernization initiatives from monolithic applications to microservices and cloud-native architectures.
• Define HA/DR, bac kup, security, governance, and performance standards.
• Conduct architecture reviews and mentor engineering teams.
• Collaborate with application architects, infrastructure teams, security teams, and business stakeholders.

Required Technical Expertise

• Azure SQL Database and Azure SQL Managed Instance (SQL MI).
• SQL Server Administration and Architecture.
• Database Performance Tuning and Optimization.
• Data Modeling, Data Architecture, and Database Design.
• Azure Migration Services, DMS, and modernization frameworks.
• High Availability, Disaster Recovery, Replication, and Always On technologies.
• T-SQL, Stored Procedures, Query Optimization, and Indexing.
• Azure networking, security, identity, and governance.
• CI/CD and Infrastructure as Code practices.

Migration & Modernization Expertise

• Design and execute database migrations for ERP, CRM, web applications, data warehouses, and mission-critical enterprise systems.
• Assess application dependencies and recommend optimal migration paths.
• Define rehost, replatform, refactor, and rebuild strategies.
• Create migration blueprints from legacy systems to modern cloud architectures.
• Evaluate business, cost, performance, availability, and security requirements when recommending target platforms.

Preferred Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
• Azure certifications such as Azure Solutions Architect Expert or Azure Database Administrator Associate.
• Experience with Agile delivery models and DevOps practices.

Enterprise Architecture, Strategic Decision Making, Cloud Transformation, Stakeholder Management, Technical Leadership, Problem Solving, Communication, and Mentoring.

TCS does not use artificial intelligence tools for candidate screening or evaluation. This post is for a current vacancy. The hiring process includes an initial screening, followed by a technical evaluation and managerial discussion.

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.

Location

Toronto, ON

Job Function

TECHNOLOGY

Role

Lead

Job Id

427436

Desired Skills

Database Administration | Network Database