SUMMARY:

Over 6 years of experience as a SQL Server Database Administrator with proficiency in managing very large and highly transactional database systems in production and non - production environment. Highly motivated and take initiative to manage and work on different projects individually and as a team.

DBA SKILLS INCLUDE:

• Installation and Configuration
• Always ON
• Capacity management
• SQL Failover Cluster
• Updates and Patches
• Log Shipping
• Security
• Mirroring
• Auditing
• Replication
• Transparent Data Encryption (TDE)
• Power shell
• Backup/Restore
• Performance Tuning
• Automation
• Documentation
• T-SQL
• Migration
• SSRS/SSIS
• Virtualization- VMware

TECHNICAL SKILLS:

Relational DBMS: Microsoft SQL server 2016/2014/2012/2008- R2/2005, Oracle, Microsoft Access.

Server Operating Systems: Windows Server 2008/2008R2/2012

ETL tools: MS SQL Server integration services /SSIS/, Data Transformation services /DTS

Reporting: SSRS/Power BI.

Third party tools: IDERA(SQL safe, lite speed), Spotlight, Solar Winds, Commvault, Redgate technology

Applications: Visual Studio, SharePoint, VISIO,IIS

Cloud Computing Services: AWS, Azure

Network Topologies: TCP/IP, FTP, SMTP,DNS

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Installed and configured MS SQL Server 2016, 2014 and 2012 and updated with latest service packs, hot fixes and security patches with Standalone and Clustered Servers.
• Successfully implemented Capacity planning for different servers (production and non-production).
• Supported and maintained large databases and troubleshooting issues.
• Responsible for Managed security, applied password policy and implemented password complexity roles depending on the company.
• Implemented TDE (Transparent data encryption) on SQL Server databases.
• Worked on Auditing of database for user’s transactions, logins, and database actions.
• Designed backup and restore plan following strict RPO and RTO guidelines of the company.
• Applied efficient Disaster Recovery and High availability strategies like Always On, Replication, Log shipping, clustering and Database mirroring.
• Worked on performance monitoring and tuning using activity monitor, Monitoring Event Viewer,sp who2, Performance counter, SQL logs, SQL profiler, standard reports, DBCC, DMV and third-party tools (spotlight, IDERA SQL Diagnostic).
• Involved in maintaining index plans including recreating, rebuilding and reorganizing.
• Performed evaluation on CPU, Disk I/O and Memory related Bottlenecks, Blocking and Deadlocks.
• Migrated SQL server 2012 to SQL server 2016 by using side-by-side upgrade process and documented the Upgrade Process.
• Worked on virtualization technologies on VMware (configuring and implementing).
• Created and controlled permission of SSRS & SSIS packages with maintenance and data extraction, transformation and loading (ETL) process.
• Performed Scripting T- SQL stored procedures, triggers, functions (UDFs) and views.
• Configured deployment and management using PowerShell scripting.
• Worked with tickets by using JIRA.
• Performed day to day activities such as database and server up and running, check OS event logs and SQL Server logs, failed SQL Server Agent Jobs, disk space, blocking issues and scheduled job.
• Closely worked with development team to Preventing SQL injections and assist them in various problems solving and troubleshooting.
• 24/7 on call support for mission critical applications and any upgrades/maintenance as required.

Environment: Microsoft SQL Server 2016/2014/2012 Enterprise and Standard Editions, Windows 2012/2008R2, T-SQL,TDE, JIRA, Clustering, Always On, Mirroring, replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, Azure, SSIS, SSRS, Microsoft Visual Studio 2015, Lite Speed, Spotlight, SQLsafe, IDERA Diagnostic.

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Installed and maintained the SQL server 2012/2008R2/2008/2005 PROD, TEST and DEV environment and apply Service Packs (SP) and hot fixes.
• Worked with capacity planning, database sizing and monitoring.
• Managed SQL Server security by granting appropriate server and databases roles/permissions and by having frequent security checks for inappropriate access.
• Created database maintenance plans for automate SQL agent job, re-indexing, backup, statistics, integrity and cleanup tasks.
• Configured tempdb on SQL Server instances by adding tempdb data files proportional to the number of processors and setup file growth parameters.
• Created SSIS packages for maintenance and data extraction, transformation and loading (ETL) and Export/Import data from different data sources.
• Worked with SQL Server up gradation and migration from lower version to upper version (SQL Server 2005 to SQL Server 2008/R2 and SQL server 2008/R2 to SQL Server 2012 ).
• Configured and managed Linked Servers, Data transfer between SQL Server and other heterogeneous relational databases.
• Used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions, third party tools for monitoring, performance tuning/analysis, and troubleshooting.
• Daily routine handling user's permissions and space issues on Production and non- Production Servers and handling maintenance Jobs.
• Worked closely with the developers and testing team to resolve Bugs and defects.

Environment: SQL Server 2012/2008R2/2008/2005 Enterprise and Standard Editions, Windows 2008 R2, Windows 2008, Lite Speed, Azure, AWS, Spotlight, Microsoft Visual Studio 2010, T-SQL,, ETL, Linked server, SSIS, SSRS, VMware.