Sport Tech & Data
Database Administrator (6 Month Contract)
Mid Level
Vancouver, Canada
in office
Contract
Job description
About the Role
Two Circles is seeking a skilled Database Administrator to join its team on a fixed-term contract covering maternity leave. The role focuses primarily on SQL Server database administration, with approximately 30% involvement in DevOps-related tasks. The successful candidate will support mission-critical SQL Server environments across Production, QA, and Development while contributing to critical enterprise systems.
Key Responsibilities
- Manage, install, configure, and maintain mission-critical SQL Server environments and enterprise-wide instances (2016 and higher) across Production, QA, and Development.
- Perform Windows Server administration (2016/2019/2022) and manage OS/SQL Server patching via AWS tools (SSM, RunCommand).
- Configure and manage SQL Server AlwaysOn availability groups and failover clustering.
- Optimise database performance through query optimization, index tuning, and execution plan analysis, and perform capacity planning, forecasting, and proactive performance tuning.
- Manage backup/restore processes and perform point-in-time recovery.
- Administer database security, users, roles, and permissions, including AWS IAM roles and permissions.
- Develop and maintain SSIS packages and SSRS reports.
- Monitor and rightsize infrastructure using CloudWatch, NewRelic, and Performance Monitor (Perfmon) for OS-level metrics such as CPU, memory, and disk I/O.
- Configure ODBC clients and HAProxy as needed, and troubleshoot connectivity and network issues including TCP/IP, DNS resolution, and hostname configuration.
- Conduct root cause analysis for outages and performance issues, and automate tasks using T-SQL scripts, SQL Agent jobs, and basic PowerShell scripting.
Required Experience & Qualifications
- Strong expertise in SQL Server administration and performance tuning.
- Hands-on experience with Windows Server environments.
- Knowledge of DevOps practices and cloud platforms, particularly AWS.
- Solid troubleshooting skills across database, network, and server layers.
- Familiarity with monitoring, automation, and reporting tools.
- Excellent communication skills, with the ability to guide less experienced team members.
- Experience with AWS services (RDS, S3, DynamoDB, EC2, IAM).
- Basic understanding of Windows Firewall rules, VPN access, and private vs public network configurations.
- Experience with SQL Server 2016 and higher.
Preferred Skills
- Azure experience is a plus.
The Application Process
The first stage interviews may be conducted remotely, while final interviews are ideally in-person.
- First stage interview
- Final interview
About the Company
Two Circles is a sports and entertainment marketing business that grows audiences and revenues by knowing fans best. It works with clients to help them understand and influence fan behaviour, including how fans spend money, which events they attend, which channels they respond to, and what content they watch. Its platforms and services are trusted by over 900 clients globally, including the English Premier League, Red Bull, UEFA, VISA, the NFL, Nike and Amazon.
Create your account to access job details
Unlock full job descriptions, apply in seconds, and get access to roles matched to your experience and interests.

