Sql Server Data Modeling

MS SQL DBA/CLOUD

TAHAR REBAHI

Cell 571-***-****

************@*****.***

US citizen (8) Years experienced as a Microsoft SQL Server Database Administrator. Skills in the areas of Installation, Configuration, Maintenance, Migration, Backup, DR Planning, Performance Tuning, Security, SSIS, SSRS, ETL, TSQL, SAN, Data Modeling and design and supporting 24/7 on call in production environment. Long experience troubleshoot users in LAN/WAN, Detail oriented hardworking professional with an effective combination of logical, analytical, communication and documentation EDUCATION

Master Degree in IT Informal Institute of ALGERIA 2004 Bachler Degree in IT EFTG Unversity of France 2001 TRAINING & CERTIFICATION

MCITP (Microsoft Certified IT Professional): Database Administrator (MCDBA) SQL Server2012 Training on SQL Server Reporting Services (SSRS): Report Development & Administration, Training on Database High Availability Solutions, Training on Microsoft Citrix server Training Microsoft Exchange server2003/2010

Training Microsoft Windows server 2008/2012server 2008/2012 Training on IIS Web Server: Administration, Training Active directory Training and certify on AWS Architecture

Training and certify on azure Architecture

Training and certify on ITIL v3

Experience

Prometheus Group dba/ Cloud Enginner Aug 2022--Mar2023

*Migrate sql database to aws instances

*Migrate applications on aws

*Migrate VMs and servers to aws using Application migration service

*Monitor instances and applications using cloud watch, cloud trail

*Moving Data from aws to azure usin RCLONE

*Monitor vdas Citrix using RPTG and citrix cloud

* Monitor/maintain/upgrade RDS database and assist application teams with performance tuning

* Troubleshoot RDS database slowness, Disk/Memory/CPU utilization and suggest resolutions

* Implement solutions for RDS database backup and recovery infrastructure

* Implement and administer RDS databases within a multi-tiered environment including providing support on all the stages

of database-related deployments, upgrades, and migrations

* work with oncall team to support for critical production systems and perform scheduled maintenance and support release deployment activities after hours

• Database performance fine tuning and optimizing poorly performing queries, stored procedures

• Support users by resolving problems with application Hogan Lovells, Washington DC SQL DB August 2021 Until june 01 2022

Fine-tune Stored Procedures and T-SQL Queries using Execution Plan, Extended

Events, DMV, wait status, etc. to make them perform better

Create database objects including tables, views, functions, triggers, stored procedures and indexes

Refine and automate regular processes, track issues, and document changes

Assist developers with query tuning and schema refinement

Perform research into database performance issues and come up with solutions to address those concerns

SQL Query Performance Tuning, System Performance Analysis, analyzing the Query

Execution Plans, Used SQL Profiler for optimizing the stored procedure.

Helped Development Team in deploying and testing the application, which uses SQL Server as a database.

Migration from different databases around the word using see unity software to net document and Imanage on the cloud

Installation and configuration SeeUnity software Advantasure, Glen Allen SQL DB April 2020 to May 2021

Perform regular database maintenance tasks such as rebuilding indexes, update statistics, database integrity check, storage management, monitoring performances, etc.

Apply Hot Fixes, Patches, Cumulative Updates, Service Packs, Upgrades, Install, manage and administer SQL Server 2008R2/2012/2016 production as well as non- production environment.

Manage backup and recovery systems to maintain disaster recovery planning

Implemented ALWAYS-ON High Availability groups with two secondary nodes.

Building SQL 2016 multi Node cluster environments on VMware/ Physical environments.

Configured Transactional Replication.

Configuring a Snowflake Storage Integration to Access Amazon S3

Configure Access Permissions for the S3 Bucket

Creating an IAM Policy

Create a Cloud Storage Integration in Snowflake

Knowledge of public cloud infrastructures and migration of on-premises SQL Server databases into the cloud (Azure)

Design high availability architecture for database availability

Configure and maintain database Transaction replication

Add new node to existing SQL Server Cluster

Configure Database Mail, Linked Servers, Transparent Data Encryption (TDE) and

Change Data Capture(CDC)

Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.

Developed reports using SQL Server Reporting Services (SSRS).

SQL Query Performance Tuning, System Performance Analysis, analyzing the Query

Execution Plans, Used SQL Profiler for optimizing the stored procedure.

Helped Development Team in deploying and testing the application, which uses SQL Server as a database.

Worked on and maintained an Active / Passive clustered environment.

Working on SQL server clusters with multiple nodes on each cluster and other methods of disaster recovery.

Diagnose and resolve data management problems and issues.

Monitoring and maintenance of databases, installation of database software upgrades, monitoring of database backups, standardization and implementation of databases to improve the management of production and test environments, physical database design

Documentation of standards and procedures, assistance to application developers, backup and recovery and consulting

Database performance fine tuning and optimizing poorly performing queries, stored procedures

Support users by resolving problems with applications databases.

Configured and maintain replication technologies that are used to support MSSQL to include log shipping, transactional, and snapshot replication

Successful implementation of service packs and version upgrades for MSSQL

Fine-tune Stored Procedures and T-SQL Queries using Execution Plan, Extended

Events, DMV, wait status, etc. to make them perform better

Create database objects including tables, views, functions, triggers, stored procedures and indexes

Refine and automate regular processes, track issues, and document changes

Assist developers with query tuning and schema refinement

Perform research into database performance issues and come up with solutions to address those concerns

Participate in the on-call rotation

Applies best practice for tuning SQL databases to improve overall performance

