SUMMARY

• Around 8 years of Database Administration and Development experience on MS SQL Server 2000/2005/2008 R2/2012/2014 in OLTP and OLAP environments
• Experience in installing MS SQL SERVER 2005, 2008, 2008 R2, 2012, 2014 & updating with hot fixes and service packs
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts
• Extensive experience in implementing High availability and Disaster Recovery solutions like Always - On Availability groups, Replication (Snapshot and Transactional), Log shipping and mirroring on physical and virtual machines
• Extensively worked on Active-Active and Active-Passive Clustering
• Implemented new features in MS SQL Server 2012 like Always On HADR in production and non-production environments
• Implemented Side by Side Migration of MS SQL SERVER R2 and 2008R2 to 2012
• Experience in developing T-SQL (DDL, DML, and DCL) statements
• Experience in Migrating DTS 2005 packages to SSIS packages in 2008 using Migration Wizard
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor and Transparent Data Encryption (TDE)
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers, views and other SQL joins and query writing.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics
• Expert in analyzing the execution plan and index management for better Query Optimization
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups and utilized to recover data in point in time in case of disaster of server.
• Extensively used third party tools like Lite Speed, Fog light and Red gate
• Auditing of database for users transactions, login and database action and removing orphan users
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Experience in creating SQL Server Reports using SSRS 2005 and 2008
• Experience working on VMware environments
• Experience working with Change control process/Change management
• Extensively worked in 24*7 Production environment

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. SQL Server DBA

Environment: MS SQL Server 2008 R2/2012/2014, Windows 2003/2008R2. SQL Server 2012, Windows … R2 Server, SQL Server Management Studio, SSIS, Query Analyzer, SQL Profiler

Responsibilities:

• Install and maintain SQL Server 2008 R2 and 2012 database and SSRS on multiple servers
• Hands on experience in creating logins and assigning roles with least privileges
• Extensive experience with SQL Server High Availability and Disaster Recovery strategies
• Experienced in Configuring, Implementing and Maintaining Database Mirroring in both synchronous and asynchronous nodes
• Monitor and troubleshoot database related issues and work with application teams to resolve issues.
• Migrate and upgrade databases from older versions to 2012
• Actively involved in capacity planning
• Provide On-Call support 24*7
• Implementing different types of Replication Models such as Transactional, Snapshot Replication in SQL Server 2008 and SQL Server 2012 in OLTP environments using different topologies
• Implemented log shipping as a part of Disaster recovery solution
• Implemented high availability solutions, including Clustering, Database Mirroring
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization
• Experience in capacity planning, performance tuning, and disaster recovery (DR) and troubleshot performance issues
• Create, drop and alter database objects
• Provide application installation and setup support
• Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views

Confidential, Atlanta, GA

SQL Server DBA

Environment: SQL Server 2000/2005/2008 R2,Windows 2003/ 2008 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008 R2

Responsibilities:

• Installed and configured SQL Server 2005/2008 R2 on Prod and Non-Prod environments.
• Configured HA & DR techniques like replication (snapshot and transactional), Mirroring, log shipping and clustering on virtual and Physical environments.
• Worked on side-by-side migrations of sql server.
• Applied service packs as a part of standardization project.
• Implemented sql server Auditing to collect data for Quarterly audits.
• Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler and DMV’s to find the resource bottlenecks.
• Resolve locking and blocking issues.
• Refresh non-prod environments with production data on regular basis.
• Implemented data availability solutions like online restore, online index, database snapshot and fast recovery.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Provided RAID level suggestion for data files, log files and tempdb drives.
• Used Index tuning wizard for optimal query performance.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Providing 24*7 support.

Confidential, CA

SQL Server DBA

Environment: SQL Server 2000/2005/2008 R2, T-SQL, Excel, Windows 2003/2008 Server

Responsibilities:

• Migrated SQL server 2005 databases into SQL server 2008 databases by side by side upgrade process and also used upgrade advisor tool in upgradation process.
• Setting up and Monitored Clustering, transactional replication, Database mirroring on Production environments.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand alone environment
• Configured Transactional replication on migrated server.
• 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.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the 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 the Application.
• Extensive testing on the Performance of the Stored Procedures.

Confidential

SQL Server DBA

Environment: MS SQL Server 2000/2005/2008 R2, Windows 2000/2003/2008 servers, .NET, MS Access

Responsibilities:

• Installing, configuring, tuning and providing 24X7 support for SQL Server 2005/2008 R2
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Involved in Migration from SQL Server and 2008.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2008 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues

Confidential

SQL Server Developer/DBA

Environment: MS SQL Server 2000/2005, T-SQL, Windows NT/2000/ 2003

Responsibilities:

• Involved in Data Migration
• Involved in resolving dead lock issues and performance issues
• Created Linked Servers between 2005 and 2008 R2 servers
• Implemented database mirroring as a part of disaster recovery plan
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps
• Involved in trouble shooting, Performance Tuning
• Managed the use of disk space, memory and connections. Implemented Backup and restore in SQL Server 2008 R2