Job Description
Responsibilities
n
· Assess existing on-premises SQL database environments to identify migration requirements, constraints, and dependencies.
n
· Implement migration strategies to Azure SQL (IaaS, PaaS), considering factors such as database size, complexity, performance, and compatibility.
n
· Plan and execute database migration while minimizing downtime and ensuring data integrity.
n
· Configure and optimize Azure SQL (IaaS, PaaS) settings, including resource allocation, security configurations, and high availability features.
n
· Collaborate with architects, developers, infrastructure engineers, and other stakeholders to coordinate migration activities and resolve migration-related issues.
n
· Develop and maintain documentation, including migration plans, procedures, and post-migration configurations.
n
· Monitor database performance, troubleshoot issues, and implement performance tuning techniques to ensure optimal database performance and resource utilization.




n
· Implement and enforce security best practices for Azure SQL, including access control, encryption, and compliance requirements.
n
· Implement and maintain database backup and disaster recovery solutions to ensure data protection and business continuity.
n
n
Requirements
n
· Migrate SQL DBs from on-Prem to Azure SQL (VM, MI and DB) via Azure Data Studio and Backup/Restore
n
· Migrate SSRS/SSAS/SSIS DBs
n
· Migrate TDE from on-Prem to Azure key vault
n
· Setup hybrid setting (Apps on Azure, DBs on-Prem)
n
· Should have worked extensively in setting up AlwaysOn Availability groups within and across Azure regions
n
· Migrate Logins, SQL Jobs, Linked Servers
n
· Configure DB Mail and
notifications/alerts
n
· Experience in Azure Site Recovery for SQL
n
n

📌 Lead Administrator (Sql, Azure) (Melbourne)
🏢 XPT Software Australia Pty
📍 Melbourne