Detail-oriented SQL Server Database Administrator with expertise in database management and recovery strategies. Skilled in cloud solutions and problem-solving, ensuring data integrity and availability.
Detail-oriented SQL Server Database Administrator with expertise in database management and recovery strategies. Skilled in cloud solutions and problem-solving, ensuring data integrity and availability.
· Worked on Microsoft Azure IaaS, PaaS SQL DB, Managed instance and ADF.
· Created VMs, drives configuration and installation of SQL services. Installed 2017 SQL version also. This is on IaaS server.
· Created SQL storage account and created container in blob storage.
· Created Recovery vaults for production and non-production to take backup of databases.
· Configured AZ backups from on-premises server to azure (IaaS SQL databases) to recovery vaults and created alerts to know the backup status whether they are healthy or not.
· Created backup policies like full every week Friday, diff backup every 6 hours and Log backup every 15 minutes.
· We are restoring these AZ backups randomly every month on on-premises server for the SOX evidence. Whether backups are valid or not and we could restore from AZ backups or not.
· If backups are failed, we will re-run those which status is showing not healthy.
· If we dropped any database on on-premises server, we will go and delete backup configuration for that particular database.
· As per the disk space issue we are increasing disk space on IaaS server.
· Created users and groups on Azure active directory. Provisioning access as per the request and optimizing privileges.
· Worked on SQL DB and elastic pools and much hands-on PaaS Managed instance.
· Created SQL DB for single application on Azure.
· Hands on PaaS migration. Migrated around 450 databases from IaaS to PaaS MI (2017 version).
· Created 4 Managed instances.
· Created databases on PaaS MI and restored databases one MI to other MI within same region.
· Restored databases from PaaS MI to IaaS SQL servers.
· Provided access on PaaS Mi instance for the users.
· Worked on DB encryption on PaaS MI and instance level.