Sql Server Windows

Lakshmi Bindu Yerneni

Email: *********@*****.***

Cell no: 713-***-****

Professional Summary

5+ years of IT industry experience in installing, configuring, managing and supporting Web applications on Internet Information Services (IIS) servers and SQL database, SQL Server Integration Services (SSIS) and Reporting Services (SSRS) in environments that run-on Windows server 2008, 2008R2, 2012, 2012R2.

Proven excellence in ensuring scalability, superiority, consistency, availability and efficiency of enterprise level websites, Web & Database Servers and Azure portals.

Solid 5+ years of experience in Operations, troubleshooting applications and systems issues and provide high level technical support for Microsoft project activities directly related to the Universal Store Engineering, ECO-CSS and Retail store web infrastructure, including IIS servers and associated hosted applications.

Proactively managed SQL backend, responsible for setting up and test Disaster Recovery Environment (DR) and maintain the clustered environments for high availability.

Good experience in installing, configuring and supporting SQL Server 2008/2012/2014 in large scale environments.

Good experience in installing and configuring SQL Server Integration Services and Reporting Services as per application and monitoring requirements.

Good knowledge and experience in implementing SQL disaster recovery methods like Replication, Log shipping, mirroring and SQL Always-On cluster.

Good knowledge and experience in Azure platform development, deployment concepts., hosted cloud Services, platform service and close interface with Windows Azure multi-factor authentications.

Good experience in Private Cloud and Hybrid cloud configurations, patterns, and practices in Microsoft Cloud Infrastructure Azure and SQL Azure and in Azure web and database deployments

Good experience in various projects, functions, programs, and service areas in SCM process using various SCM tools

Good experience in designing a Structured Process for Application Life Cycle Management

Good experience in configuring and supporting websites running on IIS 6.0/7.0/7.5/8.0/8.5 and managing Hardware load balancers for high availability.

Managed and supported CRM web applications and backend servers hosting Microsoft Dynamics CRM 4.0, 2011 and 2013 in different environments like Training, Pre-Production, and Production.

Good experience in Microsoft Dynamics CRM based application frontend and backend migration from CRM 4.0 to 2011 and CRM 2011 to 2013.

Participated in updating servers security patches and application related updates using automated technology employing PowerShell 3.0, 4.0 and Workflows.

Experience in analyzing test results and submitting the bugs using Visual Studio Team Foundation Server (VSTFS) and Visual Studio Online.

Hands-on experience in monitoring health status of multiple servers (Web & SQL) using System Center Operations Manager (SCOM) and Management Data Warehouse (MDW) tools.

Good experience in automation using PowerShell scripting to patch, manage and audit wide range of servers such as Web cluster, SQL and MSCS cluster, Virtual services clusters, DFS Servers, standalone servers, etc.

Have exceptional knowledge and experience on debugging tools like SQL Profiler (for DB issues) and Netmon, Fiddler, Log parser tools (for Web and network related issues).

Good experience in Virtualization using Hyper-V and SCVMM.

Good experience in working with end users and customers to resolve production issues.

Experience in working with team in setting up cluster environment for Load balancing NLB, F5 Big IP, NetScaler and high availability of Windows servers.

Areas Of Expertise

Operating Systems : Windows 2003/2008/2008R2/2012/2012R2, Microsoft Azure

SQL Servers : SQL 2005/2008/2008R2/2012/2014 and 2012/2014 Always On, SSIS & SSRS, SQL Azure

Web Servers : IIS 6.0, 7.0, 7.5, 8.0, 8.5

Languages : Basic knowledge in C# and .NET

App-Servers : Microsoft Dynamics CRM 4.0/2011/2013/2015/2016/Online, Dynamics AX, Basic knowledge in SharePoint Server 2007/2010

Load Balancing Tools : NLB, Basic knowledge in F5 Big IP, NetScaler and Akamai

Monitoring Tools : SCOM, SCO, VSO, Gomez, Sitescope, Xpert, CHECKMK, MDW, SQL Profiler, Fiddler

System Center Tools : SCOM, SCVMM, Basic knowledge in SCO

Virtualization Tools : Hyper-V, SCVMM

