ISL 27R - Senior Database Administrator

BC Liquor Distribution Branch; Burnaby; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

BC Liquor Distribution Branch in Burnaby, BC, seeks a Senior Database Administrator to lead the design, development and deployment of database and application systems including Oracle ERP, Oracle databases, MS SQL Server and PostgreSQL. The role requires guidance to teams on architecture, standards and security.

You will ensure data security and compliance, work across IT operations, and support 24x7 peak periods. A criminal record check is required and a hybrid work arrangement is available.

Qualifications

• Degree in Information Technology or related field with at least 3 years of related experience.
• Experience with Oracle enterprise database administration and applications.
• Experience with Oracle eBusiness Suite with SSO using OAM/OID.
• Experience in Applications Database Administration (DBA).

Responsibilities

• Lead design, development and implementation of LDB database and application systems (Oracle ERP ecosystem, Oracle databases, MS SQL Server, PostgreSQL).
• Provide expert guidance to staff and project teams on database design and deployment standards.
• Research new infrastructure software and ensure data security and compliance.

Skills

Oracle DBA

Oracle EBS SSO OAM OID

Applications DBA

Postgres

Azure Cloud

Oracle SOA Suite

Education

Degree in Information Technology or related field

Job description

About the BCLDB:

The BC Liquor Distribution Branch (LDB) is one of two branches of government that provide oversight for the beverage alcohol and non-medical cannabis industries in the province. The LDB is responsible for the wholesale distribution of liquor and cannabis, and operates the retails brands BCLIQUOR and BC Cannabis Stores.

The LDB is committed to government's goals of making life better for people in B.C., improving services, and ensuring a sustainable province for future generations. The revenue generated by the LDB helps fund essential public services like health care, education, and community programming. Learn more on the LDB careers page.

LDB's Information Technology (IT) team consists of seven competency areas: Customer Experience, Infrastructure & Operations (I&O), Information Security, Enterprise Architecture, Software Services, Data Services, and IT Program Governance. Currently five divisions managed by IT Directors collectively are responsible for all of the seven competency areas to deliver the IT mandate of supporting LDB's corporate and business operations and enabling future needs and initiatives.

At present, the IT team consists of more than 200+ full-time employees and includes a sourcing strategy to leverage external expertise to ensure the integrated IT team continues to deliver LDB's strategic initiatives timely and of high quality.

The IT department of the LDB is responsible for the entire computing infrastructure for all of the 230+ BCLIQUOR stores, BC Cannabis Stores as well as LDB's head office in Burnaby and four warehouse/distribution centres including Delta, Kamloops, Richmond, and Victoria. The IT department also manages three data centres located in Burnaby, Delta, and Kamloops.

About this role:

The Senior Database Administrator (Sr. DBA) is responsible to lead the design, development, and implementation of LDB database and application systems (such as Oracle ERP ecosystem application, Oracle databases, MS SQL Server databases, Postgress SQL databases). The Senior Database Administrator provides expert guidance to LDB staff and project teams on database application design, administer deployment tool sets, and consult with software vendors for troubleshooting. The Senior Database Administrator develops and implements standards for database administration and deployment, research new infrastructure software, and ensure data security and compliance.

A criminal record check is required.

Working conditions include the ability to work flexible hours to support business operating hours (24x7) during peak periods, weekends and holidays.

For complete details about this opportunity, including accountabilities, please refer to the attached job description, also located in the Additional Information section at the bottom of the posting.

An eligibility list for permanent or temporary future opportunities may be established.

Position requirements:

Education and Experience:

• Degree in Information Technology or related field and minimum three (3) years of recent, related experience*.

*Recent, related experience must have occurred within the last six (6) years and must include the following:

• Experience developing policy and standards documents.
• Experience with Oracle enterprise database administration and application.
• Experience with Oracle eBusiness Suite with SSO using OAM/OID.
• Experience in Applications Database Administration (DBA).

Preference may be given to those candidates with any of the following:

• Postgres databases on premises and in Microsoft Azure cloud environment.
• Experience with Oracle SOA Suite.

Working for the BC Public Service:

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.

We are committed to ensuring that reasonable accommodations are available throughout the hiring process, including the assessment and selection stages. Please email the individual or contact listed on the posting if you require an accommodation to fully participate in the hiring process.

This position is eligible for flexible work arrangements, such as a hybrid work combination of in-office and work-from-home, following the guidelines established for flexible workplaces.

The Indigenous Applicant Advisory Service is available to Indigenous (First Nations [status or non-status], Inuit or Métis) applicants originating from the land now known as Canada, seeking work or already employed in the BC Public Service. Indigenous applicants can contact this service for personalized guidance on the BC Public Service hiring process including job applications and interviews.

The BC Public Service is an award-winning employer and offers employees competitive benefits, amazing learning opportunities and a chance to engage in rewarding work with exciting career development opportunities. For more information, please see What the BC Public Service Offers.

Job Category

Information Management/Information Technology

Additional Information

IS R27_Senior Database Administrator