Rashid Djumbe

Chicago, IL | 343-201-1147 | djumbe1986@gmail.com | https://www.linkedin.com/in/rashid-djumbe-411079a1/ |

GitHub Portfolio: https://github.com/Djumbe/Rashid-Djumbe-SQL-Server-Portfolio

SUMMARY

Accomplished Senior SQL Server Database Administrator and Database Architect with 14+ years of experience

designing, implementing, securing, and supporting enterprise database environments across aviation, financial

services, energy, retail, government, healthcare, and telecommunications industries.

Expert in Microsoft SQL Server 2008–2022, SQL Server Always On Availability Groups, failover clustering, disaster

recovery, performance tuning, database security, and enterprise migrations.

Proven experience leading large-scale database modernization initiatives including Azure cloud migrations, SQL

Server upgrades, high availability implementations, data warehouse solutions, and enterprise database operational

transformations.

Experienced managing large SQL Server environments including 250+ SQL Server instances and 626 databases,

supporting mission-critical applications requiring high availability, security, and operational excellence.

Strong background in: - SQL Server Architecture - Azure SQL Database & SQL Server on Azure - Always On

Availability Groups - Disaster Recovery Solutions - Database Security & Compliance - Performance Optimization -

Power BI / SSRS / SSAS - PowerShell Automation - DBA Team Leadership

EDUCATION

Institut Supérieur de Commerce (ISC) Kinshasa, Democratic Republic of Congo

Bachelor Degree in Computer Science (Licence en Informatique) 2006 – 2009

EXPERIENCE

Senior SQL Server DBA / Database Technical Lead February 2022 – Present

Airport de Montréal (ADM) Montreal, QC

Responsible for enterprise database operations supporting mission-critical airport systems.

• Environment: Approximately 250 SQL Server instances; 626 databases; Largest database approximately 3TB;

SQL Server versions 2016–2022.

• Led database operations transition between service providers, establishing DBA operational standards,

processes, and best practices.

• Managed enterprise SQL Server operations supporting critical airport applications including flight operations,

baggage systems, security systems, and operational platforms.

• Led migration of the GES ecosystem to SMARTID ecosystem, including database planning, migration

activities, validation, and operational transition.

• Designed and implemented SQL Server Always On Availability Groups across enterprise environments from

SQL Server 2016 through SQL Server 2022.

• Developed data anonymization framework to protect sensitive production information for development and

testing environments.

• Designed SQL Server reporting solutions using SSRS for Airport Police and Migration departments.

• Provided database architecture support for Niagara Building Management System (BMS) and Historian

ecosystems.

• Managed SQL Server performance, backups, security, monitoring, and production troubleshooting.

• Provided technical leadership and mentorship to offshore DBA team members.

Senior SQL Server Database Consultant 6–Month Contract

UAP Inc. Montreal, QC

Enterprise Karmak Fusion Cloud Migration Project

• Led migration of Karmak Fusion enterprise databases from Microsoft Azure Cloud to on-premises SQL Server

infrastructure.

• Supported migration of approximately: 60 SQL Server instances; 240 databases; 64 automotive parts retailers

across Canada.

• Managed migration of primary production database approximately 2TB with supporting databases below

20GB.

• Developed migration procedures including assessment, backup/restore strategy, validation, testing, and

production cutover.

• Implemented SQL Server Always On Availability Groups to provide disaster recovery capability.

• Collaborated with infrastructure, application, and business teams to ensure successful migration with minimal

disruption.

Senior SQL Server DBA / Data Architect May 2021 – August 2023

Fondaction Montreal, QC

• Supported enterprise SQL Server database environments for financial applications.

• Designed and supported enterprise Data Warehouse implementation.

• Developed SQL data structures supporting Power BI dashboards for Marketing and business teams.

• Collaborated with internal developers on database architecture, schema design, query optimization, and

application deployments.

• Migrated SQL Server workloads from on-premises infrastructure to Azure using Lift-and-Shift methodology.

