SUMMARY

• 9 years of experience in Administration, Data Architect and Development using SQL server 2000/ 2005/2008/2008 R2/2012/2014 systems in OLTP and OLAP environment.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Implemented side by side and Inplace Migration of MS SQL server /2008R2 and applied Patches and Service packs to update different versions of MS SQL server.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments and creating linked servers between SQL servers 2000/2005/2008 R2 environments.
• Hands on experience wif SQL Server 2012 Always On High Availability Groups.
• Expertise on new feature ALWAYSON in SQL 2012 for HA, DR and Reporting access for faster, easier and better safety of data.
• Proficient in SQL Server 2008 new features like Merge Statement,Filtered Indexes, Policy BasedManagement, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, Lock escalation and new data types.
• Implemented teh new SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, DatabaseSnapshot, DDL triggers, Try - Catch blocks, Online Indexing, Online Restoring, DMV’s, DMF’s, Mail Setup, Jobs, Alerts and Database Tuning Advisor.
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting,Query Optimization, Client/Server connectivityand Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Experience in implementing and setting up Disaster Recovery and High availability solutions like different Replication Models, Log Shipping, Clustering (Active-Active and Active Passive) and Database Mirroring on physical and virtual machines.
• Extensively Worked onTransactional Replication, Snapshot Replication and Merge Replication.
• Data modeling Experience including Physical and logical data modelingusing ERWIN & VISIO.
• Experience in regular maintenance activities like Query Tuning, statistics update, Index rebuild, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions, and fragmentation issues.
• Explicitly used third party tools like Litespeed and Fog light.
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisorand Perfmon.
• Expertise on physical storage SAN configuration on different RAID 0, 1, 5, 10 levels.
• Sound knowledge in creating Maintenance Plan and writing complex SQL Queries, stored procedures, Normalization, creating Indexes, Indexed views, file group modifications, User Defined Functions (UDF), Triggers, Distributed Queries, Common Table Expressions (CTE) and adding scheduled jobs to re-index and update statistics in databases.
• Experienced in Configuration of IIS (Internet Information Service) in ISP environment wif access to SQL DBs, and creation of virtual servers and maintaining very large databases (VLDB)
• Experience configuring and working Microsoft SQL server 2008, Microsoft SQL Server 2005 on VMware Environment and maintaining threshold values, baselines and monitoring in Perfmon.
• Hands on experience in working wif System Center Operations Manager (SCOM) 2007 R2.
• Expertise in reading and understanding execution plan and fixing query to execute wif low cost using various operators depending on teh scenario.
• Expert in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Sound knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements.
• Experience in documenting teh Root Cause Analysis for various issues like memory and outage of database.
• Working Knowledge of SOX Compliance for maintaining roles and data integrity
• Auditing of database for users transaction, login, database action and removing orphan users.
• Extensive experience and proficiency on teh design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) wif DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS),Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Extensively used teh XML, FLAT FILE, BULK INSERT AND FILE SYTEMcontrol flow tasks and data flow tasks SSIS.
• Worked wif Tivoli Data Protection (TDP) and TSM for backup of databases and schedulingthe backups on teh Microsoft SQL Server 2005/2008.
• Worked wif a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects wifin scope, time and costs while following department standards, methodologies and guidelines.
• Strong ability in Scheduling and deploying reports on Report manger.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled numerous Change Management requests on production servers.
• Documented teh Service Level Agreements (SLA’s).
• 24 X 7 Production Database on Call Support.
• Flexible, Enthusiastic and project oriented team player wif excellent communication skills and analytical skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, UNIX (Sun Solar), LINUX(Red Hat), ESXi 5.5

Databases: MS-SQL Server 2014/12/08/2005/2000

ETL Tools: Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Reporting Tools: SSRS, SSIS

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Third party Tools: Erwin, Red gate, Litespeed, Idera, Comvault

PROFESSIONAL EXPERIENCE

Confidential, Florida

