SUMMARY

• Over 8 Years of IT experience as SQL Server Database Administration, 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/2008R2 to SQL2012/2014/2016 by using side-by-side and Inplace upgrade process
• Optimized T-SQL query performance using SQL Profiler, Execution Plans, Index analysis, tuning advisor, extended events, DMVS and DBCC
• Used to resolve logspace issues, TempDB issues, DB repairs and memory issues
• Monitoring day to day activities like maintenance plans, schedule jobs and database health check
• 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
• Performed BULK INSERT, Imported and Exported data from different Data Sources
• 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
• Followed Waterfall and Agile/Scrum methodology of software development which satisfies the customer through early and continuous delivery of valuable software
• Self-motivated and team player with excellent interpersonal, communication and presentation skills

TECHNICALSKILLS

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

Databases: MS SQL Server 2005/2008/2008R2/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, NJ

SQL Server DBA

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 andCumulative 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
• Performance tuning of 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 and performance tuning
• Used Idera tool for enhanced database server monitoring, alerts and issue troubleshooting
• Used DBCC and DMV commands for day-to-day troubleshooting tasks
• Participated on half yearly DR Drills and performing POC for SQL Server 2008/2012/2014 environments
• Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines

Confidential, PA

SQL Server DBA

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

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

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