Senior Database Administrator

BC Assessment is currently looking for a permanent Senior Database Administrator to join our Data Management & Reporting team in our ITS Division!

Organization Overview

BC Assessment is a Provincial Crown Corporation that develops and maintains real property assessments throughout British Columbia in addition to providing real property information.

BC Assessment serves the citizens of British Columbia and has 13 offices throughout the province.

At BC Assessment, our people and culture are important to us. We work together to create a culture that appreciates differences in all forms.

We trust and respect each other, and are invited to bring our whole selves to work. We are committed to making BC Assessment the best possible place to work, and through our efforts ultimately contribute to a better British Columbia.

Our service-centric employees are productive, engaged, and work collaboratively in a modern and flexible workplace. Our employees are at the heart of our organization and we are proud to be recognized as one of for the eleventh year!

At BC Assessment, we offer competitive for our employees :

Work-life balance 35-hour work weeks, hybrid work options and flexible work schedules.

Public Service Pension Plan One of the best in Canada, allowing you to plan for your future.

Health and Wellness - Generous extended health and dental benefits through Pacific Blue Cross and an Employee Assistance Program to help support our employees overall well-being.

We offer a reduced-cost bus pass through the BC Transit ProPASS program and our Uptown office has a secure bike storage and secure change rooms with lockers.

Career development We want you to grow and learn with us! We provide ongoing learning, leadership development and career development scholarship program.

Location Our office is located in Saanich, BC at Uptown which overlooks several shops and coffee shops and is walking distance to the Galloping Goose trail network.

One of BC Assessment's core values is that we are here for each other. We build relationships based on genuine support and care.

We respect each other as individuals with different identities, experiences and views. We are committed to recruiting, developing, and supporting the success of a diverse workforce that reflects the communities we serve.

We welcome applications from anyone, including Indigenous Peoples, Black People, Members of Racialized Groups / Visible Minorities, Persons with Disabilities and People with Diverse Sexual Orientations and Gender Identities or Expressions.

We are committed to ensuring that reasonable accommodations are made available to persons with disabilities during the recruitment, assessment and selection processes and will provide reasonable accommodations upon request.

If you require assistance or an accommodation due to a disability, please

Job Overview

Reporting to the Manager, Data Management & Reporting, the Senior Database Administrator works collaboratively with other Senior Database Administrators and project teams from across the organization to manage, support and maintain BCA corporate databases, data warehouses and reporting systems.

This high performing team is responsible for the definition, organization, standards, security, backup, and performance and evaluation of the BCA databases, data management, and database services.

We are looking for an experienced Senior Database Administrator with a strong understanding of :

• Relational database systems, Structured Query Language (SQL and PL / SQL), relational data modeling and data management principles, structured analysis and design, and documentation of business requirements;
• SQL Server Technology Stack : Database Engine, SQL Agent, SQL Server Analysis Services (Tabular and Multidimensional), SQL Server Integration Services, SQL Server Reporting Services, PowerBI (On-premises);
• SQL Server Administration including configuration, maintenance, monitoring, patching, upgrades and security;
• Data warehousing and database management theory, concepts and technologies;
• Corporate data warehouse planning, design and development;
• Policies and IT standards to research and develop corporate data warehouse; architecture, technologies, methodologies, standards and models;
• Architectural standards, business rules, reporting frameworks, and migration of data;
• Experience in Oracle application development, process optimization and querying / processing large data sets would be an asset;;
• Process optimization, scripting, automation and continuous improvement;

SQL Server Replication, High Availability, and Disaster Recovery methods.

You are also a good communicator, willing to collaborate with others and really listen to find out what the business needs.

You are inquisitive and proactive. You can work effectively with non-technical people to translate what they need and the problems they want to solve into a workable solution.

You are calm under pressure and able to re-organize your day-to-day tasks based on changing priorities. You are committed to continuous learning and understand that technical expertise is a constantly evolving state, and you are willing to do what it takes to stay current with changing technologies.

Finally, you care about making a difference and delivering the best possible database solutions to all levels of the organization.

Key Accountabilities

Develops and reviews corporate data management policies that will guide the development and maintenance of the corporate data warehouse.

Conceptualizes, designs, develops and implements the data dictionary architecture, strategies, methods and standards (i.e.

extract, transform and load standards, data cubes, data elements, table structures, naming conventions, key definitions and optimization) and data (i.

e. data entities, types, sizes and defaults) for complex models.

Leads data capacity life cycle planning, duration, usage requirements, feasibility and related planning and evaluation studies.

Develops corporate data warehouse standards, policies and procedures.

Develops and documents corporate standards for use, control, updating and maintenance of enterprise-wide data warehouse and related databases.

Provides operational support, maintenance and monitoring of databases and makes corrections based on business needs, monitors performance, utilization and growth of databases and identifies systems issues and resolves complex problems.

This position is included in the bargaining unit. BC Assessment may establish an eligibility list for this competition.

Location : Victoria, BC Uptown*

Salary Range : $93,317.50 - $109,693.26 (plus 6.25% Temporary Market Adjustment)

We may consider candidates in Vancouver, BC

Qualifications

Note : An equivalent combination of education and experience may be considered.

Education

A university degree in Computer Science.

Training or courses in database design and implementation, information retrieval techniques file access methods, and development and documentation standards.

Proficiency in database descriptor language and database command language.

Experience

Experience performing database analysis and design, managing a data warehouse or managing data administration services for an organization.

Experience providing technical direction to project staff.

Experience working in a client-focused work environment.

Application Instructions

Please complete the full application for this position, including your education, certifications and experience that are relevant to and / or required per the stated qualifications.

If you are an internal employee, please ensure that your employee profile contains your relevant education and experience.

Upload your resume and cover letter; once you submit your application, you will not be able to add documents.

If a questionnaire is present, please complete it fully. Responses may be used to shortlist candidates against the stated job requirements.

All BC Assessment employees must live in British Columbia. If you do not currently reside in, or live within commuting distance of the location(s) of the position to which you are applying, please make clear your relocation intentions as part of your cover letter.

Offers of employment are conditional upon a satisfactory Criminal Record Check. All information provided in your application may be subject to verification.

Successful applicants will be required to provide proof of qualifications and / or supporting documentation (e.g. copies of certificates, diplomas, degrees and driver’s license) as a condition of employment.