H

Omar Harchi

571-***-****

ad4akd@r.postjobfree.com

Falls Church, VA 22044

SUMMARY

As SQL Server DBA at DHS, I play a crucial role in managing and optimizing our database infrastructure. My expertise in SQL Server will be essential in maintaining the integrity, security, and performance of our Azure SQL databases, and AWS RDS.

Multi-talented Database Administrator in designing, testing and coding database solutions in various environments. Highly skilled in multiple technologies such as banking and government project. Motivated self-starter consistently meets deadlines and succeed in high-pressure environments.

SKILLS

●Microsoft SQL Server 2008 to 2019

●Commvault

●Tenable

●PowerShell

●Azure cloud shell

●SQL

●XML

●Scripting

●SSIS

●MySQL

●Requirements Gathering

●Azure

●T-SQL

●Data Warehouse

●Business Requirements

●TFS

●IIS

●Operating Systems

●Project management

●Microsoft Windows Server

●SDLC

●Additional Information

●COMPUTER SKILLS

●RDBMS:

●SQL Server 2016, 2012, 2008 R2, 2008 MS Access, MySQL, Oracle 10g ETL Tools: SSIS, DTS

●MS Platforms: MS Word, Excel, Access, PowerPoint, Microsoft Outlook Reporting: SSRS (SQL Server Reporting Services/Server)

●Data Modeling: Toad Data Modeler SharePoint and Active directory

●Programming Language: Transact-SQL,

●Windows Server 2003/2003R2/2008/2008 R2, Windows XP, VMware Other Tool: Red Gate, IDERA, Dynatrace

●Cloud computing: Azure

EXPERIENCE

Cloud Database Administrator

Department of Homeland and Security, Washington Dc 20016

Since March-2023

Oversee the maintenance and security of multiple SQL databases, ensuring their integrity and availability.

Implement disaster recovery, performance analysis, tuning, and index maintenance strategies.

Administer Active Directory user accounts and manage workflow applications.

Provide technical support for database and application issues.

Develop database backup, storage, and replication strategies, ensuring data security and compliance.

Generate comprehensive monthly reports on SQL Server usage and performance.

Coordinate network solutions and provide necessary support.

Manage SQL, DDL, DML, DCL, TCL statements for database administration tasks.

Monitor and enhance database system performance, including index optimization and database restructuring.

Oversee User Acceptance Testing (UAT) for business processes and workflows.

Database Administrator, DBA

National Heart, Lung, and Blood Institute, DHHS, Bethesda Md.

Dec 2021 to Oct 2022

●Troubleshooting database server following Jira or SNOW ticket, and apply standard changes to CME Tiers to supports different teams

●Run various DBCC commands to Checks Database Consistency

●Develop script to find out missing Index, unused Index, Duplicate Index, Partial Duplicate Index and then create appropriate Index to optimize slow running query

●Index optimization using fragmentation percentage level and developed script to rebuild Index

●Used SQL native tools to improve performance, Wait stats, DMV (Dynamic Management View), DMF (Dynamic Management Function), Activity monitor, Extended Events, Error log, Windows Performance Monitor to find out health and performance problems for the servers

●On call support for any URL issues or database issue

●Upgraded database server from lower version to upper ones in testing and production environment

●Assist Database Developers to optimize SQL queries and Stored Procedures

●Rebuild index at regular intervals for better performance

●Export & Import data from Flat file, CSV file to/from SQL Server Database using BCP, Bulk insert

●Generate Monthly SLA Report using SQL queries

●Used TDE for PII data encryption

●Shrinking database files and data compression

●Firm knowledge on implementing point in time recovery solutions

●Database refresh and deployment using backup restore or data file attach/detach Principe when needed

●Monitoring database related activities including backup, AG health, disk space, and backup verification

●Monitor Server Activity, using SQL Server Error Log, DMV, and Activity monitor tool

●Event viewer and make recommendation for improve the performance and solving problem as needed

●Deploy server alerts to Azure resource group using azure cloud shell

●Manage and resolve SNOW tickets for database related issues submitted by customer

●Support patching team by validating server state and secondary role before applying failover Principe

●Manage, validate and troubleshoot ETL package at different step, and also update ETL password every 3 month from app server then apply it in SQL server following secret server IBP procedure

●Database integrity check using DBCC check DB command

●Monitoring and maintenance of databases, installation of database software upgrades, monitoring of database backups, standardization and implementation of databases

●AWS RDS management, migration, IAM role and SCPs and deploy AMI image using EC2 image builder.

SQL Database Administrator

Georgia Own Credit Union Atlanta, GA

Mar 2018 to Dec 2021

●In the Information Management System, Responsibilities included:

●Installed, Configured, and Managed SQL Server 2016, 2012, and 2008 R2 in development, QA, and production environment

●Diagnose and resolve problems around database performance, capacity, replication,

●Azure/SQL Server DBA Experience in an IaaS/PaaS environment

●Azure/SQL Server monitoring and performance tuning, installation, administration, and maintenance

●Migrated data from on premises to Azure environment

●Working withj Agile methodology

●Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB on-going issues on all environments DEV/QA/PROD

●Coordinate and schedule DB downtimes to perform DB maintenance procedures, i.e

