SIRISHA ADAVIKOLANU

Oct 20th, 2021 – Till Date.

Project Name: Ultragenyx , Sonepar and NXP

Role: DBA Client: Ultragenyx Database

MS SQL Server 2008R2, 2012, 2016, 2017,2019

• Experienced in databases refresh activities from PROD environment to DEV and Test environment in IAAS service.
• Experienced in TLS 1.2 configuration in Azure SQL Database in PAAS environment.
• Configuring backup in azure recovery vault for SQL Server databases and create\Manage the backup policy.
• Fixing the SQL Server backup issues in azure recovery vault.
• Stopping and Starting the Virtual machine from azure portal
• Fixing connectivity issues from clients and applications to SQL server database and azure SQL dB in azure environment.
• Worked on Database Migration from On premises to Azure SQL.
• Scheduling database backups to Azure storage account from SQL server.
• Build SQL Server as per requirement in azure.

• Feb 10th 2014 - October 03rd 2021.
• Project Name : Du-Pont Role : DBA Client : Du-Pont Database : MS SQL Server 2005, 2008R2, 2012, 2016, 2017
• Installation, Configuration, Create and Maintenance of Databases across Development/ User test/ production/Standby Environment.
• Upgrading SQL versions and applying the latest service packs & hot fixes.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Recovering databases from backup in disasters.
• Data Migration from one instance to other.
• Monitoring complete health check of all DBs
• Creating Maintenance plans and jobs for automation of repetitive task.
• Performing Database maintenance activities like Backups, Restoring, and Re-indexing etc..
• Knowledge on High Availability
• Involved in troubleshooting, as performance monitoring issues.
• As part of Agile, we started working along with Wintel Team and automated patching through WSUS
• Worked on various auto & Semi automation Scripts for Windows Auditpol, Services(Qualys installation, MEF's files)
• Learning New Skills: AZURE.