Jobs
>
Vancouver

    Database Specialist - Vancouver, Canada - British Columbia Securities Commission

    Default job background
    Description
    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 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
    • Hybrid work model
    • Beautiful downtown office
    • Work life balance
    • Professional development opportunities
    • 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.

    Application Details:

    Please visit our 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

  • British Columbia Securities Commission

    Database Specialist

    3 weeks ago


    British Columbia Securities Commission Vancouver, Canada

    **Company Overview**: · 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. · ...


  • Take a Hike Foundation Vancouver, Canada

    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 paramoun ...


  • YWCA Metro Vancouver Vancouver, Canada

    Job DescriptionThe Database Specialist trains, coaches and assists the Fund Development team with one-to-one support on their technical skills use of the database (Raiser's Edge NXT) and the maintenance of their donor records (clean data) as well as researching and implementing t ...


  • The Nature Trust of BC Vancouver, Canada

    The Nature Trust of British Columbia is a leading non-profit land conservation organization dedicated to protecting critical habitat for wildlife, fish, and plants in BC. Since 1971, we have secured over 180,000 acres of ecologically significant land. · This is a part · - or full ...


  • Douglas College Coquitlam, Canada

    **Work Arrangements**What Douglas Offers** · - DO what you love. Be good at it. That's how Douglas College defines a great career. It's a philosophy that resonates through our classrooms, our offices and our boardrooms. It inspires our students and drives us to make Douglas Colle ...


  • Northeastern University Vancouver, BC, Canada

    Reporting to the Director, Global Learner Support, the Global Learner Support Specialist provides language, cultural, and academic support to international and domestic students enrolled at the Regional Campus. The key responsibilities associated with this role include organizing ...


  • Brainhunter Systems Ltd Vancouver, BC, Canada $68,000 - $84,500

    This is the most exciting time in the history of cancer research and care. · We are on the cusp of true transformation. Cancer is the world's biggest health crisis and the BC Cancer Foundation—the fundraising partner of BC Cancer—has launched the most ambitious and comprehensive ...

  • Boys and Girls Clubs of South Coast BC

    Events Specialist

    2 weeks ago


    Boys and Girls Clubs of South Coast BC Vancouver, Canada

    **START DATE**:As soon as possible · **REPORTS TO**: Director Resource Development · **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 raisin ...


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

    **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 Measu ...

  • Vancouver Shipyards

    Billing Specialist Ii

    3 weeks ago


    Vancouver Shipyards Vancouver, Canada

    **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-ke ...


  • PHSA Vancouver, Canada

    **Job Summary**: · In accordance with the Mission, Vision and Values, and strategic directions of Provincial Health Services Authority, patient safety is a priority and a responsibility shared by everyone at PHSA, and as such, the requirement to continuously improve quality and s ...


  • go2HR Vancouver, Canada

    **Website and CRM Specialist - Vancouver BC** · Are you ready to be part of a team where your skills are valued, and your opinions are sought after? Are you a technical wizard willing to share your exceptional website and content development skills or looking to grow your skillse ...


  • Alimentiv Vancouver, Canada

    Responsible for the execution and adaptation of clinical data management plans and processes for collection, management, reporting and analysis of data on behalf of project teams and sponsors. Collaborate with multi-functional project teams and functional specialists to identify, ...

  • BGC South Coast BC

    Events Specialist

    2 weeks ago


    BGC South Coast BC Vancouver, Canada

    team where every team member plays a critical role raising funds for programs that support kids in being the best they can be · **Summary of Responsibilities** · The Events Specialist assists with the development, preparation, and implementation of event activities. This involves ...


  • McDonald's Canada Vancouver, Canada

    Company Description · At McDonald's, we are committed to being the best, and that starts with finding the best people. We have built a team of extraordinary people from around the world. We are problem solvers, risk takers, innovators, and thought leaders that take our work serio ...


  • Vancouver Film School Vancouver, Canada

    **Work at VFS** · There is no such thing as an ordinary day when you work at Vancouver Film School. It's a creative and fast-paced environment where you're part of recruiting and educating the next generation of actors, filmmakers, video game developers and creative thinkers. Our ...


  • District of North Vancouver North Vancouver, Canada

    **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 **B ...


  • Northeastern University Vancouver, Canada

    About the Opportunity · Based at the Vancouver campus, the Career Services and Experiential Learning Specialist supports co-operative education, experiential learning and career development programming for students studying in graduate degree programs. These programs include Mast ...


  • CPSBC Careers Vancouver, Canada

    Full-time, permanent · Position summary · The database analyst (DBA) reports to the information technology (IT) operations manager. You will be responsible for assisting in the designing, testing, planning, implementing, protecting, operating, managing and maintaining the College ...


  • District of North Vancouver North Vancouver, Canada 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 Empl ...