Talent.com
Azure Cloud SQL Database Administrator

Azure Cloud SQL Database Administrator

Uncharted Talent IncToronto, ON, Canada
21 days ago
Job type
  • Full-time
  • Quick Apply
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 .

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.