• Implemented SQL Server monitoring using Spotlight Enterprise.

• Performed SQL Server patching, Windows updates, backups, restores, and production support.

• Supported database governance, security, availability, and performance initiatives.

Senior SQL Server Database Administrator March 2021 – March 2022

Group Guillevin Montreal, QC

• Managed SQL Server environments supporting financial and business applications.

• Performed database administration including backups, restores, security, performance tuning, and

troubleshooting.

• Supported Always On Availability Groups, replication, SQL Agent jobs, and disaster recovery processes.

• Optimized queries, indexes, stored procedures, and execution plans.

• Implemented database security controls including TDE and RBAC.

• Provided production support and mentored junior DBAs.

Senior SQL Server DBA December 2019 – May 2021

Innergex Renewable Energy Longueuil, QC

• Upgraded SQL Server environments from 2012/2014 to SQL Server 2016/2017.

• Implemented SQL Server Always On Availability Groups for high availability.

• Supported Microsoft Dynamics GP finance database platform.

• Supported Historian ecosystem for renewable energy operational data.

• Implemented and supported SSRS reporting solutions.

• Supported Azure-based MDS and SSAS analytics services for system analysts.

• Designed database solutions supporting business intelligence and operational reporting.

SQL Server DBA Consultant April 2019 – December 2019

Itergy Inc. Montreal, QC

• Managed enterprise SQL Server environments including backup, recovery, performance tuning, and security.

• Developed and optimized stored procedures, triggers, views, and complex queries.

• Supported SQL Server clustering and database continuity solutions.

• Created operational reports using SSRS.

• Supported production troubleshooting and database lifecycle management.

SQL Server DBA Consultant May 2018 – April 2019

Nova-DBA Montreal, QC

• Provided SQL Server administration services for enterprise clients.

• Performed database tuning, backups, restores, migrations, and troubleshooting.

• Supported SQL Server high availability solutions.

• Participated in infrastructure support and production incident resolution.

SQL Server DBA February 2017 – May 2018

SAC Wireless Chicago, IL

• Installed and administered SQL Server environments from 2000 through 2017.

• Managed backups, restores, security, maintenance plans, and monitoring.

• Implemented clustering, Always On, mirroring, and log shipping solutions.

• Supported SSIS, SSRS, stored procedures, and database development activities.

SQL Server DBA December 2012 – June 2017

Rivers Casino Des Plaines, IL

• Supported mission-critical SQL Server environments.

• Managed database backups, recovery, security, performance tuning, and capacity planning.

• Developed stored procedures, reports, and database solutions.

• Provided 24/7 production database support.

TECHNICAL SKILLS

Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005

Azure SQL Database

SQL Server Managed Instance

SQL Server on Azure VM

Oracle Database Administration

SQL Server Always On Availability Groups

Failover Cluster Instances

Database Mirroring

Log Shipping

Replication

Backup & Restore Strategy

Disaster Recovery Planning

RPO/RTO Implementation

Microsoft Azure

Azure Migration Services

Azure Backup

Azure Site Recovery

VMware

Windows Server

Transparent Data Encryption (TDE)

Always Encrypted

SQL Server Audit

Extended Events

Role-Based Access Control (RBAC)

Certificate Management

Data Protection & Compliance

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

SQL Server Analysis Services (SSAS)

Power BI

Data Warehouse Architecture

Data Modeling

T-SQL

PowerShell

SQL Agent

SQL Profiler

Query Store

DMVs

Spotlight

SolarWinds

Foglight

Nagios

Jira

ServiceNow

PROFESSIONAL PORTFOLIO

GitHub: https://github.com/Djumbe/Rashid-Djumbe-SQL-Server-Portfolio

Portfolio includes: - Enterprise SQL Server migration case studies - Azure database modernization projects - Always

On architecture examples - SQL automation scripts - Database security frameworks - Performance tuning examples