SUMMARY:

• Experienced Database Administrator with in - depth technical knowledge in MS SQL Server Administration, installation and Security, Backup and recovery, High Availability and Disaster recovery, Performance tuning and monitoring in production environment and providing 24/7 on-call support.
• Over 6 years of IT experience in Database Administration, Design and Development and Support of MS SQL Server 2016/2012/2008 R2/2005 in Production, Test, Development Environments.
• Experienced in RDBMS database performance tuning, optimization, backup and recovery, Index Tuning, Disaster Recovery Planning, Security Management.
• Experienced in using SQL Server Tools such as, Import/Export Wizard, Extended Events, SQL Profiler.
• Experienced in Database Migration from MS SQL Server 2005 to MS SQL Server 2008R2 and from 2008R2 to 2012/2016.
• Experienced in for DB Security such as creating logins, users, roles, and assigning permission.
• Installed, configured, and administered SQL Server Reporting Services (SSRS) and create SSRS Reports.
• Experienced in implementing high availability and disaster Recovery solutions such as Log shipping, DB mirroring and Replication, Always On Availability Groups.
• Applied SP (Service Pack) on SQL 2008/R2, 2012
• Experienced in data extraction, transformation and loading(ETL) across different databases like MS Access and flat files using tools like Import and Export Wizard, and SSIS packages.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Proficient in Active Directory security authentication, RAID configuration, Hyper-v Manager, Group Policy Management, VMware,
• Experience in documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices,
• Experienced in smoothly working with Software Vendors while maintaining the security of Database servers,
• Experienced in SQL production deployment with Change Control process using Team Foundation Server

TECHNICAL SKILLS:

Software Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler, Activity Monitor, SSIS, Replication, Database Tuning Advisor and Index Tuning Wizard, BCP, SQL CMD, Report Manager, Reporting Services Configuration and Report Builder, Upgrade Advisor, SQL Configuration manager and Service manager, PowerShell, Third party tools for back up and performance, VMware, Hyper-v, Outlook 2016, Office 2016, Skype for Business 2016, Team Foundation Server(TFS) as source control

Third Party Tools: Quest Spotlight on SQL Server Enterprise, Confio Ignite, FileZilla for FTP, SQL Sentry, LiteSpeed, RedGate'sSQL Compare and SQL Monitor

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential

Responsibilities:

• Installed configured and managed SQL server 2008 & 2012,
• Managed Production and Test MSSQL Server 2008 and 2012 Environments and provide support on development environments of the same version and windows server 2008 and 2012 Operating Systems,
• Upgraded SQL Server from version 2008 to 2016,
• Managed large databases in 24/7 environment including Active Directory support and troubleshooting,
• Applied Service Packs and Hot Fixes,
• Created an integrated maintenance plan, i.e. automated jobs such as backup, shrink database, update statistics, rebuild index, reorganize Index, maintenance cleanup, history cleanup and notify operator tasks,
• Applied DMV for finding out long running queries,
• Performed Performance Tuning activity using SQL Server Profiler, Database Tuning Advisor, Windows Performance Monitor, Query Analyzer and Tuning long running queries and stored procedures.
• Ensured SQL Server replication and mirrored database were operating as planned,
• Performed statistics management, managed SQL Server Error Logs, space usage and growth pattern,
• Used DBCC Commands to manage database consistency, index fragmentation and statistics,managed index (Cluster/Non-Cluster) and Constraints.
• Scripted queries involving joins, views, triggers and stored procedures for diverse Business requirements,
• Created and managed users, roles, security at object level, data encryption. Monitored user accounts, creation of groups and granting privileges to users,
• Working with Vendors in managing SQL deployment
• Working in SSDT DackPack deployment
• Applied Always On Availability Groups
• Involved in refreshing data from prod to beta environments,
• Performed scheduled DR testing
• Developed and applied storage strategies and disaster-recovery plan for large operational database that guaranteed recovery performance and high availability.
• Designed and deployed ETL solutions in SSIS packages
• Created documentation for maintenance plans, installation, monitoring procedures, security policies, configuration changes, migration procedures, deployment procedures

SQL Server Database Administrator

Confidential

Responsibilities:

• Managed security on Production and Development environments.
• Performed database Tuning, monitoring, and Scalability Testing
• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Created and maintained various databases on Production and development environments using SQL Server 2005/2008/2012.
• Installed SQL server 2005, 2008 and 2012 on a test and production environments.
• Experience in managing database maintenance plans such as back up database tasks; check database integrity task with DBCC, maintenance cleanup task, and shrink database rebuild & reorganize index tasks among others
• Implemented high availability on the various servers using replication/Log Shipping.
• Created and maintained various logins and managed security based on the required access.
• Created various jobs to monitor resources on various servers and configured alert
• Developed and configured SSIS packages for ETL an monitored performance.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).