Subhrangshu Chakraborty
Labpur, Birbhum
Summary
Azure Database Administrator with over 4 years of expertise in Azure SQL, SQL Server, Azure Synapse, and Azure Data Factory. Proven track record in executing large-scale data migrations and optimizing performance. Skilled in providing deployment support and managing MOVEit MFT for secure SFTP integrations and automation.
Overview
5
5
years of professional experience
2
2
Certifications
Work History
IT Analyst
Tata Consultancy Services
Kolkata
05.2021 - Current
- Administer and support Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs, and on-premises SQL Server environments across production and non-production.
- Manage Azure Synapse Analytics (Dedicated SQL Pools), including performance monitoring, workload optimization, and issue resolution.
- Design, build, and maintain Azure Data Factory (ADF) pipelines for data ingestion, transformation, scheduling, and monitoring.
- Lead large-scale database migrations from Azure Blob Storage to SQL Server on Azure VMs, including migration planning, cutover execution, and validation.
- Perform database performance tuning through query optimization, indexing strategies, and resource scaling to meet SLA requirements.
- Collaborate with data engineers and application teams to plan deployments, support releases, and resolve data platform issues.
- Implement and manage backup, restore, and HA/DR strategies, including recovery testing.
- Automate SQL Server patching using Ivanti Shavlik, ensuring timely security updates and reducing manual effort across environments.
- Perform SQL Server installations and configurations across SQL Server 2017, 2019, and 2022, including post-installation validation and hardening.
- Install and configure SQL Server Reporting Services (SSRS) to support reporting requirements.
- Administer MOVEit Automation and MOVEit Transfer to deliver secure SFTP/FTPS integrations for external vendors, including user access, certificates, SSH keys, and folder permissions.
- Maintain MOVEit application and server infrastructure, perform upgrades and patching, troubleshoot production issues, and support security audits, and compliance reviews.
Education
Bachelor of Technology - Electronics And Communication Engineering
University of Engnineering And Management
Kolkata05-2021
Skills
- Azure SQL Database
- Database migrations
- Data pipeline development (ADF)
- Performance tuning
- Cloud data management
- Data security and compliance
- Managed File Transfer (MOVEit/SFTP)
- Automation and scripting (SQL, PowerShell, Python)
Certification
AWS Certified Cloud Practitioner.
Accomplishments
Recognized by the client as one of the top-performing employees for outstanding delivery and operational excellence during 2022–2023.
Timeline
IT Analyst
Tata Consultancy Services
05.2021 - Current
Bachelor of Technology - Electronics And Communication Engineering
University of Engnineering And Management