Raghu Mashetty

Sr. SQL Server DBA

636-***-****

actipu@r.postjobfree.com

Summary

8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005/2000.

Expertise include Administration, Database Design, Performance Analysis of highly transactional servers and production support for Large (VLDB) Complex and Critical databases.

Extensive experitise with configuring High Availability and Disaster recovery scenarios like Always On, Clustering, Mirroring, Log shipping and Replication.

Experience in AZURE VM management involving Configuring, Migrating, deallocating and Capturing images of Virtual machines in Windows Azure.

Experience configuring and working Microsoft SQL server 2005, 2008/R2, 2012 on AZURE and VMware Environment.

Documented Disaster Recovery plans and participated in disaster recovery drills.

Worked extensively on Multi-Subnet Clustering and Server consolidation. Troubleshooting Production issues, HA issues and AG alerts

Experience in implementing advanced features like Policy Based Management, Resource Governor, Data Collector sets, and Backup Compression Techniques.

Implemented the methodologies like Data partitioning,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, Online Indexing,

Experience in creating cubes using MS SQL Analysis Services. Developed star and snowflake schemas.Working in both MOLAP and HOLAP environments.

Worked extensively on DMV’s, DMF’s, Mail Setup, Jobs and Alerts, DTA, SQLCMD.

Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.

Expertise in setting up High Availability and Disaster Recovery(HADR) solutions such as Active/Passive and Active/Active Clusters.

Performed Sharding and Vertical Partitioning in order to suffice the Application through put and good experience in resolving SQL Server blocking and Dead Lock Issues.

Expert in Performance Tuning by Index Defragmentation, Optimizing execution plans, Proper usage of indexes, Index Rebuild, Reorg.

Experience working with Profiler and Server side trace.

Expertise in reading and understanding Execution plan and fixing query to execute with low cost.

Expert in handling parameterized Reports, Drilldown Reports using SQL SERVER REPORTING SERVICES 2005

Designed effective Maintenance Plans for Backups (Full, Differential and Transactional Log) and RPO, RTO to recover point in time data in in case of disaster of server/center

Expert in AZURE Blob Storage Management and migrating blobs.

Thorough Understanding of different RAID levels implementation and Performed methologies such as Disk Striping with/without Parity.

Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.

Upgraded databases from MS SQL Server 2000 to 2005,2012 and MS SQL Server 2008 to 2012, 2014.

Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.

Hands on Experience with using Data Modeling Tools such as Erwin and MS Visio.

Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.

Experience in SQL Server Reporting Services(SSRS) and Crystal Reports.

Overall database design that involves creating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.

Explicit expertise in installation and configuration of SCO(System Center Orchestrator 2012) and SCOM(System Center Operations Manager 2012).

Performed both single server and multiple server deployment of SCOM and its components.

Extensively worked on Data tier applications, deploying and managing dacpacs.

Hands on expertise on both Upgrading and Downgrading SQL Server to new versions and applying Service packs and Hot Fixes.

Expertise in implementing advanced methologies like Transparent Data Encryption (TDE), Page Level Compression, Column Stored Indexes.

Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.

Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.

Explicitly used third party backup tools like Lite Speed, Fog light and Red gate.

Creation and maintenance of Databases, creating Roles and managing user permissions and Data Warehousing.

Experience in Troubleshooting and documenting root cause analysis.

Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.

Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.

Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Develop and manage reports on SharePoint Server.

Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.

Monitoring and troubleshooting by checking Performance Monitor and Activity monitor.

TECHNICALSKILLS

Databases:

MS SQL Server 2014/2012/2008 R2/2008/2005, SQL Azure.

ETL & REPORTING Tools:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools:

SQL profiler, SQL Query Analyzer, Index Analyzer, DTA, SQL Server Management Studio, Perfmon.

Third Part Tools

SCOM, Idera SQL Check, Companion,lite speed, Red gate, Veritas net backup, Erwin r7, Guardum, Azure Storage Explorer, Cloudberry Storage Explorer.

Languages:

T-SQL, C/C++, Java, PERL, java script, Visual Studio2010/2012, XML, HTML, ASP.NET, VB.Net.

EDUCATION

Bachelor of Engineering, OU, INDIA.

PROFESSIONAL EXPERIENCE

World Fuel Services, Miami, Florida Aug 2014 – Dec 2015

Sr. SQL Server Production DBA

