Sql Server Azure Cloud

Purushottam Giri

Email: *********@*****.***, Phone: +1-571-***-****

Database Administrator/Azure

SUMMARY:

• 9 years of experience on IT industry in Azure cloud administrator/ SQL Database/Windows/IIS/ Administrator with installation, Configuring, Deploying, Troubleshooting.

• Solid understanding of cloud computing service modes(IaaS, PaaS, SaaS) Azure commercial and Gov Tenant, Azure VM provision, High Availability set, Azure App service, Azure ADDS, Azure Storage Blob, file share, Azure Backup Recovery Vault, Azure Point to Site Recovery, Azure Data Factory

• Azure Network: Configure VNet, subnet, Load balancer, NSG, VNet Gateway, VPN Gateway, P2S VPN, S2S VPN, Route table

• Azure Security: Azure Security center (ASC), Azure Policy and Azure Secure Score, Azure disk encryption, Azure SSO and MFA config, Advance Data Security (ADS)

• Azure Database administrator : End to End solution for Azure Always On config and setup, On - prem Data migration to Azure PaaS and IaaS environment, Azure Data factory (ADF), Lift and shift of on prem SSIS to Azure SSIS (ADF), End to end solution for Azure SQL Managed Instance on private VNet, (SSMA, SSDT, DMA, Ora client, V/S, VS code, DPA solar wind, DMS)

• DPM administrator: End to end solution for backup of on-prem and Azure cloud work load on System center Data Protection Manager (DPM), Azure Cloud Backup, File\folder backup MARSA

• Power BI: Configure Power BI Gateway, Power BI embedded on Azure Portal, Deploy and publish report from various data source via Power BI Desktop

• Experienced in Sandbox experiments, Azure Load balancer, Azure backup (Recovery Service Vault), DNS, Azure Active directory, ADS and (ADFS).

• Developed methodologies for cloud migration, implemented best practices and helped to develop backup and recovery techniques for applications and database on virtualization platform.

• Manage different AZURE environment for provisioning of Linux servers and services executed by the providers

• Experience on Power shell and JSON templates And MS Web Deploy for creating Websites, applying windows roles, features and deploying applications.

• Experience on Azure Data Factory (ADF), Shelf Hosted Integration Runtime (SHIR) configuration and setup, Linked services and Internal runtime

• System Center Data Protection Manager (DPM) installation, configuration and deployment

• Deploy Bomgar Appliance on Azure cloud

• Experience in Database administration activities such as installation, configuration, backup &recovery, database security and data transformation devices for on-premises + Microsoft Azure cloud environment.

• Migration and upgrading of SQL Server databases into SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014/2016/2017

• Implementing different types of high availability &disaster recovery scenarios like replication models

(snapshot, transactional), log shipping, database mirroring and clustering.

• Proficiency in performance tuning, query optimization, client/server connectivity, and database consistency checks using DBCC utilities, DMVs and DMFs.

• Managing multiple projects simultaneously, Interpersonal skill and team player, develop and maintain knowledge base articles

• Advanced knowledge on ITIL, change and Incident management Providing 24x7 on-call supports PROFESSIONAL EXPERIENCE

RED CEDAR CONSULTANCY LLC. WASHINGTON, DC

Azure Cloud & Database Engineer Jan 2019 –Present

• Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings, DNS settings, security policies and routing.

• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.

• Exposed Virtual machines and cloud services in the VNets to the Internet using Azure External Load Balancer.

• Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer.

• Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces

(NICs), VMs and subnets, Configure Site to Site, Pont to site VPN Connectivity.

• Setup Azure Virtual Appliances (VMs) to meet security requirements as software-based appliance functions

(firewall, WAN optimization and intrusion detections).

• Configure Window Failover Cluster by creating Quorum for File sharing in Azure Cloud.

• Convert existing Virtual Machine from Standard to Premium Storage Account. Patching and Validating of Virtual Machine in Azure.

• Monitor Azure Infrastructure through System Center Operation Manager (SCOM).

• Coordinating with Microsoft for increasing subscription limit like- Core limit and Cloud Services. Handling and Resolving Client's Issues remotely.

• Client Interaction over the Phone or Emails to provide instant response.

• Performed a review of the technology team and worked with leadership to define a growth plan to meet product development demands.

• Providing updates business partners in a timely manner and documented technical and programming specifications.

• Configured Azure Data Factory, Shelf hosted integration runtime (SHIR), linked services, internal run time to make the connection to on- prem environment for data migration.

• Configured VNet integration for Azure SQL managed instance to connect the PAAS service via Point to site VPN Gateway for Azure App services

• Migrated on- perm SQL database to Azure cloud environment and provided all the solution to select and configure the PAAS and IAAS environment on Azure.

