Sourav Bhowmik
Leeds,West Yorkshire
Summary
Strategic and results-driven Database Administrator and Cloud Platform Engineer with a focus on Data Engineering, Performance Tuning, Database Modelling & Designing, Data Migration & providing cloud-based solutions. Offering nearly 14 years of extensive experience in Data Warehouse,Development & Administration, specializing in Data Warehouse environments in both on-premises and Cloud settings. Leading the Azure Platform team at TCS ,skilled in Azure Data Factory, Azure Data bricks, Synapse SQL, PySpark, Key Vault, Azure File Storage, Blob Storage & ADLS Gen2. Proficient in expertly executing data migration projects, specializing in on premise to cloud transitions, particularly in Azure. Successfully upgraded multiple databases from SQL Server 2008R2 and 2012 to more advanced versions such as SQL Server 2014, 2016, and 2019. Demonstrated expertise MySQL replication. Skilled in TDE (Transport Data Encryption), SQL Auditing, and user permissions management(IAM). Proven experience in database design and development using SQL Azure, Microsoft SQL Server, MySQL. Proficient in the installation, upgrades, and configuration of Microsoft SQL Server instances, with expertise in features such as Always On . Expertise in designing and implementing scalable cloud-based data architectures. Proficient in utilizing cloud platforms such as Azure. Skilled in managing data pipelines for efficient data extraction, transformation, and loading (ETL). Hardworking and passionate job seeker with strong organisational skills eager to secure industry level position. Ready to help team achieve company goals.
Overview
13
13
years of professional experience
6
6
Certifications
Work History
Azure Platform Engineer
Tata Consultancy Services
04.2022 - Current
- Azure Level 3 Support Engineer
- Worked on Azure Data Factory
- Azure Databricks
- Azure Synapse
- Azure SQL Server
- Azure Logic Apps
- Azure Databricks SQL Warehouse providing L3 level support on Azure Cloud Solutions
- Set up and manage Azure Monitor
- Log Analytics
- And Application Insights for proactive monitoring and alerting
- Develop and maintain scripts for aAndmating operational processes and implementing best practices in CI/CD pipelines (Azure DevOps, GitHub Actions)
MSSQL Database Administrator
Tata Consultancy Services
01.2016 - 04.2022
- Install, configure, and maintain Microsoft SQL Server instances (both on-premise and cloud)
- Manage and monitor SQL Server databases across multiple environments (development, testing, production)
- Perform regular database maintenance tasks such as backups, restores, database re-indexing, and integrity checks.
- Monitor and tune database performance, identifying bottlenecks and resolving performance issues
- Analyze and troubleshoot database-related issues, including deadlocks, blocking, and slow queries
- Design and implement high-availability (HA) and disaster recovery (DR) strategies using techniques such as AlwaysOn Availability Groups, Failover Clustering, and Database Mirroring
- Automate routine DBA tasks such as monitoring, backups, and deployments using scripts and tools (PowerShell, T-SQL, SQL Agent)
- Successfully upgraded multiple databases from SQL Server 2008R2 and 2012 to more advanced versions such as SQL Server 2014, 2016, and 2019.
- Managed PI data with Always Encrypted ,TDE (Transport Data Encryption), SQL Auditing, and user permissions management.
- Proven experience in database design and development using SQL Azure, Microsoft SQ L Server,MySQL.
- Proficient in database administrative skills like AlwaysOn, Data Warehousing
Technical Lead
Webgen Technologies Pvt Ltd
09.2014 - 11.2015
- Plan, design, develop, debug, implement
- Modify existing software to: correct errors, allow it to function in new operating environments, or improve performance through DB monitoring, improving Stored procedure.
- R&D is recommend to improvements to project coding standards.
- Work remotely in a team environment with shared code, disciplined use of source code control and process documentation.
- Improve software quality by conducting systems analysis, and recommending changes in policies and procedures.
- Amazon server install and maintenance .Load balancing in Amazon server EC2
Programmer Analyst
Itrix IT Solutions Pvt. Ltd.
01.2014 - 07.2014
- PHP developer with MySQL
- Technology used : PHP, MSSQL,AJAX,JQUERY,SYMPNONY framework
Sr. Software Engineer
MPS Infotech Pvt. Ltd
12.2012 - 01.2014
- Frontend website developer
- Technology used : PHP, MYSQL,AJAX,JQUERY, codeigniter framework
Software Developer
Endue Technologies India Pvt. Ltd.
09.2011 - 11.2012
- Frontend website developer
- Technology used : PHP, MYSQL,AJAX,JQUERY, codeigniter framework
Education
Master of Computer Applications - Computer Application
WBUT
West Bengal07.2010
Bachelor - Computer Science(Hons)
VU
West Bengal07.2007
Skills
- SQL Server 2019
- SQL Server 2016
- MySQL 80
- Powershell
- Azure Data Factory
- Azure Synapse Analytics
- SQL Managed Instance
- Azure SQL
- Azure Databricks
- Azure Logic Apps
- Azure
- Blob Storage
- ADLS Gen2
- Pyspark
- Netbackup
- Service Now
- SSMS
- SSRS
- MySQL
- Azure Data Migration Tool
- MS-SQL SSIS
- Snyk
- MySQL workbench
- Git
Certification
- Microsoft Certified: Azure Database Administrator Associate (DP-300),2024
- Microsoft Certified: Azure Solutions Architect Expert (AZ-305),2024
- Administering Microsoft Azure SQL Solutions (AZ-104),2022
Languages
English
Proficient
C2
Hindi
Proficient
C2
Bengali
Proficient
C2
Knowledge purview
- Data Security Management
- Cloud Infrastructure Optimization
- Business Intelligence Strategies
- Data Migration Techniques
- Performance Enhancement Solution
- Disaster Recovery Planning
- Database Partitioning Strategies
- Index Optimization Techniques
Technical stack
SQL Server 2019, SQL Server 2016, MySQL 8.0,Azure, Azure Data Factory, Data Bricks, Keyvault ,Logic app,Azure Synapse, Azure SQL managed Instance,Azure SQL,Blob Storage, ADLS Gen2, Python, Pyspark, Netbackup, Service Now,Snyk, Azure Monitor, SSRS, MySQL, Azure Data Migration Tool, MS-SQL SSIS, MySQL workbench
Personal Information
Date of Birth: 17/02/87
Playing Cricket ,Badminton
Playing as wicket keeper batsman for TCS
Timeline
Azure Platform Engineer
Tata Consultancy Services
04.2022 - Current
MSSQL Database Administrator
Tata Consultancy Services
01.2016 - 04.2022
Technical Lead
Webgen Technologies Pvt Ltd
09.2014 - 11.2015
Programmer Analyst
Itrix IT Solutions Pvt. Ltd.
01.2014 - 07.2014
Sr. Software Engineer
MPS Infotech Pvt. Ltd
12.2012 - 01.2014
Software Developer
Endue Technologies India Pvt. Ltd.
09.2011 - 11.2012
Master of Computer Applications - Computer Application
WBUT
Bachelor - Computer Science(Hons)
VU
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Paulius KacinskasPaulius Kacinskas
Labourer at Yealcon Ltd, SCS Building Solutions, Titan LtdLabourer at Yealcon Ltd, SCS Building Solutions, Titan Ltd