Senior SQL Server DBA
BC Liquor Stores
Burnaby, BC
2d ago
source : ITjobs.ca

Senior SQL Server DBA

Information Systems R27

At the Liquor Distribution Branch (LDB) our vision of Service. Relationships. Results.’ is all about providing a valued service, building strong relationships with our stakeholders, and achieving greater results for the province.

The LDB is one of two branches of government responsible for the cannabis and liquor industry of B.C. We operate the wholesale distribution of beverage alcohol and non-medical cannabis within the province, as well as the household retail brands of BC Liquor Stores and BC Cannabis Stores.

We employ nearly 5,000 people in over 200 communities and have hundreds of career opportunities spanning our entire wholesale, retail and corporate operations from supply chain logistics, to high-tech solutions, and everything in between.

The LDB has been named one of BC’s Top Employers 12 times over for offering exceptional places to work, flexible work hours and earned days off, extended health and dental benefits, maternity and parental leave top-up payments, a pension program, in-house professional and leadership development, and subsidies for professional accreditation.

The information technology (IT) team is highly customer focused and directly supports four distinct lines of business : retail liquor, wholesale liquor, cannabis, and corporate.

These line of business IT teams are supported overall by both a Chief Information Security Officer and a Chief Technical Officer and their respective departments to ensure the organization prioritizes security and innovation.

At present the technology team consists of more than 200 full-time employees, and has also adopted a multi-sourcing strategy and leverages external expertise, Cloud SaaS based services and government shared services as appropriate.

The teams integrate, maintain and enhance more than 80 business systems on a hybrid on-premises and cloud infrastructure. These include :

  • Merchandising and retail store systems that process 40 million plus customer transactions per year.
  • Wholesale, distribution and warehouse systems that enable the movement of 17 million plus cases per year.
  • Corporate finance systems to service an annual budget of approximately $3 billion and HR and payroll systems to service more than 5000 employees.
  • Reporting to the Manager of Database Services and Middleware, the Senior SQL Server DBA is responsible for providing the Liquor Distribution Branch (LDB) with expert technical direction and leadership concerning development, enhancement, installation, and maintenance of the organizations mission critical databases, the various SQL Server databases and various applications in use at the LDB.

    This position will participate in LDB’s Cloud Journey by working with architects to define strategies and framework of hybrid Database as a Service mode.

    May be required to work shift work and be on standby. Overtime may be required to meet deadlines.

    A criminal record check is required.

    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 & Experience

    Degree or diploma in Information Technology, or related field, with a minimum of 4 years of recent and related experience*.

    An equivalent combination of education, training and experience may be considered i.e., 5 years of recent and related experience* with formal course work and / or certificates.

  • Recent and related experience must have occurred in last 10 years and include the following :
  • MS SQL Server 2012 or later
  • Disaster Recovery / high availability strategies : AlwaysOn’ AG (Availability Groups), Clustering, Log Shipping, Replication
  • Performance tuning
  • Preference may be given to those candidates with experience with the following experience :

  • Operating Systems : Windows Server
  • Analyzing and troubleshooting database servers, through load testing, performance tuning, statistics, indexing, and database design.
  • Automating standard DBA tasks such as capacity planning, backups, and performance monitoring.
  • Maintaining and supporting large scale multi-server databases in an enterprise level 24 / 7 environment
  • SQL / T-SQL development and data modeling
  • SharePoint 2013,20216
  • PowerShell
  • How to Apply & Application Requirements :

    In order to be considered for this position, your application must clearly demonstrate how you meet the education and experience as outlined in the Position Requirements section above.

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

    A cover letter may be a requirement as part of your application. The content and / or format of your cover letter may be evaluated as part of the assessment process.

    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.

    For specific position-related enquiries, please contact at Sherry Zhao at 604-252-8863 .

    Only applications submitted using the BC Public Service Recruitment System on this website will be accepted. For more information about how to create or update your profile, please refer to the attached Application Instructions or refer to the page on the MyHR website.

    If you are experiencing technical difficulty applying for a competition, please send an e-mail to BCPSA.Hiring.Centre gov.

    bc.ca before the stated closing time, and they will respond as soon as possible to assist you.

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

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form