AYAN InfoTech is looking for SQL Lead Administratorto join an exciting project based in Melbourne. The role offers you the opportunity to contribute towards an extremely well structured and mature environment, working on sophisticated enhancement projects.
Role:SQL Lead Administrator
Location: Melbourne
Contract Duration: 6 Months with high possible extensions
Experience: 5+ Years
Required Skills & Experience:
- 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
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.
Contact: 61-423336440 for more details.
Please note we will be able to contact only shortlisted candidates for this role. We thank you in advance for your interest.