Data Solutions Developer / DBA (ID#5043)

New Value Solutions; Burnaby; On-site; CAD 80,000 - 100,000; Full time

Job summary

New Value Solutions, a national IT consulting firm, is seeking a Data Solutions Developer / DBA. This full-time role involves database administration and development for a major public sector organization, requiring strong SQL and cloud solutions expertise. Candidates should have significant experience in managing secure databases and developing complex data solutions, collaborating in a team environment.

Qualifications

• 5+ years administering SQL Server databases.
• 3+ years working with Azure SQL and cloud solutions.
• Experience developing data pipelines with Azure Data Factory and SSIS.

Responsibilities

• Backup and restore databases and manage SQL databases on servers.
• Implement TDE and manage replication processes.
• Develop ETL pipelines and manage data workflows.

Skills

Database Administration

Data Solutions Development

Data Analysis

Cloud Solutions

SQL Queries

Education

Microsoft certifications (e.g., Azure Database Administrator Associate)

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from New Value Solutions

Senior Talent Acquisition Specialist at New Value Solutions Group

New Value Solutions, a national IT consulting firm, is seeking a Data Solutions Developer / DBA for a full-time opportunity with a major public sector organization. This role requires a well-rounded professional with expertise in both database administration and data solutions development. We are looking for a collaborative team player with hands-on experience in designing, implementing, and maintaining secure database systems. The successful candidate will bring strong DBA capabilities, complemented by experience in data analytics, cloud solutions, and complex query development.

Responsibilities :

• Backup and restore databases.
• Set up users and security protocols.
• Install and manage SQL databases on servers.
• Utilize tools like Python or R
• Develop ETL pipelines and manage data workflows.
• Implement TDE and manage replication processes such as snapshot, transactional, and merge replication.
• Manage and optimize cloud-based database solutions.
• Create and maintain advanced database objects, including views, stored procedures, functions, and complex queries.

Requirements :

• 5+ years of experience administering SQL Server databases (2016–2022), including backup / restore, security configuration, and performance tuning.
• 3+ years of experience working with Azure SQL and cloud-based database solutions.
• 3+ years of experience developing data pipelines using Azure Data Factory and SSIS.
• Proven experience as both a DBA and data solutions developer.
• Strong understanding of hybrid (on-prem / cloud) environments.
• Strong proficiency in writing complex SQL queries, stored procedures, functions, and views.
• Experience implementing database security using Transparent Data Encryption (TDE).
• Hands-on experience managing data replication methods such as snapshot, transactional, and merge replication.
• Experience with data analysis using Python or R.
• Experience developing and supporting analytics solutions using Azure Synapse and Power BI.
• Microsoft certifications (e.g., Azure Database Administrator Associate or related) considered an asset.

If you have this expertise, and are able to work in Canada, please submit your resume. While we thank all candidates in advance for their application, only those candidates who are shortlisted will be contacted.

ID# 5043

Seniority level

Seniority level

Not Applicable

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

IT Services and IT Consulting

Referrals increase your chances of interviewing at New Value Solutions by 2x

Sign in to set job alerts for “Solutions Developer” roles.

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

Salesforce Developer - remote working BC based

Burnaby, British Columbia, Canada 8 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