SUMMARY

• Over 7 years of experience in Microsoft SQL Server Database Installation, Configuration, Administration, patching, Maintenance and Performance Tuning, Backup/Restore and disaster recovery experience in SQL Server 2019/ 2016/ 2014/2012/2008 .
• Working on Virtual Machine environments linked to MS SQL databases in both physical and VM ware hypervisor.
• Having hands on experience migrating/promoting scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors, and functions to meet business requirements.
• Experienced in database management including installation, patching, backup and recovery, performance and tuning, security administration and space management.
• Experienced in SQL Server Reporting Services Installation, Configuration and Maintenance using Visual Studio and Reporting Services.
• Experienced in implementing SQL Server Security and object permission like maintaining creation of users, configuring permissions database authentication modes, and assigning roles of users.
• Expertise in implementing different types of high availability and disaster recovery mechanism like replication models, log shipping, database mirroring, clustering and always on.
• Worked on Always on configuration.
• Worked on Patching with clustering and standalone SQL instances
• Implemented SQL Server 2012 mechanisms like data compressions, online indexing.
• Worked on Clustering and Always on and server consolidation, troubleshooting production issues and raising high availability.
• Worked on supporting databases in cloud /Azure environments IaaS, PaaS.
• Experienced on PowerShell scripting
• Proficiency in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Worked on SQL Server 2012 migration from SQL Server 2008.
• Created Linked Servers between SQL Server 2008 & 2008 R2, also created DTS package for data transfer between the two environments.
• Soundknowledge on stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.
• Expert in tuning database by choosing indexes and using tools Database engine tuning advisor, SQL Profiler and XEvent.
• Expertness in trouble shooting database issues likeworkload, space issues, deadlocks, optimization, contention, network and blocking and performance tuning.
• Experienced in SQL Server tools like Enterprise Manager and SQL Query Analyzer.
• Experienced in allocating system storage andplanning future storage requirements for the database.
• Experienced in Monitoring andoptimizing the performance of the database.
• 24 X 7 Production Database on Call Support.
• Experienced in supervising and mentoring lower - level database teams.

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

MS SQL SERVER DBA

Responsibilities:

• Installation, Upgrade, Configuration and Migration of SQLServer in clustered and non-clustered production environments.
• Modifying the database structure, as necessary, from information given by application developers.
• Planning for backup and recovery of database information.
• Responsible for performance tuning and optimization of databases using native tools like SQL Profiler, Query Analyzer Database Engine Tuning Advisor, and third-party tools.
• Created reports in SQL server using SSRS as per the requirements provided by the Front-End users.
• Worked on Integration services for the purpose of Transforming data from the cubes and storing it into the data into the SQL Server tables.
• Involved in SQL Server Reporting Services (2008 SSRS) maintenance.
• Created maintenance plans and jobs to achieve maximum performance.
• Expertise in Performance monitoring & Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Responsible for data migration from Excel, Flat file, Sybase, Oracle to Microsoft SQLServer by using BCP and DTS utilities as well as Extracting, Transforming and Loading of data using Microsoft SQLServer SSIS and DTS.
• Worked on SQL Server 2016 migration from SQL Server 2008.
• Worked on SQL server 2016 always on and WFCL
• Worked with Change Data Capture (CDC) feature in SQL server to capture all the changes during migration of data between databases.
• To ensure recoverability of the Data Warehouse with minimal loss of information which includes extensive testing of the backup and recovery processes and taking backups full and incremental as needed.
• Administrated and implemented the new SQL Server 2016 mechanisms like query store, always encrypted.
• Developed and documented backups, recovery strategies, disaster recovery mechanism and participated disaster recovery drills for various environments. Successfully implemented Log shipping for DR solutions.
• Proactively managed Microsoft SQLServer instances at the corporate office by developing Microsoft SQLscripts for creation and upgrade of databases, maintenance plans, user logins, automation of network and server monitoring with exception reporting via Database Mail notifications, and a SQLServer failover system.
• Extensively worked on upgrading Microsoft SQLserver, failover clustering, log shipping, and replication, using System Monitor and SQLServer Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.
• Involved in development of database including creating new databases, converting old databases to new databases, modification of existing databases, creating reports to meet business needs.
• Hand on experience in troubleshooting of all databases related issues.

Environment: Microsoft SQL Server 2019/2017/ 2016/ 2014/2012/2008 R2 and Windows server 2016/2012/2012 R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party Jira (Kanban Board) Networker, Remedy, Spotlight.

Confidential, Nashville, TN

DATABASE ADMINISTRATOR

Responsibilities:

• Performedbackup using backup compression and Data compression in My SQL Server 2008R2 on clustered environment.
• Involved in scheduling the reports to run on daily and weekly basis in Report Manager.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.
• Administrated and managed theSQL Server 2008R2, 2005 production and non-production servers.
• Experienced in creating SSIS packages using proper control and data flow elements.
• Export and import data from source like flat files, row files using DTS, SQL Server Integration Services.
• Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.
• Migrated SQL Server 2005 databasestoSQL Server 2008R2 databasesincludingDTS to SSIS packages.
• Implemented high availability on the various servers usingReplication, Log-Shipping and Mirroring.
• Implemented and tested the point in time recovery of the production databases.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Optimized the performance of queries with modifications inT-SQLqueries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources like SQL Server usingSSIS.
• Configureddata partitioning and table partitioningon huge tables containing numerous numbers of rows for better performance.
• Scripting theDatabase Consistency Checks(DBCC), scheduling the scripts to run daily and weekly basis.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Created necessary templates for various requirements gathering anddocumentation.
• Application support for front end feeds and ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• MonitoredLog shipping and Transactional Replicationand troubleshooting of errors.

Environment: Microsoft SQL Server 2016/ 2014/2012/2008 R2 and Windows server 2016/2012/2012 R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party Service now, Redgate.

Confidential, HUNTSVILE, AL

DATABASE ADMINISTRATOR

Responsibilities:

• Prepared, maintained, and modified SQL server installation and configuration documents.
• Database Administrator, Database Programming.
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2005tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Worked with different upstream team for downloading ETL MART data.
• Worked on extracting data from multiple data sources such as Oracle, PeopleSoft, Siebel CRM, flat files and loading into OLAP systems.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Involvedin trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Installed SQL Server 2005 and created Development Database for testing, upgrades and development.
• Recovering the databases from backup in disasters.
• Worked withApplication Developersto design databases and tables to supportDevelopment activitiesand achieveoptimal efficiency.
• Rebuilding the indexes at regular intervals for better performance.
• Involved with development team and developed functions, procedures and packages performed Logical Backups byExportandImportutilities.
• Handled numerous change management requests on production servers.
• ConfiguredSQL Server settingsusing configuration manager.
• Worked on log shipping for synchronization of database.
• Involved in creating functions to provide custom functionality as per the requirements.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: Microsoft SQL Server 2014/2012/2008 R2 and Windows server 2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio

Confidential

SQL DBA/Developer

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Involved in creating Stored Procedures, views, tables, constrains.
• Monitoring the server for High availability of the servers.
• Created stored procedures and triggers for Data consistency.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Service.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Participate in implementation of new releases into production.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Day-to-day administration of live SQL Servers.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Designed and implemented Security policy for SQL Servers
• Responsible for monitoring and making recommendations for performance improvement in hosted databases like index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Used Stored Procedures, DTS packages, BCP for updating Servers
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Using Log shipping for synchronization of database.

Environment: Microsoft SQL Server 2012/2008R2 and Windows server 2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio.