Database Administrator Server Dba
Resume:
Abdelkrim Kabbaj
Richmond, VA
*********.**********@*****.***
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