• Hugely involved on trouble shooting the performance issue on Azure SQL managed instance on various perspective, scale up the resources, fine tune the query of SQL server, managed the storage I/O.

• Configured and setup the Power BI gateway to establish the connection to Azure SQL managed instance to secure the environment by not enabling the public endpoint on SQL MI site.

• Performed the architecture diagram for connection for Azure SQL database and Azure SQL managed instance by enabling the database level firewall setting and Active directory authentication.

• Hugely involved on trouble shooting Azure VM level issue, restore the corrupted VM, attached back the NIC and data disk, swap the OS disk.

• Configured ADDS as PAAS environment and setup the windows virtual Desktop Solution.

• Performed Security task on Azure to keep the environment comply with Azure Secure score, worked on Azure blue print, azure artifacts, Advance Data security (ADS), Azure Sentinel

• Generates reports and performs analysis on usage, capacity and performance on stage and backup systems

• End to End solution for Azure SQL High Availability solution for Disaster recovery (VM creation, cluster configuration, windows, Failover configuration, Always on Group configuration)

• Performed solution for MS access front end application and back end database configuration. (migrated MS access database to Azure SQL database and configured the SSIS package on Data factory to jobs)

• Configured and setup end to end solution of package via V/S for data source on-prem oracle to destination Micro dynamic using Kingsway soft.

