Database Specialist

2 weeks ago


Vancouver, Canada BCSC Inquiries Group Full time

Employment Duration Permanent - Full Time

Centrally located in downtown Vancouver, the British Columbia Securities Commission (BCSC) strives to make the investment markets benefit the public – enabling people to achieve their financial goals, enterprises to grow, and British Columbia to thrive.

Through smart rules, diligent oversight, strong enforcement and reliable guidance, we act as guardians of the province’s investment marketplace, striving to make BC a place where people can invest with confidence and companies can flourish. We are an independent agency accountable to the provincial legislature and the public through the Minister of Finance.

Database Specialist

Technology and Project Services, Systems Development

Competition 24:120

Position Summary

As the Database Specialist, you will be working primarily within a Microsoft-centric environment. Y our role entails furnishing dependable, scalable database solutions tailored to fulfill both immediate and long-term objectives of the BC Securities Commission. Your responsibilities include crafting and enhancing data models, overseeing diverse data pipelines, administering multiple databases, and actively engaging in project initiatives. You will work closely with cross-functional teams to understand requirements, design scalable and efficient data solutions, and ensure the reliability and performance of our data systems.

Key responsibilities

  • Participates in the architecture of new application solutions
  • Manages all corporate data models, maintaining and extending these as required
  • Designs and implements data pipelines to automate data ingestion, processing, and analysis workflows
  • Develops, tests, and reviews database code as required
  • Provides practical assistance in the use of corporate database management systems to store and manipulate data
  • Designs, implements, manages and administers databases (on cloud and on-prem), data warehouses, and data lakes.
  • Performs database tuning, security administration, and software upgrades
  • Co-develops database-related policies, standards, and technical guidelines
  • Implements new technologies and develops the support infrastructures
  • Stay updated with the latest technologies and best practices in data engineering, DevOps, and cloud computing.

Qualifications

· Technical diploma or university degree in computer science or management information systems  or another relevant area

· Minimum of three (3) years of proven experience as a Database Specialist or similar role, demonstrating expertise in data engineering, database administration, and cloud computing.

· Microsoft certified in technologies related to data management  considered an asset.

· Strong communication and interpersonal skills

· The ability to set and meet deadlines, think strategically, and develop and work with a team

· Data platforms: MS SQL Server expert who is comfortable in a Microsoft-based environment, using SQL Server 2022 with AlwaysOn High Availability features, SSIS/SSAS, and Azure SQL

· DevOps Tools: Experience with AzureDevOps, Git, and CI/CD pipelines

· Data pipelines: Familiarity with ELT and ETL tools, including SSIS and Azure Data Factory, Azure Synapse Analytics

· Development tools: comfortable using Visual Studio, SSMS, R, Python, Powershell, other languages and tools relevant to the role’s duties

· Hands-on experience with Azure cloud platform

What we Offer:

  • Extensive benefit package including a defined benefit pension plan, medical and dental coverage, Wellness and Health Spending Account benefits, and four weeks of annual vacation
  • Competitive compensation package
  • Beautiful downtown office
  • Work life balance
  • A collaborative, progressive, and professionally diverse team to work with

Salary Range:

The salary range for this position is $83,997 (minimum) - $109,087 (midpoint) - $134,177 (maximum).

The starting salary for this position will be determined considering the successful candidate’s relevant experience and education, salaries of other employees in the same salary range, market conditions and other relevant factors. Starting salaries are normally below the salary band midpoint.

Please visit our  Careers  page to submit your cover letter and resume for this position, quoting competition 24:120 by, May 20, 2024.

The BC Securities Commission embraces diversity and is committed to building an inclusive workforce that celebrates the richness of our community.

Candidates must be authorized to work in Canada. Investment restrictions apply.

