Senior SQL Server DBA
Information Systems R27Regular, Full-Time, BurnabyIS R27 $71,298.93 to $81,387.14 per annum PLUS 6.6% Temporary Market Adjustment ($76,004.55 to $86, 758.61)
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 LDBâs Information Technology Division consists of seven departments and 23 distinctive units, with 200+ FTEs. IT has adopted a multi-sourcing strategy and leverages a combination of internal and external expertise, including outsourced services, contracted services and shared services, to deliver the IT mandate of supporting current operations and future business needs. Strategic plans, governance of standards and risk management are all developed internally to support Divisional and Corporate goals.Â
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.Â
Please submit a cover letter and resume clearly identifying how you meet the qualifications necessary for this position
. This information may be used as part of the selection process.Â
An eligibility list for permanent or temporary future opportunitiesÂmay be established.Â A criminal record check is required.ÂÂ
For complete details about this opportunity, including accountabilities, please refer to the attached job profile.Â For specific position related enquiries, please contact Sherry Zhao, Manager, Database & Middleware, IT, CTO by phone at 604 252-8863.
Â For more information about how to complete your job application, add/edit your resume and for more useful tips when applying for jobs, please refer to the Your Job Application page on the MyHR website. If you are still 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 we will respond as soon as possible to assist you.
Only applications submitted using the BC Public Service Recruitment System on this website will be accepted.NOTE:
Applications will be accepted until 11:00 pm Pacific Standard Time on the closing date of the competition.
Visit Careers at: www.bcldb.comÂ
Education & Experience:
Degree or diploma in Information Technology or a related field, with a minimum of 4 years of recent, related experience*.
An equivalent combination of education, training and experience may be considered i.e., 5 years of recent related experience* with formal course work and/or certificates.Â
*Recent, related experience must have occurred in last 7 years and must include experience with the following:
•MS SQL Server 2012 or later •Operating Systems: Windows Server •Disaster Recovery/ high availability strategies: âAlwaysOnâ AG (Availability Groups), Clustering, Log Shipping, Replication •Performance tuning
Preference may be given to those candidates with the following experience:
•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, 2016 •Azure •PowerShell
•Knowledge of data management and software development •Knowledge of Information Technology Infrastructure Library (ITIL) •Knowledge of Information Management and Data Management principles practices and processes •Knowledge and experience of Software development life cycleSkills/Abilities
•Ability to diagnose and resolve issues/problems related to database, OS and associated tools •Ability to deal with clients in a courteous, respectful and professional manner •Ability to communicate both verbally and in writing •Ability to work independently as well as being part of a team •Ability to prioritize and manage work tasks and achieve results within agreed timeframes •Ability to conduct research, risk analysis and recommend appropriate strategies/solutions
Information Management/Information Technology
69593 Job Profile ISL 27 Senior SQL Server DBA