We are seeking an experienced Azure Cloud SQL Server Database Administrator to manage and maintain our production SQL Server Platform as a Service (PaaS) databases within the Azure cloud environment. The ideal candidate will have extensive experience with Azure PaaS offerings, a proven ability to optimize database performance in high-concurrency transaction environments, and expertise in leveraging Azure cloud tools for database management and automation. This role will play a critical part in ensuring the reliability, scalability, and efficiency of our database systems.
Location :
This is a hybrid position based in North York, Toronto, Ontario .
Key Responsibilities :
- Azure PaaS Database Management : Manage and support production SQL Server databases hosted on Azure PaaS, ensuring high availability, scalability, and performance.
- Cloud Optimization : Utilize Azure cloud features (e.g., Azure Monitor, Azure SQL Analytics, and Automation) for database monitoring, maintenance, and automation.
- Database Partitioning : Implement and manage partitioning strategies for large tables in live production environments to optimize performance and manage data growth.
- Index Optimization : Analyze and reduce the number of indexes on high I / O tables, optimizing them based on usage patterns.
- Performance Tuning : Collaborate with development teams to optimize .NET Entity Framework queries and application performance.
- Query Plan Analysis : Perform detailed query plan analysis to ensure efficient query execution and proactively identify bottlenecks.
- Monitoring & Maintenance : Conduct regular index maintenance, monitor database growth, analyze disk fragmentation, and ensure optimal resource utilization in the Azure cloud.
- Collaboration : Work closely with developers, DevOps, and technical leads to plan, test, and deploy database updates effectively.
- Disaster Recovery : Implement and test backup and recovery strategies using Azure-native tools to ensure data integrity and minimize downtime.
Qualifications :
Experience : Minimum 7 years of experience managing production SQL Server databases, with at least 3 years in an Azure PaaS environment.Azure Expertise : Extensive knowledge of Azure SQL Database PaaS offerings, including performance tuning, scalability, and monitoring capabilities.Technical Skills : Proficiency in database partitioning, index optimization, and advanced query performance tuning techniques.Analytical Skills : Strong experience with query plan analysis, database performance monitoring, and resolving high-concurrency challenges.Tools & Features : Proven experience with Azure portal tools such as Azure Monitor, Azure Automation, and SQL Analytics for database management.Collaboration : Excellent communication skills and a demonstrated ability to work collaboratively across teams.Production Experience : Prior experience managing production databases in high-concurrency, large-scale environments.