Sql Server Manager

Gangadhar PEVR

Mobile: +1-609-***-**** Email: *****************@*****.***

SUMMARY

Having overall 10 years of IT experience

Expert in handling Multiple Complex Projects for internal as well as external customers

Expertise include:

oWindows Server Administration

oIT Infrastructure Operations

oWeb Application Support IIS

oClient Interactions

oAzure Operations

oVMWare Administration

oSQL DB Administration

oRequirements Analysis

Conversant with WINDOWS Server Administration, AD, Group Policies, DNS, DHCP & FTP

Proficient in MS SQL Server Data Base Administration & T-SQL

Experience on Azure IaaS, PaaS, SQL Cloud and Automation of tasks using Azure Power Shell

Experience in installing, configuring and managing infrastructure using VMware technologies viz. ESX/ESXi 4.0/4.1, 5.0/5.5, 6.0,6.5 vSphere 5.0, vCenter, VMware View 5.0/5.5, 6.0 VMware vCenter Converter P2V

Administration of VMware Virtual Center and virtualization services VMware DRS, VMware HA, VMotion and SVMotion.

Experience in configuring VMware standard vSwitch & dvSwitch.

Experience in cloning VMs and deploy new virtual machines from clones.

Experience in migrating the virtual machines between the ESX (i) Hosts using cold migration and VMotion.

Experience working with Hyper-V & MSCS Clustering(FCM)& Hyper-V Migrations to 2016 OS

Converted many (P2V) physical servers to Virtual Machines using VMware vCenter Converter part of decommission legacy servers effort.

IIS Configuration, Administration and Troubleshooting the live site issues

IIS Migrations from IIS 6 to IIS 7.5 & 8.0

Perform deployments on Test, PPE & Production environments using manual & Automation tools(Octopus)

Monitor production website/applications using Keynote, SiteScope & SCOM

Experience using Windows, networking and application tools such as Network Monitor, Performance Monitor, Telnet, Tracert, NSLookup, Fiddler Web Debugger, IP Scanner, SQL Profiler and Event Logging

Experience on LAN/WAN administration, TCP/IP & IPSEC

Experience on Windows NLB, Hardware NLB(Netscaler), Global Load Balancer(Akamai) and Firewalls(CISCO)

Creation of VIP (Virtual IP) for production servers, Adding/Removing Nodes from VIP

Hands on Experience on SCOM, SCCM & SCVMM

Experience on backups using Symantec, Commvault, Veritas Netbackup

Hands on experience on Storages P2000, P2324, HP 3PAR, HP OA,3PAR & SAN

Experience in EMC SAN LUN creation, LUN masking, Raw Disk Mapping and Storage pools

Expert knowledge on configuring hardware iSCSI and NFS storage to VMware ESX (i) hosts from vSphere client.

Expertise in building Microsoft Windows 2012,2008 R2, 2008, 2003, 2000 servers using HP Smart Start, Array configurations, diagnosing server, Updating Firmware and PSP, Application Software under multi-platform environments, Server and Workstation Hardening and validation process, deployment & monitoring physical Servers.

Excellent skills in patching and hardening Win2000/Win2003/2008/2012 servers using Windows Update and also by using the staged patches.

Expertise in Validating Server build & Configuration according to the Standards.

Expertise in identification threats.

Exceptional skills in critical issue identification and resolution.

Expertise in Symantec Endpoint Protection Antivirus

