Data Collector Active Directory
Resume:
WILL BROOK
FLORIDA, U.S.A
***********@*****.***,
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