Asmae Khaddar
Woodbridge,VA
Summary
Detail-oriented Microsoft Certified Azure and SQL Server Database Administrator with expertise in managing critical judicial and enterprise environments. Specializes in installation, administration, performance tuning, and high availability solutions. Proficient in Azure Managed Instances, automation with PowerShell, and data migration using SSIS and SSRS.
Overview
1
1
Certification
11
11
years of professional experience
Work History
SQL Server Database Administrator
Administrative Office of the Courts (AOC), State of Kentucky
01.2024 - 03.2026
- Administer and support enterprise SQL Server environments hosting mission-critical judicial applications across production, QA, and test systems.
- Manage and monitor Always On Availability Groups including replica health, synchronization status, failover readiness, and listener configuration.
- Manage backup and recovery strategies including full, differential, and transaction log backups with validation and restore testing.
- Support high availability and disaster recovery planning by validating failover scenarios and maintaining database resilience.
- Troubleshot production incidents such as blocking, deadlocks, long-running queries, and failed SQL Agent jobs to maintain high system availability and minimize downtime.
- Monitored database performance with SolarWinds Database Performance Analyzer and SQL Server DMVs to identify wait bottlenecks, blocking chains, and resource contention, facilitating improved system performance.
- Perform advanced performance tuning by analyzing execution plans, logical reads, and query patterns to improve response time and reduce system load.
- Implement and maintain automated database maintenance using Ola Hallengren scripts for index rebuilds, index reorganizations, statistics updates, and integrity checks.
- Collaborate with application teams, infrastructure engineers, and SRE teams to diagnose database performance issues and support system reliability.
- Review database health metrics and proactively recommend improvements to optimize performance and stability.
SQL Database Engineer with Azure
LTIMindtree
Redmond, Washington
10.2020 - 01.2024
- Supported separate database setups for development and production Azure cloud environments.
- Installed and monitored Azure Managed SQL Instances.
- Migrated SQL Server databases from on-premises systems to Azure IaaS and PaaS using Azure Site Recovery (ASR).
- Migrated application data from on-premises databases to cloud databases. from on-premises databases to cloud databases.
- Worked with Database Migration Service (DMS) tools to move data from on-premises to cloud platforms.
- Tested, validated, and applied performance and resource optimization changes with Azure development teams.
- Performed database and application performance tuning.
- Supported SSRS report deployment, maintenance, and troubleshooting for business and operational reporting needs.
- Analyzed root causes impacting database performance for troubleshooting. affecting database performance.
Database Administrator
ActioNet
Vienna, VA
09.2015 - 10.2020
- Design, test, implement, and monitor databases and related servers in enterprise systems.
- Monitor and optimize the performance of Azure cloud database
- Performance tuning of new and existing applications.
- Manage clustered/non-clustered indexes, index rebuilds, partitioning.
- Managed security, roles, logins, and user accounts integrated with Active Directory to maintain compliance and data protection.
- Database High Availability and Disaster Recovery.
- Configure and maintain different high availability technologies that are used to support MSSQL i.e., log shipping, transactional, snapshot replication, mirroring, Always on availability group, failover clustering.
- SQL Server HA database upgrades, patches, service packs and hotfixes
- Planned and implemented disaster recovery strategies to ensure data integrity and availability.
- Managing and testing backup/recovery policies in the cloud and on prem
- Automate common management tasks using PowerShell.
- Working with other IT teams to migrate existing environments from Microsoft Windows and SQL version 2008 current infrastructure to new environments, up to 2016 and 2017 versions.
- Conducted detailed assessment and planning for migration, reviewing scenarios with application owners to ensure alignment.
- Design and review the migration plan with the customer and communicate the same within the team for actual migration. Ensure to perform all in scope activities.
- Participates in the allocation, planning and implementation of hardware resources, implements database backup and recovery technologies including monitoring.
- Provided off hours support to address product enhancements, data uploads, and technical issues.
- Support deployment of SSIS packages.
- Created and maintained documentation for database system configuration, mapping, processes, and service records to support operational integrity.
Education
Bachelor's in science -
ISFPPM
Morocco07-2008
Skills
- RDBMS expertise
- Database performance tuning
- ETL with SSIS
- Programming Languages: T-SQL, PowerShell, NET, C, Command Prompt
- Development tools
- Reporting tools
- Environment: Agile Methodology
- Windows Server expertise
- Software: IIS, VMware, Microsoft Office
- Third-party tools
Certification
MCSA: Database Administration (Certified), AWS Certified Solutions Architect – Associate (Certified), Azure Associate (Certified), SSIS & SSRS (Training), SQL Server Performance Tuning (Training)
Timeline
SQL Server Database Administrator
Administrative Office of the Courts (AOC), State of Kentucky
01.2024 - 03.2026
SQL Database Engineer with Azure
LTIMindtree
10.2020 - 01.2024
Database Administrator
ActioNet
09.2015 - 10.2020
Bachelor's in science -
ISFPPM