SUMMARY

• IT Professional with 7 years of experience in SQL server (2016, 2014, 2012, 2008R2, 2008, 2005 and 2000) Database Administration in Production, Development and Staging Environments.
• Experienced in MS SQL Server planning, installation and configuration of SQL Server (2016, 2014, 2012, 2008 R2, 2008 and 2005) on Windows Server 2012, 2008, 2003 both on physical and virtual environments.
• Experienced in Database Backup, Restore and Disaster Recovery procedures.
• Expert in providing HA solutions support for SQL Server Failover clustered instances, mirroring, log shipping, replication and AlwaysOn Availability groups.
• Experience in installing Service Packs and updates for SQL Server instances
• Extensive experience in creation and maintenance of Stored Procedures, Triggers, Views, Functions and Packages with T - SQL.
• Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Experience in Database Migration. Migrated SQL Server 2005 to SQL 2008, SQL Server 2008R2 to 2012, 2014 and 2016.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
• Expertise in Performance tuning, Optimization, Data integrity, Indexes and Statistics by using native tools like index tuning wizard (DTA), profiler, Perfmon, activity monitor, Event viewer for performance analysis.
• Experience in configuring and using PowerShell to manage multiple SQL Server instances
• Well experienced in Query Optimization, Client/Server connectivity, Performance Tuning, Database Consistency Checks using DBCC utilities, DMV's.
• Hands on experience in creating Maintenance plans, scheduling SQL Server Jobs, Automatic administrative task and Configuring Database Mail.
• Experience using SQL Server 2012 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience reviewing in entire environment and quantifying the standardization of the databases and servers, worked on enforcement of Microsoft best practice standards
• Knowledge of SQL Server Integration Services and SQL Server Reporting Services.
• Experienced in working RAID and SAN environment and have good understanding in capacity planning.
• Performed Production code and SSIS package deployments during maintenance windows
• Experience in providing 24 x 7 Production Support and On-Call rotation.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills
• Strong documentation skill, analytical skills as well as flexible to learn advancements in the IT Industry.

TECHNICAL SKILLS

RDBMS &Tools: -Azure, MS SQL Server 2016/2014/2012/2008 R2/2008/2005,MS Access, DB Moto.

Operating System: - Windows 7,8,10, Windows NT/ 2000/2003/2008 and 2012 Servers

Development skills: - T-SQL, SSIS/SSRS/SSAS

Languages: - T-SQL, HTML, XML

Ticketing Tools: - HPSM, Service now ServiceNow

Backup Software: - LiteSpeed, RedGet, Idera

DB Query Tools: - MS SQL Server Query Analyzer, Erwin, SQL Profiler, TOAD for SQL Server

Database Tools: - SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Analysis Services, Business Intelligence & Development Studio.

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential

Responsibilities:

• Installed/Configured SQL Server 2016/2014 on windows 2008/2012R2 environment.
• Good experience in migrating from on-prem to Cloud (Azure SQL Server) projects.
• Configured Migration and Post Installation Automation using T-SQL.
• Migrated databases from SQL Server 2008/2012 to SQL Server 2014/2016
• Use the third part tools such as REDGATE for comparing the databases and to overwrite any changes on the new servers.
• Extensively worked upon T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Migrated the SQL jobs, SQL logins using the SQL server data tools and SSIS packages.
• Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Configured the Mirroring between the required databases with and without witness server.
• Configured the required end points for the mirroring.
• Configured the log shipping between the databases.
• Created Linked Servers between 2012 and 2014 servers.
• Involved in Monitoring and troubleshooting replication issues.
• Configured Database Mail for SQL Servers for the Positive Mail Notification.
• Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
• Successfully configured and maintaining critical production AlwaysOn.
• Used to sync up the triggers, Indexes, Constraints by using the SQL Compare.
• Solved the regular tickets that we received from different application team and pointing them towards the successful completion.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Used Dynamic Management Views (DMV) for monitoring the performance of the server
• Rebuilding the indexes at regular intervals for better performance.
• Worked on Active/Active, Active/Passive, Active/Active/Passive i.e. 2-2 and 3-2 node clusters environment.
• Tuned stored procedures, Triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Reporting on a weekly basis to the Project manager.
• Extensively worked on 24 X 7 Production Database on Call Support and involved in troubleshooting SQL Server issues in various levels

Environment: Azure, Windows 2003/2008/2008 R2/2012, MS SQL Server 2000, 2005, 2008R2/2012/2014, 2016, SSRS, SSIS, MS Visual Studio, TFS, DBmoto, HPSM.

SQL Server DBA

Confidential - Atlanta, GA

Responsibilities:

• Installed and configured different versions of SQL server in Clustered and standalone servers.
• Involved in all ITIL process like Change management, Incident Management & Problem Management
• Implemented backup and Recovery strategies based on RPO and RTO
• Configured Jobs, maintenance plans, database mail and operators
• Configuring SSRS, Deploying and Migrating SSRS reports.
• Create and Modify of the database objects according to the requirement.
• Database Migrations from SQL 2005, 2008 R2 to 2012 and 2014
• Implemented table and index partitioning.
• Maintained User Permissions and Login, assigned the least required permission
• Monitoring Event Viewers, SQL Error logs
• Monitoring servers through Foglight alerts.
• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Working on production Break fix issues which include performance, blocking and space related issues.
• Configured, monitored and troubleshoot AlwaysOn iHa Availability Group and replication (Transactional and Snapshot).
• Monitored and troubleshoot log shipping configuration and errors
• Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards.

Environment: Window Server 2012/2008 R2, VMware, MS-SQL Server 2012/2008R2/2005, SSIS, SSRS, System Monitor / Performance Monitor, Foglight, Lite Speed.

SQL Server DBA

Confidential - Bellevue, WA

Responsibilities:

• Installed and Configured SQL Server 2012 on windows 2012 servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning
• Rebuilt indexes at regular intervals for better performance
• Deployed new codes (database scripts) to UAT and Production Environments.
• Performed SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts
• Involved in Index Analysis and Performance Tuning.
• Performed database consistency checks using DBCC commands
• Migrating SQL Server 2008 R2 data bases into SQL Server 2012.
• Implemented log shipping, Mirroring and Transactional Replication
• Analyzed long running slow queries and tune the same to optimize application and system performance
• Implement AlwaysOn Availability Groups for high availability mechanism
• Worked on Active/Active, Active/Passive, Active/Active/Passive i.e. 2-2 and 3-2 node clusters environment.
• Reviewed the entire environment and quantify the standardization of the databases and servers, worked on enforcement of Microsoft best practice standards
• Implemented best practice database and server security as part of Security Policies
• Monitored database environment and server utilization using Idera Monitoring Tool
• Compared schemas / data and moved database objects from one server to another using RedGate Tool
• On-call production database support

Environment: SQL Server 2008 R2, 2012, Windows 2008 / 2012 Server, SSMS, MS Visio, SQL Query Analyzer, SQL Profiler, Idera Monitoring, RedGate, Spotlight ServiceNow Ticketing

SQL Server DBA

Confidential

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2005/2008 R2
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Involved in Migration from SQL Server 2005 to 2008
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for Performance tuning.
• Used Index tuning wizard and rebuilding indexes for faster Query performance.
• Involved in resolving dead lock issues and performance issues.

Environment: MS SQL Server 2005/2008 R2, Windows 2003/2008 servers, SSIS, SSRS