Sql Server Database Administrator
Resume:
Omar Harchi
●**.****.******@*****.***
●Falls Church, VA 22044
●Public Trust Clearance
SUMMARY
* ***** ** *** ****** Database Administration experience both on premise and cloud; installation, configuration, migration, upgrading, performance tuning, query optimizing, backup/recovery, clustering, mirroring, log shipping, replications, managing Database Always on Availability group, Azure as well as on Azure in an IaaS/PaaS. Multi-talented Database Administrator in designing, testing, and coding database solutions in various environments. Highly skilled in multiple technologies across industries in banking and government. Motivated self-starter consistently meets deadlines and succeeds in high-pressure environments.
SKILLS
●Microsoft SQL Server 2008 to 2019
●Commvault
●Tennable
●Powershell
●Azure Cloudshell
●SQL
●XML
●Scripting
●SSIS
●MySQL
●Requirements Gathering
●Azure
●T-SQL
●Data Warehouse
●Business Requirements
●TFS
●IIS
●Project management
●Microsoft Windows Server
●SDLC
●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: RedGate, Idera,dynatrace
●Cloud computing: Azure and Aws
●Jira
●Splunk
●Tenable
●ATO
●NMAP
●Wireshark
●Security Hub
●Remediation finding, Poam and artifacts
EXPERIENCES
Cloud Security, engineer and Database support .
DEPARTMENT OF HOMELAND AND SECURITY
03/2023 to now
●Leveraged AWS services to deploy new EC2 instances with essential agents and web server software.
Utilized the AWS Account Factory pipeline to onboard new tenants, including the assignment of dedicated CIDR blocks for network configuration within an AWS Organization.
Automated the process of joining EC2 instances to the domain, adding application segments in Zscaler, and updating IP addresses in Intra ID.
Developed and implemented serverless solutions using AWS Lambda for the automated rotation of sensitive secrets.
Demonstrated proficiency in system administration by performing regular kernel and package updates on EC2 instances.
Manage cross-platform vulnerability remediation efforts by leveraging Tenable, Splunk, and AWS Security Hub data to identify critical findings and required patches.
●Orchestrated the lifecycle of security findings from initial identification through remediation tracking using Jira ticketing system.
●Executed technical remediation of security vulnerabilities across diverse operating systems (Windows, Linux) and AWS infrastructure.
●Implemented configuration changes to AWS resources and services within tenant accounts to align with security best practices and policies across the AWS Organization.
●Generated and maintained security artifacts critical for Authority to Operate (ATO) and Plan of Action and Milestones (POAM) documentation.
●Managed and maintained the security posture of Azure SQL Databases, including user access controls and proactive security measures.
●Optimized Azure SQL Database performance and availability through tasks such as online index rebuilds and stored procedure management.
●Diagnosed and resolved critical Azure SQL Database issues, including troubleshooting corrupted databases to ensure data integrity and system uptime.
●Developed and utilized advanced queries in Tenable, Splunk, and AWS Security Hub to proactively identify security gaps and prioritize remediation efforts.
●Contributed to a secure and compliant cloud environment by translating security findings into actionable remediation tasks and configuration adjustments within AWS and Azure
●Aligned Security System Plan (SSP) controls to AWS Organization tenants, implementing configurations and generating artifacts as evidence of security control implementation or documented exceptions for non-conformity.
●Ensured compliance by mapping SSP requirements to AWS tenant environments, producing auditable artifacts to demonstrate implemented security controls and managing exceptions where deviations occurred.
●Database Administrator
National Heart, Lung, and Blood Institute, DHHS, Bethesda Md.
●Dec 2021 to Oct 2022
●Performed troubleshooting database server in various environments including Development, Test and Production, following Jira or SNOW tickets, and applied standard changes to CME Tiers in support of various teams.
●Ran various DBCC commands to Checks Database Consistency.
●Developed scripts to find missing, unused, duplicate, or partial index and created appropriate optimization solutions to slow running queries.
Facilitated index optimization through 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.
Acted as on-call support for any URL or database issues.
Planned and performed database server upgrades from lower to higher versions in both test and production environment.
Assisted Database Developers with creating database objects and optimizing SQL queries and Stored Procedures.
Rebuilt index at regular intervals for optimized performance.
Exported/Imported data from various sources (flat, CSV files) to/from SQL Server Database using BCP, Bulk insert.
Generated monthly reports to support SLAs (service-level agreements) using SQL queries.
Used TDE for PII data encryption.
Shrunk database files through data compression.
Supported implementation of point-in-time recovery solutions.
Facilitated database refresh and deployment using backup restore or data file attach/detach Principe as needed.
Monitored database related activities to include backup, AG health, disk space, and backup verification. Likewise, tasked with monitoring server activity using SQL Server Error Log, DMV, and activity monitor tools.
Made recommendations to Team Lead in improving performance and troubleshooting as needed.
Deployed server alerts to Azure Resource Group using Azure Cloud Shell.
Managed and resolved SNOW tickets for database-related issues from customer.
Supported the patching team through validation of server state and secondary role before applying failover Principe.
Managed, validated, and troubleshot ETL package at different steps in the process; updated ETL password every three months from app server following IBP procedure.
Performed database integrity check using DBCC check DB command.
Monitored and maintained databases, assisted in installation of database software upgrades, monitored database backups, standardized, and implemented databases across different projects.
SQL Database Administrator
Georgia Own Credit Union Atlanta, GA
Mar 2018 to Dec 2021
Installed, configured, and managed SQL Server 2016, 2012, and 2008 R2 in Development, QA, and Production environment.
Diagnosed and resolved problems around database performance, capacity, replication.
Experienced in Azure/SQL Server DBA Experience in IaaS/PaaS environment.
Monitored Azure/SQL Server and fine-tuned performance, installation, administration, and maintenance.
Migrated data from on premise to Azure environment.
Worked on several projects through Agile methodology.
Proactively monitored databases for errors and quickly responded to troubleshoot and resolve DB issues on all environments in Development, QA, and Production.
Coordinated and scheduled DB downtimes to perform DB maintenance procedures, such as database patching and upgrades.
Managed backup and recovery strategies using Native SQL Server backup/recovery Tools, Idera SQl Safe.
Performed database administration activities, to include database performance tuning, T-SQL tuning, backup and recovery and DB disaster recovery solutions.
Worked with teammates and other groups in gathering requirements for new instance build outs or supported existing applications.
Analyzed existing systems and made recommendations to Team Leads on the technology that best suits business requirement for high availability, Disaster Recovery, or high performance.
Worked independently and with other teams to design functional and/or performance tests.
Created update database documentation on standard procedures, database technology features, or production issue troubleshooting.
Assisted with design and implementation of highly available production systems using Database Mirroring, Log Shipping, SQL clustering and availability groups.
Reviewed scripts submitted by Development team for performance.
Worked with development teams to deploy code in production, as needed.
Participated in on-call rotations for increased awareness and training.
Acted as POC for day-to-day issues encountered on production as well as development database environments.
Ran various DBCC commands to Checks Database Consistency.
Developed scripts to figure out fragmentation level as well as rebuild Index to improve 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.
Performed several 24/7 on-call shifts in team rotation using excellent verbal and written communication skills.
Installed, configured, and maintained SQL Server Reporting Services (SSRS), replications, log shipping, and Always On.
Upgraded databases from SQL 2008 R2 to 2016 in testing and production environment.
Assisted database developers in optimizing SQL queries and Stored Procedures.
Rebuilt index at regular intervals for better performance.
Configured and maintained database encryption used TDE.
Performed data compression and shrunk databases as necessary to improve performance.
Recovered database from backup in disasters, implemented point-in-time recovery solutions.
Refreshed database from production and attached them from data file as needed.
Scheduled jobs to automate different database-related activities to include backup and verification, database health, disk space.
Monitored server activity, using SQL Server Error Log, DMV, and activity monitor tool.
Created and executed PowerShell script.
Managed and resolved trouble tickets for database-related issues submitted from customer.
Worked and maintained an active/passive clustered environment.
Worked on SQL server clusters with multiple nodes and other methods of disaster recovery.
Diagnosed and resolved data management issues.
Monitored and maintained databases, installed database software upgrades, monitored database backups, standardized and implemented databases to improve management of production and test environments, as well as physical database design.
Experienced with creation of backup scripts and various backup strategies through Microsoft SQL Server.
Wrote and executed Data Manipulation Language (DML) scripts for Microsoft SQL Server.
Produced database metrics using SQL Management Studio as well as created custom scripts.
Configured and operated in Windows Server 2008 R2 hosted on a virtual platform such as VMware.
Developed and produced reporting metrics on database performance and health.
SQL Server DBA
The Saint Consulting Group
November 2015 to February 2018
Performed troubleshooting of day-to-day database issues on both production and development database environments.
Ran various DBCC commands to Checks Database Consistency.
Developed scripts to optimize slow running query.
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 optimize health and performance problems for the servers.
Installed, configured, and maintained SQL Server Reporting Services (SSRS), replications, log shipping, and Always On.
Upgraded databases from SQL 2008 R2 to 2016 in testing and production environment.
Generated report using SSRS (SQL Server Reporting Services).
Create and execute PowerShell script.
Manage and resolve trouble tickets for database related issues submitted by customer.
EDUCATION AND TRAINING
Associate’s Degree: Engineering
Northern Virginia Community College, Aug 2015
Bachelor’s Degree: Information Technology
University of Cadi Ayyad, Jan 2009
●
Contact this candidate