Ali HMID

– Serve as a member of the international Microsoft Architects team, supporting enterprise customers across the EMEA region. – Act as the primary Cloud Architect DBA, guiding clients through their ongoing cloud transformation journey to Microsoft Azure. – Lead end-to-end Azure migration initiatives, including environment discovery, migration execution, cutover, post-migration support, and performance tuning. – Design and implement rehosting, refactoring, and rearchitecting strategies to enable seamless adoption of Azure services. – Configure and maintain high availability/disaster recovery (HA/DR) solutions such as Failover Cluster Instances (FCI) and AlwaysOn Availability Groups across multi-region, multi-subnet environments. – Conduct in-depth SQL Server performance analysis using Query Store, Extended Events, Performance Monitor, and Dynamic Management Views (DMVs). – Perform SQL Server audits, including both Performance Audits and Security Audits, to optimize systems and ensure regulatory compliance. – Lead migration workshops and assessments, recommend appropriate Azure SKUs, and define optimal migration paths based on performance and business needs. – Produce and maintain detailed technical documentation including migration proposals, resource sizing, tuning recommendations, and cutover planning. – Collaborate closely with customers, partners, project managers, and internal Microsoft stakeholders to ensure technical alignment with strategic business goals.

– Designed and implement end-to-end Azure-based solutions tailored to customer needs. – Defined cloud architecture strategies, focusing on scalability, performance, availability, and security. – Architect and manage Azure IaaS, PaaS, and hybrid cloud environments. – Designed and implemented Azure-based database solutions, Azure SQL MI and Azure SQL Database. – Deployed and managed Virtual Machines (VMs) and Azure App Services for high-performance applications. – Monitored and troubleshoot deployed solutions using Azure Monitor, Log Analytics, and Application Insights. – Implemented Azure Backup strategies to ensure data protection, recovery, and business continuity. – Configured Microsoft Defender for Cloud to enhance security and threat protection for databases, servers, and cloud workloads. – Managed and optimized Azure SQL Database, SQL Managed Instance, and Cosmos DB for high availability and scalability. – Led cloud migration projects, ensuring a seamless transition from legacy systems to Azure cloud environments. – Led cloud migration projects, ensuring a seamless transition from legacy systems to Azure cloud. – Migrated on-premises infrastructure, Windows Servers and SQL Server, to Azure for improved scalability and performance. – Executed SQL Server migrations to Azure SQL Managed Instances and Azure SQL Databases, optimizing data management. – Advanced expertise in migration tools: Azure Migrate, Data Migration Assistant (DMA), and Database Migration Service (DMS) for efficient and secure data transitions. – Developed and document best practices, deployment guides, and technical architectures. – Facilitate collaboration and training among team members to ensure successful project execution. – Networking: ExpressRoute, peering, DNS, Private Endpoints, and Azure Load Balancers. – Resource Management: Subscriptions, Resource Groups, Tags, and Azure Policies. – Monitoring & Analysis: Implemented Azure Monitor, Log Analytics. – Security: Configured Azure Key Vault, RBAC, Security Center. – Storage: Managed Azure storage accounts. – Data Services: Azure SQL Databases, SQL MI, Cosmos DB, and Azure Data Factory.

– Provided L1/L2/L3 support for highly available and performance-sensitive e-commerce databases. – Managed and monitored Always On Availability Groups and Windows Server Clustering for HA/DR. – Administered transactional replication, TDE encryption, database snapshots, and automated maintenance. – Performed backup and recovery operations, index tuning, and table partitioning strategies. – Tuned performance through query optimization, resource monitoring, and troubleshooting using Query Store and Extended Events. – Collaborated within a team of 4 DBAs to lead the migration of SQL Server environments to SQL Server 2019. – Conducted comprehensive server analysis and dependency mapping to ensure safe and efficient migrations. – Designed and implemented target database architectures on SQL Server 2019 (on-premises) and Azure SQL Managed Instance. – Worked with development teams to implement and optimize database designs for new applications.

