SUMMARY:

• A Microsoft certifiedSQLServerDBAwith over 10 + years of experience in Database Administration, Design, Development and Support of MS SQL Server 2019, 2016, 2014, 2012, 2008R2 in Production, UAT and Development Environments. Hold strong knowledge of database security including data encryption and decryption. Experience in Performance Tuning, Index Tuning, Execution Plan, database Optimization, Producing Reports, Backupand Disaster Recovery. Solid experience in SQLServerhigh availabilitysolutions, including Always - On Availability Groups, and SQL Server Clustering (Active-Active, Active-
• Passive). Proficient in SQL/T-SQL, indexes, stored procedures, triggers, and functions. Proven ability to identify root cause of database issues with expertise to troubleshoot and resolve issues promptly. Performed of SQL server and database upgrades and migrate on different versions and third-party tools like ERWin, Toad Data Modeler, SQL Sentry/SentryOne, SolarWinds, Idera and Redgate. Cloud Computing (Azure Services), migrating on-premises from Legacy databases to Azure Services and setup production, development and UAT environments. Power BI experience in designing analytical reports based on company data, transating data into knowledge, as well as developing BI and analytical solutions.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2019, 2016, 2012R2, 2008.

Virtualization: VMWare, and V-sphere, Hyper-V, Virtual Box Managed Database Servers, and Databases in Virtual Environment

Database: MS SQL Server 2019, 2016, 2014, 2012 R2, 2008R2, MS Access, Oracle, MySQL and No-SQL. Azure database

SQL Server Tools: SSMS, Query Analyzer, PerfMon, Windows Event Viewer, Resource Monitor, SQL Server Profiler, BIDS/Data Tools, Database Tuning Advisor, Index Tuning Advisor, SSIS, SQL Server Configuration Manager, Activity Monitor, Job Activity Monitor, Event Handler, Execution Plan, DMVs, DMFs, DBCC

Data Modeling Tools: ERWin, Toad Data Modeler

Reporting Tools: SSRS, Report Builder, third Party Tools Tableau, Power BI

Data Migration Tools: In-Place, Side by Side SQL Server Upgrade Advisor, SSIS, SSMA, SSMS

ETL: SSIS, DTS, Third party Tools Informatica

Hardware/Storage: SAN, RAID, ISCSI

Third Party Tools: ERWin, SolarWinds, Redgate, Toad Data Modeler

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Confidential

Responsibilities:

• Worked for the Confidential ’s SQLDBA Team where my primary focus was Supports day to day operational activities for the database ad SQL server, securing database and servers, migrating SQL Servers, configuring High Availability structures, troubleshooting and in-depth root cause analysis (RCA) for database related issues.
• Installed, Configured, and Maintained SQL Server 2019, 2016, 2014 in Development, UAT and Production Environment on Premises and Cloud Environment
• Configured & Managed HA (High Availability) Solutions including monitoring and troubleshooting database Log Shipping, AlwaysOn and SQL Clustering using SQL Server 2016 and 2019.
• Installed SP (Service Pack)/ Hot Fixes, Cumulative updates, and patches in AlwaysOn, Fail-Over Clustering instances and SQL Server Standalone Instances.
• Performed performance tuning for TSQL codes having poor performance
• Used SQL Server Profiler, Extended Event, Database Engine Tuning Advisor, Performance Monitor, and Activity Monitor to analyze and monitor performance of the system.
• Troubleshoot performance issues related to query optimization, tempdb, log file growing fast, identify and release Lock, block, and deadlock.
• Configured &Managed Database and Data Security Solutions applying TDE, Column level encryption, Dynamic Data Encryption, Role based Security Policy, created server logins, database users, custom database roles, assigned users to specific roles and ensured only the required privileges are granted to the users.
• Implemented &Managed DR (Disaster Recovery) Solutions, Backup, Point-In-Time Recovery according to RPO, RTO and SLA using Native and third-party tools, setup Retention Policy for Development, UAT, Production Instances.
• Worked on Database Migration and Upgrade: In-place as well as side-by-side depending on the conditions, Used Data Migration Services (DMS) and Export-Import wizard to migrate data between On-Premises SQL Server and RDS SQL databases
• Monitored Server and Database Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Installed and Configured SQL Server Integration Services (SSIS), Deployed and Configured automated SQL Server jobs using SSIS Packages
• Automated couple of work flows using Powershell. Involved in writing background jobs using Powershell.
• To play leader ship role in managing, architecting and implementing the development and infrastructure strategies for the enterprise that could help save millions of dollars and manage a team of both application and database developers helping with the planning and smooth execution of software development project. helped large enterprises save millions of dollars by providing effcient strategies fo consoidating the databases/servers/storage and decommissioning servers freeing up data centers and licensing coast

