Data Solutions Developer / DBA

Affinity; Burnaby; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading technology consulting company is seeking a Full Time Data Solutions Developer / DBA in Burnaby, British Columbia. The role focuses on designing and maintaining secure database systems while developing innovative data solutions, requiring expertise in SQL Server, Azure SQL, and data analytics. Ideal candidates will have strong collaborative skills, extensive database administration experience, and proficiency in data engineering.

Benefits

Referral bonuses for successful placements

Inclusive work environment

Qualifications

• Expertise in database backups and restoration.
• Skilled in configuring database security protocols.
• Experience in developing and maintaining complex SQL objects.

Responsibilities

• Backup and restore databases.
• Install and manage SQL databases on servers.
• Develop ETL pipelines and manage data workflows.

Skills

Database Server Administration

Database Design

Performance Optimization

Data Analytics

Cloud-based Solutions

Complex Data Queries

ETL Pipelines

Python

R

Database Security

Education

Experience with SQL Server 2016-2022

Proficiency in Azure SQL

Tools

Azure Data Factory

SQL Server Integration Services (SSIS)

Azure Synapse

Power BI

Job description

Affinity Burnaby, British Columbia, Canada

Data Solutions Developer / DBA

Affinity Burnaby, British Columbia, Canada

On behalf of our public sector client, Affinity is looking for a Full Time Data Solutions Developer / DBA who will design, implement, and maintain secure database systems while developing innovative data solutions. They are seeking a collaborative team player and experienced database and data solutions developer skilled in database server administration, database design, security, and performance optimization, with a strong foundation in data analytics, cloud-based solutions, and complex data queries.

Responsibilities :

The role is a balanced mix of database administration and data solutions development, with the following breakdown :

o Backup and restore databases.

o Set up users and security protocols.

o Install and manage SQL databases on servers.

• 10% Data Science : Utilize tools like Python or R
• 10% Data Engineering : Develop ETL pipelines and manage data workflows.
• 10% Database Encryption / Data Replication : Implement TDE and manage replication processes such as snapshot, transactional, and merge replication.
• 10% Azure SQL : Manage and optimize cloud-based database solutions.
• 10% Complex Database Development : Create and maintain advanced database objects, including views, stored procedures, functions, and complex queries

Qualifications :

o Experience with on-premise SQL Server (versions 2016–2022)

o Proficiency with Azure SQL and cloud-based database solutions

o Skilled in database installation, configuration, and management

o Expertise in performing database backups and restorations

o Ability to configure and enforce database security protocols

o Strong knowledge of database performance monitoring and optimization

o Experience developing and maintaining complex database objects (e.g., views, stored procedures, functions, advanced SQL queries)

o Proficiency in building and managing ETL pipelines and data workflows

o Familiarity with Azure Data Factory and SQL Server Integration Services (SSIS)

o Proficiency in Python and / or R for data analysis and automation tasks

o Working knowledge of Azure Synapse and Power BI is an asset

• Database Security & Replication :

o Experience implementing Transparent Data Encryption (TDE)

• Knowledge of database replication techniques including :

o Snapshot Replication

o Transactional Replication

o Merge Replication

o Experience working in hybrid data environments and managing cloud-based database infrastructure (Azure SQL)

o Strong problem-solving skills and attention to detail

o Ability to work collaboratively in a team-oriented environment

o Effective communication skills to convey technical information to both technical and non-technical stakeholders

Affinity Earn :

Know someone who’s great for this, or any of our open roles? Earn up to $4,000 / year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https : / / affinity-group.ca / earn / or browse our jobs & follow us at https : / / www.linkedin.com / company / affinity-staffing / jobs /

About Affinity :

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number : 12215

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

IT Services and IT Consulting

Referrals increase your chances of interviewing at Affinity by 2x

Get notified about new Solutions Developer jobs in Burnaby, British Columbia, Canada .

Burnaby, British Columbia, Canada $80,000.00-$100,000.00 20 hours ago

Senior Full Stack Developer (React / Next.js / Python )

Senior Full Stack Developer (Shopify Expert)

Software Developer, .Net Desktop Application

Software Engineer II (Developer Tooling - Frontend)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr

Create a job alert for this search