SUMMARY

• Expert SQL Server DBA with over 7 years of experience in installing / configuring SQL Server / 2019 enterprise edition, troubleshooting, and performance monitoring / tuning. Skilled in working with Always On high availability, implementing Transparent Data Encryption (TDE) to encrypt data, database mirroring / log shipping for disaster recovery, and identifying / testing / resolving database performance issues.
• Expertise in installing / configuring SQL Server 2014/2016/2019 enterprise edition and setting up Always On high availability on 2014/2016/2019 SQL Servers
• Good Understanding & Knowledge on Cloud computing and implementations including Infrastructure as a Service (IaaS) on VM.
• Designed, Developed and Deployed packages in SQL server environment using SSIS - 2016.
• Hands on experience on Azure cloud services.
• Developed and optimized database structures, stored procedures, Dynamic Management views (DMVs), DDL triggers and User-Defined Functions (UDFs).
• Writing complex stored procedure for different purposes.
• Performance tuning, Backup and recovery, Disaster recovery techniques such as mirroring, log shipping and clusters.
• Experience setting up and managing SQL Always on High Availability Group AAG Environments
• Experience working in a VMware environment
• Experience in AWS - platform as a service (PaaS) and infrastructure as a service (IaaS)
• Ability to work well with customers of varying levels of technical expertise.
• Hands on experience scripting in PowerShell to automate SQL administration functions.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Skilled in implementing TDE to encrypt data at a file level and for backup encryptions
• Proficient in troubleshooting performance issues for different database applications
• Expertise in using Database Tuning Advisor, Performance Monitor, and Activity Monitor for performance tuning
• Well-versed in writing complex T-SQL queries / stored procedures for retrieval of data and other applications
• Excellent in using tools like SQL server profiler and performance monitor to identify bottlenecks

TECHNICAL SKILLS

MS SQL versions: Microsoft SQL server 2019, 2016, 2014, 2012, 2008R2Availability GroupsTDE

SQL Server Tools: SSMS, BIDS, Query Analyzer, Profiler, DB visualizer, Database Engine, Tuning Advisor, Performance Monitor

Data Migration: SSIS, BCP, Data Migration, Import / Export Wizard, Detach / Attach, Backup / Restore, Azure Data Migration

BI Services: SSRS, SSIS, and SSASVMware

Scripting language: TSQL, Batch commands and PowerShell, PowerShell Scripting

Monitoring Tools: BMC, SQL Server Profiler, Performance Monitoring, and Activity, Monitor, Redgate, SQL Sentry, Extended event, Solar winds

Scheduling Tool: Windows scheduler, SQL Server Agent, PowerShell

Reporting: Microsoft SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

Senior SQL Server DBA

Confidential, Houston, TX

Responsibilities:

• Maintained data integrity by performing validation check
• Involved and interacted with the application team in upgrading
• Used results of upgrade advisor before and after migrating from SQL Server
• Implemented TDE to encrypt data at a file level and for backup encryptions
• Installed and configured SQL Server 2014/2016/2019 enterprise edition
• Set up always on high availability on 2014/2016/2019 SQL Servers
• Implemented database mirroring and log shipping for disaster recovery
• Configured snapshot and transactional replication
• Configured and maintained Always on Availability groups (AAOG)
• Used tools like SQL server profiler, and performance monitor to identify bottlenecks
• Involved in troubleshooting the performance issues for different database applications
• Used the execution plan to improve the optimization of the T-SQL code
• Identified, tested, and resolved database performance issues to ensure query optimization
• Performed migration from on premise servers to Azure cloud
• Supported ETL process and deployed SSIS package
• Supported data migration from Excel, Flat file to Microsoft SQL Server by using BCP / DTS utilities as well as extracting, transforming & loading of data using Microsoft SQL Server SSIS and DTS
• Resolved performance related issues to blocking, deadlocks, and long running queries
• Conducted baselining of SQL Servers to identify potential bottlenecks in to Memory, Disk I/O, CPU, database locks using SQL native tools & DMVs as well as third party tools
• Provided 24x7 production support for the database and application issues
• Created SSIS packages on MS SQL environment
• Checked database health / consistency by using DBCC Commands and DMVs
• Created backup strategies and scheduled them as part of database maintenance plans
• Played a key role in business requirements analysis, architecture design, physical / logical Data modeling, application development, testing,, production support, and project review with clients
• Deployed the generated reports onto the server

