SUMMARY:

• 6+ years of experience, Certified SQL Server Database Administrator in managing large enterprise environments using SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2. Professional experience & skill entails configuring and managing Databases and SQL Servers including installation, configuration, backup, restoration, apply patches/Patch Management, troubleshooting, supporting clients, database monitoring, performance tuning, database security and HA/DR solutions FCI, Always - On Availability Group, T-SQL query for developing index, stored procedure, join by using logical and comparison operators.
• Migration from On-Premise to On-Premise, SSIS package migration, migration from On-Premises to Azure Cloud Environment, manage and configure Elastic database pool, create databases in Azure environment and deploy SQL Server Management Studio, configure long term Backup Retention for Azure SQL Databases, Automated maintenance job in Azure environment.

TECHNICAL SKILLS:

Databases: MS SQL Server (2019, 2016, 2014, 2012 R2, 2008 R2), Azure SQL

OS Servers: Windows Server 2019, 2016, 2012R2, 2008R2

SQL Server Tools: SQL Server Management Studio (SSMS), Activity Monitor, DBCC, DMV, Performance Monitor, Task Manager, Extended Events Query Analyzer, SQL Profiler, Database Tuning Advisor, SQL Server Configuration Manager, and Execution Plan, also Confidential s internal tools PssDiag. DiagScan, Nexus, AGDiag etc.

Performance Tuning: Execution Plan, using SQL query to solve disk fullness, Database issues, Create Index, Extended Event, Activity Monitor, Profiler, Performance monitoring tool, DTA (Database Engine Tuning Advisor), DMVs, and Third -Party tools SQL Sentry, Red-gate.

DBCC Commands: Experienced using DBCC commands to manage database consistency and repair as needed.

Database Backup & Restore: Designed backup strategies for development,, Staging, Test/UAT, and Production Environment, setup automated backup jobs.

Migration: Migrated On-premise 2012 version to 2016 version using DMA (Data Migration Assistance), Migrated On-premise to Azure platform using Data Tier Application (Export/Import), Migrated SSIS Package SQL server using SSISDB (Export/ Import)

Database High Availability: Configured and administered High Availability Always On, FCI.

Security: Secured Database, using Principal/Roles, Auditing, Policy Based Management, (Transparent Data Encryption), Row/Column Level Encryption, Dynamic Data Masking (DDM) and Always Encrypted.

Service Pack: Applied Service Pack (SP) and Hotfixes, CU for SQL Server AG / FCI Environments

SSIS: SSIS Package deploy and migrate packages.

Third Party Tools: Red-Gate, SolarWinds, SQL sentry plan explorer.

Azure SQL Server: Creating databases, Tables, Elastic database pool, selecting pricing tier, configure long term Backup Retention, automatic backup for Azure cloud environment.

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, Washington.

SQL Server DBA (Senior Engineer)

Responsibilities:

• Supporting on database monitoring, performance tuning and troubleshooting for client by using Confidential tools PssDiag, DiagScan, Nexus etc, also collecting Error Logs by using SDP file.
• Using SQL query to create Index, resolve disk fullness, Database issues for client.
• Supporting to Migrate On-premise 2012 version to 2016 version and related Trouble shooting for client.
• Supporting to Migrate On-premise to Azure platform and helping related Trouble shooting for client.
• Supporting client to create Azure SQL single database, Elastic database pool, SQL managed Instance, SQL server on VM, deploy the Azure databases on SQL Server Management Studio and Troubleshooting related issues.
• Helping client to select a service tier/pricing/purchasing tier for Azure database as needed.
• Creating Azure Automation account to Index rebuild, reorganize and statistics update.
• Supporting client Configure Long-Term Backup Retention for Azure SQL Databases.
• Working with client for Database Refresh (Production to Test Environment)
• Managing and supporting SQL Database Servers in Development, Test, and Production environment.
• Supporting client to Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014, 2016, 2017, 2019 in Development, Test, and Production environment.
• Installed, Configure and Maintained HA/DR Solutions using Always On and FCI.
• Strong working experience in Database Backup and Restore, designed backup strategies in Test, Stage and Production Environments, also supporting client to do this task successfully.
• Applied SP/Hotfixes/CU on FCI and Always on Availability Group Environments.
• Applied TDE in AG Environment.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Monitor SQL Server Error Log, Space usage, SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan.
• Besides Native tool, third- party tools Red-gate, SQL sentry plan explorer for monitoring and Performance Tuning.
• Helping client by using DBCC commands to manage database consistency and repair as needed
• Write T-SQL query for developing index, stored procedure, join by using logical and comparison operators to support the client.

Confidential, Reston, VA

SQL Server DBA

Responsibilities:

• Experience on database monitoring, performance tuning and troubleshooting.
• Using SQL query to create Index, resolve disk fullness, Database issues.
• Migrated On-premise 2012 version to 2016 version
• Migrated On-premise to Azure platform.
• Experience to create Azure SQL single database, Elastic database pool, SQL managed Instance, SQL server on VM, deploy the Azure databases on SQL Server Management Studio.
• Experience in selecting a service tier/pricing/purchasing tier for Azure database.
• Creating Azure Automation account to Index rebuild, reorganize and statistics update.
• Configure Long-Term Backup Retention for Azure SQL Databases.
• Working Experience for Database Refresh (Production to Test Environment)
• Managing SQL Database Servers in Development, Test, and Production environment.
• Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014, 2016, 2017, 2019 in Development, Test, and Production environment.
• Installed, Configure and Maintained HA/DR Solutions using Always On and FCI.
• Strong working experience in Database Backup and Restore, designed backup strategies in Test, Stage and Production Environments.
• Applied SP/Hotfixes/CU on FCI and Always on Availability Group Environments.
• Applied TDE in AG Environment.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Monitor SQL Server Error Log, Space usage, SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan.
• Besides Native tool, third- party tools Red-gate, SQL sentry plan explorer for monitoring and Performance Tuning.
• Experienced using DBCC commands to manage database consistency and repair as neededWrite T-SQL query for developing index, stored procedure, join by using logical and comparison operators.

Confidential, Alexandria, VA.

SQL Server DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2019, 2016, 2014 on Prod/Test/Dev On-Premises environment
• Upgraded SQL Server 2008 R2 and 2012 instances and databases to 2014/2016
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Performed regular backups, restores and automated different day to day tasks
• Migrate SSIS packages from SQL Server
• Deployed Changes/SPs/Queries in Production Environment
• Configured and Maintained Always on Availability Group, Monitoring, Troubleshooting, Apply SP, Backup Job Setup, Synchronization, Failover Management
• Configured and Managed SQL Server Clustered Instance, Monitoring, Troubleshooting, Apply SP, Backup Job Setup, Synchronization, Failover Management
• Performed performance tuning for servers, databases, SQL/T-SQL queries and Stored Procs
• Applied SP (Service Pack)/ patching/CU on all database instances.
• Working experience for database Refresh, Production to Test environment.