SUMMARY

• Microsoft Certified Database Administrator with Six years hands on experience in Microsoft SQL Server Installation, configuration, migration, performance tuning and maintenance on Production Servers with outstanding troubleshooting capabilities of MS SQL Server 2016/2014/ 2012/2008 R2/2008/2005 in both Physical and virtual environments.
• Experience in overall database design, Normalizing and De - normalizing the tables and apply maintaining database Referential Integrity by using constraints, Primary and Foreign Keys
• Experienced in using SSIS /ETL/for data extraction, transformation and loading across different sources.
• Expertise in Analysis, designing and implementing Backup/Restore and Disaster recovery strategies and solutions.
• Experienced in Security implementation, and Automating of job process and schedule the administration tasks.
• Experienced on SQL Server high availability and disaster recovery solutions, including replication (snapshot replication, transactional replications merge and peer to peer replication), SQL Server Clustering (active-active & active-passive), Log Shipping, Database Mirroring, and AlwaysOn high Availability.
• Use DBCC commands to check physical and logical consistency of the databases and reorganized/rebuilt indexes, Create and update statistics and managed the databases effectively.
• Experienced in Performance Tuning, Query Optimization, Analyzing Execution Plan, managing indexes and troubleshooting deadlocks by using Performance Monitor, SQL Profiler, Extended events, DMVs and other related monitoring and troubleshooting tools.
• Experienced on detecting and troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Expertise in installation of hot fix and service packs
• Experienced in database migration: migrated databases from MS SQL server 2008, 2008 R2 to MS SQL Server 2012/2014/2016.
• Experienced with using performance enhancement features such as Partitioning, File Groups, and Materialized Views.
• Used Resource governor to specify resource allocation based on user groups.
• Experienced in using DAC (Dedicated Administrator Connection) in MS SQL Server while resolving login (connectivity) issues.
• Experienced in using command line tools like BCP utility for Data Transfer between various servers.
• Experienced in working with VLDB (Very Large Database).
• Through knowledge of Storage Area Network (SAN) and VMware server.
• Experienced on configuring linked server.
• Developed a good habit in creating documentation that provides guidelines in regards to maintenance tasks, policies and procedures.
• Good team player, strong interpersonal and communication skills, fast learner, dedicated, result oriented and cooperative individual.

TECHNICAL SKILLS

Platforms: Windows server 2000/2003/2008/2008 R2/2012/2012R2

Language: T-SQL, power shell, C++, HTML

RDBMS: MS SQL server 2005/2008/2008 R 2/2012/2014/2016 Ms access, Filemaker, SAP

SQL Server database Tools and services: SQL Server Management Studio, SQL server configuration manager SSIS, SSAS, SSRS, Profiler, Query Analyzer, Database Engine Tuning AdvisorBCP, SQLCMD, SQLDiag, Upgrade Advisor.

Third party tools: Idera, Solarwinds,Red gate, Spotlight, ServiceNow

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Installation, configuration, Upgrade/Migration of SQL Server 2008/2008R2 to the higher versions.
• Extensively working on database backups and restores, automating the job process and schedule the administration tasks.
• Performed data partitioning for efficient management of database tables and indexes.
• Provides dedicated support to all the production test and development MS SQL server environments.
• Monitor blocking /deadlocks and maintain all the OLTP servers with maximum database availability, reliability and investigate and resolve any database related issues.
• Monitored, troubleshoot, Optimized and fine-tuned databases' Performance issues using Database Tuning advisor, SQL server Profiler, Performance Monitors, DBCC and DMVs.
• Working on SQL server Disaster recovery and high availability solutions, including replication, SQL Server Clustering, Mirroring and AlwaysOn.
• Working on configuring linked server including from various RDBMS.
• Created SSIS packages with which data resources such as Excel, Flat file and SQL data imported daily.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Handled periodical Database Refresh in QA-Test environment for testing new Deployments
• Monitored and modified performance using execution plans and tuning the index
• Performed and necessary index tuning such as creating missing indexes and updating.
• Involved in performance monitoring and tuning using SQL Profiler, DBCC commands, DMVs and WindowsPerformance monitor.

Environment: MS SQL Server 2016/ 2014/ 2012 , 2008 R2, SSDT, Windows Server 2014, 2012 and 2008,, Query analyzer, SSIS, SSRS, Solarwinds, AYS, ServiceNow,Cisco Jabber.

