WILL BROOK

FLORIDA, U.S.A

adqc6m@r.postjobfree.com,

240-***-****/813-***-****

Professional Summary

Microsoft Azure SQL DBA Certified Professional with Eight years (8) of all rounded experience in SQL database administration, and two years of experience in PostgreSQL,Maria db, DB2,Mongo DB and Oracle DBA. I have had the opportunity to work for multiple organizations and provided technical guidance, client interactions, team building and people management. I am a skilled and an easy person to work well in a team and as individual with minimal supervision. I have an excellent written and verbal communication.

Installation and Configuration

Experienced in installation and Patching of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, and 2008 on standalone and cluster servers.

Experienced in configuration of Microsoft Azure environment and also doing data migration from SQL machine to SQL Azure.

Installed and configured MYSQL Workbench 8

Installed, configured and maintained PostGreSQL 14

Azure SQL

Deploy, Configure, Maintain Compute on Azure IAAS and PAAS servers

Troubleshoot Azure related issues and engage internal teams and vendor issue resolutions

Automate deployment and troubleshoot mechanisms for quick service.

Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.

Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.

Restore deleted databases in Azure cloud.

Import and Export data within Azure Cloud environment.

Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

Upgrade & Migration

Experienced in in place upgrade and side by side upgrade, upgrade to new hardware.

Experienced in migration from MySQL/MS-SQL database management system to SQL Server 2012 and SQL Azure.

Apply OS patches and upgrades on a regular basis and upgrade administrative tools and Utilities, Configure / add new services as necessary.

High Availability & Disaster Recovery

Implemented and supported Always On Availability Groups, Clustering, Database Mirroring, Log shipping, Replication.

Experienced in creating Maintenance plans and backing up databases and restoring databases.

Creating jobs and experienced in rebuilding master database and restoring Master database and user databases.

Contribution to projects

Greatly improved the performance with less optimum resources.

Expertise in grooming of Junior DBA’s by transferring the KT.

Strong experience in mentoring team members and writing documentation.

Experienced client project presentation

Automation

Automated Daily DB Severs check Report on multiple servers which includes Disk Spaces, Last Boot Up information, Database sizes, Transaction log file sizes, Scheduled job running history, Any job schedule disabled, DB Backup history, Any Errors in error log or in event viewer.

Automated Instant Blocked Process Alerts.

Automated Deadlock Alerts, Automated Low Disk Space Alerts, Automated Missing index and Unused indexes details tracking, Automated schema changes, security changes, DB changes instant alerts

Automated the best optimum maintenance plans across the servers, automated the Business reports.

Automated Always On Availability Group using of Windows Power Shell.

Performance Tuning and Monitoring

Experienced in implementing the database mail, operator and implementing the alerts

Monitor the production server using tools like SQL Profiler, Windows Performance Counters and SQL server logs for Monitoring and Tuning SQL Server.

Experienced in performance tuning by using DBCC commands, Execution plans, system stored procedures, and DMV’s and tools like DTA and SQL profiler.

Education

Microsoft Certified: Database Administrator 70-462 Administering Microsoft SQL 2012/2014

Microsoft Certified: Azure Database Administrator Associate DP-300

Bachelor Degree Business Administration

Master of Science (MSc Data Analytics) Western Governor University 2022-2024

Professional Experiences

Title: SQL Server DBA

Client: Mosaic Co FL // Company: Capgemini

Duration: Oct 2018 to till Date

Team Size: 5

Responsibilities:

Installed, applying Service packs on MS SQL Servers 2012R2//2012-2016 C2

Configured temp database, model database and Memory configuration

Implemented SQL 2012-2019 Always on availability groups and troubleshooting on clustering

Database up-gradation from SQL Server 2008R2 to 2012/2014/2016/2017

Experienced in Database Backup/Restore, implementing Recovery Models and maintenance activities

Moved data files and log files to various drives avoiding space issue and enabled trace flags

Implementing SQL Server Security and database permissions. Creating schemas and assigning object level permissions.

