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