Environment: MS SQL Server 2005, 2008 R2, 2012, 2014 Windows 2003 Server, Windows 2008 R2 Server, Windows 2012 R2 Server, SCOM, MS Visual Studio 2010, SSIS Packages, Excel, HTML, Symantec.

Responsibilities:

• Installed, managed and administrated teh MS SQL Server 2014/12/08/05 Production and Non Production Servers
• Setup development, testingand production environment wif SQL Server 2012 and 2008 R2 Enterprise edition
• Performed installation of SQL Enterprise bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise datacenters. Patch applications.
• Handled Six Node clustered Environment
• Involved Upgrade and Migration of SQL Server 2005/2008 in placed, side by side to MS SQL Server 2012.
• Configured and worked on Database Mirrored Environments
• Performed Failover drill tests to check teh High Availability during disasters
• Worked on High Availability 2012 Solutions Always On
• Used Symantec Netback up for backups and maintenance jobs which includes updating statistics, database integrity checks
• Day-to-day activities like taking backup (or schedule teh backups daily for database and transaction log) on disk and restore teh databases
• Created Logins for teh users and manage their permissions
• Used SQL Profiler to monitor teh server performance, debug T-SQL and slow running queries.Used Bulk insert to load huge tables
• Worked in setting up teh SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Worked extensively wif Microsoft service manager console and Microsoft operation manager
• Used to Work wif Active Directory Tickets
• Developed and created teh new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Handled up to fifty Production SQL servers
• Experience in SQL Server security and maintenance of security objects
• Created Logins, Roles and Proxy accounts wif appropriate permissions and maintaining Database Maintenance Plans
• Configured DB mail by creating accounts and profiles
• Monitored alerts using SCOM and Spotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors
• Provided On call Production support. Ticketing Tool Remedy was being used
• Implemented partitioning on large table to get teh performance
• Used table hints in teh queries to avoid locks in teh server
• Worked as a team in Windows Administration(IT IS DCS Admin)
• Created missing indexes on teh tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands
• Implemented new features of MS SQL Server 2014in Development and Test environments
• Executed and performed Product support and installation documentation

Confidential, Minneapolis, MN

SQL Server DBA

Environment: MS SQL Server 2005, 2008 R2, 2012, Windows 2003 Server, Windows 2008 R2 Server, ERWIN, MS Visual Studio 2010, SSIS Packages, Excel, HTML, Idera, RedGate.

Responsibilities:

• Installation of MSSQL Server 2012/2008R2 on Production, and Development environment
• Assigned for Database Optimization dat involved re-engineering teh databases, data and index organizing, performance tuning and query tuning
• As a part of teh team, configured Transactional Replication wif multiple publishers and centralized subscriber for real time reporting
• Also implemented Mirroring for DR Plan
• Created numerous reports using reporting services SSRS and deploying them on SharePoint
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments
• Migrated teh SCOM (System Center Operations Manager) 2007 R2 and installed required Service packs and cumulative updates to teh SQL Server 2008R2 environment
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
• Creating Logins and Roles wif appropriate permissions
• Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing teh queries, which are involved in blocking and deadlock issues
• Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans
• Involved in capacity planning, sizing and database growth projections
• Monitor and modify performance using execution plans and Index tuning
• Optimize teh performance of queries wif modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables
• Interacting wif development team in writing good standard TSQL queries
• Applied patches, hot fixes, cleared .NET framework corruption errors
• Documentation, Training and mentoring teh staff
• As a part of teh team, was always involved in production deployment or production release

Confidential, Minneapolis, MN

SQL Server DBA

Environment: SQL Server 2000/2005/2008 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service, VMware, SQL Server Reporting Services and SQL Server Integration Services.

Responsibilities:

