Database Administrator/analyst

**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 opportunities and a competitive total compensation package including a nine-day fortnight and hybrid work options. 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 offers an exceptional workplace culture. 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**What we can offer you**
- We’re looking for a talented Database Administrator/Analyst 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**:

- Take responsibility for the ongoing administration, performance tuning, configuration, security, and backup and recovery processes for the District’s SQL Server database environment.
- 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.
- Analyse current software and configurations and propose updates or modifications based on best practice.
- Perform ongoing evaluation to ensure data security, privacy and integrity.
- Determine, enforce, and document database policies, procedures, and standards.
- Assist with the design and construction of integrations and facilitate the movement of data between systems.
- Troubleshoot and resolve technical issues as they arise.
- Assist with the modernization of legacy data storage systems and tools.
- Maintain documentation for data transformation processes, standards, and operational procedures.

**What you’ll need to succeed**:

- A degree or diploma in computer sciences or considerable related database management and support experience.
- 5+ years of experiencing deploying, managing, and administrating MS SQL Server.
- 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.
- Experience using SSIS, FME, or similar, for data transformation and migration.
- Possess the ability to consider the “big picture” when implementing solutions, including provision of technical support and long-term sustainability.
- An enthusiasm for tackling new and unfamiliar tasks and problems.

**It’s great if you have**:

- Basic experience working with APIs - ex querying and extracting data.
- Experience with Azure data storage and migration.
- Experience working with PowerBI and PowerApps.
- 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.

**Who we are**:

- We are a growing, multi-disciplinary team of technology professionals focused on providing our customers and colleagues the right solutions to help them succeed. You will be supported by skilled technical architects, technology infrastructure specialists, business systems analysts, and usability and user experience professionals.- We love what we do and take pride in delivering what our customers need, and we have been recognized for the innovative and high-quality work that we have delivered. 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.- _
- 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._

**Compensation**
- The pay range for th