Two Circles Logo

Two Circles

Database Administrator (6 Month Contract)

Posted 2 Days Ago
Be an Early Applicant
In-Office
Vancouver, BC, CAN
Entry level
In-Office
Vancouver, BC, CAN
Entry level
Manage mission-critical SQL Server environments across production, QA, and development. Responsibilities include SQL Server installation, configuration, performance tuning, backups and recovery, AlwaysOn availability, security, SSIS/SSRS, Windows Server administration, AWS infrastructure, monitoring, automation, troubleshooting, and capacity planning. Approximately 30% of the role involves DevOps tasks, including patching, cloud administration, scripting, and infrastructure optimization.
The summary above was generated by AI

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 skilled Database Administrator to join our team on a fixed-term contract, covering a maternity leave. This role focuses primarily on SQL 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-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.  

Required Skills & Experience: 

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

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

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


Similar Jobs

2 Hours Ago
In-Office or Remote
CA
Senior level
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Leads complex third-party security assessments, reviewing vendor controls, certifications, penetration tests, integrations, data handling, identity systems, and cloud deployments. Documents risks, recommends mitigations, coordinates reassessments and incident responses, escalates exceptions, improves assurance processes, and mentors teammates while partnering with Procurement, Security, Privacy, Legal, and business stakeholders.
Top Skills: APIsCisaCismCisspCloud ComputingCriscCybersecurity Risk ManagementGripIamIso 27001JIRANistOauthOnetrustOpenid ConnectPci DssSAMLSoc 2SsoZip
2 Hours Ago
In-Office or Remote
CA
Senior level
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Own and evolve Block’s globalization quality program, including quality planning, assurance, control processes, documentation, training, metrics, dashboards, and vendor collaboration. Analyze quality data, manage escalations, support regulatory compliance, optimize tools through automation, and apply AI-driven translation quality evaluation. Partner with legal, risk, compliance, product, internal teams, and localization suppliers to improve quality, scalability, productivity, and global customer experiences.
Top Skills: AirtableArtificial IntelligenceCmsContentfulDatadogGitJIRALarge Language Models (Llms)Machine Translation (Mt)PhraseSnowflakeTms
4 Hours Ago
Easy Apply
Remote or Hybrid
CA
Easy Apply
Mid level
Mid level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Leads project-based customer adoption engagements for Samsara’s technical products, APIs, integrations, and AI capabilities. The role researches customer workflows, designs practical solutions, manages milestones, troubleshoots complex issues, and communicates technical concepts to diverse audiences. It also enables Account Managers through training and documentation, collaborates with Support, Product, and Engineering, and creates scalable playbooks. Candidates need 3–5+ years in customer-facing technical roles, strong project management and communication skills, and familiarity with Salesforce, Gainsight, Gong, or similar tools.
Top Skills: AIAPIsGainsightGongIntegrationsIotSaaSSalesforce

What you need to know about the Vancouver Tech Scene

Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account