SUMMARY:

• Over 9 Years of IT experience as a SQL Server Database Administrator, Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, 2012, 2014 and 2016 environments
• Installed, upgraded and administered SQL Servers 2008, 2008R2, 2012, 2014, 2016 in virtual and physical environments and patched periodic Service Packs (SPs) and cumulative updates
• Implemented and managed SQL Server High availability and Disaster Recovery solutions like Mirroring, Log shipping, Replication, Windows Failover clustering and Always-On Availabiity Groups (AAG)
• Hands on experience in database migration from SQL server 2005/2008/2008 R2 to SQL 2012/2014/2016 by using side-by-side and Inplace upgrade process
• Experience in configuring & working on active-active, active-passive & Multi-subnet cluster environment for HA
• Optimized T-SQL query performance using SQL Profiler, Execution Plans, Index analysis, tuning advisor, extended events, DMVS and DBCC
• Monitoring day to day activities like maintenance plans, schedule jobs and database health check
• Ensure stable operation, performance and availability of production MS SQL Server environments through proactive monitoring, maintenance, and management
• Ensure native database back up processes and schedules meet defined Recovery Point Objectives (RPO) and that backups are routinely tested to ensure consistency and the ability to meet Recovery Time Objectives (RTO)
• Participate in on-call rotation and after hours or weekend work for disaster recovery testing, production support, and code deployments
• Implemented data security features of Transparent Data Encryption(TDE), Columnlevel encryption, table partition
• Experience in creating objects like Tables, Views, Normalization, Indexes, Batches, Stored Procedures, Functions, Cursors, Triggers, Common table expression (CTE) and other SQL joins and query writing using T- SQL statements
• Exposure on Storage Area Networks (SAN) and utilizing SanDisk space in a Windows Environment
• Experience in ETL and reporting tools. Basic understanding of the Data Warehousing SDLC of ETL, reporting and BI tools
• Served as the key point of contact/Liaison between on-site and offshore resources working from client location
• Basic Knowledge on Cloud Technology such as AWS, Azure
• Basic understanding on installation and configure MapReduce, HIVE and the HDFS; implemented Cloudera Distributed Hadoop cluster on CentOS

TECHNICAL SKILLS:

Operating Systems: Windows NT/ 2003/2008/2010/2012, Unix, Centos

Databases: MS SQL Server 2005/2008/2008 R 2/ 2012/2014/2016

Database Tools: SQL Server Management Studio, SQL decryptor, Visual studio, SQL profiler, Extended events, SQL Query Analyzer, Index Analyzer, Performance monitor, Data Migration Asistant

Third Party Tools: Idera, Spotlight, Red gate, servicenow, Remedy, Litespeed, Netbackup

Languages: T-SQL, PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, North Brunswick, NJ

SQL Server DBA

Environment:

• M S SQL Server 2008/2008 R 2/ 2012/2014/2016
• Extensively used third party tools IDERA and SQL Decryptor

Responsibilities:

• Responsible for supporting & troubleshooting issues with databases using 2008R2/ 2012/2014/2016 enterprise edition
• Install, configure, upgrade, and maintain database instances from SQL 2008/2012 to 2014/2016 on clustered and standalone servers of Non Prod & Prod servers
• Scheduling and implementing patching activities i.e. Service packs and
• Cumulative upgrades as per baseline standards at Wellsfargo
• Contributed to implementation of HA/DR solutions for database servers of SQL 2012/2014/2016, including Failover Clusters, mirroring and Always On Availability Groups
• Manage application and user access to SQL Server environments
• Deploy and test maintenance jobs, and change scripts in both test and production environments
• Performance tuning on long running queries and stored procedures, using SQL Profiler, server side traces, Database Tuning Advisor, and query execution plans
• Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, and transaction log file sizes, backup/restore
• Configure and refine IDERA monitoring tool and alerts
• Used DBCC and DMV commands for day-to-day troubleshooting tasks
• Participate in AlwaysOn Availability Group failover testing of High Availability and Disaster Recovery environments during DR test
• Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines

Confidential, Chambersburg, PA

SQL Server DBA

Environment:

• M S SQL Server 2008/2008 R2/2012
• Extensively used third party tool spotlight

Responsibilities:

• Manage and administer SQL server 2008/2008R2/2012 servers Involved in Administration, Performance Analysis and 24X7 Production Support for Large (VLDB) and Complex Databases
• Managed over 25 SQL Servers including Production and Test servers
• Installed and configured SQL Server 2008/2008R2/2012/2014 on clustered and non-clustered environments
• Migrate databases from SQL 2008 & 2008R2 to SQL 2012/2014
• Contributed to implementation of HA/DR solutions for database servers of SQL 2012/2014/2016, including Failover Clusters, mirroring and Always On Availability Groups
• Deployment of databases, jobs from pre-production to production
• Create and schedule maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
• Worked with database tuning advisor, SQL server profiler, Performance counters for Performance tuning
• Used DBCC and DMV commands for day-to-day troubleshooting tasks

Confidential, Atlanta, GA

SQL Server DBA

Environment:

• SQL Server 2008/2008 R2

Responsibilities:

• Installed and configured SQL Server 2008/2008 R2 on Prod and Non-Prod environments
• Upgradations of sql server versions and applying patches and hot fixes
• Configured HADR techniques like Mirroring, log shipping and transaction replication
• Troubleshoot Performance issues on production environments using Performance counters, SQL Profiler to find the resource bottlenecks
• Resolved locking and blocking issues
• Refresh non-prod environments with production data on regular basis
• Used Index tuning wizard to optimize query performance
• 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

Confidential

SQL Server DBL

Environment:

• SQL Server 2005/2008 & 2008R2
• Extensively used third party tool Redgate

Responsibilities:

• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2008 databases by side by side upgrade process
• Setting up and Monitored database logshipping, mirroring on Production and non production environments
• Migrate DTS packages into SSIS packages
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks
• Monitoring SQL server performance using profiler to find the performance, deadlocks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing
• Implementation of SQL Principle, 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