ITIL Ticketing Tools : ITSM, MS Ticketing, Service NOW, ICM (Incident, Change and Problem management)

Scripting : PowerShell (3.0, 4.0 and Workflows), Basic knowledge in Batch Scripting, T-SQL

Certifications

Database Administrator 2008 (Certification Number- E421-6560).

SQL Server 2008, Implementation and Maintenance (Certification Number- E420-7843).

Windows Server 2008 (Certification Number- E420-0188).

Windows Server 2008 Network Infrastructure, Configuration (Certification Number-E420-0186).

Windows Server 2008 Active Directory, Configuration (Certification Number- E418-9191).

EXIN-AXELOS - ITIL ® Foundation Certificate in IT Service Management (ITSM).

Academic Credentials

Degree

University

GPA

Pass Year

Master of Science

University of Houston Clearlake – Houston, TX, US

3.36 GPA

Dec-2012

Bachelor of Technology

DVRHS MIC College of Technology

(affiliated to JNTU Hyderabad), Kakinada, AP, India

3.3 GPA

June-2011

Professional Experience

OSLO Solutions LLC

Client- Microsoft Corporation, Bellevue, WA, 98008

August 2016 – Present

Deployment and Operations Engineer

Project Details: Microsoft Dynamics CRM 365 Services

Duties and Responsibilities:

Coordinate with CRM Dynamics Operations and Build Engineering team on re-occurring tasks like application code installations and upgrades, Servers maintenance (Web and SQL) and troubleshoot & fix system issues for 24*7 service availability.

Responsible for upgrading core CRM product servers from 2013(6.0-Leo) to 2015(7.0-Vega) and from CRM 2015 to CRM 2016(8.0, 8.1, 8.2)

Responsible for taking ownership on Post Release support by providing 24*7 support.

Platform upgrade (On-premise and Azure VMs), installing/deploying IIS services and Windows OS, SQL server installation (database, Integration and Reporting Services) and management, hardware load balancing, scripting, automation, combination of Systems and Web administration.

Setup, configure, manage and support MSCS/SQL Active/Active, Active/Passive and SQL Always-On clusters.

Implemented high availability with Azure Classic and Azure Resource Manager deployment models

Design Azure Resource Manager (ARM) template and build steps through scripts using PowerShell scripting.

Automating in azure for creation of subscription, Storage Account and tables using Windows PowerShell

Work in Private Cloud and Hybrid cloud configurations, patterns, and practices in Windows Azure and SQL Azure and in Azure web and database deployments.

Responsible for debugging and diagnosing platform outages on cloud platform.

Build and configured integrated automated Continuous Integration CI build with Visual Studio Online.

Work and coordinate on Incident and Change management process using Visual Studio Online(VSO)

Designed a Structured Process for Application Life Cycle Management.

Responsible for Configuration Management, Build, Deploy, Release Management and Quality Assurance.

Create customer CRM sandboxes on request, troubleshoot the accessibility issues of the created CRM sandboxes

Setup and configure SSIS & SSRS in environments dependent on these requirements. Provide post installation support.

Work on SCOM and Management Data Warehouse (MDW) tools for application monitoring and reports generation.

Maintain databases on high availability by setting up SQL ALWAYS-ON high availability in SQL 2012 and 2014.

Scheduling SSIS jobs (SQL agents), migrating DTS packages to SSIS packages, using DTS upgrade wizard.

Design and build Hyper-v machines on clustered and non-clustered host machines running on Windows.

OSLO Solutions LLC

Client-Microsoft Corporation, Redmond, WA, 98052

October 2013 – July 2016

Service Operations Engineer

Project Details: Universal Store Operations/ ECO-CSS Services

Duties and Responsibilities:

Support Build team during application code releases, migration and tech upgrade projects and drive till GO-LIVE and till post release support completes.

Responsible to assist the CSS Tier-3 team in its coordinating and resolution of complex systems issues.

Responsible to migrate Microsoft Dynamics CRM based application frontend and backend from CRM 4.0 to 2011 and CRM 2011 to 2013.

Support web applications based on Microsoft Dynamics CRM 4.0, 2011 and 2013 in different environments like Training, Pre-Production, and Production.

