SUMMARY:

• 8+ years of experience in Hyper - V administration, Application Management and Database Administration for very large and complex applications.
• Physical to VM/Cloud Migrations, Azure end to end migrations and deployments.
• Administration of Hyper-V environments for servers 2008, 2008 R2 and 2012.
• Configuring SQL AO’s, Web clusters, VIP’s, ACL, and SNAT. Ordering PHY servers, On Premise VM’s & Azure Subscriptions.
• Managed multiple applications in portfolios critical to business
• KPI management and experience in Security Patching, IPAK’s and Service Packs.
• Creating servers/clusters in Hyper-V and maintaining all hardware and storage requirements for all the servers in the portfolio
• Upgrading applications to Win 2012 and SQL 2014 and on both cloud and on premise environments.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Hands on experience in configuring IIS.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Migration of servers and applications from one DC to another
• Expertise in remote control, patch management, software distribution, operating system deployment, network access protection, and hardware and software inventory

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008R2/2005/2000, MS Office 2003/2007/2010/2013

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, SQL Server Integration Services (SSIS), Data transformation services (DTS), and SQL Server Reporting Services (SSRS)Web Servers

IIS 6.0/7.0: Tools

Operating Systems: Windows 2003/2008/2012R2/2016 Server, Vista/7/Windows 8/8.1

Data Modeling Tools: Lite Speed, Red Gate, Fog Light, CommVault, Idera, Erwin

Reporting Tools: SQL Server Reporting Services, Crystal Reports.

Cloud: Azure

Virtualization: Hyper-V, VMWare

PROFESSIONAL EXPERIENCE:

Confidential, Renton, WA

Service Engineer

Environment: MS SQL SERVER, VISUAL STUDIO, Service Now, Windows Server, Microsoft Office, Microsoft SharePoint, Hyper-V, Azure.

Responsibilities:

• Installed, managed and administrated Win 2012/2008/2003 servers, MS SQL Server 2014/12/08 Production and Non Production Servers.
• Physical to VM/Cloud migrations and P2P migrations.
• Create and configure servers in Azure
• Configure live migration without using failover clustering using Hyper-V
• Provision and Administer Hyper-V hosts, Guest OS with SCVMM 2012 SP1 admin console.
• Performed Failover drill tests to check the High Availability during disasters.
• Hands on experience in provisioning Servers, SQL installs and clusters in Windows Azure.
• Deployment of SQL/Web applications in Windows Azure.
• Remote control, patch management, operating system deployment, network access protection, and hardware and software inventory
• Deployment of SSIS packages, jobs creation for efficient running of the packages.
• Collected business requirements from users and translated them as technical specs and design docs for development
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Patching of all servers with latest IPAK’s, Service Packs, Hot Fixes and Security Patches.

Confidential, Redmond, WA

Service Engineer

Environment: MS SQL SERVER, VISUAL STUDIO, ITSM, WINDOWS SERVER, SSIS, SSRS, Microsoft Office, Microsoft SharePoint, Hyper-V, Azure.

Responsibilities:

• Physical to VM/Cloud migrations and P2P migrations.
• Configuring SQL AO’s, Web clusters, VIP’s, ACL, and SNAT. Ordering PHY servers, On Premise VM’s & Azure Subscriptions.
• Configure live migration without using failover clustering using Hyper-V
• Manage and administer private clouds in Hyper-V infrastructure
• Hands on experience in provisioning Servers, SQL installs and clusters in Windows Azure.
• Remote control, patch management, operating system deployment, network access protection, and hardware and software inventory
• Deployment of SSIS packages, jobs creation for efficient running of the packages.
• Patching of all servers with latest IPAK’s, Service Packs, Hot Fixes and Security Patches.
• 24/7 production support for all the applications in scope.
• Change Management - On behalf of MSIT customers, Infrastructure engages Datacenter Services through established call tracking systems (ITSM Change) to submit Move/Add/Change requests on server platforms such as Server OS rebuild, Server OS configuration change, Server moves, Server decommission, IP/WINS/DNS add or change, ACL/VIP/SNAT add or change, Backup schedule add or change, OS Security compliance, Asset database update (ITSM), Server EOW/EOL notification, DC monitoring add or change.

Confidential, Houston, TX

SQL Server DBA

Environment: TSQL, MS SQL SERVER 2008/2012, QUERY ANALYSER, VISUAL STUDIO 2010, WINDOWS SERVER 2008/2012, SSIS, SSRS.

Responsibilities:

• Installed, managed and administrated the MS SQL Server 2012/08/05 Production and Non Production Servers.
• Installation of SQL on Windows 2003, 2008 &2012 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise datacenters. Patch applications.
• Handled up to 1.8 TB size database in clustered Environments.
• Used Bulk insert to load huge tables.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Monitored alerts using FogLight and Spotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Provided On Call Production support, hands on Remedy ticketing tool.
• Hands on experience on standalone configurations of SQL/Web applications in Windows Azure.
• Deployed the SSIS packages and created jobs for efficient running of the packages.
• Used Online Indexing and online Restoring in SQL 2008.
• Implemented new features like CLR integration on Development server.
• Expert in implementing the DDL triggers.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.

Confidential

SQL Server DBA

Environment: SQL Server 2000, Windows NT server, SQL Profiler.

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee’s requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.