Environment: Microsoft Windows Azure, Windows server 2012/R2/2013/2016/2019, Linux server, Red hat, ubuntu,, Windows PowerShell, Azure CLI, Azure DevOps, Microsoft Azure Storage SCOM (System Centralized Operation Manager, ADiTaas tools, Service Now, Solar winds DPA, Net apps SM for SQL Server, OCUM (On Command Unified Manager) and SharePoint.

PRACTICAL SOLUTION INC – WASHINGTON, DC

Azure Cloud & Database Administrator, strategic planner April 2018 –Dec 2018

• Architected & Implemented public cloud infrastructure in highly distributed environment

• Creating, validating and reviewing solution and effort estimate for data center migration to Azure cloud environment.

• Cloud Administrator on Microsoft Azure configuring virtual machines, storage accounts, and resource groups.

• Remote login in to Virtual Machines to troubleshoot, monitor, and deploy applications.

• Managing Windows 2012/2016 servers, troubleshooting IP issues and working with different support teams.

• Using Power shell to write +debug scripts to automate the processes and conduct migration of VMinvolving copying and creating of VHDS.

• Configuration of Microsoft DevTest Labs to migrate the virtual machines from one subscription to another subscription.

• Managing day to day activity of the cloud environment, supporting development teams with their requirements.

• Creating Labs, Virtual Machines along with setting up policies and using Formulas and Custom Images to deploy the network.

• Work on Visual Studio Team Confidential to manage a backlog of daily activities.

• Designed and configured Azure Virtual Networks (VNets), subnets, Traffic manager, Express route, Vnet peering, point to point VPN.

• Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces

(NICs), VMs and subnets.

• Installed Configured and deployed System center Data Protection Manager to setup the file, application, disk and volume level backup for on-prem and cloud infrastructure

• Troubleshooting Azure VM OS disk by restoring on Hyper-V, diagnosis issues, and standing up VM on azure.

• Migrated On-Premises SQL databases to Azure VM, Data scrubbing, cleanings and maintained the maintenance task.

• Deploy the Bomgar appliance to Azure VM and supporting to helpdesk for operational activity.

• Configuration license for evaluation use of Fortinet Edge server and upgraded the firmware.

• Collaborated with SMEsto document recommendations for various application modernization architecture.

• Provide hands-on technical support to client and for database and Azure cloud enhancements + upgrades Environments: Windows Server 2003/2008/2012/2016/R2, SQL Server 2017/ 2016/2014/2012/2008R2/2008), ASP.net Applications, IIs Application Serve, SCCM (System Centralized Configuration Manager, SCOM (System Centralized Operation Manager, Service Now, Solar winds DPA, System center Data protection manger (DPM), Bomgar Appliance, Fortinet and Firmware. LAM RESEARCH CALIFORNIA

Database Administrator Nov 2016 –Mar 2018

• Administered VMware and Hyper -V tools to virtualize the server and allocating resources to each VM machine.

• Set up cluster environment for load balancing and high availability of Windows servers, Configuration of Static & Dynamic IP addresses, heartbeat connection between the nodes using network editor, partition of disk through ISCSI, configuration of cluster and MSDTC IP address.

• Installed and configured SSL certificates in web servers and enabled secured (https) transactions.

• Implemented database Security including creating Logins and Roles for users to access the database. Managed security logins and worked with Windows authentication, SQL server authentication and mixed modes.

• Hands on Experience in making documentation for issues we worked on and provide knowledge transfer to other team members to share the workload when we get multiple priority issues at the same time.

• Managed and Administrated the SQL Server 2016/2014/2012/2008R2/2008 production and Non- production servers

• Upgraded/Migrated SQL Server 2008/2005 databases to SQL Server 2014/12 databases.

• Migrated SQL Server 2008 databases to SQL Server 2016/2014/2012 databases including DTS to SSIS packages.

• Performed backup using backup compression and Data compression in SQL Server 2014 on clustered environment.

• Handled up to 2.5 to 4 TB Size databases with clustered environment.

• Provided application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.

• Extensively worked on Profiler, Perfmon, DMVs to tune the databases, servers and query tuning.

• Managed Security using SQL Logins, Roles and Security Modes for various users.

• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.

• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.

• Set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.

• Configured and deployed SSIS Packages from Test to Production Environments.

• Created, deployed and managed reports using SQL Server Reporting Services(SSRS)

• Supported 24 X 7 Production environment

Environment: Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), ASP.net Applications, IIs Application Server Windows Server 2008R2, 2012, 2016AD, SCOM (System Centralized Operation Manager, ADiTaas tools, Service Now, Solar winds DPA, Net apps SM for SQL Server, OCUM (On Command Unified Manager) and SharePoint. DATA GROUP VIRGINIA

Database Administration July 2013 – Oct 2016

• Installed, configured, and Managed SQL Server 2012, 2008 R2, 2005 database instances.

• Managed development, test and production environment of SQL server Database Server Instances.

• Upgraded from SQL server 2005 to 2008R2 and 2012.

• Involved in setting up,managing and maintaining High availability technologies:Log shipping, Mirroring and Replication

• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.

• Involved in implementation of replications like Snapshot and Transactional.

• Worked onSQL Server Clusters Active - Passiveon mission critical financial applications.

• Applied SP (service Pack) and Hot fixes on SQL server database instance - standalone and HA environment

(Log shipping, Mirroring, Replication and clustering Database servers)

• Managing security, which includes monitoring and controlling database access, assigning permissions to application owners.

• Involved in partitioning Databases and Tables for better Performance issues.

• Implemented Databases log shipping using the Lite-speed.

• Created SSIS packages using proper control and data flow elements.

• Configured SSRS, setup data source and data set and deploy the report in reporting server.

• Hand on Experience on Change control management tool – BMC Remedy user for problem tickets and Change requests.

• Deployed packages on different servers by configuring it.

• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.

• Involved in upgrading the instance of development environment of SQL Server 2000 to 2005

• Partitioning tables to achieve better performance for access and writes.

• Resolving locking (Dead Locks) and blocking issues.

• Troubleshooting SQL server performance problems using Profiler and Performance monitor.

• Capacity-planning, maintaining run book documentation on all the servers in word, pdf and excel formats.

• Managing and Coordinating with the offshore team on daily Database maintenance activities

• Analyzed query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.

• Automated and enhanced daily administrative tasks, including space management, object alteration, backup

& recovery, and performance monitoring.

• Involved in SQL Server Cluster and Database Mirroring implementation. Environment: Windows 2003, 2005, 2008, 2012, Windows NT, SQL Server 2005/2008, lite speed, SQL backup, ETL, SSIS, SSRS, OLAP, MS Excel,System Monitor / Performance Monitor, Third party tools IT Solutions VA

Technical Support Specialist March 2012– June 2013

• Provided phone support for customer technical issues

• Assisted users with OS installation on various machines

• Resolved connectivity + hardware issues on site and online using Team viewer

• Maintained records of daily data communication transaction, problem and remedial action take

• Responsible for database backup and recovery such as build the master database; if crash, recover the master and user database in point in time.

• Installed SQL server and Migration of SQL Server 2008 to SQL Server 2008R2/2012 using side by side strategy.

• Handled multiple tasks and responsibilities independently as well as a proactive team member.

• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach

• Environment: windows 2003/2008/R2 SQL SERVER 2012/2008R2/2008/2005, Microsoft Dynamics, Microsoft SQL Server Integration services SSIS, Windows Server, DTS, SQL Profiler. Certifications

Microsoft Azure Architect Technologies

MCITP - 2008, (Microsoft Certified IT Professional - Database Administration) MCITP - 2012, (Microsoft Certified IT Professional - Database Administration) CompTIA – Certified CompTIA Security+

Education

*Tokyo University of Agriculture (Bio Environment)

*Certification of Proficiency of Japanese Language and Culture, Japan

*BBS, Tribhuvan University, Nepal

Additional Information

U.S. Citizen

Active Public Trust Clearance

Contact this candidate