Work on Incident and Change management for Business continuation through MS ticketing, ITSM and Service NOW tools.

Coordinate and work closely with Problem management team for return to service and problem mitigation to assure 24*7 service availability.

Monitor system performance and availability through SCOM and Xpert tool and engage appropriate teams in case of service interruptions.

Implement SQL disaster recovery methods like Replication, Log shipping, mirroring and SQL Always-On cluster.

Responsible for setting and configuring Disaster recovery environment for critical MS applications.

Setup, configure and manage MSCS/SQL Active/Active, Active/Passive and SQL Always-On clusters.

Responsible to configure SharePoint 2010 web farm integration into CRM Web application to establish a documentation storage location for the business users.

Responsible to configure and deploy web applications on IIS servers and configure database servers on windows 2008R2/2012R2 and measure web applications for performance and stability.

Created and configured virtual directories using IIS manger to support new additional applications located in different place to the existing web sites.

Support Distributed File System (DFS) and Replication (DFSR) environments to maintain several Terabytes of System folders and files redundancy during maintenance and patching in application.

Developed and improved PowerShell and batch scripts to check the System environment status before and after performing major changes.

Write PowerShell scripts to automate SQL tasks and windows administrative tasks

Using PERFMON, PROCMON, FILEMON tools for troubleshooting and to improve the performance and High availability of the web applications.

Worked on SQL Server 2012 migration from SQL Server 2008.

Generating reports as per the requirement using SSRS.

OSLO Solutions LLC

Client-Microsoft Corporation, Redmond, WA, 98052

April 2013– September 2013

Systems Engineer

Project Details: Retail Technology Group (RTG)

Duties and Responsibilities:

Installing security patches and scheduling regular maintenance to ensure the health and security on the servers.

Responsible for configuring and deploying web applications on IIS servers and configuring database servers on windows 2008/2012.

Handled security, performance, and tuning issues on Web servers to optimize performance

Responsible for debugging and diagnosing platform outages on cloud platform.

Performed various network security issues using various tools like network monitor, portqry, NS Lookup etc.

Working knowledge of Power shell in running automated queries for Patching, Imaging and Deployments.

Responsible for configuring, troubleshooting, supporting, and maintaining Dynamics CRM 2011.

Have experience in working with the Microsoft Dynamics AX and Point of Sales.

Configure, troubleshoot, support, and maintain Dynamics AX 2011 in a Systems Administrator capacity.

Installed and configured system center tool SCOM and Responsible for monitoring the health status of multiple servers using SCOM and troubleshooting them for high availability.

Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.

Replaced a transaction log replication with mirroring on a report server and took reports from snapshots of the mirror database.

Implemented Database Mirroring and log shipping.

Responsible for updating and maintain TSG’s, SOP’s for Tier1 and Deployment documentation.

OSLO Solutions LLC, Issaquah, WA

April 2012 – March 2013

Windows Administrator

Duties and Responsibilities:

Responsible for Installing, configuring, and supporting IIS 7.0/6.0 web servers on windows server 2008.

Created and configured different websites using different IP addresses, port numbers and host headers in IIS manager.

Deployed ASP.NET web applications, ASP.NET web services on IIS 6.0, IIS 7.0.

Bug Tracking and Reporting through TFS bug tracking tool.

Responsible for measuring the web applications performance and capacity planning by per analyzer tool.

Responsible for monitoring the health status of multiple servers using SCOM and troubleshooting them for high availability.

Analyzed IIS logs by using Log parser tool, DEBUGDIAG, WinDbg tools.

Good Experience Building Virtual machines using Hyper-v and VMWARE technologies.

Good experience in debugging ASP.NET and IIS related issues.

Used Power Shell scripts for automating daily tasks both IIS tasks and windows administrative tasks.

Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.

Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.

Worked with developers to tune the SQL queries using SQL Profiler.

Responsible for implementing and supporting high availability solutions with SQL Server including SQL Clustering/ Replication/Mirroring.

Implemented Database Backup, Recovery and Disaster Recovery procedures.

Played key role in L3 in providing the KTs for lower level and created KBs for their reference to resolve the user issues.

Attend day to day sync calls of the team to discuss the progress of the project.

Contact this candidate