• Worked extensively on installation and configuration of MS SQL Server /2008 R2 on standalone and clustered Environments
• Involved in migration of MS SQL Server 2005/2008 to MS SQL Server 2008 R2
• Handled clustering between two Production Servers and performed daily backups and developed recovery procedures
• Experience in teh field of Unit Testing, has tested codes of T-SQL and SSIS packages in teh testing environment
• Configured DB mail for sending automatic mails to respective people when SSIS process fails
• Migrated DTS packages to SSIS 2005 packages
• Administered teh MS SQL Server by creating User Logins wif appropriate Roles, dropping and locking teh logins, monitoring teh User Accounts, granting and privileges to users
• Scheduled teh Backups for Databases and performed Restoration operations
• Created, built and deployed successfully SSIS packages by using BIDS
• Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database
• Implemented and Maintaining Replication
• Generate every day morning Replication reports from branch SQL Servers and Resolve Issues
• Created jobs and scheduled jobs according to Requirements and Data-warehousing
• Assisted in Deploying 2 NODE failover clustering
• Implemented Transactional Replication between Primary and Secondary Servers
• Created Databases, Tables, Indexes and Views
• Created Linked Server between SQL Servers
• Experience in SQL Server security and maintenance of security objects
• Implemented SQL Server Clustering on VM Ware
• Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on teh business requirements.
• Worked wif SQL Server Profiler to Generate Traces
• Developed documentation dat sufficiently describes technical deliverable as required for internal controls so dat teh maintenance responsibility can be passed on to production support team
• Continuous monitoring server health wif Idera
• Effectively configured MySQL Replication as part of HA solution
• Managed VERITAS net backups and LiteSpeed backups, Used SQL Profiler to capture teh activities of teh database and used teh trace file as workload file to teh Database Tuning Advisor for index recommendation
• Executed and performed Product support and installation documentation using IIS

Confidential, Phoenix, AZ

SQL Server DBA

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2005/2008/2008 R2, Microsoft SQL Server 2005, MS Visual Source Safe, IIS 6.0, XML.

Responsibilities:

• Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments
• Usage of new compression Techniques in SQL Server 2008 R2 for Backup and Restore jobs
• Implemented Database Mirroring and Transactional Replication as a part of DR plan
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation
• Creating Logins and Roles wif appropriate permissions
• Creating and Maintaining Database Maintenance Plans
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs
• Tune slow running queries using SQL Server Profiler
• Import data across multiple instances using BULK INSERT and BCP Utility
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements
• Create and manage database objects dat include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic
• Create Clustered and Non-Clustered Indexes to improve teh performance of database access
• Create and manage databases across Development and Production instances using SQL Server Management Studio
• Involved in Capacity Planning, Database Normalization and De-normalization process
• Involved in Logical and Physical Data Modeling process using MS Visio
• Use MS Visual Source Safe as a Version Control System
• Involved in Change Data Capture process
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors

Confidential, Seattle, WA

SQL Server DBA

Environment: TSQL,MS SQL SERVER 2005/2008, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINDOWS SERVER 2008, IIS, SSAS

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
• Migrated SQL server 2000/2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation
• Set up and Monitored transactional replication, Database mirroring on Production, QA and Development servers
• Migrated DTS packages into SSIS packages
• Configured Transactional replication on migrated server
• Wrote teh packages using SSIS in SQL 2005
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s)
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
• IntegratedSQL traces wif Perfmon log to has better graphical analysis to find system bottlenecks
• Implementation of SQL Principle, Securable, Permission, Roles and Autantication Modes as a part of Security Policies for various categories of users
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe)
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks
• Planned teh Complete Backing up of Database and Restoring teh Database from Disaster Recovery
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database
• Good experience in data modeling and metadata services
• Monitoring SQL server performance using profiler to find performance and deadlocks
• Created Stored Procedures, Triggers, Views and Functions for teh Application

Confidential

SQL Developer /DBA

Environment: SQL Server 2000/2005, Windows NT server, SQL Profiler.

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions
• Involved in creating Stored Procedures, views, tables, constrains
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into teh database
• Wrote complex stored procedures to process employee’s requirement and generating
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Created Database Maintenance Plans for teh Performance of SQL Server, which covers Database Integrity
• Debugged teh T-SQL queries for performance tuning
• Checked & updated Database Statistics and Re-indexing
• Created Users and Roles, and managed security and permission of database