Data Solutions Developer/DBA

TEEMA; Burnaby; Hybrid; CAD 115,000 - 125,000; Full time

Job summary

Une entreprise innovante recrute un Data Solutions Developer/DBA à Burnaby. Le candidat idéal aura une solide expérience en administration de SQL Server et en développement de solutions de données, ainsi qu'une connaissance des outils cloud tel qu'Azure. Ce rôle hybride permet une collaboration sur divers projets liés à l'ingénierie des données et à l'analytique, contribuant à la sécurité et à l'optimisation des environnements de bases de données.

Qualifications

• Expérience en administration et optimisation de bases de données SQL.
• Compétences en développement de procédures stockées, requêtes complexes.
• Connaissance des pipelines ETL avec Azure Data Factory.

Responsibilities

• Installer et gérer des bases de données SQL Server sur site et cloud.
• Développer et entretenir des solutions de données et rapports.
• Surveiller performance et optimiser bases de données.

Skills

SQL Server

Azure SQL

Python

R

Azure Data Factory

SSIS

Azure Synapse

Power BI

Transparent Data Encryption (TDE)

Replication strategies

Job description

Job Title:Data Solutions Developer/DBA
Job ID:80674
Location:Burnaby, British Columbia

Overview:
Our client is seeking aData Solutions Developer / DBAto join their team in a full-time capacity. This hybrid role is ideal for a collaborative professional with a balanced background in SQL Server administration and modern data solutions development. The successful candidate will design, secure, and optimize database environments while also supporting data engineering, analytics, and cloud-based initiatives.

What you will be doing:
Database Administration

• Install, configure, and manage on-premise and cloud-based SQL Server databases.

• Execute and monitor backup, restore, and disaster recovery operations.

• Implement and manage database access, roles, and security protocols.

• Monitor performance and tune databases for speed, reliability, and efficiency.

• Apply Transparent Data Encryption (TDE) and manage replication strategies (snapshot, transactional, and merge).

Data Solutions Development

• Develop and maintain stored procedures, functions, views, and complex queries.

• Design and manage ETL pipelines using Azure Data Factory and SSIS.

• Support analytics and reporting via Power BI and Azure Synapse.

• Utilize Python or R for data science and automation tasks.

• Work with cloud-native platforms like Azure SQL to build scalable solutions.

What you must have:
Skills/Tools

• SQL Server (2016–2022), Azure SQL

• Python, R

• Azure Data Factory, SSIS, Azure Synapse, Power BI

• Transparent Data Encryption (TDE)

• Snapshot, Transactional, Merge Replication

• Experience administering and optimizing SQL databases.

Salary/Rate Range: $115,000 – $125,000

For more information about TEEMA and to consider other career opportunities, please visit our website atwww.teemagroup.com