Description: World Fuel Services is a Fortune 100 company that is based in Miami, Florida.It provides marketing and financing of aviation, marine and ground transportation fuel products and related services to commercial and corporate aircraft, petroleum distributors and ships at more than 8,000 locations around the world.

Responsibilities:

Installation and upgrades of SQL server SQL 2008 r2 and 2012.

Installation, Setup and Management of Always On Availability Cluster

Apply patch and security updates on regular basis

SQL Server Logins and Windows Access Administration.

Repaired, Recovered, Database Synchronization for Disaster Recovery.

Database Performance Tuning using Data Tuning Advisor, Profiler and Extended events, DMV’s.

Managed Databases using Maintenance Plan, DBCC, Backup (Full, Differential, Log), Automated Backup to Blob Storage.

Performance troubleshooting for Production systems

Implemented partitioning and Page Compression for Very Large Tables.

Implementation of TDE (Transparent Data Encryption and maintenance of Encryption Keys, Certificates and migration of Encrypted Databases across different environments.

Downgrading SQL Enterprise Edition to DE (Developer Edition 2012/2014) in Development Environments.

Installed, authored, and managed reports using SQL Server Reporting Services (SSRS).

Involved in capacity planning, sizing and database growth projections.

Migrated SQL Databases on Cloud using SQL Server Azure

Maintenance of Virtual Machines across Microsoft AZURE subscriptions.

Monitoring and maintenance of Azure Bolb Storage and Virtual Hard drives

Configuring and setting up RAID levels for the Virtual Hard Drives.

Implemented disaster recovery strategy and configure relative job on DR.

Installed and Configured Microsoft monitoring tool System Center Operations Manager (SCOM)

Installed and integrating MOM Agents across different machines for SCOM monitoring

Powershell scripts for Server Health monitoring and automated jobs for Blob storage

Create alerts for AG (Availability Groups) health and Extended Events for Dead Lock monitoring.

24*7 Production oncall support

Environment :MS SQL Server 2005/2008/R2/2012/2014, Windows 2003/2008/2010, SSRS, SSIS, SSAS, PL/SQL, MS Access, perl script, MS Excel, Visual Basic, .NET, DTS, Erwin

Volkswagen Group of America, Auburn Hills, Michigan Oct 2013– July 2014

Sr. SQL Server DBA

Description: Volkswagen Group of America, Inc abbreviated to VWoA, is the North American operational headquarters, and subsidiary of the Volkswagen Group of automobile companies of Germany. VWoA is responsible of five marques: Audi, Bentley, Bugatti, Lamborghini, and Volkswagen cars.

Responsibilities:

Involved in the Migration of Databases of SQL Server’s from 2005 to 2012 and SQL Server’s 2008 to 2012.

Involved in migrating DTS packages from SQL Server 2005/2008 to SSIS packages in SQL Server 2012 database.

Performance tuning of slow running systems using performance counters/Data collector sets, SQL profiler, Extented events.

Extensively used SSIS and DTS packages for Data Warehousing and Archiving.

Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.

Optimize slow running queries to improve application performance.

Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Created backup and recovery strategy for the systems based on their RTO and RPO’s.

Configured and maintained transactional Replication Server.

Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.

Created alerts and notifications for System errors, insufficient resources, and Fatal database errors.

Created Triggers to enforce data and referential integrity.

Involved in writing T-SQL Programming to implement Stored Procedures and Functions for different tasks.

Performance Tuning, Analysis and optimizing for SQL Server Application by using Performance monitor.

Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration

24*7 Production oncall support

Environment :MS SQL Server 2005/2008/R2/2012, Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, perl script, Erwin, companion, Idera, TSM/TDP.

Department Of Health & Mental Hygiene,Baltimore,MD May 2011 –sep 2013 Sr.SQL Server DBA

Description: Maryland’s health care delivery system consists of public and private hospitals, nursing homes, outpatient clinics, home health care services, hospices, providers, and health educators, among others. DHMH has four major divisions - Public Health Services, Behavioral Health, Developmental Disabilities, and Health Care Financing. In addition, the department has 20 boards that license and regulate health care professionals; and various commissions that issue grants, and research and make recommendations on issues that affect Maryland’s health care delivery system.

Responsibilities:

Working as a Production DBA with 50+ Production MS SQL Servers and 100+ Dev-Test SQL Servers and 1000 + Databases.

SQL Server 2005/2008 Production Database Administration.

Installed and configured SQL Server 2005/2008R2.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Migrated DTS packages from Legacy system to SQL SERVER 2005.

Created and Maintained jobs, alerts and Maintenance plans.

Worked in Active passive and Active active cluster environment.

Worked in Huge Transactional, Merge Replication environment.

Extensively worked to implement Database mirroring, configured Principal, witness and mirror using the SQL SERVER 2005.

Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency

Used Online Indexing in SQL 2005.

Installed, authored, and managed reports using SQL Server 2005 Reporting Services (SSRS).

Configured and maintained Database Mirroring and CTE.

Maintained the database consistency with DBCC at regular intervals.

Set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

Created Documentation for all the major activities done on day to day basis.

24*7 Production oncall support

Environment: SQL Server 2005/2008/2008R2, Windows 2003, QNXT, Care Advance, Biz Talk, Crystal Reports, SSRS, SSIS, Visual Basic, .NET, ADP Pay Roll.

Aetna Healthcare, Hartford, CT Jan 2010 – April 2011

MS SQL Server Developer/DBA

Description: Aetna is one of the nation’s leading diversified health care benefits companies serving members with information and resources to help them make better informed. The project was about to design and develop the data model and to increase performance by writing different kinds of queries.

Responsibilities:

Performed backup/restore, created database objects such as tables, procedures, constraints, indexes and views, user security management. Designed database tables and relations between them through Normalization. Involved in project planning, scheduling for database module with project managers.

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints 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.

Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.

Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning and optimizing indexes using Performance Monitor, Profile and Index Tuning wizard.

Experience on Import / Export using DTS and BCP utility.

Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and views.

Involved in Database designing, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.

Environment: MS SQL Server 2000/2005/2008, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.

TCF BANK, Minneapolis, MN Feb 2009 – Dec 2009

Sr SQL SERVER DBA

Description: TCF Banks are affiliated with TCF Financial Corporation, a financial holding corporation based in Minnesota. TCF has 444 banking offices in Minnesota, Illinois, Michigan, Colorado, Wisconsin, Indiana, Arizona and South Dakota. TCF is now the 10th largest U.S. Visa® Classic debit card issuer ranked by sales volume.

Responsibilities:

Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005 and 2008.

Created and optimized SSIS packages for data flow between SQL Servers.

Extensively used SSIS and DTS packages for Data Archiving.

Extensively worked on Extracting, Transforming and Loading(ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages.

Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.

Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.

Installed, configured and maintained transactionalReplication Server.

Checking Database Health by using DBCC Commands and DMV.

Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.

Created alerts and notifications for system errors, insufficient resources, and fatal database errors.

Created Triggers to enforce data and referential integrity.

Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.

Performance Tuning, Analysis and optimizing for SQL Server Application by using performance monitor.

Assist the SQL Developers in SQL tuning.

Environment: SQL Server 2000/2005, T-SQL, Excel, Advanced Windows 2003 Server & PVCS Version Control Management

Life Insurance Corporation of India Nov 2007 – Dec 2008

SQL server Developer/DBA

Description: Life insurance in India made its debut well over 100 years ago. Life insurance is a contract that pledges payment of an amount to the person assured (or his nominee) on the happening of the event insured against. In our country, which is one of the most populated in the world, the prominence of insurance is not as widely understood, as it ought to be. What follows is an attempt to acquaint readers with some of the concepts of life insurance, with special reference to LIC.

Responsibilities:

Involvement in the Design and Development of Database.

Creating Automatic data loading Procedures from the host system to master systems.

Created ER diagrams

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.

Used stored procedures, bcp and DTS Packages

Involved in automation of the job and was involved in daily monitoring of the tables and indexes for performance

Monitoring Log shipping/Replication and trouble shooting of errors

Security issues related to logins database users and application roles and linked Servers.

Performance Tuning of SQL 7.0

Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.

Backup and Restoration of data/database.

Involvement in Development and Implementation

Designing the database

Creating Automatic data loading Procedures from the host system to master systems

Security issues related to logins database users and application roles and linked Servers.

Timely completion of activities for database backup, restoration and health check of databases.

Involved in trouble shooting and fine-tuning of databases

Tuning front-end applications like Visual Basic and MS Access, which query the SQL Server databases. Troubleshooting ODBC and OLEDB issues between the application and the server.

Scheduling Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.

Environment: SQL SERVER 2000/2005, MS-Access, Visual Basic 6, and Windows NT Server and Windows 2000.

Contact this candidate