Sql Database Administrator (Azure)

Job Description Responsibilities ·          Assess existing on-premises SQL database environments to identify migration requirements, constraints, and dependencies.·          Implement migration strategies to Azure SQL (IaaS, PaaS), considering factors such as database size, complexity, performance, and compatibility.·          Plan and execute database migration while minimizing downtime and ensuring data integrity.·          Configure and optimize Azure SQL (IaaS, PaaS) settings, including resource allocation, security configurations, and high availability features.·          Collaborate with architects, developers, infrastructure engineers, and other stakeholders to coordinate migration activities and resolve migration-related issues.·          Develop and maintain documentation, including migration plans, procedures, and post-migration configurations.·          Monitor database performance, troubleshoot issues, and implement performance tuning techniques to ensure optimal database performance and resource utilization.·          Implement and enforce security best practices for Azure SQL, including access control, encryption, and compliance requirements.·          Implement and maintain database backup and disaster recovery solutions to ensure data protection and business continuity.  Requirements ·          Migrate SQL DBs from on-Prem to Azure SQL (VM, MI and DB) via Azure Data Studio and Backup/Restore ·          Migrate SSRS/SSAS/SSIS DBs ·          Migrate TDE from on-Prem to Azure key vault ·          Setup hybrid environment (Apps on Azure, DBs on-Prem) ·          Should have worked extensively in setting up AlwaysOn  Availability groups within and across Azure regions ·          Migrate Logins, SQL Jobs, Linked Servers ·          Configure DB Mail and notifications/alerts ·          Experience in Azure Site Recovery for SQL Requirements SQL database Administrator (Azure)