– Part of a dedicated team managing SQL Server performance tuning and optimizing critical production workloads. – Acted as the technical referent for SQL Server, handling escalations related to query and instance performance issues. – Conducted comprehensive audits and analyses of SQL Server instances, including resource usage (CPU, memory, storage) and configuration (MAXDOP, Min/Max Memory, TempDB settings). – Defined and standardized best practices for T-SQL development, query performance, and index optimization. – Supported development teams, providing guidance on how to read, update, and delete large datasets efficiently without blocking or degrading performance. – Delivered recommendations for query refactoring, indexing strategies, and batch processing to improve throughput and response times. – Developed and enforced best practices and maintenance strategies for the production and BI teams, including index rebuilds and statistics updates. – Worked on performance optimization of very large databases (VLDBs), ensuring efficient data access and minimal resource contention. – Audited and maintained maintenance plans to manage indexes, statistics, backups, and consistency checks. – Conducted index audits to identify missing, duplicate, or unused indexes for performance tuning. – Analyzed execution plans to identify slow queries, bottlenecks, and optimize resource usage.

– Member of the SQL Server Engineering & Database Operations Team, supporting build projects and Level 3 operations. – Led the automation and industrialization of SQL Server deployments across the BNP Paribas group. – Designed and built modern, resilient, monitored, and secure SQL Server infrastructures for critical banking applications. – Developed PowerShell scripts to streamline SQL Server management and infrastructure provisioning. – Contributed to the development of new database service offerings and platform modernization. – Actively involved in security and audit compliance, participating in assessments and hardening initiatives. – Managed obsolescence remediation by identifying outdated platforms and planning upgrades. – Oversaw inventory and monitoring of the entire SQL Server estate across BNP Paribas globally. – Ensured compliance with internal standards and regulations, especially for critical platforms, through periodic audits. – Performed instance patching, remediation scripting, and standardization of environments. – Led task force participation for issue resolution and execution of action plans for continuous improvement. – Provided Level 3 support for production teams and business units, including critical incident and change management. – Supported migration projects involving platform upgrades and cross-environment transitions. – Addressed and resolved performance issues, collaborating with developers and infrastructure teams. – Participated in planned operations, offering deep technical expertise during system maintenance windows.

– Part of a team of 3 DBAs providing end-to-end support for IT and business teams across the organization. – Managed the entire SQL Server estate, ensuring performance, security, and availability. – Built and deployed SQL Server environments from scratch, following best practices for scalability and maintainability. – Performed daily health checks, monitored backups and overnight processing jobs, and resolved system alerts and incidents. – Maintained high database availability, proactively identifying and addressing risks. – Implemented and managed database security, including access control, encryption, auditing, and Active Directory group integration. – Assisted development teams in code deployment and database change management, ensuring adherence to SQL best practices. – Created and maintained maintenance plans, covering index and statistics management, backup and restore strategies, and database integrity checks. – Led patching, upgrading, and migration of SQL Server databases with minimal downtime. – Performed database restores and environment refreshes for non-production systems. – Recommended and implemented performance, reliability, and process improvements across SQL environments. – Ensured compliance with corporate IT policies and procedures. – Documented all SQL environments, configurations, and operational procedures.

– Install, configure, and maintain Windows Server environments. – Manage Active Directory (AD), Group Policy, DNS. – Maintain user accounts, permissions, and security policies following best practices. – Monitor and optimize server performance, capacity planning, and system updates/patching. – Perform backup and disaster recovery planning. – Conduct security audits, vulnerability assessments, and patch management. – Manage and support SQL Server databases, ensuring performance and availability. – Assist with application deployments and integrations in Microsoft environments. – Work closely with development teams to support infrastructure needs. – Diagnose and resolve hardware, software, and network problems. – Collaborate with IT teams, vendors, and stakeholders to ensure system stability.