Boukhalfa Ouhamouche

Enterprise Database Management

Manages 150+ SQL Server databases (2016–2022) across Production, Test, and Development environments. Conducts schema analysis to ensure consistency, implements maintenance strategies, and provides proactive monitoring and performance tuning for high-volume OLTP systems.

High Availability & Disaster Recovery

Designed and implemented comprehensive HA/DR solutions using AlwaysOn Availability Groups, Failover Clustering, Log Shipping, Database Mirroring, and Replication. Ensures minimal downtime and rapid recovery from failures across mission-critical systems.

Cloud Migration Leadership

Led on-premises SQL Server database migrations to Azure SQL Database, Azure SQL Managed Instance (MI), and Azure SQL Virtual Machines (VM) with zero data loss. Performed full backup, restore, recovery validation, and post-migration performance verification.

Performance Optimization

Specializes in query optimization using execution plan analysis, index tuning, and statistics maintenance. Uses Extended Events, SQL Profiler, and Dynamic Management Views (DMVs) to identify bottlenecks in high-volume transaction processing systems.

Production Incident Resolution

Provides 24/7 production support for mission-critical databases, resolving P1/P2 incidents within SLA. Troubleshoots complex issues including blocking, deadlocks, CPU/memory pressure, and long-running queries in real-time environments.

ETL & Data Integration

Builds and maintains SSIS ETL processes integrating ERP, Oracle, and flat-file data sources. Reduces data load errors and improves data consistency across enterprise systems using advanced data integration techniques.

SQL Server Administration

• SQL Server 2012–2022
• Installation & Configuration
• Upgrades & Patching
• Production Support

High Availability & DR

• AlwaysOn AG
• Failover Clustering
• Log Shipping
• Database Mirroring
• Replication

Performance Tuning

• Query Optimization
• Execution Plans
• Index Strategies
• T-SQL Development
• Stored Procedures

Cloud & Migration

• Azure SQL Database
• Azure SQL MI & VM
• Database Modernization
• Migration Validation

Tools & Platforms

• SQL Server Management Studio
• Redgate Tools
• SSIS / SSRS
• Performance Monitor

Languages & Scripting

• T-SQL
• PowerShell
• PL/SQL
• XML

Aldi - Senior SQL Server DBA (Mar 2023 - Present)

Houston, TX (Hybrid)

Managing 150+ SQL Server databases across production environments. Designed and implemented HA/DR solutions, led on-premises to Azure SQL migrations, and provides 24/7 production support for mission-critical systems.

Walmart - SQL Server DBA (Jul 2021 - Feb 2023)

Houston, TX

Administered SQL Server 2016–2019 environments processing 2M+ transactions daily. Led SQL Server upgrade projects, designed table partitioning strategies, and optimized replication across 2,300+ stores.

Region Bank - SQL Server DBA (Mar 2019 - Jun 2021)

Birmingham, AL (Remote)

Managed SQL Server environments supporting banking systems. Implemented database maintenance solutions, developed T-SQL solutions, built SSIS ETL pipelines, and achieved 25% query performance improvement through optimization.