Subhajit Dutta
Kolkata
Summary
Experienced SQL Database Administrator with 13 years in IT, specializing in SQL Server 2012-2019 and Azure Cloud. Led migrations of on-premises databases to Azure SQL, optimizing performance through indexing strategies and configuring Always On Availability Groups for HA/DR. Skilled in database maintenance, security, and backup/recovery protocols, with expertise in T-SQL and PowerShell to ensure data integrity and availability.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Azure SQL Database Administrator
TATA Consultancy Services
Kolkata
02.2021 - Current
- Migrated On-prem SQL database to Azure SQL DB using Transactional replication which offered minimal downtime during the migration process and the ability to test the target environment with a live copy of production data
- Configured and managed SQL server always on availability groups with Disaster recovery secondary replicas.
- Executed regular vulnerability patching, cumulative updates, and SQL version upgrades to ensure system security and reliability.
- Developed and maintained maintenance plans that ensured data integrity and availability across all SQL instances.
- Provisioned SQL Servers in VMware PaaS environment by gathering business requirements, planning, and installing necessary components.
- Maintaining all SQL instances under Centrally Managed Server group to perform bulk activities and maintaining DB inventories.
- Troubleshooting slow performance and high memory usage of SQL instances. Checking on long running queries, wait stats and index performance to come up with Query performance improvement.
- Performed regular database backups and restored them. Diagnosed backup failure issues in Rubrik tool and corrected them.
- Refreshing non-prod databases with Production database backups and automating same process with SQL Server Agent jobs.
- Creating, configuring and troubleshooting Linked Servers for Development team.
- Proficient in TSQL scripting. Creating procedures and views and integrated them with powershell scripts to run as SQL agent jobs for creating reports and daily monitoring.
- Worked closely with software developers to design efficient database solutions for new applications.
- Configured database mail feature to turn on email notification for all kinds of SQL job failures.
- Acquired skills in VMware 7.0 through hands-on server building and resource adjustments.
SQL Server Database Administrator
Cognizant Technology Solutions
Kolkata
10.2012 - 02.2021
- Provisioned SQL Servers in VMware PaaS environment, starting from business requirements to planning and installing components.
- Troubleshot slow performance and high memory usage of SQL instances, analyzed long-running queries and their wait stats, and developed solutions by generating estimated query plans for cost usage and index management.
- Worked on regular vulnerability patching and SQL version patch upgrades.
- Installing latest Service Packs with Cumulative Updates on SQL instances.
- Maintaining all SQL instances under Centrally Managed Server group to perform bulk activities and maintaining inventories.
- Configured and troubleshot Linked Servers to support development activities.
- Refreshing non-prod databases with Production databases backups and automating same process with SQL Server Agent jobs.
- Configured database mail feature to turn on email notification for all kind of SQL job failures.
- Managed client relationship with Allianz Global Investors, ensuring alignment on SQL database needs and supporting their operational objectives.
Education
Bachelor of Technology - Electronics and Communication
West Bengal University Of Technology
Kolkata06.2012
Skills
- MS SQL Server
- Azure SQL migration
- TSQL Scripting
- Database management
- Database Performance Tuning
- Python Scripting
- PowerShell Scripting
- MySQL DBA Basics
- MongoDB Basics
- VmWare Basics
Certification
• ITIL V3 Foundation
• AZURE Administrator Associate (AZ-103)
• Microsoft Certified: Azure Database Administrator Associate(DP-300)
• AZURE Administrator Associate (AZ-103)
• Microsoft Certified: Azure Database Administrator Associate(DP-300)
Disclaimer
I hereby declare that the above information is true and best of my knowledge.
Personal Information
Date of Birth: 05/03/90
Timeline
Azure SQL Database Administrator
TATA Consultancy Services
02.2021 - Current
SQL Server Database Administrator
Cognizant Technology Solutions
10.2012 - 02.2021
Bachelor of Technology - Electronics and Communication
West Bengal University Of Technology