Perform database health checks using DBCC commands, DMV, Error log, Event log

Set the technical direction through the definition and implementation of standards, technical roadmaps, processes and controls

Document standard processes and procedures on a regular basis• Conduct various meetings with teams to meet corporate milestones for database merging and data movement

Review technical designs, reports, documentation and other materials produced by team member

AVANT Inc., Richmond, VA MS SQL DBA (October 2012 to April 2020)

Database Installation and configuration (Development, QA and Live environment):

SQL Server 2008, 2012, 2014/2016 (SSRS, SSIS) installation.

Familiar with different types of error occurred during installation.

Instant file initializing, Proper allocation unit for system drive and other drives.

Database Upgraded (Development, QA and Live environment):

SQL Server 2008 to 2012 and 2014/2016

SQL Server 2005 to SQL Server 2008, 2008R2

Server Migrated (Production environment )

Physical server to VM ware.

Standalone to Active/passive Cluster (By consuming Old DNS name and IP Address)

Database Developing and deployment (Change management)

Written T-SQL, Trigger, and Stored-Procedures

Assisted application, web and database developers to optimize SQL queries, Stored Procedures, functions etc.

Maintain a change control process. Guide developers through new SQL code deployment to Dev, QA and Production environment. Tool use - TFS, SQL compare, Service Desk.

Database High Availability:

SAN replication, Avamar, De-duplication.

Create and managed MS SQL Cluster (Active/Passive), Multi node cluster on Cisco UCS blade chassis 5100 series, shared storage on EMC VNX 5200 Series.

Installed, Configured and Maintained SQL Database Mirroring (High Safety) using automatic fail- over option (Multi database, Agent Job) for Jennifer(Voice Picking Software for warehouse solution)

Configured and troubleshooting Replications (Transactional).

Data Modeling:

Involved in data modeling for the application and created ER diagram.

Backward & Forward Engineering with data modeling tools mentioned above

Tools Used: VISIO, SQL Server Data Diagram

Patch Management:

Applied SP (Service Pack) on SQL Server (2008 and 2012) and Windows Server (2008, 2003,

Cluster aware update for windows servers 2012 R2.

Applied HOT Fixes, Cumulative update on SQL Server (2008, 2012, 2014/2016)

Database Monitoring/Performance Tuning:

Strong knowledge on database Monitoring and Performance tuning.

Monitor different logs, Space usage, Events, Agent Job history by PowerShell scripts.

Provide support to application developers in designing and implementing physical database structures.

Tune slow running, resource-consuming queries by evaluating query execution plan.

Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve deadlock, block, and locking conflicts and resource utilization.

Backup/Recovery:

Idera Backup solution - SQL SAFE.

Familiar with EMC Recovery Point techniques.• Strong working experience in SQL native database Backup and restore.

Disaster Recovery planning and implementation.

Experienced with Point-in-Time Recovery.

Dealing with Database Corruption:

Take necessary prevention for data corruption.

Strictly maintain data integrity using DBCC CHECKDB.

Documentation: Prepare different documentation (SQL Server Build Guide, Database Decommissioning steps, restore steps,) and update them in timely manner.

Encryption: PCI complacence by using SQL Compliance from Idera, SQL auditing.

Managing backups and restore on cloud using RDS

Migration sql server to AWS

Westin Arlington Gateway, Washington D.C.

Database Analyst (September 2011 to September 2012)

Database Upgraded (development, testing and production environment):

SQL Server 2000 to 2005/2008

SQL Server 2005 to SQL Server 2008, 2008R2

Database Migrated (development, testing and production environment)

Oracle 10gR2 databases to SQL Server 2008

My-SQL 4.1.0/5.0.1 databases to SQL Server 2005 and 2008

Tools Used: SSMA (SQL Server Migration Assistant) for Oracle, MySQL, Access, and ODBC/DB Link

Database Programming:

Written T-SQL, Trigger, and Stored-Procedures

Assisted Database Developers to optimize SQL queries, Stored Procedures etc.

Tools Used: Query Analyzer

DTS/SSIS:

Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources

Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources to SQL Server

Database High Availability:

Managed MS SQL Cluster (Active/Passive), Multi node cluster.

Installed, Configured and Maintained Database Mirroring using automatic fail-over option

Configured Log Shipping as Standby database from Production database for Reporting purposes

Configured and Maintained Replications (Transactional)

Technology Used: Clustering, Database Mirroring, Log Shipping, and Replication

Report Development:

Installed, Configured, and administered SQL Server Reporting Services (SSRS)

Developed, Deployed, and Managed Reports

Managed Reports Security

Tools Used: Developed Reports using BIDS (Business Development Studio), and Report Builder 3.0, 2.0

Data Modeling:

Involved in data modeling for the application and created ER diagram using ERWin

Backward & Forward Engineering with data modeling tools mentioned above

Tools Used: Data Modeler, VISIO, SQL Server Data Diagram• Patch Management:

Applied SP (Service Pack) on SQL Server (2000, 2005, 2008) and Windows Server

Applied HOT Fixes on SQL Server (2000, 2005, 2008) and Windows Server

Database Monitoring/Performance Tuning:

Strong on database Monitoring and Performance tuning

Monitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine

Tools Used: SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, Perfmon, Counter etc

Backup/Recovery:

Strong knowledge and working experience in Database Backup and Disaster Recovery

Experienced with Point-in-Time Recovery

Extensive knowledge on Restoring Databases using backups AWS

Migrate from MSSQL server to AWS using SCT/DMS

Create S3 buckets and give users permission using ACL

Create access control to S3 using VPc

Contact this candidate