Confidential

SQL Server DBA

Responsibilities:

• Working on Installation, configuration and Upgrade/Migration of SQL server to higher version
• Working on database backup and restore, automating SQL agent job process and schedule the administration tasks.
• Use DBCC commands to check physical and logical consistency of the databases and reorganized/rebuilt indexes, Create and update statistics and managed the databases effectively.
• Created databases, tables, cluster/non-Cluster index, unique/check constraints views and triggers
• Working on resolving the Tempdb and disk space issues.
• Managing SQL Server logins and user accounts, granting of permissions based on the business requirements,
• Responsible for performance tuning and optimization of databases using built in and third parity tools
• Working on Extraction, Transformation and Loading using SSIS across different sources
• Monitor blocking /deadlocks and maintain all the OLTP servers with maximum database availability, reliability and investigate and resolve any database related issues.
• Monitor windows event log for system, application errors, and available issues.
• Working on SQL server Disaster recovery and high availability solutions, including replication, logshipping, SQL Server Clustering, Mirroring and AlwaysOn.
• Working on configuring linked server including from various RDBMS.
• Installation of hot fix and service packs in MS SQL server.
• Migrating and upgrading SSIS packages
• Worked on production migration from SQL Server 2008R2 to 2016

Environment: MS SQL Server 2016/ 2014/ 2012 , 2008 R2, SSDT, Windows Server 2014, 2012 and 2008,, Query analyzer, SSIS, SSRS, Solarwinds,Idera, IT 360 Service Desk .

Confidential

SQL server DBA

Responsibilities:

• Responsible for installing, Configuring and maintaining SQL Servers
• Resolving system/database issues, monitoring automated jobs, monitor system availability
• Coordinating with the Systems Administration/Network team pertaining to any system, network related issues.
• Support and maintenance of Transactional Replication and experience in troubleshooting replication problems.
• Administer security for server logins (Windows, SQL Logins) and Role based permissions
• Periodic creation of objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment
• Worked in Cluster environment which included replication as a High availability solution.
• Periodic monitoring of Database Health by using Consistency Check Commands
• Good experience in pulling out performance and database growth Reports using Spotlight tool
• Worked on Performance Tuning of long running Queries and Stored Procedures using Database Engine Tuning Advisor and Profiler.
• Worked on deploying Codes, SSIS packages and jobs in production environment
• Daily routine DBA tasks like handling Security and space issues
• Handled periodical Database Refresh in QA-Test environment for testing new Deployments

Environment: Windows 2003 / 2008 Server, SQL Server 2005/2008/ 2008 R2,2012 Management Studio, SQL Profiler, SQL Query Analyzer, DTA, SSIS, SSRS and Spotlight

Confidential

SQL server DBA

Responsibilities:

• Installed, configured and migrated SQL Server 2008/2008R2/2012 in clustered and non-clustered production environments.
• Provided advice to management on SQL server 2005/2008/2008 /2008R2/2012 pre-installation requirements.
• Installed SQL Server service packs based on the errors and requirements.
• Developed and performed SQL server Maintenance plans: Database backups, Integrity Checks, Update Database Statistics and Index maintenance.
• Managed SQL Server logins and user accounts granted server and database level permissions based on the business requirements; and configured and audited SQL Server security issues.
• Monitored, troubleshoot, Optimized and fine-tuned databases' Performance issues using Database Tuning advisor, SQL server Profiler, Performance Monitors, DBCC and DMVs.
• Resolved concurrency issues in SQL server by adding Index, by Tuning queries, identifying missing indexes and using appropriate isolation level.
• Created databases, tables, cluster/non-Cluster index, unique/check constraints views and triggers
• Developed SSIS packages for importing and exporting data.
• Prepared reports based on the requests.
• Involved in Design and implementing SQL server comprehensive disaster recovery strategies including failover clustering, replication, log shipping and database mirroring.
• Involved in Linked Server setup.
• Monitor Server Level Blocks/deadlocks & Maintain all the OLTP Servers with Maximum Database Availability, Reliability & Investigate and resolve any Database Related issues /performance related issues with Minimal Downtime & Maximum Reliability

Environment: MS SQL Server 2008,2008R2, MS SQL Server 2012, Windows 2003 Enterprise Edition, SQL Server Management Studio, SQL Profiler, SSIS, SQL Agent