Database Administrator (10-month Contract)

Two Circles•Vancouver, BC

3d•Hybrid

About The Position

We are Two Circles, a Sports & Entertainment Marketing business focused on growing audiences and revenues by understanding fans. We partner with clients to help them understand and influence fan behavior across spending, event attendance, channel response, and content consumption. Our platforms and services are utilized by over 900 clients globally, including major organizations like the English Premier League, Red Bull, UEFA, VISA, the NFL, Nike, and Amazon. With nearly 1000 employees across 14 offices, we serve sports and entertainment businesses worldwide. We are seeking a skilled Database Administrator for a 10-month fixed-term contract to cover a maternity leave. This role primarily involves SQL Server database administration with a secondary focus on DevOps tasks (approximately 30%). While initial interviews may be remote, final interviews are preferred to be in-person.

Requirements

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.

Nice To Haves

Azure experience is a plus.

Responsibilities

Manage and support mission-critical SQL Server environments across Production, QA, and Development.
Install, configure, and maintain enterprise-wide SQL Server instances (2016 and higher).
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.
Optimize database performance through query optimization, index tuning, and execution plan analysis.
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 tools like CloudWatch and NewRelic.
Understand and configure ODBC clients and HAProxy as needed.
Perform capacity planning, forecasting, and proactive performance tuning.
Conduct root cause analysis for outages and performance issues.
Automate tasks using T-SQL scripts, SQL Agent jobs, and basic PowerShell scripting.
Troubleshoot connectivity and network issues, including TCP/IP, DNS resolution, and hostname configuration.
Use Performance Monitor (Perfmon) to monitor OS-level metrics (CPU, memory, disk I/O).
Basic understanding of Windows Firewall rules, VPN access, and private vs public network configurations.
Experience with AWS services (RDS, S3, DynamoDB, EC2, IAM); Azure experience is a plus.