Senior SQL Server & Azure Database Administrator

Location : Toronto

Overview

Welcome to Pinnacle, the ultimate destination for sports enthusiasts seeking an exhilarating sportsbook and gaming experience! Established in 1998, we have solidified our position as one of the globe's foremost licensed online gaming companies. With our cutting-edge offerings, we guarantee an electrifying experience that will keep you on the edge of your seat.

Pinnacle invites you to join our team and become an instrumental figure in the exciting realm of sports betting. Our vibrant team is fuelled by passion and driven by innovation, working together to redefine the landscape of sports betting and gaming. Together, we constantly strive to surpass limitations and deliver unparalleled experiences to sports enthusiasts worldwide. Here, you'll work with high-throughput, real-time systems at scale and tackle advanced distributed systems challenges in a demanding, low-latency environment. Prepare yourself for a thrilling journey and discover sports in an entirely new dimension with Pinnacle!

Job Purpose

The Senior Database Administrator will work within our hybrid database environment with focus on Azure cloud database services while managing remaining on-premises SQL Server systems during our cloud migration. You'll implement, optimize, and secure our database infrastructure through hands-on administration and technical expertise.

Responsibilities

• Cloud and On-Prem Database Management : Implement and maintain mission critical on-prem databases, Azure SQL Database, Azure SQL Managed Instance, as well as some AWS RDS instances
• Performance Optimization : Proactive tuning of high-volume OLTP workloads, specifically targeting index optimization, wait statistics analysis, and deadlock resolution in a 24 / 7 clustered environment
• High Availability Implementation : Architect and administer mission-critical SQL Server Failover Clusters and Availability Groups, ensuring quorum stability, listener connectivity, and rapid failover capabilities
• Security & Compliance : Enforce data security standards and compliance requirements across all database platforms
• Production support : Assist in providing 24 / 7 for critical production systems, including being on-call one week per month
• Technical Support : Provide guidance to development teams on database design and query optimization
• Cost Optimization : Monitor and optimize cloud resource utilization to manage database-related expenses

Skills & Qualifications

Technical Requirements

Preferred Qualifications

We are an equal opportunity employer dedicated to fostering an inclusive and diverse workplace. We prioritize hiring the best candidates based on their skills and qualifications, irrespective of race, gender, age, religion, or any other characteristic. Our strength lies in our diverse teams, and we proudly celebrate and empower everyone to embrace and promote diversity throughout their time with us.

#J-18808-Ljbffr