I am a passionate Database enthusiast who is highly competent and motivated in owning, tracking and resolving IT application issues related to databases. I have been working as a database professional for around 7+ years and really enjoyed working with data throughout my career. I am currently working for the Microsoft's SQL team where I primarily focus on Performance Tuning, troubleshooting and performing in-depth Root Cause Analysis (RCA) for database related issues. Some of the key responsibilities that I took up in my career include responding to alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems in a diverse and often fast paced environments. I frequently writes on my blog http://sqlserverzest.com on various subjects regarding SQL Server technology and Business Intelligence. My passion for the community drives me to share my training and knowledge. When not working with data, I like to travel and explore hidden treasures in nature or go out for a run (a half-marathoner).
SQL Server 2012, SQL Azure, SQL Server 2008/R2, SQL Server 2005, SQL Server 2000
Web design using HTML, SharePoint, Word Press, Adobe Suite, Blogger
MicrosoftRedmond, WASr. SQL Server DBA10/2013 to Current
Presently working in the SQL support Team for the Microsoft Products & Services IT (MPSIT) group.
My main focus.
is on Performance tuning, performing Root Cause Analysis (RCA) and recommending any new features in SQL.
Server that can add value to a customer's SQL footprint.
Maintaining more than 20 mission critical applications.
Maintaining and configuring the Performance Data Collection which collects key SQL performance metrics useful for proactive monitoring and troubleshooting for complex database issues.
Collaborating with Infrastructure Management teams for any kind of Major Incidents & Complex Issues to figure out as per priority.
In depth knowledge on SQL internals with a strong troubleshooting skills in solving performance issues with the help of wait statistics and other in build SQL features.
Upgrading SQL 2012 servers to SQL Server 2014 RTM for Production environments Performed the new Cross Cluster migration of AlwaysOn Availability Groups for operating system upgrades for SQL 2012 server with minimal downtime.
Working on latest technologies like Analyze Migrate Report (AMR) tool released in the SQL Server 2014 version.
Working on Reporting Services (SSRS) for providing Proactive Database Performance Monitoring (PDPM) reports using the data from the Management Data warehouse (MDW) servers.
Performing in-depth Root Cause Analysis (RCA) on variety of SQL Server related issues.
Providing Escalation support for Production issues and lead Line2/Line3 teams Page 2 of 6 Hareesh Gottipati 15217 NE 16 Pl NE, Bellevue, WA 98007 | Phone (678) 994-7668 th Configure and support high availability features like SQL Server AlwaysOn, Database Mirroring, Transactional Replication and SQL Server Log Shipping.
Driving weekly Study Group meetings to help prepare team for attaining Microsoft SQL Server Certifications.
Migrating data from the old SharePoint site to the new Office365 team site for the MPSIT SQL Team and adding additional functionalities to the site.
Recommend and implementation of SQL Server standards and Best practices.
Troubleshooting Internet Information Services (IIS) issues related to website functionality and backend database connectivity.
Worked as a Production Support Engineer overseeing SQL Server 2005 through 2012 servers in a very large scale.
900 instances) environment.
Was also involved in leading a team of seven in a Global delivery model.
Played a vital role in developing a durable database backup and restore strategies partly in light.
due to the recent storm Sandy damaging one of the Data Centers hosting SQL Servers.
Initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes.
Setting up the new SQL Server 2012 feature AlwaysOn Availability Groups for Disaster Recovery and High Availability.
Member of Change Management panel responsible in reviewing and approving the production deployments Configuring and maintaining transactional replication for reporting purposes.
Working with application engineers on troubleshooting connectivity issues related to IIS and troubleshooting errors with the help of Worker Process, Failed Request Tracing and Log Parser modules.
Moving databases from on-premise servers to Microsoft Cloud platform (SQL Azure).
Working on Backup Remediation process to make sure all production servers are recoverable in case of failure/disaster Troubleshooting performance issues and working on Server and query optimization.
Analyzing and recommending on changes for maintaining standards and best practices in all the SQL Servers.
Redbox. OakbrookIL04/2011 to 02/2013
Hareesh Gottipati 15217 NE 16 Pl NE, Bellevue, WA 98007 | Phone (678) 994-7668 th.
Redbox specializes in the rental of DVDs and video games via automated retail kiosks.
It had over 40,000 kiosks at.
more than 34,000 locations around the US.
I was working in the IT group managing some Extra Large Databases.
ELDBs) and Highly Transactional Systems.
Reviewing service related reports (e.g.
database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs Installation and Maintenance of SQL Server 2008 R2/2008 on Production, Development and Test Environments along with configuring the RAID levels according to the best practices and standards Subscribing SQL Azure cloud services and managing and creating SQL Azure databases through windows Azure portal.
Setting up data sync from cloud to on-premise databases for reporting and data warehousing purposes and troubleshooting sync issues.
In depth working on Transactional Replication and database mirroring for very largedatabases (VLDBs) and highly transactional systems.
Implementing and maintaining Log Shipping as part of Disaster Recovery program and utilizing Transparent Database Encryption (TDE) for the databases being part of Disaster Recovery and data sensitive databases in general.
Daily maintenance of the production servers with weekly 24/7 support throughout the duration of the project.
Actively working with ETL developers and in deploying the SSIS packages into production.
Administering and deploying the reports and working on SQL Server Reporting (SSRS) Resolving and investigating dead locks and blocking using Server side Profiler traces Designing the Multi-tier Architecture of the SQL Server production boxes using Microsoft Visio.
Creating Backup strategies and scheduling them as a part of database maintenance plans and using striped backups for VLDBs.
Identifying and recommending the resolutions for the failed jobs in all the production servers.
Resolving blocking and long running queries issues and performing a Root Cause Analysis (RCA) Installation and Maintenance of SQL Server 2008 R2 on SIT, UAT and Production Environments.
Creating and maintaining Policies as part of automating and administering the servers using Policy Based Management (PBM).
Resolving and investigating dead locks and blocking using Server side traces on weekly basis.
Troubleshooting and identifying the resolutions for the failed jobs in the production servers.
Utilizing the SQL Server's best practices to implement maintenance plans and other regular maintenance tasks.
Hareesh GottipatiBellevue, WATechnology Assistant/SQL Developer08/2008 to 03/2011
Jawahar Knowledge CenterHyderabad, IndiaWeb Designer/ SQL Developer01/2007 to 03/2008
Jawahar Knowledge Center (JKC) is a non-profit initiative taken by the Government that attracts the best students.
from all over the state, providing them with a world class infrastructure and opportunities to apply their knowledge.
Alabama Productivity Center, University of AlabamaTuscaloosa, Al
The APC is a nonprofit organization at University of Alabama that works to improve Alabama companies' quality,.
productivity and competitiveness through the use of the University's research and educational resources.
I was part.
of the APC Technology Unit working on Data migration and maintaining the SQL Databases.
Creating and modifying Stored Procedures and T-SQL Queries for efficient data retrieval and consumption into the systems.
Creating Database Objects: Tables, Views, Constraints, Functions, Stored Procedures, Triggers, Rules, Defaults, and user defined data types.
Creating database Triggers and set up database mail to notify database admins for any new databases created across the Production Servers.
Importing data into SQL Server from MS Access databases.
Writing T-SQL Scripts for database backup jobs for daily/weekly jobs.
Create and manage databases across Development and Production instances using SQL Server Management Studio.
Usage of new compression Techniques in SQL Server 2008 for backup and restore jobs.
Creating Logins and Roles with appropriate permissions.
Creating and Maintaining Database Maintenance Plans.
Planning, analyzing and developing Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
Creating and managing database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
Creating Clustered and Non-Clustered Indexes to improve the performance of databases.
Hareesh GottipatiBellevue, WA
Phone (678) 994-7668 th.
to the challenging problems.
I was part of the team developing an Online Library System and databases supporting.
SharePoint servers that were used to store large quantities of documents Working on basic web design for building a user friendly online library portal using Adobe Dreamweaver and Photoshop and HTML Dealing with Customer Service Requests for constant maintenance tasks pertaining to information retrieval and report generation Creating Full text Catalogs and Indexes to enable the Full Text search feature for searching based on key phrases or synonyms searches.
This was especially important due to the documents being saved in the database servers.
Creating stored procedures, data reports, and version upgrade documentation & Visio diagrams.
Importing and exporting data from the servers and analyzing the trends in the customer details Creating and Maintaining Database Maintenance Plans for index rebuilding and update statistics for efficient data retrieval.
Page 6 of 6.
Education and Training
Master of Sciences:Engineering2011The University of Alabama, Tuscaloosa, USAGPA: GPA: 3.63Engineering GPA: 3.63
(2012) Member Professional Association of SQL Server (PASS) Member Toastmasters International (Public speaking) Publication Transient Heat Transfer In Nanoscale Particles (Link) Scholarship Received $1,200, to travel to Puerto Rico in Spring 2009 for Community Service
.NET, Adobe Suite, Adobe Dreamweaver, Photoshop, Ad, Backup, basic, Catalogs, Change Management, Encryption, Customer Service, Data Collection, Data migration, Data warehouse, Databases, Database, Database Architecture, data warehousing, delivery, Designing, Disaster Recovery, documentation, Driving, Engineer, ETL, features, focus, Government, HTML, IIS, Logic, managing, meetings, Microsoft Products, MS Access, C#, mail, Office, SharePoint, SQL Server 2000, Microsoft Visio, windows, Word, works, migration, operating system, optimization, Page 6, Pl, Policies, Press, profit, quality, RAID, reporting, research, retail, scheduling, Servers, Scripts, Shipping, Microsoft SQL Server, SQL, SQL
Server, SQL Server, statistics, Tables, Phone, T-SQL, Troubleshooting, upgrades, Upgrading, upgrade, video, Visio, Web design, website