Sql Server Manager

HEMA PATEL (SQL Server DBA/Administrator)

Summary:

• 6+ years of IT experience including SQL SERVER 2012/2008/2008R2/2005 Database Administration,

Development, Performance Tuning and Windows System Administration.

• Possess extensive work experience in Installing, Configuration & Maintenance of MS SQL Server

2012/2008R2/2008/and 2005.

• New installation and upgrades, SQL Server stand-alone, virtualized, and clustered, Patch maintenance.

• Expertise in Relational Database Management Systems (RDBMS).

• SQL Server 2005 DDL/DML Triggers, Migration, Upgrading 2005 database to SQL server 2008R2.

• Creating Databases, Transactions, Tables, Joint, Indexes, Constraints, Writing and Debugging, Stored

Procedures, Triggers, Views, Functions and Cursors using SSMS.

• Experience Database Security: granting and revoking end user access to resources. Database Maintenance:

backup and restore, integrity checks, index rebuilds, usually as jobs, setting them up and periodically reviewing

them to make sure they are operating correctly. Restoring Databases to test environments.

Expert in Monitoring SQLServer Performance, Troubleshooting using SQL Profiler, and Scheduling Jobs using

SQL Server Agent. Index Tuning Wizard (or) DTA, Windows Performance Monitor and Maintenance plan.

• Experience in performing Database consistency checks using DBCC Utilities, Recompiling Stored Procedures

and Index Maintenance.

• Managed day to day activities like creation of Users, Schemas, Configuring Permissions and assigning Roles To

Users

• Database Backup, Recovery and Disaster Recovery procedures.

• Experience in implementing many types of High availability such as Clustering, Database Mirroring, Log

Shipping, and Replication.

• Performance Monitor/Profiler to resolve Dead Locks or long running queries.

• Table Normalization, Relational Database Management Systems (RDBMS), Optimization and Maintenance

plans, troubleshooting.

• Installation and configuration of Microsoft reporting, and integration services, (SSRS, SSIS) ETL experience,

Experience in creating SQL Server 2005/2008/2008R2 Reporting services.

• Creating the SSIS, DTS Packages for Data Migration and Modification using DTS Lookups and transformations.

• Experience in Create Objects (cubes, de-normalized tables etc) to support BI Analytics type of work.

• Indexes (Clustered/Non-Clustered) and partitioning of VLDBs (Very Large Data Bases-700GB) for improving

the Data base performance.

• Troubleshooting system wide problems including Network, database & third party software.

• Experience in Windows Server 2005/2008/2008R2/2012 systems.

• Possess skills in Network, OS installation and Hardwaretroubleshooting.

• Production (24 x 7) support.

• Excellent interpersonal and Communication skills, detail oriented, aggressively penetrating into the root cause,

organized and highly motivated.

• Experience in SQL SERVER 2012

TECHNICAL SKILLS:

Operating Systems Windows 2008, Windows 2003,Windows 95/98/ME/NT/2000/XP, VISTA, Window

7

RDBMS MS-SQL server2012/2008/2008R2/2005

Languages SQL, T-SQL Scripting

Tools/Utilities Enterprise Manager, Management studio, Profiler, Export & Import, DTS, SSIS-

Integration Services, Replication, SSRS-Reporting Services, ETL

Front End Tools MS FrontPage 98/2000, MS Office 97/2000/XP, MS Project 2000, MS Outlook

97/2000

Database Modeling/ Schemas Erwin, UML

Web Technologies HTML, DHTML, XML, ASP, VB Script, Visual Studio

Microsoft products: MS Office Suite- Word, Access, Excel, Word and Power Point, MS-Access

97/2000/2003/2007/2010

PROFESSIONAL EXPERIENCE

Client : Charles Schwab Corporation, Austin – TX

Duration : Feb’13 - Present

Position : SQL Server DBA

Responsibilities:

• Install and configure SQL Server 2012 and apply Service Packs and Cumulative Updates.

• Create maintenance plans for backups, integrity checks, index maintenance etc.

• Troubleshoot application issues using Windows Event Viewer, SQL Profiler, Query Analyzer.

• Installed and configured Quest Spotlight to alert on SQL and OS issues such as low disk space and deadlocks.

• Cooperate with Project Management and vendors on new rollouts and problem resolution.

• Follow best practices for new installations and installed and configured SQL Server Best Practices Analyzer to

analyze server configurations. Enhanced SSIS security to utilize

Environment: MS SQL Server 2012, T-SQL, Visual Studio 2010/2012

Client : Progressive Insurance, Columbus, OH

Duration : Nov’11 – Feb’13

Position : SQL Server DBA

Responsibilities:

• Administration of SQL Servers in Production and Development environment

• Installation and configuration of MS SQL Server 2005/2008/2008R2

• Developed Backup and Recovery Strategies, and Disaster Recovery Plan

• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored

Procedures, User Defined Functions, Views, and Jobs.

• Successfully implemented indexes on tables for optimum performance.

• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-

Clustered Indexes for significant performance boost using index tuning wizard.

• Experience in implementing many types of High availability such as Clustering, Database Mirroring, Log

Shipping, and Replication.

• Created SSIS packages to import data from MS Access, Excel to SQL 2005.

• Created report models and deployed on report server using SSRS

• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data

from various data sources using BCP in staging database from MS Access, excel.

• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as

create error logfor event during data load.

