Azure Cloud SQL Database Administrator

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.