We took backup of database and restored it on Azure SQl PAAS and ensured all front end connections are connected to database Azure.

Configured Alway on AG.

we are provideing support to the client Avanade for their infrastucture maintenance. I am a senior SQL Server database administrator.

Database administration of Production/Dev/Test servers located in different geographic locations of various clients. Performed backups and restore operations Automated few tasks in Power shell (AG Failover, Auditing multiple servers for Security) Configured/Monitoring Mirroring, Always on availability group and clustering. Monitoring Log space, disk usage and Troubleshooting log space and disk space issues. Monitoring and resolving SCOM 2012 alerts. Resolved the SQL server login issues. Creating logins, roles and granting rights assigning permissions and mapping user databases. Resolved production performance issues. (CPU and memory, Fragmentation) Performed SQL servers Service pack installation. Performed Cluster failover during windows level patches. Performed adding databases to the availability group. Performed SQL server validations as per the project standards. Monitoring, Backup tool Data Protection Manager (DPM) Creating Protection Group levels and adding databases under protection groups in DPM. Hands on experience on MS Azure Cloud. Creating Resources groups, SQL Server, SQL database. Worked on IAAS, PAAS and Managed SQL instances. Monitor Azure environment with automated reports like Server level & database level audit, Security policies etc. Created Data Factories, pipelines and configured alerts to get logged in Azure logs. Configured Azure SQL Analytics to monitor performance of Azure databases and managed instances. Knowledge on KQL. Resolving tickets within SLA.

Vodafone money transfer, we support DBA things.

Performed SQL servers installation, and configurations. Performed backups and restore operations. Performed to add more data files and log files in the existing database. Monitoring Log space, disk usage and Troubleshooting log space and disk space issues Performed database Migration from SQL server 2005 to 2008R2. Creating logins, roles and granting rights assigning permissions and mapping user databases. Resolved the SQL server login issues. Configured the jobs alerts like SQL server error log, agent, CPU, memory, transaction usage, blocking) through DB Mail. Configured the linked server from one server to another server for to pull the RFC(request for change) Monitoring Mirroring and clustering. Resolved blocking and deadlock issues. Resolved production performance issues. (CPU and memory, Fragmentation) Working on production deployment requests & validating the post deployments. Checking the database consistency by using DBCC commands. Resolving tickets within SLA.