Isl 27r

Posting Title- ISL 27R - Database Administrator- Position Classification- Information Systems R27- Union- GEU- Location- Kamloops, BC V2H 1B7 CA
- Kelowna, BC V1Z 2S9 CA
- Multiple Locations, BC CA (Primary)
- Nanaimo, BC V9T 6L8 CA
- Prince George, BC V2N4P7 CA
- Vancouver, BC V6B 0N8 CA
- Victoria, BC V9B 6X2 CA- Salary Range- $75,552.53 - $86,175.83 annually plus 9.9% Temporary Market Adjustment- Close Date- 2/5/2023- Job Type- Regular Full Time- Temporary End Date- Ministry/Organization- BC Public Service -> Water,Land,ResourceStewardship- Ministry Branch / Division- Application Infrastructure/Natural Resource Information & Digital Services- Job Summary**Database Administrator**
**Information Systems R27**

An eligibility list may be established for future permanent and temporary opportunities

British Columbia’s Natural Resource Ministries (NRM) are the stewards of the Province’s Crown land and natural resources which reflect the diverse values and interests of all British Columbians. In order to support the growth of the economy while providing effective environmental stewardship, the province’s NRM must transform in order to advance the shared management of British Columbia’s natural resources.

Natural Resource Information & Digital Services (NRIDS) is leading the modernization and transformation of business practices for the NRM through continuous improvement projects, new technology options and operational information management/information technology (IM/IT). NRIDS is providing leadership for IM/IT planning, policy and business process solutions and is also the single authority for all information and technology across the NRM.

In this position you lead the design, development and implementation of Ministry database systems._ _

This is your opportunity to live in one of the most beautiful regions in British Columbia and work for the BC Public Service. We offer a healthy work/life balance, excellent benefits and much more.

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**:

- Degree, diploma, certification or equivalent in the computer science field.
- A minimum of two years of experience with PostgreSQL and/or Oracle Enterprise Database Administration.
- A minimum of two years of experience performing database backup and recovery procedures.
- A minimum of two years of experience working with Structured Query Language.
- A minimum of four years of experience working on implementing and/or supporting complex infrastructure projects.

**Preference may be given to applicants with**:

- Experience in Deploying, administering and managing SaaS and PaaS Technology
- Experience in engineering solutions to migrate databases from BareMetal/VM to Openshift/Docker platform
- Experience in container orchestrator(Openshift), docker platform, configuration management platform(Ansible), CIT tools(Jenkins)
- Experience with release management, supporting the implementation of projects using the AGILE/DevOps frameworks; using Confluence and JIRA.
- Experience with administration of high availability solutions with PostgreSQL and/or ORACLE database
- Experience with Spatial DBMS, such as ESRI SDE, Oracle Locator, Oracle Spatial or PostGIS

**Willingness Statement**:

- Willingness to provide on call 24-hour support during peak periods.

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

A Criminal Record Check (CRC) 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**:
**IMPORTANT**: Comprehensive questionnaire responses will be used to shortlist applicants against the job requirements. Please ensure you include all relevant information about your educational accomplishments and employment history including job titles, start and end dates (month and year) of your employment, and your accountabilities and accomplishments.
- Job Category- Information Management/Information Technology