Senior SQL Server

Location: TorontoOverviewWelcome 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 PinnacleJob PurposeThe 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.ResponsibilitiesCloud 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 instancesPerformance Optimization: Proactive tuning of high-volume OLTP workloads, specifically targeting index optimization, wait statistics analysis, and deadlock resolution in a 24/7 clustered environmentHigh Availability Implementation: Architect and administer mission-critical SQL Server Failover Clusters and Availability Groups, ensuring quorum stability, listener connectivity, and rapid failover capabilitiesSecurity & Compliance: Enforce data security standards and compliance requirements across all database platformsProduction support: Assist in providing 24/7 for critical production systems, including being on-call one week per monthTechnical Support: Provide guidance to development teams on database design and query optimizationCost Optimization: Monitor and optimize cloud resource utilization to manage database-related expensesSkills & QualificationsHighly technical problem-solver with hands-on approachStrong communication skills to collaborate with cross-functional teamsSelf-motivated with ability to manage competing prioritiesTechnical Requirements6+ years professional experience administering SQL Server environments3+ 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 environmentProven track record managing highly transactional, high-concurrency OLTP systems (1000+ TPS) with strict uptime SLAsExperience performing complex cluster migrations, upgrades, and patching with near-zero downtime strategiesDeep understanding of transaction log throughput, latch contention, and locking/blocking analysis specific to high-volume OLTP workloadsProficiency in T-SQL, PowerShell, and Azure CLIFamiliarity with DevOps practices and Infrastructure as CodePreferred QualificationsAzure Solutions Architect certificationWe 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