Sql Server Database Administrator
Resume:
Tahar Rebahi
Holly springs NC 27540
ad061g@r.postjobfree.com
MS SQL DBA/CLOUD
• 10 Years experienced as a Microsoft SQL Server Database Administrator.
• 8 years’ experience with replication with a specialty in transactional replication and have worked with the third part replication called Qlik.
• 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.
• 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
o MCITP (Microsoft Certified IT Professional): Database Administrator (MCDBA) SQL Server 2012 o Training on SQL Server Reporting Services (SSRS): Report Development & Administration o Training on Database High Availability Solutions, Training on Microsoft Citrix server o Training Microsoft Exchange server 2003/2010
o Training Microsoft Windows server 2008/2012
o Training on IIS Web Server: Administration, Training Active directory o Training and certify on AWS Architecture
o Training and certify on azure Architecture Training and certify on ITIL v3 Experience
Prometheus Group Raleigh, NC
DBA / Cloud Engineer Aug 2022 – Mar 2023
• 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 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
• 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 on call 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, 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
• 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
• 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 Oct 2012 - Apr 2020
• Database Installation and configuration (Development, QA and Live environment): o SQL Server 2008, 2012, 2014/2016 (SSRS, SSIS) installation. o Familiar with different types of error occurred during installation. o Instant file initializing, Proper allocation unit for system drive and other drives.
• Database Upgraded (Development, QA and Live environment): o SQL Server 2008 to 2012 and 2014/2016
o SQL 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
• 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): o SQL Server 2000 to 2005/2008
o 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:
o Applied SP (Service Pack) on SQL Server (2000, 2005, 2008) and Windows Server o 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:
o Strong knowledge and working experience in Database Backup and Disaster Recovery o 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