SUMMARY

• 8+ years of experience with the 32bit, 64 - bit Microsoft SQL SERVER in Production and Non-Production environments with versions 2005,2008,2008R2,2012,2014.
• Expertise in Database Administration of verylarge and complex databasesinSQL Server 2014, 2012, 2008 R2, 2008andSQL Server 2005/ 2000
• Expertise with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Implemented new SQL Server 2012 technique ALWAYS ON for High Availability Disaster Recovery.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing HADR solutions like Replication, Log shipping, Clustering and mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Worked on Transactional and Snapshot Replication
• Configured Synchronous and Asynchronous Mirroring for DR.
• Implemented Inplace and Side by Side Migration of MS SQL SERVER of different Versions.
• Experience with Policy Based Management, Resource Governor, and Transparent Data Encryption (TDE).
• Good experience in Deploying SSIS packages in MS SQL Server 2008 and MS SQL Server 2012.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large Databases.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Upgradation of SQL server versions and applying patches and hot fixes.
• Experience with Change management process for production and non-production changes.
• Troubleshooting the Disk failures in a Cluster Environment.
• Experience working in both OLTP and OLAP environments.
• Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Implemented T-SQL features like Data partitioning, Error handling and Snapshot Isolation.
• Configured the DB SMTP mail for the notification purposes.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor, SQL profiler, Extended events and handling them by implementing better Query Execution plans.
• Used DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer, Extended events for performance analysis.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Experience in using DMV’s, DBCC and dynamic management functions.
• Having experience in monitoring server health using MS SCOM.
• Strong ability in Scheduling and deploying reports on Report manager
• Experience in the development of Reports using SQLServer2000/2005 Reporting Services (SSRS)
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Good understanding of different RAID levels implementation.
• Explicitly used third party tools like Lite Speed, Fog light, Red gate, Idera,TSM.
• Auditing of database for users transaction, login and database action and removing orphan users
• Strong experience in mentoring junior team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

Operating System: Windows 2000/2003/2008 R2/2012 Server, Windows 95/98/XP/NT, Linux, Solaris, Unix

Databases: MS SQL Server 2014,2012,2008 R2,2008, 2005,2000, Oracle 8i,9i, Sybase

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Log Shipping,SSIS, SSRS, SSAS, Microsoft Clustering Services (MSCS), PowerShell, SCOM

Programming: T-SQL,PL-SQL,HTML,HTML5,XML,CSS,C,C++

Data Migration: SSIS, BCP, Data Migration, Import/Export Wizard, BMC Patrol, SQL Server Profiler and Performance Monitoring

Third party Tools: Quest Lite speed, SQL Safe, RedGate, Tivoli, Idera, Guardium

PROFESSIONAL EXPERIENCE

Confidential, Eden Priare, MN

Sr. SQL Server DBA

Responsibilities:

• Install, Manage and administer SQL server 2005\2008R2\2012\2014 SQL servers.
• Implemented side by side and Inplace Migration of MS SQL server 2005/2008R2 to 2012 and applied Patches and Service packs to update different versions of MS SQL server.
• Implemented SQL Server 2012 technique ALWAYS-ON High Availability groups with two secondaries.
• Building SQL 2008R2 multi node cluster environments on VMware/ Physical environments.
• Applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability.
• Configured Transactional Replication and Log Shipping.
• Fix the Cluster and Replication issues on sql 2005/2008R2/2012 servers with in very strong SLA’s.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Performed Administrative tasks in SQL Server using PowerShell.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting the standard procedures on regular basis.
• Used Extended events/ SQL profiler for performance tuning
• Work in change control process for production and non-production changes
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Handled numerous Change Management requests on production servers.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction.
• Involved in transferring data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Involved in capacity planning, sizing and database growth projects.
• 24*7 On Call production support.

Environment: MS SQL Server 2005/2008R2/2012/2014, Windows 2003/2008/2012, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl script, Erwin, companion, MS SCCOM, Tivoli TSM

Confidential, Maryland

Sr. SQL Server DBA

Responsibilities:

• Setup Always-On High availability on 2012 SQL Servers.
• Migrating SQL server from 2008R2 to 2012 on standalone and cluster environment.
• Identify locking and blocking issues using Extended events and SQL profiler
• Tuning the Production server to get the performance improvement.
• Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
• Use log shipping for synchronization of database.
• Fixed high Memory utilization issues.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Build two-node/Multi-node cluster on physical/Virtual environments.
• Refresh non-prod environments with production.
• Checking Database Health by using DBCC Commands and DMVS.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Restore Development and Staging databases from production backups as per the requirement.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Managed SQL Server using PowerShell.
• Involved in Change Data Capture process.
• Setup SQL Auditing to capture data changes.
• Performance Tuning & Establishing integrated change control.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Documented and Created SLAs (Service Level Agreement) for the server availability in case of disaster.
• Configure Transparent Data Encryption (TDE) on Financial Applications.
• To 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.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security on SQL Servers databases.
• 24*7 On-Call Support.

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, IIS Server 5.0, WINOWS SERVER NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Manage 210+ Database Production and non-production servers
• Migration and Troubleshooting of Upgrades issues like SQL Server in Microsoft Windows Server 2003 R2 Enterprise Edition.
• Built Disaster recovery environment as replica to the Production servers and Created Custom Log-Shipping to manage and Support Disaster Recovery and Production Support restores
• Administration and Troubleshooting of Log Shipping
• Written stored procedures, cursors, user defined functions and tuning and optimizing Queries in SQL Server
• Extensive testing on the performance of the Stored Procedures.
• Enhanced the coding guidelines document for SQL developers
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Monitored the SQL Server Jobs, database size, disk space in SQL Server.
• Developing Backup & Disaster Recovery strategies and implementing on all production servers.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Monitor all DDL changes in production environment
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Configured Email notifications thru SMTP to get Alerts and diagnose the performance counters.
• Used Dynamic Management Views (DMV) and Functions for monitoring the performance of the server
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
• Controlled and Coordinated the installations ( Security Patches, Service packs ) and evaluated the performance before Pre-deployment
• Migrated DTS packages to SSIS Packages using DTSX change tool
• Performed SQL Server 2008 Compression Backup and Data Compression
• Perform the Node Injection to upgrade the Hardware on Cluster Servers.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
• Perform capacity planning and offer both long and short term solutions to controlling and managing database growth and space management
• Develop and implement backup and recovery strategies using both native SQL and third party technologies like Lite Speed 4.8 and 5.0.
• Rebuilding the online indexes at regular intervals for better performance

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, IIS Server 5.0, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential, Columbus, OH

SQL Server DBA

Responsibilities:

• Configure Transactional and Snapshot replication on SQL 2008R2 Servers
• Install SQL server 2008R2 servers on Physical/virtual servers and apply Service packs where needed.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Responsible for creating the reports basing on the requirements using SSRS
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Performed Full and Differential backup with bulk-logged recovery models.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Wizard (DTA)
• Used Joins, correlated and correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, trigger and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Used T-SQL for programming for stored procedures and queries.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.

Environment: T-SQL, MS SQL SERVER 2005/2008R2, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008R2/2005/2000 production and Non-production servers.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 R2 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Extensively worked on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Memory Configuration for SQL server on 32-bit boxes.
• Created various jobs to check health of the server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, triggers.

Environment: T-SQL, MS SQL SERVER 2000/2005/2008 R2, Windows Server NT/2003/2008R2, SSIS.