Azure Cloud SQL Database Administrator

2 weeks ago

North York, Canada Uncharted Talent Inc. Full time

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

Pay: $100,000.00-$130,000.00 per year

**Benefits**:

- Dental care
- Extended health care
- Paid time off

Application question(s):

- Are you open and willing to work hybrid on-site in North York?

Work Location: Hybrid remote in North York, ON M2N 5Y7

  • SQL Server Database Administrator

    1 week ago

    North York, Canada Uncharted Talent Inc. Full time

    **Key Responsibilities**: - Maintain and support production SQL Server PaaS databases, ensuring high availability and performance. - Implement and manage database partitioning strategies for large tables in live environments. - Optimize and reduce the number of indexes on high I/O tables based on usage analysis. - Perform query plan analysis and maintenance...

  • SQL Server Database Administrator

    7 days ago

    North York, Canada Uncharted Talent Inc. Full time

    **Key Responsibilities**: - Maintain and support production SQL Server PaaS databases, ensuring high availability and performance. - Implement and manage database partitioning strategies for large tables in live environments. - Optimize and reduce the number of indexes on high I/O tables based on usage analysis. - Perform query plan analysis and maintenance...

  • Database Administrator

    2 weeks ago

    North York, Canada Ministry of Public and Business Service Delivery and Procurement Full time

    **Database Administrator**: **Job ID**: - 232009 **Posting status**: - Open **Organization**: - Ministry of Public and Business Service Delivery and Procurement **Division**: - GovTechON - Health Services I&IT Cluster / Emergency Health I&IT Solutions & Technology Management Branch **City**: - North York **Position(s) language**: - English **Job...

  • Azure DevOps

    2 weeks ago

    North York, Canada Rivago Full time

    **Key Responsibilities**: - Experience with DevOps (automation, infrastructure design, provisioning, configuration management, deployment, monitoring, continuous integration, delivery) - Experience on the Azure platform - Maintenance of documentation throughout development and post-deployment - Operational support and continuous evolution of existing...

  • Database Deployment Specialist

    1 week ago

    North York, Canada StoreForce Full time

    StoreForce is deeply passionate about Specialty Retail - it’s in our roots. Every day we strive to help Specialty Retailers set a new standard for operational excellence and accelerate their store sales. We make managing Store Operations a lot easier by baking both the art and science of running a store into an intuitive and powerful, made-for-retail...

  • Senior SQL Database Developer

    17 hours ago

    North Vancouver, Canada Global Relay Full time

    Who we are:For over 20 years, Global Relay has set the standard in enterprise information archiving with industry-leading cloud archiving, surveillance, eDiscovery, and analytics solutions. We securely capture and preserve the communications data of the world’s most highly regulated firms, giving them greater visibility and control over their information...

  • System Administrator

    2 weeks ago

    North York, Canada PI Fine Art | PI Creative Art Full time

    **About Us**: PI Fine Art is a proudly Canadian company celebrating over 45 years in business. As one of the largest vertically integrated art companies in North America, we specialize in art, wallcoverings, mirrors, and alternative wall décor. Our expertise spans every stage of the art development and supply chain process, including art consulting,...

  • Database / Edw Application Administrator

    7 days ago

    North York, Canada Tangerine Bank Full time

    **Requisition ID**: 151270 Tangerine is Canada’s leading direct bank. We offer flexible and accessible banking options, innovative products, and award-winning Client service. The reason why Tangerine employees come to work each day is to help Canadians live better lives. We focus on making a difference in our communities, and that includes our own...

  • Senior SQL Database Developer

    3 weeks ago

    North Vancouver, Canada Global Relay Full time

    Who we are: For over 20 years, Global Relay has set the standard in enterprise information archiving with industry-leading cloud archiving, surveillance, eDiscovery, and analytics solutions. We securely capture and preserve the communications data of the world’s most highly regulated firms, giving them greater visibility and control over their information...

  • PostgreSQL Database Administrator

    1 week ago

    / York street NSW, Sydney, Australia, Canada Darumatic Full time

    Location: Sydney, NSW Remote work available? Hybrid Rate: Great rate on offer for a suitable candidate About Us    Darumatic is an IT Consultancy and Recruitment Services Company that focuses on cloud native technologies and software development. Our mission is to help clients to "Build better software". We are passionate about working with clients...