●DB patching, upgrades

●Managed Backup and Recovery strategies using technologies used Native SQL Server Backup/recovery Tools, IDERA, SQL Safe

●Performs database administration activities including DB Performance Tuning, T-SQL tuning, Backup and recovery and DB disaster recovery solutions

●Work with other groups gathering requirements for new instance build outs, or supporting existing applications

●Analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, Disaster Recovery or high performance

●Work independently or with other teams to design or participate in functional/performance tests

●Create/update database documentation about standard procedures, DB technology features, or production issue troubleshooting

●Design and implement highly available production systems using the following technologies: Database Mirroring, Log Shipping, SQL clustering and availability groups

●Review scripts submitted by the Development team for performance

●Work with development teams to deploy code in production when needed

●Participate in on-call rotations., the Information Management System

●Responsibilities included:

●Troubleshoot day-to-day problems encountered on production as well as development database environments

●Run various DBCC commands to Checks Database Consistency

●Develop script to find out missing Index, unused Index, Duplicate Index, Partial Duplicate Index and then create appropriate Index to optimize slow running query

●Develop script to find out fragmentation level and developed script to rebuild Index which affectedly improves performance

●Used SQL Profiler, Wait stats, DMV (Dynamic Management View), DMF (Dynamic Management Function), Activity monitor, Extended Events, Error log, Windows Performance Monitor to find out health and performance problems for the servers

●Strong technical abilities to quick learn the modern technology

●Ability to be on call 24 x 7 x 365 in a team rotation excellent verbal and written communication skills

●Installed, Configured and Maintained SQL Server Reporting Services (SSRS)

●Configured and Maintained Replications, Log Shipping, Always On

●Upgraded databases from SQL 2008 R2 to 2016 in testing and production environment

●Assist Database Developers to optimize SQL queries and Stored Procedures

●Rebuild index at regular intervals for better performance

●Export & Import data from Flat file, CSV file to/from SQL Server Database using BCP, Bulk insert

●Generated Report using SSRS (SQL Server Reporting Services)

●Configure and Maintained database encryption used TDE

●Data compression and shrinking database as necessary to improve the performance

●Recover database from backup in disasters, implement point in time recovery solutions

●Refresh Database from production and attach the database from data file when needed

●Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification

●Monitor Server Activity, using SQL Server Error Log, DMV, and Activity monitor tool

●Event viewer and make recommendation for improve the performance and solving problem as needed

●Create and execute PowerShell script

●Manage and resolve trouble tickets for database related issues submitted by customer

●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

●Experience with the creation of backup scripts and the various backup strategies that are provided by Microsoft SQL Server

●Wrote and executing Data Manipulation Language (DML) scripts for Microsoft SQL Server

●Producing database metrics using SQL Management Studio as well as the creation of custom scripts

●Configuring and operating in Windows Server 2008 R2 hosted on a virtual platform such as VMware

●Developing, producing, and reporting metrics on database performance and health.

SQL Server DBA

The Saint Consulting Group - Washington, DC November 2015 to February 2018

•Troubleshoot day-to-day problems encountered on production as well as development database environments.

•Run various DBCC commands to Checks Database Consistency.

•Develop script to find out missing Index, unused Index, Duplicate Index, Partial Duplicate Index and then create appropriate Index to optimize slow running query.

•Develop script to find out fragmentation level and developed script to rebuild Index which affectedly improves performance.

•Used SQL Profiler, Wait stats, DMV (Dynamic Management View), DMF (Dynamic Management Function), Activity monitor, Extended Events, Error log, Windows Performance Monitor to find out health and performance problems for the servers.

•Strong technical abilities to quick learn the modern technology.

•Ability to be on call 24 x 7 x 365 in a team rotation excellent verbal and written communication skills.

•Installed, Configured and Maintained SQL Server Reporting Services (SSRS).

•Configured and Maintained Replications, Log Shipping, Always On.

•Upgraded databases from SQL 2008 R2 to 2016 in testing and production environment.

•Assist Database Developers to optimize SQL queries and Stored Procedures.

•Rebuild index at regular intervals for better performance.

•Export & Import data from Flat file, CSV file to/from SQL Server Database using BCP, Bulk insert.

•Generated Report using SSRS (SQL Server Reporting Services).

•Configure and Maintained database encryption used TDE.

•Data compression and shrinking database as necessary to improve the performance.

•Recover database from backup in disasters, implement point in time recovery solutions.

•Refresh Database from production and attach the database from data file when needed.

•Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.

•Monitor Server Activity, using SQL Server Error Log, DMV, and Activity monitor tool. Event viewer and make recommendation for improve the performance and solving problem as needed.

•Create and execute PowerShell script.

•Manage and resolve trouble tickets for database related issues submitted by customer.

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

•Experience with the creation of backup scripts and the various backup strategies that are provided by Microsoft SQL Server.

•Wrote and executing Data Manipulation Language (DML) scripts for Microsoft SQL Server.

EDUCATION AND TRAINING

Associate Degree : Engineering

Northern Virginia Community College Aug 2015

Bachelor: information Technology

University of CADI AYYAD Jan 2009

Mcsa164,164, azure 103 and public trust clearance

Contact this candidate