Abdelkrim Kabbaj

Richmond, VA

571-***-****

advnuw@r.postjobfree.com

https://www.linkedin.com/in/abdelkrim-kabbaj-7a9118187/

SUMMARY:

A certified SQL Server DBA with (8) years of professional experience in SQL Server Database Administration with excellent technical knowledge, and troubleshooting experience in Database Design/Modeling, create, manage, deploy reports as well as creating and deploying packages using DTS, and Integration Services (SSIS). Backup/Recovery, Monitoring, Performance Tuning, Replications, Always On, Mirroring, Clustering, and writing Stored Procedures, Functions, Triggers, Constraints, and Views. Acquired solid working experience in designing and implementing Database Security including Encryption and Transparent Data Encryption (TDE).SQL Migration to Azure/Back up/Active Directory

CERTIFICAITON / TRAINING:

MCSA

MS SQL Server 2008 - 2014

MCITP

Azure

AWS

Performance tuning

CORE EXPERTISE

Database: SQL Server 2016,2014, 2012, 2008R2, MY SQL, Oracle 11g,19c

Languages: SQL, T-SQL, HTML

ETL Tools: SSIS/DTS,

Reporting: SSRS

Data Modeling: Erwin, Visio, Toad Data Modeler, SSDD

Third-Party Tools: Red Gate, Idera, Spotlight, Visio, Toad Data Modeler, SolarWinds

Networking: Active Directory, TCP/IP, TFS

EDUCATION DETAILS:

A.S Computer Science 2004 Fes Sais University, Morocco

A.S. Technical Enterprise Mgmt. 2006 Specialized Institute of Applied Technology applique, Morocco

PROFESSIONAL EXPERIENCE

Stantec, SQL Server Database Administrator, Richmond, VA Aug 2022 - Present

Responsible for installation, configuration, and maintenance of MS SQL Server on various environments

Supported: Development Team: 8 / Database Engineering: 2 /Systems Administrators: 3, experience on Azure especially migration on premises SQL Server to Azure VM and Managed Instance

Responsible for Performance and tuning of SQL servers and application issues related to migration.

Responsible for routine Backups and Restoration

Designed and Deployed SSIS Packages to Export and Import Data from various Databases and Files

Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures. Testing and implementing these procedures

Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creating of groups, granting and privileges to user and groups

Monitored MS SQL Server performance and managing the use of disk space, memory and connections.

Ran DBCC consistency checks

Monitored and tune SQL scripts. Created and upgraded scripts for Production database and supporting it

Audited stored procedures for optimization and improving performance

Profiler and execution plan for stored procedures, developed and index for optimizing performance

Assisted developers optimize and create store procedures views and functions

Dominion Energy, Database Administrator, Richmond, VA Sep 2019 – Feb 2022

Installed, Configured, and Managed SQL Server 2014/ 2012/2016/2019 and migrated databases from SQL Server 2008R2/2005/2012/2014

Configured and Maintained Four-Node Active/Passive Windows Failover Cluster with SQL Server 2012 R2 on SAN environment

Configured and maintained transactional and peer-to-peer replication and troubleshoot replication issues

Configured and administered Always on Availability Group

Designed and Deployed SSIS Packages to Export and Import Data from various Databases and Files

Performed Database Backup and Point-In-Time Recovery solutions using SQL Server Client and Quest LiteSpeed

Managed security and permission of SQL Server

Created Database Objects like Stored Procedures, functions, Views, Triggers

EHP Ventura, Database Administrator, Richmond, VA Jul 2016 - Sep 2019

Installed, configured, and managed MS SQL Server 2016/2014/2012 in Development, Test, and Production environments

Migrated databases from SQL Server 2008/2008 R2 /2012 to SQL Server 2014/2016

Performed Performance Monitoring and Tuning using windows and SQL performance monitoring tools (i.e., system monitor, task manager, extended events, SQL profiler, activity monitor, DBCC, DTA & DMVs)

Used DBCC commands, DMVs and DMFs to check database integrity, index fragmentation and statistical updates

MCM, Operational DBA Mar 2014 - Jun 2016

Installed, configured, and managed MS SQL Server 2014/2012 in Development, Test, and Production environments

Responsible for Performance and tuning of SQL servers and application issues related to migration.

Responsible for routine Backups and Restoration

Contact this candidate