Job Description

Database Administrator
Information Systems R27

There is currently 1 temporary appointment until December 31, 2023. This opportunity may be extended and/or a permanent appointment may result from this temporary appointment.
An eligibility list may be established for future temporary and/or permanent opportunities.

On November 1, 2021 the BC Public Service announced the COVID-19 Vaccination Policy that defines the conditions and expectations for BC Public Service employees regarding vaccination against COVID-19. Among other possible measures, proof of vaccination will be required. It is a term of acceptance of employment that you agree to comply with all vaccination requirements that apply to the public service. More information can be found here.

The Information Systems Branch is responsible for providing strategic IM/IT leadership for the Justice and Public Safety Sector, and for the provision of IM/IT services to support our sector program areas and stakeholders. The branch includes four divisions: MCIO Division, Client Services Division, IT Security, Privacy & Operations Division and the Strategic Initiatives Division.

The IT Security, Privacy & Operations Division (ITSPO) is responsible for oversight and maintaining a stable, secure, and efficient operational environment for our sector clients and their business applications. Key services include information security and privacy, infrastructure support, liaison with central agencies and a Service Desk that supports sector staff and our broader stakeholders.

This position is a member of the Database Administration team in the Operations work unit in the ITSPO Division. The Operations work unit consists of four teams: Service Transition, Middle Tier Infrastructure, Database Administration and Data Architecture.

The Database Administrator is responsible for day to day development and control of the definition, organization, protection and documentation of databases in accordance with data administration plans, policies, procedures and standards.

The BC Public Service is committed to creating a diverse workplace to represent the population we serve and to better meet the needs of our citizens. Consider joining our team and being part of an innovative, inclusive and rewarding workplace.

For information about the Indigenous Applicant Advisory Service please visit: Indigenous Applicant Advisory Service - Province of British Columbia (gov.bc.ca)

NOTE: Applications will be accepted until 11:00 pm Pacific Standard Time on the closing date of the competition.

Job Requirements:
In order to be considered for this position, your application must clearly demonstrate how you meet the education and experience as outlined below:

• Degree, diploma, or certification in the computer science field or related. An equivalent combination of experience and education may be considered.
• Minimum 1 year experience in each of the following:
  • working within complex IT environments.
  • with MS SQL Server database administration.
  • with backup and recovery techniques.
  • with database tuning and performance troubleshooting processes.

Preference may be given to those applicants with:

• Experience with MS SQL Server 2008 R2 and above.
• SQL Server Replication and High Availability Technologies
• Experience with SQL Server BI with SSAS, SSIS and SSRS.
• Experience with Oracle, Postgres, Mongo or other open source databases and/or MySQL.

Applicants selected to move forward in the hiring process may be assessed on the Knowledge, Skills, Abilities and Competencies as outlined in the attached Job Profile located in the Additional Information section at the bottom of the posting.

Enhanced - Enhanced Security Screening will be required.

APPLICATION REQUIREMENTS:

Cover Letter: NO - Please do not submit a cover letter as it will not be reviewed.

Resume: YES - Ensure your resume includes your educational accomplishments, employment history including start and end dates (month and year) of your employment, and any relevant information that relates to the job to which you are applying.

Questionnaire (BASIC): YES - As part of the application process, you will be prompted to complete an online questionnaire to demonstrate how you meet the job requirements.