Ayan Infotech are looking for an Azure SQL DBA for a long term contract job opportunity in Melbourne.
All applicants must have full unrestricted work rights in Australia.
Title: Azure SQL DBA
Location: Melbourne
Type: Contract (6-12 months + longer)
Required Skills and Experience:
- 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
Contact: 02 9412 4178 for more details.
www.ayaninfotech.com
