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.

Involved in taking the requirements from the client and implementing them in the environment. Created Azure Cloud Services for different layers like Development, Testing and Production. Configured Azure Internal Load Balancer between VMs inside a Cloud Service to distribute the traffic. Configured Public and Private Endpoints for Azure Virtual Machines. Installed and configured VM agent and extensions manually on all VMs. Configured Monitoring tool Datadog for all the VMs. Configured Azure Recovery services. Configured Auto-scaling based on given metrics for Virtual Machines. Configured automated database backups to Azure Blob Storage. Configure automated Virtual Machine backups to Azure Vault. Installed SQL Server 2012 and Installed service packs and security fix on production and test instances. Attaching and initializing disks to the instances. Created SQL Server Agent jobs to automate backups, Index Maintenance 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

Installed SQL Server 2008 and Installed service packs and security fix on production, test and development Amazon EC2 instances. Experience in creating backup strategy for production, test and development servers. Performed Database Refreshment task from Prod to Dev/Test environment. Configured Database LogShipping in SQL Server 2008 between EC2 instances. Experienced in creating logins and assigning the permissions to databases. Maintained the SQL Server in secured environment. Created Operators, Jobs, and Alerts and configured database mail. Monitored the scheduled jobs and made sure that they were running successfully. Trouble shooting database and Space management issues to maintains the SQL Server to provide maximum availability. Maintaining the database consistency with DBCC and DMVS at regular intervals.