Database Administrator Sql Server
Resume:
Tahar Rebahi
**** **** ******** ** #**** Holly springs NC 27540 *****.******@*****.***
Linkdn : linkedin.com/in/tahar-rebahi-b45a43153
MS SQL DBA/CLOUD
•US Citizen
•10 Years experience as a Microsoft SQL Server Database Administrator.
•experience with replication with a specialty in transactional replication and have worked
with the third part replication called Qlik.and mirroring, log shipping, cluster, and always on
•Skills in the areas of Installation, Configuration, Maintenance, Migration, Backup, DR Planning, Performance Tuning, Security (encryption, always encrypt, data masking), SSRS, ETL, TSQL. supporting 24/7 on call in production environment.
•Extensive experience troubleshoots 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 University of France 2001 TRAINING & CERTIFICATION
oMCITP (Microsoft Certified IT Professional): Database Administrator (MCDBA) SQL Server 2012
oTraining on SQL Server Reporting Services (SSRS): Report Development & Administration
oTraining on Database High Availability Solutions, Training on Microsoft Citrix server
oTraining Microsoft Exchange server 2003/2010
oTraining Microsoft Windows server 2008/2012
oTraining on IIS Web Server: Administration, Training Active directory
oTraining and certify on AWS Architecture
oTraining and certify on azure Architecture Training and certify on ITIL v3
Experience
Prometheus Group Raleigh, NC
DBA / Cloud Engineer Aug 2022 – Aug2023
•Migrate SQL database to AWS instances using DMA/ DMS or replication transactional
•Migrate SQL database to AWS instances using DMS or always on or replication
•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 using 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
•databases sizes is from 50 GB to 2 Tera
•Implement and administer RDS databases within a multi-tiered environment including providing
•migrate MS sql from 2012/2014/2016 to versions 2017/2019 on production and 2022 on dev
Environment
•Implement security using IAM, MFA, VPC, and KMS to manage encryption key
•Encrypt RDS database and restrict access to them
•Monitor instances and network and applications using cloud watch and cloud trail
• support on all the stages of database-related deployments, upgrades, and migrations
•work with on call team to support for critical production systems and perform scheduled
Maintenance and support release deployment activities after hours
•Applied HOT Fixes, Cumulative update on SQL Server (2008, 2012, 2014/2016/2017/2019)
•Building SQL 2016 multi-Node cluster environments on VMware/ Physical environments.
Configured Transactional Replication
•Database performance fine tuning and optimizing poorly performing queries, stored procedures
•Support users by resolving problems with application and document it
•using powershell and batch file for queries automation
Hogan Lovells DC
SQL DB Aug 2021 – Jun 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
•Building SQL 2016 multi-Node cluster environments on VMware/ Physical environments.
•Configured Transactional Replication
•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 manage on the cloud
•Installation and configuration See Unity software
Advantasure, Glen Allen
SQL DB Apr 2020 – 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
Configured and troubleshooting Log shipping
. Documentation: Prepare different documentation (SQL Server databases projects,
•Implemented ALWAYS-ON High Availability groups with two secondary nodes.
•Building SQL 2016 multi-Node cluster environments on VMware/ Physical environments.
•Configured Transactional Replication
•Configure Access Permissions for the S3 Bucket
•Creating an IAM Policy
•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 Oct 2012 - Apr 2020
•Database Installation and configuration (Development, QA and Live environment):
oSQL Server 2008, 2012, 2014/2016 (SSRS, SSIS) installation.
oFamiliar with different types of error occurred during installation.
oInstant file initializing, Proper allocation unit for system drive and other drives.
•Database Upgraded (Development, QA and Live environment):
oSQL Server 2008 to 2012 and 2014/2016/2017
oSQL Server 2005 to SQL Server 2008, 2008
•R2 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
•Create and managed MS SQL Cluster (Active/Passive), Multi node cluster on Cisco UCS blade
•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 logshipping
•Configured and troubleshooting Replications (Transactional).
•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):
oSQL Server 2000 to 2005/2008
oSQL 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:
oApplied SP (Service Pack) on SQL Server (2000, 2005, 2008) and Windows Server
oApplied 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:
oStrong knowledge and working experience in Database Backup and Disaster Recovery
oExperienced 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
TAHAR REBAHI
Aug 2024
Contact this candidate