Data Solutions Developer / DBA

ETalentNetwork; Burnaby; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading company is seeking a Data Solutions Developer to design, implement, and maintain secure database systems. This candidate will handle database architecture, develop innovative data solutions, and enhance data analytics capabilities, ensuring effective integration across platforms to support strategic initiatives.

Qualifications

• Completion of a University degree in computer science or related discipline.
• Thorough knowledge of database design, management, and security best practices.
• Experience with cloud-based solutions and expertise in data analytics.

Responsibilities

• Design and maintain database systems for high data availability.
• Develop data analytics solutions for efficient data flow.
• Lead projects and collaborate with internal teams on technology solutions.

Skills

Database Design

Data Security

Data Analytics

Cloud Storage

Data Querying

Education

University degree in computer science

Training in data analytic tools

Training in data warehousing

Training in database administration

Training in data science

Tools

Azure SQL

SQL Server

Python

R

Power BI

Azure Data Factory

SSIS

Azure Synapse

Job description

Our Human Resources and Corporate Services Department is seeking a Data Solutions Developer who will design, implement, and maintain secure database systems while developing innovative data solutions. Leveraging expertise in data pipelines, data science, complex data queries, and cloud storage, this role ensures efficient, integrated data management across platforms to support our strategic data initiatives.

You are a collaborative team player and experienced database and data solutions developer skilled in database design, security, and performance optimization, with a strong foundation in data analytics, cloud-based solutions, and complex data queries.

Responsibilities

• Designs, installs and maintains database systems and database objects and structures to ensure a high level of data availability and system security; develops database architecture; develops, maintains and communicates database and coding standards and quality assurance standards and procedures; plans and coordinates data migration between systems; and ensures efficient storage, retrieval and manipulation of data.
• Develops, implements and maintains data analytics solutions, including on premise and cloud data warehouse, data storage and data pipelines to facilitate efficient data flow and integration across various platforms and services.
• Develops, implements and maintains cloud based data solutions and architecture; implements advanced data replication and synchronization techniques; supports and enhances data science initiatives to ensure optimal performance and alignment with business strategies.
• Monitors and evaluates system performance; resolves technical issues; manages data security; and identifies and resolves data abnormalities to avoid system outages.
• Leads infrastructure and database projects; establishes project schedules and milestones; assigns tasks to team members and provides advice and guidance; monitors progress and performs follow up services as required.
• Collaborates and liaises with internal teams to deliver business technology solutions; assess and mitigates database related security risks and best practices for access controls, encryption and data masking; evaluates new database technologies; designs and implements database related security measures, including data encryption management; and maintains corporate database monitoring solutions.
• Researches, evaluates and recommends information technology solutions related to database and performance measurement tools, backup and recovery processes, system storage and data security and confidentiality; designs, implements and tests backup systems and policies and procedures for data and disaster recovery and data archiving; prepares and presents reports related to information technology and storage solutions as required.
• Provides guidance and assistance to infrastructure and applications staff; shares expertise and best practices in database administration and cloud data management; stays updated on industry trends and emerging technologies; makes recommendations for adoption and integration to existing systems; and oversees the work of consultants for compliance with corporate database and applications development standards as required.
• Performs related work as required.

Qualifications

To be successful, you have :

• Completion of a University degree in computer science, database administration, information technology or related discipline, supplemented by training in data analytic tools, data warehousing, database administration or data science plus considerable related experience; or an equivalent combination of training and experience.
• Thorough knowledge of the principles and techniques associated with database design, management and database security best practices.
• Thorough knowledge of the characteristics and capabilities of the organization's computer hardware as it relates to the work performed.
• Key Responsibilities

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

• 50% DBA Responsibilities :

Backup and restore databases.

• Set up users and security protocols.
• 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
• Required Skills Category Skills / Tools Database Platforms On-premise SQL Server (2016-2022), Azure SQL Programming and Analytics Python, R Data Engineering Tools Azure Data Factory, SSIS, Azure Synapse, Power BI Database Security Transparent Data Encryption (TDE) Data Replication Snapshot, Transactional, Merge Replication

In summary, we are seeking a DBA with strong data solutions development expertise. While DBA skills are the primary focus, making up half of the role, we require a candidate who also brings additional capabilities in data solutions development to excel in this position. In addition to DBA skills, the candidate should ideally meet at least 80% of the skills listed below.