Job Description

Job Description

Job Description

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 .

• 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.

• 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.

Job Tags

Similar Jobs