SUMMARY

• IT Professional with 6+ years of experience in SQL server Database Administration and SQL Server development.
• Experience in installation, maintenance of different versions of SQL Servers (2014, 2012, 2008R 2/2008/2005/2000 ) in both OLTP and OLAP lower regions and Production environments.
• Implemented High Availability & Disaster Recovery techniques like Always ON Availability Groups, Clustering (Both Active - Active and Active--Passive), Database Mirroring, Transactional Replication and Log Shipping.
• Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012.
• Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012/2014 new features.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.
• Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
• Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
• Experience in Physical and logical data modeling using ERWIN & VISIO.
• Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
• Experience in developing and tuning SQL Server Integration Services (SSIS) packages and SSRS reports.
• Configuring and maintaining Report Manager and Report Server for reporting services
• Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call.
• Documenting procedures in runbooks.

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and Database,Administration of MS SQL Server 2014/ /2005/2000 /7.0 ,Oracle.

ETL Tools: MS SSIS and DTS, TSQL, SQL Server bulk insert and BCP utilities

Tools: IIS, SSIS, DTS, Lite Speed, Spotlight, Visual Studio 2003/2005, Team Foundation Server (TFS), Visio 2003, Enterprise manager, query analyser, Perfmon, SQL Profiler, Idera, Foglight, Red gate, Tivoli, Symantec Net Backup

Languages: SQL, TSQL, C, C#

Markup Languages: HTML, XML

Operating Systems: Windows NT/2000/XP/2003, 2008/2008R2/windows2012/Windows 2012R2, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Santa Monica, CA

SQL Server DBA

Responsibilities:

• Installed SQL Server 2014/2012/2008 R2 on Windows Clustered and standalone environments with latest service packs.
• Upgraded SQL server databases from 2008R2 to 2012/2014
• Experience in working and troubleshooting2TB Very Large databases (VLDB) in OLTP Environment.
• Configured AlwaysON availability groups in SQL server 2012
• Configured log shipping for multiple databases as a part of DR.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.
• Analyze long running slow queries and tune the same to optimize application and system performance.
• Reorg/Rebuilding the indexes at regular intervals for better performance
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• 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.
• Involved in trouble shooting and fine-tuning of databases for its performance.
• Improve the performance of SQL Queries and stored procedures using SQL Profiler.
• Configuring TEMP DB on files and file groups and capacity planning of databases.
• Configuring and deploying SSIS packages and SSRS reports.
• Documenting procedures in run books.

Environment: SQL Server 2014, 2012, 2008R2, 2005, Windows 2012, 2003 Server, Symantec netbackup, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Managed and Administrated the SQL Server 2012/2008R 2/2008/2005/2000 production and Non-production servers.
• Installation of SQL Server 2012/2008R2/05 on Windows Server Clustered environment.
• Upgraded/Migrated SQL Server 2005/2008 databases to SQL Server 2008R2 and SQL server 2012 databases.
• Migrated SQL Server 2005 databases to SQL Server 2008r2 databases including DTS to SSIS packages.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Configured Backups, optimization jobs and involved in restoring database to point in time in case of issues, troubleshooting long running queries, locks, deadlocks and performance issues.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Monitored Log shipping/ Transactional Replication and troubleshooting errors.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Supported 24 X 7 Production On call

Environment: SQL Server 2000/20 R2/2012(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server)

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

• Installing and Maintaining SQL server 2008/2008R2
• Upgrading SQL server databases from SQL 2000/2005 to SQL2008R2
• Recovering the databases from backup in disasters
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, WA, DC

SQL Server DBA/DEVELOPER

Responsibilities:

• Upgrading SQL Server 2000 to SQL Server 2005/2008.
• Installing and maintaining SQL Server 2000/20 r2.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Designed the reporting databases using ERWIN.
• Used Query hints to Tune the SQL queries for maximum efficiency and performance.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Worked in active/active and active/passive cluster environment
• Data migration using bulk copy program and DTS.
• Helping the front-end application developers with their queries.
• Job Monitoring and making sure all jobs run successfully every night.
• Performing low-level scripting, fixing of codes and software enhancement process.
• Performed Database backups with tools like litespeed.
• Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
• Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.
• Suggest Replication techniques to meet business needs.
• Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes.
• Generated script files when changes applied to stored procedures and functions.

Environment: MS SQL 2000/2005/2008 , Windows NT/2000/XP, SSIS, SSRS, SSAS, MS Access, MS Excel, VB.NET, C#, OLAP.