Responsibilities:

• Created Resource groups, Virtual Networks for QA, UAT, Production and DR associated with different regions.
• Configured secure virtual network within azure and between azure and on-premises.
• Created Site to Site VPN connections between on-premises and Azure.
• Configured different Subnets for Web, App & DB in each environment separately.
• Created standard and premium storage accounts.
• Migrated VM’s using azure site recovery.
• Configured Azure VM backups and Disaster recovery.
• Created and configured RBAC roles.
• Configured Geo-replication for VM’s high availability and DR.
• Strong hands-On experience on Azure Services, monitoring, patching, antivirus, log monitoring and alerting.
• Provisioned Windows and SQL server Virtual Machines and configured Static IP’s.
• Created Network Security Groups and configured Inbound rules as part of Cloud Security.
• Created Internal Load Balancers to distribute traffic between Web and Application servers.
• Monitored Azure VM’s security using Azure Security Center.
• Added Machines to the Active Directory Domain. Created Domain Users, Groups and provided appropriate permissions.
• Added roles and Features like IIS Webserver, DNS, DHCP, Failover Cluster etc.
• Created Websites, Application Pools, binded SSL Certificates to the Websites.
• Deploying Code to different environments like QA, UAT and Production using Team Foundation Server from Dev as part of day to day activities.
• Migrated Team projects from 2010 TFS to 2013 Team Foundation server.
• Created Automated Build Templates in TFS.
• Creating Team Projects, Branches and code merging between branches like Dev-QA, QA-UAT and UAT- Prod in TFS.
• Configured Build Sever and User security in Team Foundation server.
• Installed SQL Server 2012 and Installed service packs and security fix on production, test and development instances.
• Configured Windows Failover Cluster for Production and UAT SQL Server VM’s spanning across different regions.
• Created AlwaysOn availability groups and Configured Failover and Availability Modes on SQL VM’s.
• Created DB Full backup jobs to Azure Blob Storage directly.
• Created SQL Server Agent jobs to automate backups, Index Maintenance, Backup retention and other regular maintenance tasks.

Responsibilities:

• Created Amazon EC2 Instances inside a VPC and Installed SQL Server 2008 R2 and 2012.
• Hands on experience with Server configurations.
• Involved in server upgrades and migrations from micro to large.
• Hands on experience with performing migration from on-premises SQL Server 2005 to SQL Server 2008 and SQL Server 2008R2 Amazon EC2 instances.
• Configured High Availability technology, Sql Server Database Mirroring between EC2 SQL Server Instances.
• Created Amazon machine Images and moved to Amazon S3 Bucket.
• Moving Database backups to Amazon S3 bucket.
• Created SQL Server Agent jobs to automate backups, Index Maintenance, Backup retention and other regular maintenance tasks.
• Created Jobs to maintain Backup Strategy i.e. full/diff/log backups.
• Monitoring Blocking and Deadlock issues. And monitoring Disk Space issue.
• Hands on experience with security administration. Creating logins, users and fixing orphaned user issues.
• Worked with developers in fixing level 1 and level 2 performance issues like logins, connections and resolving blockings.
• Involved in monitoring the performance of database servers using DBCC commands, Dynamic Management Views and stored procedures.

- Created Azure Storage accounts, Azure datalake storage, Azure data factory, key vault and Azure SQL managed Instance for different requirements.

- Creating pipelines, triggers, datasets, linked connections in azure data factory.

- Migrating data from Azure datalake store to SQL managed Instance using Datafactory.