• Documentation for all kinds of reports and DTS and SSIS packages

• Experience in Creating and managing user accounts / logins for development purpose

Environment: MS SQL Server 2005/2008, 2008R2, MS Excel, MS Access, SSIS and SSRS

Client : Utah Department of Human Services, Salt lake City UT

Duration : Apr’09 – Nov’11

Position : SQL Server DBA

Responsibilities:

• Administrating more than 120 (Production and Non-production servers) both physical and virtual machines

which runs SQL server 2005 SP3/2008 R2 SP1 versions.

• Installing Microsoft SQL Server 2005 and 2008 R2 on New Production and Test servers with latest Security

updates involving Service Packs and Security patches as they are released.

• Involved in the SQL Migration Process (both in-place and side-by-side) with System Eng, Networking and

Application departments for upgrading SQL servers from 2005 SP3 version to 2008 R2 SP1 version.

• Implemented and maintained Failover clustering (Active/Passive node) and Replication (Snapshot and

Transactional, Transactional with Updateable) as databases high availability solution.

• Managing our DR environment with comprehensive restore plan meeting to our SLA

• Enabled Resource Governor to manage SQL Server 2008 database workload and evaluating critical system

resource consumption

• Research on Extended Events subjects to monitor the CPU consumption and Deadlock info on the servers with

disabling the trace flags.

• Supporting one of the major application team in column level encryption release using SMK, certificates and

symmetric keys.

• Documenting the procedure(SOP) to create and manage these Encryption keys for future deployment

• Applying data fixes based upon the incident request by App team members.

• Handled Table and Index partitioning for 1TB size of databases.

• Rebuilding the indexes at regular intervals for better performance and monitoring these jobs weekly.

• Monitoring the unused indexes in the databases using Catalog Views and DMV’s and dropping them.

• Archiving/purging the data in the tables using TSQL and executing as a job.

• Used Windows Performance monitor and SQL Profiler to optimize queries and enhance the performance of

database servers.

• Reviewing cluster event logs using Failover cluster Manager in case of failover following with verifying SQL

health and submitting RCA to Operations team.

• Reviewing the release code in TFS before deploying into Production. Recommending the developers to make the

changes as per coding standards.

• Troubleshooting various SQL Server 2005 and 2008 Database connectivity issues from the web applications.

• Managing the Quest Litespeed v5.0/v6.5, used for backup and restore procedures.

• Designed and implemented comprehensive Backup plan and rewriting the code to use SQL Native commands

for SQL Server 2008 R2 versions

• Monitoring Double-take console to check the status of mirroring/replication of backup files cross the network

• Reviewing DBA Daily status report to troubleshoot the low disk space, consistency checks, server configuration

and DB growth in proactive and submitting to Manager.

• Participated in Primary On-Call rotation, responsible for the prod releases, supporting app teams in case of

assistance, applying patches, server verification and monitoring maintenance jobs

• Responded to issues that have been escalated with Change Control Processes and adherence to standards and

documentation.

Environment: SQL Server 2005SP3/2008R2 SP1, ADO.Net, Windows Server2003/2008 Enterprise /Standard Edition,

SSIS,SSRS, Visual Studio 2008/2010, Quest LiteSpeed Backup, Double-Take, Windows 2007R2 Communicator, BMC

Ticketing System

Client : NBC, Eden Prairie, MN

Duration : Jun’07 – Apr’09

Position : SQL Server DBA

Responsibilities:

• Primarily responsible for Backup/Restore, Database Management, Monitoring, Space Management, Update

Statistics, Rebuild Indexes, wrote stored Procedures for administration purpose, and also involved in automating

administrative tasks.

• Involved in the process of logical/physical database design, implementation, Normalization of databases.

• Installation of MS SQL Server2005, configuration and doing performance tuning, Migration, capacity planning,

query optimization.

• Administering the MS SQL Server2005 and enforced the Security by creating logins with appropriate roles,

creation of groups, granting the privileges to users and groups.

• Handled Backup and Restore Database strategies large amounts of data (multi-terabytes) max. Size of 3.2

Terabyte.

• Migration of Cable order Data from Excel, Flat file to MS SQL Server by using BCP and DTS utility, ETL -

Extracting, Transforming and loading of data using SQL Server DTS and SSIS Packages.

• Involved in writing Stored Procedures, Triggers, User Defined Functions and Views using T-SQL.

• Installed and configured Microsoft 2Node Cluster Server and also configured Log shipping on Standalone SQL

Server using Light speed tool.

• Created the Jobs and scheduled for daily running, worked with pearl 3.0 scripts on the Server to make the

application easy to build and test simple

• Created various crystal reports and scheduled them as daily and monthly reports.

• Deployed SSIS packages and SSRS reports from TFS (Team Foundation Server) server.

• Replicating databases from the Production server to the reporting server by using Snapshot Replication.

• Played as member in CCB (Change Request Board) meetings to get approve production change requests.

Environment: SQL Server 2005/2000, Windows 2000/2003 Server,.Net Framework, ASP.NET, C#, Business

Intelligence Tool 2005, Visual Studio 2005, Pearl3.0, PVCS, Red Gate, DTS/SSIS, T-SQL, LiteSpeed, Log Shipping,

Replication.

EDUCATION:

• Bachelor of Advanced Accounting, SQL Server DBA

• Bachelor of Information Systems In Strayer University

Contact this candidate