No longer accepting applications

Data Solutions Developer / DBA (ID#4769)

New Value SolutionsBurnaby, BC, Canada

3 days ago

Job type

Full-time

Job description

New Value Solutions, a Full Time Data Solutions Developer / DBA who will design, implement, and maintain secure database systems while developing innovative data solutions. Looking for 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.

Requirements :

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.

Thorough knowledge of data science methodologies, tools, and techniques, including statistical analysis, machine learning and data visualization to derive actionable insights from large datasets.

Thorough knowledge of designing, developing and optimizing complex database objects such as views, triggers, stored procedures and functions to ensure efficient data storage, retrieval and performance.

Considerable knowledge of data warehousing concepts and tools and of data pipeline architecture and developments.

Considerable knowledge of cloud-based database solutions related to the work.

Considerable knowledge of data analytic tools and techniques.

Considerable knowledge of the operations and functions of departments served and their requirements as applied to the work performed.

Ability to analyze and evaluate various data and information requirements and to prepare recommendations regarding the advisability and feasibility of incorporating changes or additions to the corporate data model.

Ability to prepare detailed designs for all databases including physical and logical data structures and to control shared usage of data throughout the organization.

Ability to establish standards and procedures to ensure the integrity, security, availability and recovery of all data.

Ability to evaluate and monitor the performance of databases and related applications to ensure data integrity, security and optimization of database resources.

Ability to lead projects for a variety of infrastructure and database projects, establish project schedules, assign and guide the work of team members and monitor progress.

Ability to establish and maintain effective working relationships with a variety of contacts and to provide advice and assistance on matters related to the work.

Ability to review the work of consultants for compliance with corporate standards.

Ability to communicate effectively orally and in writing.

Ability to read and understand computer programs.

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# 4769

Salary Range / Wage Rate : PG T31 $4,119.45 - $4,871.28 bi-weekly.