Sql Server Disaster Recovery
Resume:
Seybou Diallo
Senior SQL Server Database
Engineer
Bethesda, MD, USA 347-***-****
Highly skilled SQL Server Expert with 10+ years of progressive experience in the information technology industry, ensuring availability and functionality withing SQL Server environment through disaster recovery solutions, backup plans, and business continuation strategy. Experienced in change management, following best practices throughout transition in production environment. Skilled at migrating databases from on-prem to Cloud platforms with no interruptions to business operations. Proven success designing/implementing wide range of database changes with high availability and disaster recovery plans. Technical Proficiencies
Platforms: SQL Server 2019/2017/2014/2012/2008R2/2008/2005/2000, MS Access, Azure Databases, Azure Managed Instances.
Tools: SSIS/DTS, BCP, BMC Remedy, Idera Diagnostic Manager, Idera SQL Doctor, Commvault backup, Lightspeed Backup, Symantec NetBackup, Foglight Monitoring, OlA Hallengrem maintenance Scripts and Brent Ozar First Responder Kit Programming: T-SQL, Windows PowerShell Scripting, Java. Azure automation. DB/Data
Modelling:
SQL Server Database Diagrams, Visio, SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS)
Operating
Systems:
Windows Server 2019/2016/2012R2/2008R2/2003, Unix, Linux. Professional Experience
GEICO Chevy Chase, MD 2013 – Present
Senior Systems Engineer II, SQL Server
Establish policies, processes, and best practices across the enterprise, maintaining healthy and secure database environment. Identify/resolve performance bottlenecks by conducting performance tuning and optimization. Design, implement, maintain, and monitor database systems during/after migration of DB systems to Azure Cloud.
Engaged in design of databases and capacity planning, rebuilding of indexes at regular intervals for better performance, and troubleshooting/fine-tuning of databases for performance and concurrency.
Decreased system vulnerabilities by embedding various database related security programs while reviewing designs for potential security risks and improving software quality by assessing systems/design methods.
Seybou Diallo
2
Executed several infrastructure planning and implementations, including technical platform selection, instance strategy, architecture design, and backup/recovery strategy.
Designed/implemented new data management schema, detailed backup plan, and disaster recovery strategy for very large databases (VLDB).
Enabled availability and accessibility of database and network resources by creating disaster recovery and business continuation plans for IT systems and system redundancy.
Created databases, views, tables, triggers, store procedures, data structures, accessing strategies, Windows clustering, and availability group.
Produced optimal performance and uptime within production environment by guaranteeing 24/7 production support for SQL Server databases on clustered servers ranging from 1 to 30+ terabytes.
Adopted standards and configuration controls by using change management process for enterprise systems, including Enterprise Systems Management, Windows Platforms, and Messaging. Insight Catastrophe Group New York City, NY 2012 – 2013 Senior Database Administrator, SQL Server
Instigated 24/7 production support for database issues to ensure continuous maintenance, troubleshooting queries and performance issues to recommend changes for optimization. Administered couple clustered SQL server and service packs.
Maintained multiple production, development, and staging SQL Server databases, as well as user accesses.
Developed performance baseline for production environments, security policies, and new standard for SQL Server environment.
Steered build of replications between reporting databases and production databases.
Completed various deployments between a wide range of SQL Server environments and migrated production SQL Servers after Sandy.
Dimenionu Inc. New York City, NY 2011 – 2012
Senior Database Administrator, SQL Server
Oversaw health of SQL Servers through the restoration, backup, and monitoring of servers while reviewing/tuning SQL queries, views, triggers, and stored procedures. Improved performance of applications in conjunction with in-house developers.
Designed/implemented database changes, as well as disaster recovery and high availability solutions while configuring I/O subsystems for performance improvement.
Drove cost optimization for software and infrastructure expenses by consolidating databases onto less servers.
Delivered suggestions on disk capacity, memory, and processors according to capacity planning.
Reviewed SQL Server performance to recommend opportunities for improvement to Developers, covering areas like storage, code, configuration, and indexes. Seybou Diallo
3
Provided 24/7 on-call production support for database issues while automating most SQL Server maintenances, saving time needed to complete processes manually.
Installed/configured SQL Server 2008 on Windows Server 2008 while setting up log monitoring/alerting, shipping/mirroring for High Availability (HA), and replication for reporting function.
Collaborated with Developers on creating stored procedures/triggers, new schema design, and to tune SQL queries, as well as with Windows Administrator to implement Windows/SQL Server Clustering. Additional Experience: Database Administrator: SQL Server & MySQL, Bluewolf Database Administrator: SQL Server, Energie Du Mali IT Helpdesk, Westchester University Education
Bachelor of Science in Computer Science & Mathematics Westchester University Westchester, PA
Licenses & Certifications
Microsoft Certified Professional (MCPS)
Microsoft Certified Solutions Associate, SQL Server 2012 (MCSA) Certified in ITIL Foundation
Professional Training
Mastering Index Tuning; Mastering Query Tuning; Mastering Parameter Sniffing; Mastering Server Tuning and The Senior DBA Class. Brent Ozar Unlimited
Immersion Event on Azure SQL Database, VMs, Azure Managed Instance SQLskills IEAzure Immersion Event on Clustering and Availability Groups SQLskills IECAG Immersion Event on Performance Tuning and Optimization, Part1 SQLskills IEPTO1 Immersion Event on Performance Tuning and Optimization, Part2 SQLskills IEPTO2
Contact this candidate