SUMMARY

• 7 years of IT experience in Confidential SQL Server database installation, configuration, administration, maintenance, performance tuning, backup/restore and disaster recovery experience in SQL Server 2017/2016/2014/ 2012/2008.
• Proficiency in Azure SQL database and Azure SQL Managed Instance
• Have migrated SQL database from on - premises to SQL Azure using DMA and DMS
• Have experience in configuring Virtual Machines using Azure portal.
• Create linked server between Azure SQL MI and on-premise SQL Server
• Proficiency in implementing different types of high availability and disaster recovery mechanism like replication models, log shipping, database mirroring and clustering.
• Used PowerShell to create scripts to monitor Services and Scheduled tasks, created scripts and alerts to monitor disk spaces
• Implemented a process to purge old backups and move/copy files from one location to the other using PowerShell
• Configured PowerShell to get data from SQL server databases and generate report for specific management requests
• Configured Oracle's GoldenGate to setup real-time replication between SQL Server and Oracle
• Created logins, users and assigning the permissions to users in Azure.
• Set up and managed AlwaysOn high availability for HA/DR solutions.
• Have hands on experience migrating scripts in a production environment.
• Experienced in SQL Server Reporting Services installation, configuration and maintenance using Visual Studio and Reporting Services.
• Worked on Clustering, SQL Server Replication, backup/recovery, and disaster recovery.
• Created Linked Servers between SQL Server 2014 and 2016.
• Experienced in monitoring andoptimizing the performance of a database.
• Worked on tuning database by choosing indexes and using tools Database Engine Tuning Advisor and SQL Profiler.

TECHNICAL SKILLS

Cloud Platform: Azure SQL Database and Azure SQL MI

RDBMS: Confidential SQL Server 2019/2017/2016/2014/2012/2008 , MS Access

SQL Server Tools: Management Studio, SQL Profiler, DTS/SSIS (ETL), Database Tuning Advisor (DTA).

Case Tools: MS Office (MS Excel, MS Outlook, MS Word)

BI and Modeling Tool: SSIS, SSRS, SSAS, PDM

Scripting Language: T-SQL, PowerShell

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator

Confidential, Ohio

Responsibilities:

• Responsible for all aspects of database maintenance, refresh, and tuning
• Created various database alerts as a proactive measure to prevent major database issues.
• Troubleshooting SSIS packages and making sure all jobs are running smoothly
• Perform regular database refresh to QA and Integration environments
• Database performance tuning by optimizing existing tables and stored procedures, and adjusting database file structure.
• Setting up Azure VM to company standard to perform required database shrink job and backups to use for database refresh

Azure SQL Database/ SQL MI Support Engineer

Confidential, Atlanta, GA

Responsibilities:

• use advanced troubleshooting methods to resolve Azure SQL DB and Azure SQL MI issues in Azure work with customers to find root cause of performance issue and provide guidance in database performance tuning use various tools and technologies such as Kusto and XTS to diagnose and identify root causes for complex issues.
• Assess client needs, identify challenges or issues, and configure solutions that are customized for their individual needs and ensuring their products work as intended.
• Experience with Azure cloud services - Azure SQL Database, Azure SQL Managed Instance and Azure Storages
• Identify and setup alerts and logging in Azure
• Resolve Azure SQL Db/ MI integrity, performance, blocking, connectivity issues.
• Perform and manage Azure SQL Database backup/recovery/restore
• Ethically handle private data, including financial and sensitive organizational data

Sr. SQL Server DBA

Confidential, Atlanta, GA

Responsibilities:

• Ensures adherence to disaster recovery best practiced and Confidential guidelines for on-premises and Cloud Data Solutions.
• Migrated SQL Database from on-premises to SQL Azure.
• Have experience in configuring Virtual Machines using Azure portal.
• Set up and managed AlwaysOn high availability for HA/DR solutions.
• Ethically handle private data, including financial and sensitive organizational data and preserves data integrity.
• Establish the needs of users and systems and monitor access and security.
• Control access permissions and privileges both on SQL Server and in Azure.
• Work closely with system administrators, software engineers, and data architects to ensure new data capabilities meet organizational needs while conforming to operational standards.
• Communicate regularly with technical and operational staff to ensure database integrity and security.
• Using clustered and non-clustered production environments for installation, upgrade, configuration, and migration of MSSQLServer.
• Installing and upgrading the Database server and application tools.
• Planning for backup and recovery of database information.
• Working on upgrading Confidential SQLserver, failover clustering, log shipping, and replication, using system monitor and SQLServer Profiler to identify bottlenecks.
• Discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.

SQL BI DBA

Confidential, Charlotte, NC

Responsibilities:

• Performedbackup using backup compression and data compression in MS SQL Server 2012 on clustered environment.
• Worked on a day-to-day activity such as configuring and troubleshooting agent jobs, scheduling backups and recovery, indexing, health and consistency check.
• Worked with database maintenance (partitioning, archiving, and purging), incident management, and security maintenance.
• Involved in scheduling the reports to run on daily and weekly basis in Report Manager.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.
• Administrated and managed theSQL Server 2016, 2014, 2012 production and non-production servers.
• Experienced in creating SSIS packages using proper control and data flow elements using SSDT for SQL Servers 2014 and 2016.
• Export and import data from source like flat files, row files using DTS, SQL Server Integration Services.
• Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.

SQL Server DBA

Confidential, Atlanta, GA

Responsibilities:

• Installation, configuration, upgrade, replications and migration of data using MSSQLServer in both clustered and non-clustered production environment on premises.
• Setting up the Transactional Replication in between SQL Server databases and from SQL Server to Oracle databases.
• Modifying the database structure, as necessary, from information given by application developers.
• Backup and recovery of database on production environment and creating maintenance jobs.
• Upgrading Confidential SQLserver, log shipping, and replication, using System Monitor and SQLServer Profiler to identify bottlenecks, and performing backup and recovery databases.
• Involved in development of database including creating new databases, converting old databases to new databases, modification of existing databases, creating reports to meet business needs.