Environment: Windows Server 2019,2016, 2012 R2, 2008 R2, SQL Server2019, 2016, 2014, 2012, DDBoost, SCOM, ServiceNow, SharePoint, Visual Studio 2013/2015, SSDT, BCP

SQL Server Database Administrator

Confidential, Washington DC

Responsibilities:

• SQL/TSQL/Database Programming:
• Performed performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard Created stored procedures, functions, Queries, views, and other database objects
• ETL/SSIS:
• Developed SSIS packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow Tasks Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services Deployed and Debugged SSIS packages for import, export, and bulk insert data with transformations from various data sources
• SSRS:
• Installed, Configured, and administered SQL Server Reporting Services. Developed periodical SSRS reports in BIDS used to generate daily, weekly, monthly, and quarterly reports. Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-downReportsusing SSRS
• Installation and Configuration:
• Installed, Configured and Managed and applied Service pack to SQL Server 2016, 2014 and 2012, 2008R2 in development, test, and production environments
• Backup/Recovery:
• Performed different daily routine backup jobs by using maintenance plan
• Performed manual and automation schedule backup job
• Performedtail logbackup forpoint in timerecovery based on the disaster recovery.
• Restored Database from backup file Server to production
• Database Upgraded/Migrated
• Created documentations for upgrade and migrate databases Solid hands-on skills in migrating/upgrading in development, testing and production environment SQL Server /2008R2 & SQL Server 2005, 2008/2008R2 to 2012 and 2014, and applying service packs.
• Database Automation/Monitoring/Performance Tuning
• Created, modified tables, Index (Clustered/Non-Clustered), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring. Created maintenance plan for Automatic Backup, Job setup, indexes rebuild and re-Organize, Automatic History Remove and cheek data Integrity UsedDBCCto check database Integrity and Consistency, monitoring error logs andDMV commandto Check Database and Server health. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification
• Monitoring Server and databases Health (Disk’s space, lock block Deadlock and why query is running slow) Monitor SQL Temp DB, Server Error Log, and Usage space
• High Availability:
• Configure and Maintained AlwaysOn in 2012 on Virtual machine
• Configure, Manage, and maintain Transactional Replication
• Configured WSFC Clustering in VMware Environment and Installed FCM and SQL Cluster
• OTHERS:
• Applied SP (Service Pack), Hot Fixes on SQL Server 2008, 2012, Create Trace file usingSQL Profilerthen review it for further steps. Tuning queries which are running slow usingPerfMon, Profiler and Statistics I/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Work with windows team to failover the cluster when needed after windows patching,create jobs, Scheduling jobs, Alerts using SQL Server agent and handle error logs for troubleshoots. Created DB master key, symmetric keys, asymmetric keys, and s forTDE Performing partition for efficient management of database tables
• Troubleshoot performance issues such as locking, blocking and deadlocks on production database using tools like SQL Server profiler

Environment: Windows Server 2019,2016, 2012 R2, SQL Server 2019, 2016, 2014, 2012, SQL Profiler, PerfMon, Execution Plan, Event handler, Activity Monitor, ASP.NET, HTML, SSIS, T-SQL, & SQL Server Agent

Confidential

SQL Server Database Administrator/DBA

Responsibilities:

• Installed, and Maintained SQL Server 2008 R2, 2012, in development, test, and production environments
• Configured Backups, involved in restoring database to point in time in case of issues, and optimization jobs for various purposes and DBA notifications like job failures, disk issues, critical events
• Support day-to-day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting locks, deadlocks, and performance issues
• Implementing high availability with AlwaysOn Availability Groups, Mirroring, Replication and Failover Clustering
• Upgraded SQL Server 2000 to SQL Server 2008 R2 and SQL Server 2005 to SQL Server 2012
• Applied SP (Service Pack) and Hot Fixes on SQL Server 2008 R2, and 2012
• Installed, Configured, and Administered SQL Server Reporting Services (SSRS) using SSRS, Crystal Reports and Report Builder
• Involved in complete database modeling and designing
• Created and managed schema objects. such as tables, views, indexes, stored procedures, and triggers and maintained referential integrity.
• Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources to SQL Server
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources
• Migrated database from various platforms like Oracle 10g/11g, MySQL 5.1/5.5 to SQL Server.
• Conducted Performance Monitoring, and troubleshooting using SQL Profiler, Execution Plan, Database Tuning Advisor, and tracing and optimizing long running queries
• Wrote T-SQL scripts including Stored Procedures, triggers, and functions
• Installed, Configured, Developed, and administered SQL Server Reporting Services (SSRS)
• Created and Deployed Scripts like tables, views, Stored Procedures, triggers, and functions
• Created and Managed Jobs, Setup Alerts, SQL Mail Agent and scheduling SSIS Packages