SUMMARY

• Six plus years of experience in Database Administration for very complex and large databases in SQL Server 2014, 2012 and 2008 R2.
• Expertise in Database Administration on Production Server with server configuration and upgrade.
• Expert in migrating databases and Monitored appropriate disk storage requirements for the databases.
• Expertise and proficiency in SQL Server Replication with Disaster Recovery Planning and Security Management operations.
• Expertise in T - SQL, writing stored procedures.
• Experience in designing, testing and implementing High Availability solution such as Cluster, Always On, Mirroring and Log Shipping.
• Experience in data migration between the two environments with SSIS and Import, Export wizard.
• Designed data Partitioning solutions for tables for better performance.
• Strong Experience in creating jobs, Alerts, SQL Mail Agent and Scheduling SSIS Packages.
• Experience in maintenance plans to perform index de-fragmentation, reorganize index, rebuild index, and update the index statistics.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Technical Documentation writing skill, Self-motivated, creative team player with effective communication and Leadership qualities.

TECHNICAL SKILLS

• DATABASES
• MS SQL SERVER
• SQL Server Replication
• Alwayson Availability Group
• Performance Tuning and Optimization
• Database Backup and Recovery
• Database Migration

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

Database Administrator

Responsibilities:

• Installed configured, and managed SQL Servers 2012 and 2014 and upgraded from SQL 2012 to 2014.
• Setup database maintenance plans to backup/restore, reorganize indexes, and update index statistics on production databases.
• Used system monitor, SQL Server Profiler and in house queries to troubleshoot CPU/memory bottlenecks that negatively impact performance.
• Used of SSIS to provide greater automation of the importing, exporting and manipulation of data.
• Used Execution Plans to fine tune Stored Procedure performance.
• Implemented table partitioning for a large table to optimizing query execution.
• Created insert and update Trigger to monitor changes for the audit purposes.
• Configure and managed AlwaysOn for SQL Server 2012.
• Configured and managed Transactional Replication.
• Check drive space and maintenance plan\view history.
• Periodically run in-house query to monitor the status of Indexes.
• Check SQL error logs for any unexpected issues.
• Prepared technical documentation for all database process and procedures.

Confidential, Colege Park, MD

Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012.
• Upgraded SQL server 2008 r2 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Created SSIS packages to move data from SQL Server 2005 to SQL Server 2008 R2.
• Monitor, reorganize or rebuild indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters and Implementing Point-In-Time Recovery.
• Experience in using SQL Server Profiler, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Extensively worked on Dynamic Management Views (DMV) in SQL Server 2012 and checked Database Health by using DBCC Commands and DMVS
• Performed daily tasks including backup and restore by using SQL Server 2012 & 2008 R2.
• Configured and managed Windows clustering in SQL server 2012.
• Prepared the project management and technical documentation.
• Experience working on taught schedule like 24 x 7 Production Database on Call Support.

Confidential

Database Administrator

Responsibilities:

• Installed, configured SQL Server 2008 R2 in all environments.
• Involved in Analyzing and Upgrading SQL Server 2005 test server to SQL Server 2008 R2.
• Designed and implemented comprehensive Backup plan using SQL Server Maintenance studio.
• Experienced in configuring log Shipping and Mirroring for SQL Server 2008 R2.
• Troubleshoot performance problems and fine-tuning of databases.
• Rebuilding the indexes at regular intervals for better performance.
• Checking Database Health by using DBCC Commands and DMVS.
• Worked extensively in execution plan and profiler for tuning queries and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Performed data migration using ETL tool by SQL Server 2008 Integration Services.
• Involved in troubleshooting databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Designed and created databases, tables, views, store procedures and triggers.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Involved in capacity planning and monitoring data/log files size, growth and disk space.