MS SQL Developer

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 and is reflected in our people stories across our workforce implemented through equitable workplace policies and processes.

About TCS

TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries.

TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status.

Our organizational structure is domain-led and designed to offer businesses a single window into industry-specific solutions.

Our agile industry units have embedded capabilities to enable rapid responses that provide a competitive edge to our customers.

This, coupled with a unique Global Network Delivery Model™ (GNDM™), is recognized as the current benchmark of excellence in technology deployment.

We have made significant investments in digital technology, horizontal, and vertical platforms, allowing us to successfully serve our clients for over 50 years.

Required Skills :

• Experience in T SQL development & MSBI.
• Strong technical skills with PL SQL, Stored procedures, Functions,
• T-SQL / Stored Procedure development on MS SQL database
• Should be able to handle performance optimization tasks (Indexing, Partitioning, Parallelization)
• Experience with Reporting tools (ex. - Crystal Reports and SQL Reporting Services)
• Mandatory - Good understanding of Microsoft SSIS, SSRS development and deployment
• SSAS knowledge would be nice to have.
• Capability to deploy the SSIS pkgs using catalog scripts and monitor jobs scheduled jobs.
• Knowing how to send alert and failure notifications for scheduled SSIS and Jobs
• Experience working with and configuring data-driven applications.
• Understanding of translation between multiple file formats
• Ability to use scripting languages, ETL tools and methodologies to map data between various formats.

Roles and Responsibilities :

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyze, solve, and correct issues in real time, providing Problems SQL developer, SSIS, SSRS, Python Provide SQL Server database expertise.
• Participate in performance monitoring. Participate in database architecture design.
• Review database / query optimization Implement SQL Standards and best practices.

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 accommodations during the recruitment and selection process, please inform Human Resource.

Thank you for your interest in TCS. Candidates that meet the qualification 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.