Abdelkrim Kabbaj

adpn8h@r.postjobfree.com Cell: 571-***-****

OBJECTIVE

A certified SQL Server DBA with (7) 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, Azure Backup, Azure Active Directory

Substantial knowledge, and strong experience in using third party tools like Red Gate, Idera, Solar Winds, Net, ERWin, Visio and Toad Data Modeler in managing SQL Server database development.

Very good team player and can work without supervision self-motivated and can easily work with non-technical people.

EDUCATION

Dhar El Mahraz University, Morocco: June 2003

•Bachelor’s degree in science

Specialized Institute of Applied Technology applique, Morocco: June 2006

•Technician of enterprise management

CERTIFICATES & TRAININGS

•MCSA: Microsoft Certified Solution Associate) - MS SQL Server 2012/2014

•MCITP: Microsoft Certified IT Professional on Microsoft SQL Server 2008,2012

•Training on Azure and AWS

•Training on performance tuning.

SKILLS & ABILITIESs

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

Operating System: Windows Server 2016, 2012, 2008 R2, Windows XP, 7, 10

Languages: SQL, T-SQL, HTML

ETL Tools: SSIS/DTS,

Reporting: SSRS (SQL Server Reporting Services), VISIO 2007/2010

Data Modeling: Erwin, Visio, Toad Data Modeler, SSDD (SQL Server Database Diagram)

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

Networking: Active Directory, TCP/IP, TFS (Team foundation Server)

WORK EXPERIENCE

Dominion Energy, VA September 2019 - Present

Database administrator

•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.

•Managed index usage and fragmentation and updated statistics in databases.

•Involved in troubleshooting and fine-tuning database performance and concurrency and root cause analysis.

•Monitor Event viewer, SQL Error logs and Failover Cluster Manager Event Viewer for software and hardware related errors

•Worked on Query optimization and tuning using SQL Server Profiler, Database Engine Tuning advisor, and Activity Monitor and analyzing execution plan.

•Check the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation, and the impact on system performance. Analyze potential problems (response delay, locking, server down time, etc.) to avoid and optimize.

•Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

•Checked Database Health by using DBCC Commands and DMVS.

•Enforced Policy Based Management at Database Level as well as Table Level.

•Implemented Partitioned Table, Error handling through TRY-CATCH statement, Common Table Expression (CTE), MERGE statements.

•Developed reports using SQL Server Reporting Services (SSRS) and deployed in SharePoint.

•Involved in Data Modelling, Normalization, developing Logical/Physical ER Diagram using Erwin and SQL Server Data Diagram.

•Translated business requirements into technical design specifications and actively supported business users for change requests.

•Provided 24/7 on call support for all the Production Servers.

•Designing Migration Plans for SQL Azure Project, Identifying On-premises Workload.

•Managing Monitoring Azure Backup Service

•Managing & Monitoring Azure Virtual Machines

•Architecting for High-Availability in Microsoft Azure for SQL workloads with Availability Sets

EHP VENTURE, VA July2016-September 2019

Database administrator

•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,

•Administrated the MS SQL Server security by enforcing security policy.

•Resolved low disk space alerts, connection issues and failed jobs,

•Identified and Troubleshoot CPU, Memory, and I/O bottle necks,

•Configured database mail, jobs, and alerts in all SQL Servers,

•Planed, designed, and implemented backup and restore plans according to company’s Recovery Time Objective (RTO) and Recovery Point Objective (RPO),

•Configured various event driven e-mail notification process in SSIS packages,

•Develop, update, and maintain existing processes and procedures relating to databases

•Maintain, monitor, and improve database status, security integrity, access controls and performance

•Develop, test, and maintain procedures for backup, restoration, and Disaster Recovery for high availability databases

•Provide Database capacity planning and developing and maintaining best practices

•A basic understanding of executing PowerShell scripts and as they related to MSSQL is required.

•Ensuring database integrity, stability, and system availability.

•Ensuring new database schema meets standards for readability and performance.

•Performance tuning new and existing applications.

•Working with IT Manager to be responsible for database procedures, and related documentation.

•In-depth understanding of application lifecycle management process including planning, design, development, maintenance, and management of multi-terabyte OLTP databases in a 24/7 support environment.

MCM CPAs & Advisors LLP IN March 2014-June 2016

Operational SQL DBA

•Install, maintain, and troubleshoot all database environments and serves as primary SQL server database administrator

•Monitor, identify, and implement security related updates and patches for SQL Server database systems and Microsoft OS

•Configured SQL Server Agent job and automated alerts and maintenance plan,

•Performed root cause analysis for slow running quires, missing index, outdated statistics, blocking and deadlocking issues,

•Configured and maintain database Always on in Synchronized and A synchronized mode,

•Imported and Export data from/to flat file, access, excel to/from SQL Server databases using SSIS and Import/Export wizard,

•Create and maintain documentation as it relates to database system configuration, mapping, processes, and service records.

•Recommend and execute modifications to database and server environments to improve efficiency and performance.

•Coordinate and collaborate with various Information Services departments to ensure availability, reliability, and scalability of corporate database environments to meet business demands.

•Configure and maintaining different high availability technologies that are used to support MSSQL i.e., log shipping, transactional, and snapshot replication, mirroring.

•Manage clustered/non-clustered indexes, index rebuilds, partitioning.

•Manage security, roles, logins, and user accounts integrated with Active Directory.

•Teaming with technical and business resources to perform implementation and ongoing upgrades.

•Developed parameterized and non-parameterized store procedures, functions, triggers, views and other T-SQL codes,

•Deployed and Automated SSIS Packages using SQL Server Agent Jobs,

•Monitors and maintains physical database structures for data integrity, database performance, quality, recoverability, and maintenance and space requirements to maintain optimal service levels.

•Researches, evaluates, and coordinates software releases, systems upgrades, enhancements, and software updates to ensure that client specifications, industry standards, and best practice guidelines are met.

Contact this candidate