Database Administrator (6 Month Contract)

Two Circles

Vancouver

Sur place

CAD 50 000 - 60 000

Plein temps

Il y a 3 jours
Soyez parmi les premiers à postuler

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Résumé du poste

Two Circles is seeking a skilled Database Administrator on a fixed-term contract to cover maternity leave. The role focuses on SQL Server administration with about 30% DevOps tasks. Initial interviews may be remote, but final in-person in Vancouver area.

Salary CAD 50,000–60,000 per year. You will manage production SQL Server environments, configure AlwaysOn, tune performance, automate tasks with T-SQL and PowerShell, and contribute to security and data reliability across AWS and on-premises

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.

Responsabilités

  • 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 New Relic.
  • 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.

Connaissances

SQL Server
Windows Server
DevOps
AWS
Performance tuning
SSIS/SSRS
PowerShell

Outils

SSIS
SSRS
PowerShell
CloudWatch
New Relic

Description du poste

We are Two Circles. We are a Sports & Entertainment Marketing business. We grow audiences and revenues. We do that by knowing fans best. We work with clients to help them understand & influence what their fans are doing – the way fans spend their money, the events that fans attend, the channels fans respond to, the content fans watch and more. And we use the understanding this gives us to help our clients grow. Grow their audiences and grow their revenues - both direct to consumer and business to business revenues. Our platforms and services are trusted by over 900 clients globally, including the English Premier League, Red Bull, UEFA, VISA, the NFL, Nike and Amazon. We are almost 1000 people, based out of 14 offices, and we deliver work for sports and entertainment businesses of all shapes and sizes all over the world.

We are seeking a skilledDatabase Administratorto join our team on a fixed-term contract, covering a maternity leave. This role focuses primarily onSQL Server database administration, with approximately 30% involvement in DevOps-related tasks. The first stage interviews may be conducted remotely, but final interviews are ideally in-person.

Key Responsibilities:
  • Manage and support mission-criticalSQL Server environmentsacross Production, QA, and Development.
  • Install, configure, and maintain enterprise-wide SQL Server instances (2016 and higher).
  • PerformWindows Server administration(2016/2019/2022) and manage OS/SQL Server patching via AWS tools (SSM,RunCommand).
  • Configure and manageSQL ServerAlwaysOnavailability groupsand failover clustering.
  • Optimize database performance throughquery optimization, index tuning, and execution plan analysis.
  • Managebackup/restore processesand perform point-in-time recovery.
  • Administer database security, users, roles, and permissions, includingAWS IAM roles and permissions.
  • Develop and maintainSSIS packages and SSRS reports.
  • Monitor andrightsizeinfrastructure using tools likeCloudWatch andNewRelic.
  • Understand and configure ODBC clients andHAProxyas needed.
  • Performcapacity planning, forecasting, and proactive performance tuning.
  • Conductroot cause analysisfor outages and performance issues.
  • Automate tasks usingT-SQL scripts, SQL Agent jobs, and basic PowerShell scripting.
  • Troubleshoot connectivity and network issues, including TCP/IP, DNS resolution, and hostname configuration.
  • UsePerformance Monitor (Perfmon)to monitor OS-level metrics (CPU, memory, disk I/O).
  • Basic understanding ofWindows Firewall rules, VPN access, and private vs public network configurations.
  • Experience withAWS services(RDS, S3, DynamoDB, EC2, IAM); Azure experience is a plus.
Required Skills & Experience:
  • Strong expertise inSQL Server administrationand performance tuning.
  • Hands-on experience withWindows Server environments.
  • Knowledge ofDevOps practices and cloud platforms, particularly AWS.
  • Solid troubleshooting skills acrossdatabase,network, and server layers.
  • Familiarity with monitoring, automation, and reporting tools.
  • Excellent communication skills, with the ability to guide less experienced team members.

This is an excellent opportunity for aSQL DBA with DevOps capabilitiesto join a dynamic team and contribute to critical enterprise systems.

Salary: $50,000-$60,000 CAD

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Database Administrator – Oracle, SQL Server, AWS RDS
Database Administrator – Oracle, SQL Server, AWS RDS

Astra-North Infoteck Inc. • Toronto

Hybride
CAD 95 000 - 130 000
Database Administrator and Back-up Consultant
Database Administrator and Back-up Consultant

TEEMA Group • Edmonton

Sur place
CAD 110 000 - 150 000
Database Administrator
Database Administrator

Tri-global Solutions Group Inc. • Saint John

Hybride
CAD 55 000 - 78 000
Senior Database Developer / Administrator
Senior Database Developer / Administrator

Reelcruit • Toronto

Hybride
CAD 90 000 - 130 000
Inclusive workplace
Growth opportunities
Flexible work arrangements
+3
Database Administrator - Senior (SQL)
Database Administrator - Senior (SQL)

Bevertec • Toronto

Sur place
CAD 110 208 - 117 096
Database Engineer
Database Engineer

TSX Inc. • Toronto

Hybride
CAD 110 000 - 120 000
Database Administrator
Database Administrator

Eizie • Kitamaat

Sur place
CAD 90 000 - 120 000
Competitive salary
Health benefits
Professional development
+5
SQL DBA
SQL DBA

Info-Ways • Brampton

Sur place
CAD 80 000 - 100 000
Database/Cloud Engineer (6-month contract) [14249]
Database/Cloud Engineer (6-month contract) [14249]

MEDA Engineering & Technical Services • Windsor

Sur place
CAD 49 593 - 55 104
Paid Benefits after 90 days
Pension eligibility after 1 year
Referral bonus
Technical Lead - SQL DBA, SQL Server & Database Administration
Technical Lead - SQL DBA, SQL Server & Database Administration

Astra-North Infoteck Inc. • Vancouver

Sur place
CAD 120 000 - 180 000