Windows Administration, SQL Server Administration, Project Management

VIKRANT BAM 425-***-****) *******.***@*****.***

SUMMARY AND OBJECTIVE

A results-oriented IT Professional with 10+ yrs. of experience in IT Industry with strong understanding of Service operations, Project Management and Infrastructure Support. Proven abilities to plan, execute, monitor & deliver services and projects on schedule with emphasis on high quality & customer satisfaction. I have played various roles working in different areas of IT operations like Infrastructure Service Manager, Build Engineer, IT operations Manager including incident, Release & Change Management.

Implemented a program to optimize the capacity requirements that had resulted in overall reduction in our hosting expenses, saved millions of $$$ for business by removing unused infrastructures.

Built new environment within three months of short period which included, new 550 servers’ procurement, OS builds, SQL AlwaysOn Cluster, Failover Clusters, Remote Desktop (Web) Load balancing.

Decommissioned 250 + servers (Physical and VMs) to save millions of $$$ for business by migrating application and data to new environment.

Drove Windows and SQL Upgradation Project within my portfolio for 4500+ servers and took the space from 42% to 98% level within 3 months.

Completed over 5,000 IPAK's (security, service and driver patches) installations through automation which saved an estimated $350K by avoiding traditional manual supports costs and made 100% compliance.

PROFESSIONAL DEVELOPMENT, CERTIFICATION, SKILLS & EDUCATIONS

MBA in Information Technology

Master in Economics

Bachelor in Educations (B.Ed.)

Bachelor in Economics

Microsoft Certified SQL DBA

PowerShell

Windows Server

PMP Training

PowerBI Development

Azure Support

MS SQL Server

ITIL Foundations Training

WORK EXPERIENCE: SERVICE OPERATIONS & CLOUD MS (Microsoft Contract) - Redmond, WA - March 2015 to Present)

Project Lead Security Compliance and Maintenance

Maintain and scheduled manual security patch compliance. Performed update installations on bulk machines

Troubleshoot and resolve security patch installation issues, including server/software configuration and network issues.

Increased effectiveness by identifying issues and working to resolve/prevent, including server health/configuration, software agent health, server OU maintenance, database accuracy.

Scheduling and Installing latest and complaint SQL and Window’s latest patches and version

Project Lead Cloud Series: IaaS Migration

Migrating application to Azure and working with engineering team to complete testing and pilot migrations.

Resizing and Scaling Azure VMs as per the application’s requirement

Creating Snoozing Schedule for Azure VMs on usage basis.

Creating new Azure VM

Project Lead Infrastructure and Application Support (MSIT Business Process Units (BPUs)

Deploy internal Microsoft finance applications in multiple environments utilizing technologies including MS Build, IIS, SQL, PowerShell and Azure.

Driving infrastructure upgrade for applications including procuring new servers in various data centers.

Building out infrastructure requirements like SQL Always on, Failover Clusters, Hardware Load Balancing, Remote desktop Services etc.

Troubleshoot SQL jobs, Server and IIS administrating issues.

Monitor SQL Jobs, automating monitoring, creating scripts and websites.

Creating service Principal Name (SPN), Users and Service Account.

Ensured availability and stability of infrastructure by developing upgrade plans accounting for planned capacity, volume growth, and retirement.

Maintains and provide 24/7 support to day-to-day operations.

Tech Mahindra - Microsoft Contract (Service Deployment and Operations (SDO) September 2011 to March 2015

Infrastructure Service Lead Hosting Resource Recovery Program (HRRP)- Project

Frozen Server project is aiming to target servers that have had very low-to-no usage indicated through monitoring data. By targeting these servers, we intend to reduce SDO footprint through decommissioning servers that are under-utilized. Risk assessments are built into the processes and tools, including reaching out to server owner(s).

Reduce SDO hosting costs, free up capacity to reallocate as part of Capacity delivery strategy, and optimize our overall CI Inventory management

To develop a sustainable and repeatable Host Resource Recovery program by which we can recover compute resources systematically across all environments.

Infrastructure Service Lead Lighthouse Phase III & IV Project

The goal for Lighthouse project is to remediate VMs that reside on v1.0 Blades or Standalone Hosts by migrating to High Availability (HA) Hosts minimizing impact during host maintenance

Drove VM migration project for MSIT and helped with migrating over 6000 VMs to move to High Availability (HA) Hosts

Infrastructure Service Lead Data Center Re-IP Project

Servers to be RE-IP from old to new E3 network. The RE-IP is only for PHY discrete server. The VIP and SNAT IP will not change. But the node IPs will change. The DNS mapping to static IP will change. For static IPs assigned to MSCS Cluster / SQL Cluster will also modify these to new IP

Infrastructure Service Lead Physical to VM and EOL SAN Project

Improved performance optimization capability through new technology and Auto-Tiring solution.

Improved solution for Storage Allocation Service to application units and Maintain assets that have full hardware/software warranty coverage

Sr. System Engineer MSIT Stay Current Project

Managing infrastructure & maintenance service support project for Microsoft's Internal and 3rd party’s applications. Managed support & network maintenance services for Microsoft’s different business units and customers

Managed all infrastructures deliveries for customers like procuring new capacities which includes Physical Servers/Virtual Machines and servers on cloud with/without Window and SQL cluster configurations

Negotiated the downtime with business and drove the critical work like security patching, migrations over the weekends Managed resource scheduling as well.

Coordinated all security activities and compliance in accordance to CIO directed KPI’s Daily/Weekly in MSIT

Manage and define the strategy, process, and drive the execution, communication with customers, mitigate the risk, provide cost avoidance trend to the business weekly

Requirements gathering and analysis, time estimates, preparing design documentation, design reviews, development, testing and deployment of application enhancements, project planning

Answering the technical queries, driving the product initiatives and metric collection and analysis. Assisting business to keep all their infrastructure up to date as per MSIT standard

Rofous India Pvt. Ltd. (April 2010 to August 2011)

Worked as SQL Database Administrators on World map project for Google India Pvt. Ltd

SIS InfoTech Pvt. Ltd. (May 2009 to April 2010)

Worked as SQL Database Administrators and managed databases for the company.

Intellisis Resources Pvt. Ltd. (January 2007 to April 2009)

Worked as System Analyst

Contact this candidate