SUMMARY:

• Over 7 years of database administration experience with SQL server 2005 through 2017
• Excellent database administration skills in all areas including planning, implementation, configuration, troubleshooting, performance tuning, high availability, and disaster recovery
• Perform Daily DBA tasks that includes database backups and restores, manage user's permissions and securities, storage and capacity planning, maintaining SQL agent job in order to optimize index and statistics on both production and non - production environments
• Expertise in implementing different types of high availability and/or disaster recovery solutions such as log shipping, database mirroring, clustering, replication, AlwaysOn Availability Group
• Setup automated jobs using SQL server agent, native maintenance plan and Ola Hallengren maintenance plan
• Experienced in troubleshooting disk space issues, performance issues and resolving blocking and deadlocks occurrences
• Expert in setting up database mail, linked servers and transparent data encryption (TDE)
• Expertise in data migration Migrated and upgraded SQL Server Databases from lower version to higher version as well as extracting, transforming and Loading of data using Microsoft SQL Server Integration Services and Data Transformation Services
• Experienced in allocating system storage and database capacity planning
• Monitoring and optimizing experience of database queries by using SolarWinds and third party tools experience such as LiteSpeed, Foglight, SCOM, IDera and ServiceNow
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS:

Platforms: Windows Server 2016/2008/2012

Languages: T-SQL

RDBMS: Microsoft SQL Server 2017/2016/2 r2/2008

IDE: Microsoft Visual Studio 2003/2005/2008/2010

SQL Server Tools: Management Studio, SQL Profiler, Database Tuning Advisor (DTA), SSCM

Case Tools: MS Office 2000/XP/ 2003/2007/2010 , MS Outlook / 2000/2003/2010

BI & Modeling tools: SSIS, SSRS, SSAS, SSDT, BIDS

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Troubleshooting SQL Server database backup failures on Full, Differential and Transaction Log backups
• Configuring High Availability and disaster recovery solutions such as Log shipping, Windows Failover Clustering and AlwaysOn Availability Group
• Worked under Active/Passive Windows Failover Clustering environment
• Supported Customer service databases that are more than 2TB in size
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Played an active role in requirements gathering, design, configuration and documentation for Enterprise SQL Server Installations.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Troubleshoot and fine-tune databases for query and database performance enhancement
• Scheduled jobs and alerts using SQL Server Agent and proactively resolve database issues
• Documented HA and DR strategies and actively Participated in DR Test.
• Troubleshoot issues with Availability Groups/Replicas/Databases/Listener
• Correct and re-synchronize databases that are out of sync in Availability Groups
• Configuring backup strategies for Databases in Availability Groups
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in Performance Tuning, troubleshooting. Monitoring Dashboard Reports for Performance Tuning and finding bottlenecks in database.
• Expertise in handling Incidents, Service Requests and creating Change Management tickets.
• Monitoring alerts, job failures, log file issues and data file issues
• Migrated and upgraded SQL Server Databases from lower version to higher version in coordination with the application owners

Environment: Windows Server 2019/ 2016/2012/2008 , SQL Server 2017/2016/2014/2012 ,, MS Outlook, MS Word, MS Excel, MS PowerPoint, Tracker tool

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

• Installed, Configured, Administered, maintained and utilize policies and procedures for ensuring the integrity, validity and consistency of the database
• Developed strategies for data acquisitions, archive recovery, implementation of data access and table maintenance of SQL databases
• Participated in capacity planning and review database changes for system impact.
• Experienced and proficiency in setting up backup recovery strategies supporting high availability and disaster recovery
• Performed backup using backup compression and data compression in SQL server databases on clustered environment
• Migrated databases from SQL server 2005/2008 to SQL server 2012/2016.
• Implemented high availability and disaster recovery on the various servers using Windows Failover Clustering Service, Log-shipping and AlwaysOn Availability Group setup
• Implemented and tested the point in time recovery of the production databases.
• Experienced installing SSIS services and maintaining SSISDB database for successful package deployments
• Installed SSRS for scheduling reports to run on daily and weekly basis in report manager.
• Maintained and troubleshoot SQL performance tune using cycling the SQL Server error logs, Activity monitor, DBCC, DMV’s, SQL profiler and Foglight
• Resolved application connectivity issues such as connection timeouts, connection pooling issues and memory leaks

Environment: Windows Server 2016/2012/2008 , SQL Server 2016, SQL Server 2014, SQL Server 2012, MS Outlook, MS Word, MS Excel, MS PowerPoint, Tracker tool

Confidential, Atlanta, Ga

SQL Server DBA

Responsibilities:

• Involved in installation, upgrade, configuration and migration of SQL server in clustered and non-clustered production environments of SQL server
• Provided technical guidance during all phases of development
• Worked in a mission critical environment in a multi-terabyte database platform
• Managing SQL Server that is running on a VMWare and Hyper-V virtual machine
• Skillful in allocating, planning future storage requirements for the database system
• Involved in development of database including creating new databases, converting old databases to new databases, modification of existing databases as per business needs
• Expert in performing routine maintenance on database instances including applying updates, patches, and hotfixes
• Configuring SQL server security with business requirement such as server logins, user account and passwords along with database object permissions
• Involved in database migration and server consolidation along with TDE encryption and logins
• Planning and implementing backup and recovery strategies for large databases in Production and QA environments to ensure recoverability of the data warehouse
• Ensure high availability and disaster recovery by implementing failover clustering, Log Shipping and AlwaysOn Availability Group Configuration
• Installing SQL Server Reporting Services (SSRS) to create a common report template and using SSRS data source connections inside the report
• Configuring SSIS and maintaining SSISDB database for successful package deployments.
• Troubleshooting performance degradation by using native and 3rd party tools such as Activity Monitor, DMV’s and Foglight
• Monitoring SQL server logs to ensure whether the backup operations, batch commands and scripts have completed successfully

Environment: Windows Server 2012/2008, SQL Server 2014, SQL Server 2012, SQL Server 2008R2/2008, MS Outlook, MS Word, MS Excel, MS PowerPoint, Tracker tool

Confidential

SQL Server DBA

Responsibilities:

• Planning and implementing backup and recovery strategies for large databases in Production and QA environments to ensure recoverability of the data warehouse
• Expert in performing routine maintenance on database instances including applying updates, patches, and hotfixes
• Involved in development of database including creating new databases, converting old databases to new databases, modification of existing databases as per business needs
• Installing SQL Server Reporting Services (SSRS) to create a common report template and using SSRS data source connections inside the report
• Monitoring SQL server logs to ensure whether the backup operations, batch commands and scripts have completed successfully
• Developed strategies for data acquisitions, archive recovery, implementation of data access and table maintenance of SQL databases
• Updating, implementing and maintaining procedures
• Prioritize initiatives based on business needs and requirements
• Experienced in allocating system storage and database capacity planning

Environment: Windows Server 2008/2003/2000 , SQL Server 2008R2, SQL Server 2008, SQL Server 2005, MS Outlook, MS Word, MS Excel, MS PowerPoint