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
• Highly technical problem-solver with hands-on approach
• Strong communication skills to collaborate with cross-functional teams
• Self-motivated with ability to manage competing priorities
Technical Requirements
• 6+ years professional experience administering SQL Server environments
• 3+ years of experience with Azure database services (Azure SQL DB & Managed Instances)
• Expert-level proficiency in configuring, troubleshooting, and maintaining SQL Server Always On Availability Groups (AG) and Windows Server Failover Clustering (WSFC) in a production environment
• Proven track record managing highly transactional, high-concurrency OLTP systems (1000+ TPS) with strict uptime SLAs
• Experience performing complex cluster migrations, upgrades, and patching with near-zero downtime strategies
• Deep understanding of transaction log throughput, latch contention, and locking/blocking analysis specific to high-volume OLTP workloads
• Proficiency in T-SQL, PowerShell, and Azure CLI
• Familiarity with DevOps practices and Infrastructure as Code
Preferred Qualifications
• Azure Solutions Architect certification
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.
