SUMMARY:

• Having 9+ years of SQL DBA experience with Microsoft SQL Server 2000, 2005, 2008R2, 2012, 2014 and 2016.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Handling routine DB related requests like backup/Restore/Refresh and DB deployment.
• Cloud experience with Microsoft SQL Azure.
• Expertise in setup of Always - On Availability Groups (AAG) and Troubleshoot the issues.
• Daily Queue Management like incidents, requests, problem resolution requests and work with scheduled changes handled as per process of SLA by using MS, SNOW and BMC remedy in multi-complex environment.
• Experience in BI Deployment of DTS, SSIS packages and designing, implementing and supporting packages using SQL Server Integration Service (SSIS) and Reporting services (SSRS).
• Experience in backup, restore and setup different roles of SSAS packages.
• Extensive experience in designing implementing and configuring High Availability (HA) and Disaster Recovery (DR) solutions like Clustering, Log shipping, Replication, Mirroring and Always On high availability Groups.
• Implementing database security by creating logins, users, roles and assigning permissions to the principle of giving list privilege.
• Database and column level encryption thorough TDE.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and Importing/Exporting Data from various data sources like Excel and Flat file using BCP & DTS utility.
• Experience in Installation, upgrading SQL Server software to new versions and applying latest service packs as per standards.
• Experience in creating Jobs, SQL Mail Agent and Alerts.
• Experience in writing T-SQL queries, stored procedures and troubleshoot performance issues.
• Implementation of database maintenance plans and backup automation.
• Experience in Upgradation/Migration.
• Expertise in Query Optimization, Performance tuning(CPU, Memory, I/O), Database consistency using DBCC utilities and server connectivity, DMV’S, analyzing Locks, Deadlocks and Handling the Isolation Level and Concurrency Effects.
• Verifying and tuning stored procedures and queries by using Execution Plans, SQL Server Profiler and Database Tuning Advisor and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Documentation of all DBA tasks as run books and defining process of support based on application requirement and cross training to other DBA’s.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012, 2008R2, 2008, 2003

Databases: Microsoft SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000

Database / ETL Tools: SQL Profiler, Query Analyzer, SSMS, SQL Server Integration Services (SSIS), SSAS, DTS, TSQL, Azure.

Reporting Tolls: SQL Server Reporting services (SSRS) and Report Builder

Third Party Tools: SQL Backtrack, Quest Lite Speed, Idera, Ignite, Avamar, BMC Remedy, Snappimon, Snow, Microsoft Service Manager, ControlM

EXPERIENCE:

Confidential, Irving, TX

Senior SQL Server DBA

Responsibilities:

• Installation, configuration, patching, monitoring of critical SQL Server databases.
• Migrations of SQL Server and 2008 R2 to 2012,2014,2016.
• Implementation of scheduling and Maintenance of Jobs in ControlM.
• Setup Alwayson high availability group of databases and troubleshoot on it.
• Repaired, Recovered, Database Synchronization for Disaster Recovery.
• Created High Availability Solution with Database Mirroring, Log Shipping, Replication and Clustering.
• Configured and troubleshooting of SQL Server Cluster and Implemented on service patches.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
• Provided Consulting for Database Performance Tuning and used tools such as Data Tuning Advisor and Sql profiler.
• Installed SQL AZURE instances and Create Databases on SQL AZURE.
• Setting up SQL Azure Firewall and manage SQL Server AZURE Databases.
• Restore them whenever necessary, creating back up strategies and scheduling them for execution.
• Manages Mirrored databases & monitoring them appropriately Worked on Database Migration from SQL server to AZURE (Deploy DB to Windows AZURE SQL Database)
• Involved in deploy of SSIS packages and provide security and troubleshoot of SSAS and SSRS.
• Regular monitor of servers, we troubleshoot all the issues on regular basis as per priority.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Environment: SQL2005,2008,2008R2,2012,2014,2016,SSIS,SSRS,SSAS,PowerShell, Azure,Idera,ControlM and Microsoft Service Manager.

Confidential, NY

SQL Server DBA

Responsibilities:

• Migrations of SQL Server /20 and .
• Resolving all DB related external/internal production & non-production incidents within SLA.
• Handling routine DB related requests like backup/restore/refresh, Table refresh, DB changes deployment.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Created and managing Users, Roles and Groups and handling database security policies.
• Upgrading/Downgrading and Migrating the Sql Servers as per client requirement.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Resolve any data issues like Transformations, Error handling, Logging & Configurations;
• Configuring, monitoring and troubleshooting the Replication, Log shipping and mirroring.
• Attend the Database issues related calls and Work on production rollouts.
• Creating the user defined Template and running the profiler as user requirement.
• Refreshing the databases by using Lite Speed tool and configure log shipping using LightSpeed tool.
• Involved in reorg/ rebuild based on the fragmented database tables frequently and tuning SQL Queries.
• Responsible for IIS Administration for web applications includes creating virtual directories, connecting to servers, managing Services and configuring IIS backup and recovery.
• Experience working with Windows Server, including Active Directory and proper disk configurations.
• BCP in, out and exporting the data from Prod to Dev environment.

Environment: SQL 2005,2008,2008R2,2012, RapidSql, Ignite, Snapimon, Litespeed, Avamar and Snow.

Confidential

SQL Server DBA

Responsibilities:

• Responsible for keep the servers up and running.
• Responsible for maintaining the Replication and DB Mirroring and Full Text Search
• Performing daily checks on regular day-to-day basis.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Created and managing Users, Roles and Groups and handling database security policies.
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
• Reviewing SQL Server and SQL Server Agent Error Logs.
• Troubleshooting connectivity issues raised by Application users.
• Implementing and monitoring various DBA related tasks like database health check by performing weekly consistency checks, scheduled maintenance plans - backups, Error-log monitoring, resource utilization within thresholds, auto alerts, Index reorganizing & rebuilding etc.

Environment: SQL 2000,2005,2008,2008R2, DbArtisan, Sql Backtrack, BMC Remedy.

Confidential

SQL Server DBA

Responsibilities:

• Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of users.
• Installed SQL Server 2000 and 2005.
• Performing Database maintenance activities like Backups, Restoring, and Re indexing etc.
• Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Resolving various performance issues and running DBCC commands
• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Perform Full Backups and Transaction Log Backups. Restore them whenever necessary, creating back up strategies and scheduling them for execution.
• Administering Replication using Transactional Replication with updatable subscriptions.
• Manages Mirrored databases & monitoring them appropriately.

Environment: SQL 2000,2005,2008, BCP, Idera and BMC Remedy.