Scheduling and Monitoring jobs using SQL Server Agent as per the business requirement.

Refreshing Databases in Development /Testing environments on request basis.

Rebuilding and Reorganizing the Indexes based on the Index Fragmentation Strategy.

Resolving Blocking and enabling trace to capture the Dead Lock Issues.

Design and develop ETL solutions such as SSIS and Informatica

Experienced in query tuning finding statics, blocking, dead lock, fragmentation, missing indexes, using DTA to improve query performance.

Experienced in improving database performance by considering antivirus policy, firewall, network, fragmentation, disk performance, CPU, utilization, memory utilization and disk fragmentation.

Configuring performance counters (CPU, memory, physical disk) to monitor the resource utilization.

Export or Import data from other data sources like flat files using Import/Export through SSIS

Responsible for providing 24x7 supports for production SQL Server database or priority ticket to meet SLA.

Title: SQL Server DBA

Company: Baltimore-Washington Financial Advisors, Inc. (BWFA., MD)

Duration: August 2015 to September 2018

Team Size: 4

Responsibilities:

• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

• Performed various routine DBA tasks like table space management, alert logs undo-table spaces and temporary table space, etc

• Rebuilding the indexes at regular intervals for better performance.

• Monitored and modified Performance using execution plans and Index tuning.

• Extensively worked on DBCC commands and Dynamic Management Objects.

• Implemented an archive log process to produce local and remote archive log files with multiple-archive log destinations for high-availability of the database.

• Export or Import data from other data sources like flat files using Import/Export through SSIS.

• To analyze long running slow queries and tune the same to optimize application and system performance.

• To set up SQL Server configuration settings for better server management.

• Installed and configured SQL Server 2008 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.

• Resolved and tweaked memory pressures caused during product release.

• Worked with customers on Application roll outs and server migrations.

Title: SQL Server DBA

Company: COMCAST

Duration: March 2013-Apirl2015

Team Size: 10

Responsibilities

• Migrated SQL server 2008, 2008 R2 to SQL Server 2012 in Microsoft Windows Server 2008 R2 Enterprise Edition.

• Expert in Using DMV's, Performance dash board, Log shipping, database snapshots and tracking Performance Counters.

• Rebuilding / monitoring the indexes at regular intervals for better performance.

• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions

• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.

• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

• Rebuilding the indexes at regular intervals for better performance.

• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

• Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

• Monitored and modified Performance using execution plans and Index tuning.

Technical and Software skills

RDBMS: MS SQL Server 2005-2019, MySQL, PostgreSQL, Maria DB, Mongo DB MS-Access 2003/2007

TOOLS: SSRS, SSIS, SSMS, SSDT

THIRD PARTY TOOLS: Spot light, SQL Backup- pro (Red Gate), Idera SQL DM, and Lite Speed, My Service Desk

MONITORING TOOLS: Windows Performance Monitor, SQL Trace, SQL Server Profiler, DMV, DMF, DTA,

DBCC, SQL Activity Monitor, Trace flags, Extended Events

PLATFORMS: Microsoft Windows Server: 2019, 2017, 2016, 2012, 2008, and 2003

HA & DR: SQL Failover Cluster, Always ON, Replication, Mirroring, Log shipping

VIRTUAL MACHINES: VMware, Hyper-V

LANGUAGES: SQL, T-SQL, PowerShell, C++, Python, JAVA, and HTML

NETWORKING Active Directory, DNS, TCP/IP

HARDWARE/STORAGE: SAN, RAID, iSCSI, Commvault

Environment:

Microsoft SQL Server 2008-2019, Windows 2008/2012/2016, Management Studio, Enterprise Manager, Microsoft Office packages: Microsoft Word, Microsoft Excel 2007 & Microsoft Access 2007, Performance Monitor, SQL Profiles, Microsoft Dashboard, Replication Monitor, Mirroring Monitor, DBCC, DMV, Data Collector, SCOM, Commvault, SAP, HANA, Citrix, VDI, OpenText, TFS, WorkSoft, Informatica

Contact this candidate