Lead Administrator (Sql, 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 Lead Administrator (SQL, Azure)