#J-18808-Ljbffr
  • Database Specialist

    3 weeks ago


    Vancouver, Canada British Columbia Securities Commission Full time

    Database Specialist Technology and Project Services, Systems Development Competition 24:120 Position Summary As the Database Specialist, you will be working primarily within a Microsoft-centric environment. Your role entails furnishing dependable, scalable database solutions tailored to fulfill both immediate and long-term objectives of the BC Securities...

  • Database Specialist

    1 week ago


    Vancouver, BC, Canada BCSC Inquiries Group Full time

    Employment Duration Permanent - Full Time Centrally located in downtown Vancouver, the British Columbia Securities Commission (BCSC) strives to make the investment markets benefit the public – enabling people to achieve their financial goals, enterprises to grow, and British Columbia to thrive. Through smart rules, diligent oversight, strong...


  • Vancouver, Canada Take a Hike Foundation Full time

    Are you a database enthusiast looking for an engaging, rewarding, and supportive work environment? Take a Hike has a strong workplace culture that prioritizes kind and open communication. An enthusiasm to learn and grow as a fundraiser is important, but cultural fit is paramount. The way we speak to each other, to donors and to partners is the same across...

  • Database Curator

    1 day ago


    Vancouver, Canada United Way British Columbia Full time

    **This a full-time project funded position which is scheduled to end no later than December 31, 2023.** **This is a bargaining unit role with CUPE Local 1936. This position is a pay Grid 11 which is $23.10 per hour.** **JOB PURPOSE** This role collects, enters, and maintains information on human services for the 211 British Columbia community information...


  • North Vancouver, Canada District of North Vancouver Full time

    **Database Administrator/Analyst**: **3 Year Temporary Full-Time** Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of **BC’s Top Employers **for 4 years, the District offers exciting professional...


  • North Vancouver, Canada District of North Vancouver Full time

    **Database Administrator/Analyst**: **3 Year Temporary Full-Time** Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of **BC’s Top Employers **for 4 years, the District offers exciting professional...


  • Vancouver, BC, Canada University Canada West Full time

    Position Job Title: Career Development Specialist Location: University Canada West - Vancouver (Hybrid) Reports To: Associate Director, Career Development Centre The Career Development Specialist (CDS) provides career learning facilitation, career advising, coaching and consultation to students, graduates, and alumni through one-on-one sessions, and...

  • Events Specialist

    4 days ago


    Vancouver, Canada BGC South Coast BC Full time

    Summary of Responsibilities BGC South Coast BC is seeking a self-motivated, energetic person to work with our Resource Development team where every team member plays a critical role raising funds for programs that support kids in being the best they can be! The Events Specialist assists with the development, preparation, and implementation of event...


  • Vancouver, Canada Lifetouch Full time

    **Description** At Lifetouch (part of the Shutterfly family of brands), we believe there is extraordinary power in the self-expression. Built on the tradition of "Picture Day", Lifetouch has captured the unique personalities of children and families for more than 85 years. Be part of our amazing team in a key role as an _Account Specialist!_ As an Account...


  • Vancouver, Canada B.C. College of Nurses and Midwives Full time

    **Status**: Regular, Full-Time **Number of Positions**: 1 **Work Location**:Hybrid (a combination of in-office and remote work) **Compensation**: $91,202 - $95,761 per annum **What you’ll be doing** Reporting to the Director, Research & Evaluation, the Performance Measurement Specialist (PM Specialist) works cross-functionally to assess, measure and...


  • Vancouver, Canada Royal Bank of Canada> Full time

    Job SummaryJob DescriptionWhat is the Opportunity?As part of the Data Protection team, you will be responsible for proactive identification and detection of threats / risks associated with databases assets. We are a team of security experts that are enthusiastic about solving complex problems and developing innovative security solutions. We engineer...

  • Billing Specialist Ii

    4 weeks ago


    Vancouver, Canada Vancouver Shipyards Full time

    **Billing Specialist II**: The Billing Specialist II is responsible for ensuring the accurate and timely invoicing of National Shipbuilding Strategy (NSS) programs and to support in the preparation of monthly financial statements, management reports, financial analysis, time-keeping oversight for both hourly and salary employees, and capital spending/AFE...


  • Vancouver, BC, Canada Horizon Recruitment Inc. Full time

    Horizon Recruitment Inc. is currently seeking an experienced Procurement Specialist for one of our large BC clients. The Procurement Specialist will manage a large volume of vendor sourcing projectsand will develop and maintain systems to effectively manage a complex portfolio of services and capital projects. Responsibilities: Work closely with...


  • North Vancouver, Canada District of North Vancouver Full time

    **Job Status** - Temporary Full-Time**About Us** - Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of - **BC’s Top Employers **for 4 years, the District offers exciting professional development...


  • Vancouver, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionWhat is the Opportunity?As part of the Data Protection team, you will be responsible for proactive identification and detection of threats / risks associated with databases assets. We are a team of security experts that are enthusiastic about solving complex problems and developing innovative security solutions. We engineer...


  • VANCOUVER, Canada Royal Bank of Canada Full time

    Job SummaryJob DescriptionWhat is the Opportunity?As part of the Data Protection team, you will be responsible for proactive identification and detection of threats / risks associated with databases assets. We are a team of security experts that are enthusiastic about solving complex problems and developing innovative security solutions. We engineer...


  • Vancouver, Canada PHSA Full time

    **Job Summary**: Reporting to the Decision Support Consultant, Information Integration, the Data Integration Specialist provides integrated healthcare data analysis and interpretation to senior leadership, agency committees, departments and external consultants. This role is responsible for opportunity identification, business requirements analysis, design...


  • Vancouver, Canada Pacific Community Resources Society Full time

    **Employment Specialist - WorkBC** **Employment Services - Midtown-Vancouver, BC** Supervisor: Employment Services Coordinator Regular Full-time (35 hours/week) Grid 13($29.96 - $31.24/hour) Closing Date: May 12, 2023 *** *** **Flexible** *** **hours** *** **may** *** **be** *** **required** **Opportunity** Pacific Community Resources Society seeks...


  • VANCOUVER, Canada Royal Bank of Canada Full time

    Job SummaryJob DescriptionWhat is the Opportunity?As part of the Data Protection team, you will be responsible for proactive identification and detection of threats / risks associated with databases assets. We are a team of security experts that are enthusiastic about solving complex problems and developing innovative security solutions. We engineer...


  • Vancouver, Canada Hypertherm Full time

    Inventory Control Specialist Hypertherm Associates is looking for an Inventory Control Specialist to join our US Distribution Center team residing in The Netherlands. As an Inventory Control Specialist, you will help us manage the replenishment process for our regional distribution centers. At Hypertherm, we are more than just a company. We are a global...