Ahmed Imran

Azure SQL DBA

• Job Details:Administered Azure SQL databases and SQL managed instances, including login management, MFA configuration, and user access provisioning. Provisioned, configured, and supported Azure cloud resources, integrating recovery services vault for automated and scheduled full/differential backups. Performed database restores and migrations using bacpac files, ensuring data integrity and seamless cutovers. Secured sensitive data with always encrypted integrated with Azure Key Vault across stage, QA, LT, and production environments. Led SQL Server migration from 2012 to 2019, including documentation and analysis with Data Migration Assistant (DMA), cross-team coordination (app support, windows, network, release), EC2 provisioning, and production cutovers post-UAT. Applied OS- and database-level security patches and vulnerability remediations in line with compliance requirements. Automated maintenance tasks (backups, DBCC checks) using PowerShell scripts, Azure CLI, and Azure-native tools. Implemented and maintained high availability solutions and conducted performance tuning using Azure Monitor, Query Store, and DMVs. Collaborated with infrastructure and DevOps teams to troubleshoot Azure connectivity, networking, and authentication issues, ensuring maximum uptime. Maintained detailed SOPs, architecture diagrams, and recovery runbooks to support operational readiness and audits.

SQL Database Administrator

• Job Details:Led the AMP migration project, transitioning on-premises databases to Microsoft Azure with a focus on high availability, minimal downtime, and scalable architecture. Leveraged Azure-native tools such as Azure Monitor, SQL Analytics, and Query Performance Insight to proactively detect and resolve performance bottlenecks, significantly improving query execution times. Strengthened data security posture by implementing encryption at rest and in transit, and enforcing role-based access control (RBAC) across Azure resources. Developed and maintained PowerShell automation scripts to streamline backup operations, enhancing reliability and reducing manual overhead. Collaborated with application developers to design and optimize database schemas, ensuring efficient integration with Azure-hosted applications. Served as the primary escalation point for complex production issues, ensuring rapid resolution and minimal service disruption. Maintained comprehensive documentation for Azure configurations, security policies, and operational procedures. Ensured data integrity and availability through consistent backup routines and coordinated patching/updating of Azure SQL instances to maintain security and performance. Conducted business analysis, gathered requirements, and prepared detailed documentation and technical specifications for database and cloud solutions. Diagnosed and resolved SQL performance issues using advanced tools such as SQL Profiler, execution plans, index tuning advisor, and statistics analysis. Monitored and validated backup operations, promptly addressing failures, ensuring data integrity, and performing periodic test restores.

SQL Database Administrator

• Job Details:Supported database upgrades and migrations, including transitions to newer SQL Server versions and cloud platforms like Azure SQL. Installed and configured SQL Server instances for development, staging, and production environments, ensuring optimal setup and performance. Monitored database performance regularly, identifying and resolving issues like slow queries and resource bottlenecks to enhance efficiency. Managed routine database backups and restores, conducting regular recovery tests to ensure data integrity and quick disaster recovery. Configured user access, roles, and permissions based on security policies to safeguard sensitive data and maintain compliance. Implemented and monitored data encryption techniques, such as transparent data encryption (TDE), to secure critical information. Contributed to disaster recovery planning by implementing high-availability solutions like SQL Server Always On availability groups. Developed automated SQL Server agent jobs for routine maintenance tasks, documented procedures, and regularly tested failover processes for system reliability.