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.

Uncharted Talent

New Jobs

Azure Cloud SQL Database Administrator