Environment: SQL Server 2019, 2017, 2016, 2012, 2008, SSAS, SSIS, SSRS, Service Now, Windows Enterprise Server 2003, 2008 & 2012

SQL Server DBA

Confidential, Houston TX

Responsibilities:

• Extensively involved in the maintenance of SQL Server 2014/2016
• Involved in configuring HADR solutions like replication, database mirroring, and log shipping
• Involved in building disaster recovery environment as a replica to the production servers / created custom log-shipping to manage & supported disaster recovery and restores
• Handled multiple SQL instances on cluster environment for server consolidation projects built on SAN using RAID levels
• Expertise in analyzing locks, deadlocks / handling the isolation levels and concurrency effects
• Involved in MS SQL from 32bytes to 64bytes
• Applied patches to production databases as required by the business
• Reformed de-fragmentation / reorganization of the database, rebuild indexes and move the table in MS SQL Database
• Wrote complex T-SQL queries / stored procedures for retrieval of data and other applications
• Performed database statistics and performed re-indexing through maintenance planner
• Applied security patches / service packs and evaluated the performance.
• Implemented database recovery models, backup strategies, and restore jobs
• Performed database consistency checks using DBCC Utilities
• Involved in setting up SQL server maintenance plans using client tools
• Configured logins, roles, and authentication modes
• Involved in modifying database objects following change requests
• Interacted with business analysts to clarify terminologies, concepts, and attributes
• Identified index fragmentations for decisions in rebuilding or reorganizing Indexes
• Created SSIS Packages to export and import data from various sources
• Extensively testing the performance of the stored procedures
• Monitored the SQL Server Jobs, database size, and disk space in SQL Server
• Ran DBCC consistency checks and fixed data corruption in application databases
• Configured SQL Servers with appropriate settings to resolve various resource allocation and memory issues
• Monitored connections, locks, and performance of SQL Server

Environment: SQL Server 2017, 2016, 2012, 2008, SSAS, SSIS, SSRS, Service Now, Windows Enterprise Server 2003, 2008 & 2012

SQL Server DBA

Confidential, Houston TX

Responsibilities:

• Managed database servers between the development, quality assurance, user acceptance, and disaster recovery environments
• Installed, managed, and administered SQL servers SQL servers
• Implemented side by side and In-place up-gradation of MS SQL server
• Applied patches and service packs, hotfixes to update different versions of MS SQL server
• Implemented and configured Always On High Availability in MSSQL Server
• In-depth knowledge in implementing HADR solutions like clustering, replication, and log shipping
• Designed database recovery plans and participated in disaster recovery drill processes
• Used shrinking / compression options in backup and restore jobs for storage space management
• Created and modified database objects as per change requests from development teams
• Created linked servers between different servers in SQL Server environments.
• Performed database consistency checks using DBCC Utilities and handled data corruption
• Skilled in rebuilding and reorganizing Indexes based on Index fragmentation Levels
• Implemented SQL server logins, roles, and authentication Modes as a part of security policies
• Configured the DB SMTP mail and Alert system for notification purposes
• Created / scheduled maintenance plans for jobs like checking fragmentation and backup plans
• Used Database Tuning Advisor, Perf. Monitor and Activity Monitor for performance tuning
• Created a SSIS package from Production servers
• Understood in SQL server reporting services (SSRS) on SQL Server 2016
• Created logins and roles with appropriate permissions
• Fixed SQL server failed logins following migration projects following detach and attach decisions
• Fixed the failed logins / user permissions in Active Directory and at the SQL server level
• Used IDERA SQL diagnostic manager for monitoring, analyzing, and troubleshooting
• Handled numerous change management requests on production servers
• Conducted various meetings with application teams to ensure corporate milestones are pursued and met

Environment: SQL Server 2016, 2012, 2008, SSAS, SSIS, SSRS, Service Now, Windows Enterprise Server 2003, 2008 & 2012