Skip to Main Content

Database Administrator

Position Details

Position Information

Position Title Database Administrator
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 five years, the District offers exciting professional development opportunities and a competitive total compensation package including a nine day fortnight. This is an exciting time to join the District, as we embark on a range of initiatives to transform digital service delivery, customer experience, and our approach to climate action. Known for being a flexible, family-friendly employer with an inclusive workplace culture, the District of North Vancouver is an exceptional place to work. If you are civic-minded and interested in making an impact on people and businesses on the beautiful North Shore, consider working for the District of North Vancouver.
Position Overview
The District of North Vancouver is looking for a dynamic, highly motivated Database Administrator to join the District’s Information Technology team to support our database environment and enterprise applications.
What we can offer you
We’re looking for a talented Database Administrator to join our team. In this 3-year temporary full-time (TFT) position, you’ll work with a multi-disciplinary team to maintain and build solutions that both support and transform government services. Your work will be impactful and will help modernize how the District does business.
In this complex technical and analytical role, you will:
  • Modernize legacy data storage systems and tools.
  • Design and construct integrations and facilitate the movement of data between systems.
  • Take responsibility for the ongoing administration, performance tuning, configuration, security, and backup and recovery processes for the District’s SQL Server database environment.
  • Analyse current software and configurations and propose updates or modifications based on best practice.
  • Conduct regular system patching and upgrades; analyze proposed updates and determine their impact on existing systems and integrations prior to applying.
  • Provide technical support and guidance to the IT Department and perform tasks such as database monitoring, reporting, archiving, and optimization.
  • Perform ongoing evaluation to ensure data security, privacy and integrity.
  • Determine, enforce, and document database policies, procedures, and standards.
  • Troubleshoot and resolve technical issues as they arise.
  • Document processes, standards, and operational procedures for data transformation.

Qualifications

What you’ll need to succeed:
  • An enthusiasm for tackling new and unfamiliar tasks and problems.
  • Possess the ability to consider the “big picture” when implementing solutions, including provision of technical support and long-term sustainability.
  • Experience using SSIS, FME, or similar, for data transformation and migration.
  • An expert understanding of relational data structures, database platforms, and data modelling standards.
  • Experience creating and executing data recovery plans.
  • An in-depth knowledge of database structures and queries.
  • Demonstrated knowledge of Windows operating systems and Windows Server platforms.
  • Be a self-starter with the ability to work independently, take ownership over processes, and have a strong desire to understand the root causes of problems.
  • 5+ years of experiencing deploying, managing, and administrating MS SQL Server.
  • A degree or diploma in computer sciences or considerable related database management and support experience.

It’s great if you have:
  • Basic experience working with APIs – ex querying and extracting data.
  • Experience working with PowerBI and PowerApps.
  • Experience with Azure data storage and migration.
  • Experience migrating and transitioning legacy systems to modern applications and technologies.
  • Knowledge of cybersecurity requirements for on premise and cloud-based applications.
  • Experience working with enterprise software including management and configuration.
  • Experience working with business users to define software requirements.
  • Experience with municipal enterprise systems and environments.
  • Microsoft Certified Database Administrator (MCDBA) certification.

Details

Salary: The pay range for this unionized position is $48.20 to $56.95 per hour (2023 rates)
Hours of Work: 35-hour work week (Compressed work schedule available)
Other: Please note that this position is expected to be in office for first 6 months with potential for hybrid work after

Apply
The District of North Vancouver is committed to creating a diverse, inclusive, and accessible work environment. If you have what we’re looking for and have a passion to serve people and the community, and a demonstrated commitment to supporting a healthy and safe workplace, we would like to hear from you. Please apply with on-line at https://careers.dnv.org. This posting will remain open until filled.
If you require accommodation to participate in the recruitment process, please inform us when we contact you.

We thank you for your interest in employment with the District of North Vancouver and advise that only those shortlisted for an interview will be contacted.

We respectfully acknowledge the Coast Salish peoples, specifically the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh Úxwumixw (Squamish), and səlilwətaɬ (Tsleil-Waututh), on whose ancestral lands the District of North Vancouver is located.

Compensation The pay range for this unionized position is $48.20 to $56.95 per hour (2023 rates)
Posting Detail Information

Posting Number 23-28T
Job Open Date 10/19/2023
Job Close Date
Special Instructions to Applicants

Supplemental Questions

Required fields are indicated with an asterisk (*).

  1. * What is the highest level of education attained?
    • High School Diploma/GED
    • Technical/Trade School Certificate/Diploma
    • Associates Degree
    • Bachelors Degree
    • Masters Degree
    • PHD
  2. * How many years of experience do you have in this type of position?
    • 0-1
    • 1-3
    • 3-5
    • 5-7
    • 7+

Documents Needed to Apply

Required Documents
  1. Resume
  2. Cover Letter
Optional Documents
  1. Other