Greensolution
SQL Database Administrator
Pune
06.2020 - 06.2023
- Resolved performance tuning issues related to memory, CPU, disk I/O, and statistics.
- Demonstrated expertise in indexing, execution plans, and query optimization.
- Installed and configured MS SQL Server 2016, 2019, and 2022 environments.
- Worked on disaster recovery plans, including log shipping, mirroring, replication, and Always On.
- Executed backup and recovery processes while ensuring database security protocols.
- Monitored critical database and server metrics using Excel for DB and disk growth tracking.
- Automated tasks through PowerShell scripting to enhance operational efficiency.
- Performed day-to-day responsibilities with accuracy and efficiency.
- Azure DBA:
SQL on Azure VM (IAAS)
Azure DB (Single DB / Elastic Pool)
Managed instance
Worked in Purchase Model
Migration on DBs from on premise to Azure Db with Backpac file
Adding and removing database from and in Elastic Pool