Advanced experience in Patch Management (Planning the schedules by coordinating with stakeholders and implement them without application downtime (Production, UAT and Test Environment) and Install Critical Hardware updates.

Provided 24/7 On Call production support onsite and remotely on rotation basis.

CERTIFICATIONS

Completed ITIL Certification

Certified on MCITP Server administration certification (70-640, 70-642 & 70-646)

Certified on Implementing Microsoft Azure Infrastructure Solutions (70-533)

TECHNICAL SKILLS

Microsoft Products and tools

Active Directory Domain Services, AD lightweight Directory Services, AD Certificate Services, Active Directory Federation Services, Active Directory Rights Management Services, DNS, Exchange 2010, Hyper-V, WSUS server, PowerShell, SQL Server 2008, SQL server 2012, Microsoft System Center Configuration Manager, Microsoft SCVMM 2012, Hyper -V 2008 & 2012, IIS 6, IIS 7, DHCP, TCP/IP

VMware Platform Skills

vSphere 5.5/5.1 / 5.0 / 4.1 / 4.0, ESXi5.5/5.1 / 5.0, ESX 4.1 / 4.0, Virtual Center Server, VCAC5.1,5.2&6, VDI, VMware View4.0/4.5&5.0, VMware vCenter Orchestrator, HA, DRS, Storage vMotion, Site Recovery Managers, Host Profile vApp, VMware vCenter Heartbeat, VMware vSphere Client, VMware Thinapp, P2V, V2V, VMware Consolidated Backup, VMware Management Assistant, Capacity Planning, PowerCLI, Plate spin Power convert

Server Operating System

Microsoft Windows 2000, 2003, 2008 R2, 2012, 2012 R2,2016

Management Tools

HP Onboard Administrator, HP Virtual Connect Manager, CISCO UCS, CIMC, Avocent DS View, Putty, System Centre Virtual Machine Manager, McAfee DLP software, SCCM, SCOM, Microsoft Robocopy GUI, Solar winds IP Address Tracker, Password Updater tool.

PROFESSIONAL EXPERIENCE

Projects Handled: September 2016 – Till date

Project #1: GE Power & Digital

Client: GE (General Electric International Inc, US)

Team Size: 13

Description:

GE will help customers achieve higher #efficiency and lower emission on Coal-based Power Generation.

Deliverables:

Actively Participated on upgrade of VMware vSphere Suite ESXI from 5.0 – 5.5.

Installation and Configuration of vCentre update manager.

Running Update and Patches through ESXI Hosts.

Worked on Update VMware Tools

Installation and configuration of Windows servers 2008 R2, 2012, 2012R2, 2016 Virtual Machines in the ESX host clusters.

Worked on Upgrade/ Migration of SQL server.

Actively Participated on Virtualization of the Environment using Azure Cloud

Did work on Integration of VM Ware to Hyper V with Virtual Machine Manager.

Worked on Building of and Set up of Hyper V Operation Manager Console.

Installed and Configured to Expand Hyper V Development environment.

Did Build and Set up of Hyper V 2012 Cluster(FCM)

Worked with Ability to isolate LAN connectivity issues for Systems and ability to resolve Layer 1 problems.

Worked on Hardware management experience (troubleshooting/repairing server hardware, performing RMA's)

Configured medium sized Microsoft Active Directory environment. (Minimum of 2500 accounts).

Worked on Automatic Tool Conversion VMware VMDK to VHD Tools.

Participated on Purging and Decommissioning of Old vSphere Infrastructure 5.0 Virtual Desktop’s Vm’s, Server Vm’s Data stores ESXI Hosts.

Actively Participated on Failover Capacity Management for both Hyper V and VMware Environment.

Coordinate Server Migration Time with stakeholders

Clone VMware Virtual Machine (Rollback if necessary).

P2 V and V2V migration from VM Ware to Hyper V.

Deploy VM’s from preexisting ISO image managed in central location and reducing duplication.

Worked on the Upgradation of Netuitive (VMware Monitoring Tool) from 5.5 – 6.2.

Worked on Building Servers as per the company standards.

Expertise in Validation and configuration of Servers according to the standards.

ESXi Host build ILO Configuration/Base OS Setup/Firmware/Security Scans

Expertise in SCCM Patch Management and Microsoft Security updates

Actively Participated on VMware Air Watch Console in Deploying devices to the users and maintaining the console.

Participated on Upgrade of VMware 5.5 3b update.

Migration of Storage from XP – 3PAR in VMware 5.5 Environment.

Expertise skills in Patching and Hardening Win2000, win 2003/2008/2008R2/2012 using staged patches

Work experience with LTO tape technology, agent based backups, backup schemes, rotation schedules, off-site storage by schedule based.

Creating and setup VCO Agent, Endpoint and Group configuration.

Diagnoses and troubleshoots problems with Servers, software, and communications devices

Hands-on experience in Deployment, Installation, Administration, Maintenance and Troubleshooting of various Microsoft Operating Systems and Application, Networks and Computers.

Experience with Virtualization technologies like Installing, Configuring and administering VMware ESX/ESXi and created and managed VMs (virtual server) and also involved in the maintenance of the virtual server.

Deploy IIS applications on DEV, QA, PreProd & Prod environments

Monitoring & troubleshooting production sites and make sure they are live

with 0%downtime (using Akmai & Sitescope)

Involving in weekly and monthly production code pushes

Handling the Hardware Load balancing (Netscalars) and Global DC level Load

balancing and Content Delivery Network (CDN) using Akamai.

Perform backups using Symatec and Veritas Netbackup

Perform Antivirus Systems Management using Symantec Endpoint Protection.

Project #2:

Microsoft Retail IT Stores September 2014- June 2016

Client:

Microsoft

Team Size:

19

Environment:

Software:

Windows AD, DHCP, DNS, Fail Over Cluster Manager(FCM), Hyper-V, SCVMM, SCCM, SCOM, Azure, Power Shell, NETMON, PROFILER, HLB(NetConf), SiteScope(Web URL Monitoring)

Database:

SQL Server 2005 / 2008 / 2012

OS:

All Microsoft Windows OS

Deliverables:

Server Administration such as Setting up Infrastructure for project teams based on the Regions and environments like Production/UAT.

Experience supporting Windows Administrator in an enterprise environment covering Windows 2008r2, 2012.

Providing Remote support for 2000+ MS owned Physical/Virtual servers comprising of Windows 2008r2/2012 r2 Operating System with Roles like Application, SQL, Web and File servers hosted in various Data center’s/Labs across the world.

Configuring and managing Virtual Machines using Windows Azure IaaS

Configuring and monitoring Cloud services.

Configuring Alert notification in Windows Azure.

Troubleshooting Remote Connectivity issues by using DS View, HP ILO.

Managing virtual machines using SCVMM, Hyper-V manager.

Trouble shooting the Remote Connectivity related issues SCVMM r2 consoles.

Creation of VMs using Hyper-V, FCM & SCVMM.

Experience working with MSCSS Clustering.

Security patching of VM's on monthly as part of Patch Management.

Responsible for tracking of all scheduled outages and maintenance activities like Data Centre migrations, Storage migration, Hyper-V migrations, VM host maintenance movements, power outages, Patching…etc. and communicating to stakeholders upfront with appropriate notifications. This will help them to inform customers well in advance about the outage and put their servers in maintenance mode.

Perform backups using Commvault Simpana, Veritas Netbackup

Having hands on experience on HP (OA Onboard Administrator).

Having hands on experience on HP ILO’s management (Integrated Light out)

Successfully performed changes in the environment during the change management windows defined by client.

Create and update a handbook with technical information on common issues and steps to fix them, processes to be followed and information on client infrastructure.

Work with multiple team and vendors on severity 1 issues and provide Root cause analysis

As per process, working with upstream technical support teams like Server IM for escalated P1 issues and taking necessary actions as suggested by them to minimize the number of P1 calls. Ex: Upgrade IPAK, RAM/Storage upgrade, Rebuild OS…etc.

Complaint ticket booking through ITSM & SCSM Incident Management Tool and ITSM Change Management Tool

Coordinated with different Application teams for getting the downtime required for all the scheduled activities on servers as per the schedules.

Maintaining 100% SLA in supporting Customer issues.

Support and Respond On-Call site to site for end user issue.

Microsoft infrastructure architect and technical project manager specializing in global deployment, transitions, and migrations to the latest versions of Active Directory, Exchange

Handling escalated issues and closing the Incident with in the SLA

Following ITIL Processes (Change Management, Incident Management & Problem Management etc.)

Project #3:

Volume Licensing In A BOX (VLIB) Jun 2013 – Sep 2014

Client:

Microsoft

Team Size:

11

Environment:

Software:

Azure, Power Shell, NETMON, PROFILER

Database:

SQL Server 2005 / 2008 / 2012

Tools:

Octopus, IIS

OS:

All Microsoft Windows OS

Description

Microsoft Enterprise Commerce IT (ECIT) simplified its complex production ecosystem by adopting innovative Azure IAAS Cloud-based solutions.

The following are Azure models adopted in the production ecosystem:

1. Azure IAAS Model

2. Hybrid Model – Azure IAAS, Hyper-V, and On-Premise

3. Hybrid Model – Azure IAAS and On-Premise

Deliverables:

Deploy on premises infrastructure including web application and Databases to Cloud (Using Azure, SCVMM and Nebula Cloud Mechanism)

Building VM's based on the requirement using Windows Hyper-V, SCVMM, Nebula and Azure Cloud

Administer and manage Host machines and VMs using SCVVM, SCOM, SCCM

Convert Physical servers to Virtual servers (Web and SQL) using SCVMM

Automation of manual process using Power Shell

SQL DBA and scripting

Creation & Renewal of SSL Certificates

Project #4

STO Ops Jan 2012 – Jun 2013

Client:

Microsoft

Team Size:

10

Environment:

Database:

SQL Server 2008 / 2012

Tools:

Keynote, Akamai, Netscalar, Azure, PowerShell

OS

Windows server 2008 / 2012

Description:

Microsoft Enabling Platform experience (EPX) provides online content for IT Professionals and Developers that use the MS Stack (MSDN/ TechNet/ CodePlex/ Blogs/ Wikis/ Galleries etc.)

Deliverables:

Maintaining around 2500 Web servers to handle the load of MS critical business site (msdn and technet) where Availability 99.99% and Page Load time of less than 2 sec.

Handling the Hardware Load balancing (Netscalars) and Global DC level Load balancing and Content Delivery Network (CDN) using Akamai.

Maintaining the Windows Azure instances to balance load along with On-premises servers

Handling few critical servers associated to WCF and Proxy environment.

Building Hosts and VM's based on the requirement using the windows Hyper V.

Installation and configuration of SCVMM, maintaining Hosts and VMs from SCVVM

Convert Physical servers to Virtual servers (Web and SQL)

Installing and Configuring the Windows Server 2008 R2/WIN 8 and SQL Server 2008 / 2012 based on the requirement.

Perform monthly patching on 1000 servers

Perform the Service account password resets and SSL Certificate rotations.

Maintaining the replication and mirroring in the environment.

Perform Monthly releases to push the new changes and bug fixes in the environment.

Troubleshoot and fix the live site incidents with in minimum time.

Implement new changes in the environment to improve site performance.

SSL certification creation and renewals

Perform backups using Symantec

Project #5:

CLUBBING Jun 2010 - Jan 2012

Client:

Microsoft

Environment:

Software:

Windows server 2008 & IIS 7

Database:

SQL Server 2005 / 2008

Tools:

Perfmon, Netmon, Omniture

Description

Microsoft Club Bing offers members a fun way to experience Bing's rich, useful search results, while also rewarding members with prizes and donations to charities. Catering over 40 Million Users, Microsoft Club Bing offers a unique way introducing more people to the advantages of searching with Microsoft Bing Search.

Deliverables:

Hands on experience on SQL Server 2008R2/2012/2014/2016 versions.

Handled Large size databases up to 6TB

24 X 7 Production Database On-Call Support following the escalation matrix

Supporting the team in high priority issues.

Responsible for installing, configuring SQL server cluster and troubleshooting issues with SQL Cluster

Monitoring HADR technologies Always on, Clustering, Replication

Monitoring & Maintaining Active/Passive clustering

Performed SQL cluster upgradation from SQL Server 2008R2 to SQL Server 2014

and 2016 Versions

Migrating SQL Databases from on premises to SQL Azure

Strong experience in Capacity Planning, Implementing Backup and Recovery Strategy for application and database.

Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes.

Increased RAM in SQL Server clustered environment to avoid performance issues

PowerShell scripts for automation on backup schedule

PowerShell to automate multiple database SQL Server restores

Monitor Disk space using PowerShell

Monitor a SQL Server Cluster using PowerShell

Organization#:

DATAWISE MANAGEMENT SERVICES INDIA PVT LTD

Jan 2007 - June 2010

àClient (1) : APTION

Organization : DATAWISE

Period : Jan 2007 – Oct 2009

àClient (2) : NEXUS

Organization : DATAWISE

Period : Oct 2009 – June 2010

Deliverables:

Assembled, configured, installed, tested and repaired computer hardware and s/w.

Management of Active directory and windows server infrastructure.

Provided technical support for the users and resolving software/hardware issues.

Performed hands-on administration and monitoring of Local Area network (LAN).

Experience with solar winds monitoring tools for servers and network devices.

Resolved Microsoft desktop applications (Word, Excel and Outlook) issues.

Managed the installation and configuration of Windows 2003 Server/Workstations.

Created user and computer accounts on the Active directory users and computers.

Configured servers for DHCP, WINS and DNS services.

Installation, configuration and Administration of IIS web servers.

Provided Norton Antivirus support for virus security.

Administration of print servers and troubleshooting print jobs.

Installation and configuration of Domain Controllers and implementation of trusts.

Handled multiple tasks to meet project deadlines.

Develop and update the required network/system administration documentation

Installed and Configured Networks, and Wireless Access Point/Router with

security, TCP/IP, VPN, Content Filtering, Access Control Lists on router/switches

in both LAN/WAN and wireless networks. LAN Cabling, RJ-45 crimping, Labeling

Worked with Network Concepts such as OSI reference model, IP protocols such as

TCP/IP, IP addressing and subnets

Setup and configured various RAID 1 and RAID 5

Configured backups and recovery plans for windows based servers using

windows server backup utility

Responsible for troubleshooting network, database, applications, and web

performance issues. Documented and maintained automation scripts for

administration of servers

Education:

Bachelor of Technology (Computer Science), JNTU Hyderabad, India

Diploma in Polytechnic (Computer Science), JNTU Hyderabad, India

Contact this candidate