Database Administrator
A skilled Database Administrator to join the team on a fixed-term contract, covering a maternity leave, focusing primarily on SQL Server database administration with 30% involvement in DevOps-related tasks.
- Vancouver, British Columbia, Canada
- Contract
- Hybrid
- CA$50K–CA$60K per year
- Posted Nov 19, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise SoftwareData & Analytics
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
Requirements
- Experience in a Sports & Entertainment
Nice to have: Azure
Skills
SQL Server administrationPerformance tuningWindows Server environmentsDevOps practicesAWSTroubleshootingSQL ServerSSISSSRSAWS SSMAWS RunCommandCloudWatchNewRelicODBCHAProxyT-SQLSQL AgentPowerShellPerfmonRDSS3DynamoDBEC2IAM
Full description
Company details are for members
Sign up for a free job alert to see Two Circles's profile, website and LinkedIn, and the same for every employer on Referso Jobs.