Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Insurance Advisor - Trainee Insurance Advisor - Trainee Commercial Account Manager Manager Translator - Moody Technical Translator ASL-English interpreter Translator Translator and Translation Coordinator Foreign Language Intelligence Analysts Bilingual Translator-Reviser translator Foreign Language Translator Ford Master Service Technician Facility Manager - Gold Creek Commercial Account Manager Senior Accountant Home Financing Advisor - Timmins Financial Advisor Opportunities - Associate Insurance Advisor II Associate Financial Advisor Financial Advisor - Eastern Ontario Co-op Student Franchise Specialist - Ontario East Investment Advisor Agriculture Account Manager Client Advisor Department Manager Senior Financial Advisor - Peterborough Financial Advisor Marketing Coordinator Financial Advisor Opportunities- Accounting Supervisor Prospective Student Advisor Financial Advisor - Edmonton Insurance Advisor Senior Financial Advisor - IIROC Client Accommodation Services Advisor Financial Services Representative II Senior Long-Term Financial Planning Financial Advisor - IIROC Financial Advisor I Manager Small Business Advisor - Cold Lake Financial Services Representative II- Insurance Advisor Financial Advisor - Northern British Associate Financial Advisor Auto Associate Associate Newest Jobs
Companies
Yelp Two Sigma CareGuide Brightenvantage international Business Consulting Inc. Sterling-Turner Moscleancom CCLINKS TRADING AsteroidX Canadian Embassy LowCostWebDesignFirm.com Aecom Clearbanc Exact Media M*A*C - Southcentre Mall Storyboard That WeWork The Youth Connection Aerotek I Want What It's Worth Shopify AT&T First Convenience Bank jobox.ai mappedin Recovhub Clickworker Insight Global Amazon Flex Scotiabank American Income Life TD Bank ATI Physical Therapy Paylocity Creative Circle Algolia Microsoft Vector Marketing Desjardins CUCU Covers UFD Consulting Inc Unbounce Top Hat Kourts Athletic Alliance Hootsuite SnapTravel GoParkr Doordash Hinge JUUL Labs All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

MSSQL Database Administrator BurnabyHead Office At Best Buy Canada

Location: Burnaby, British Columbia

Job Description

MSSQL Database Administrator (DBA)

Information Technology (IT)


Reporting to Senior Manager Database Service, as a member of the Best Buy Canada IT database team the MSSQL Database Administrator will be responsible for supporting all Best Buy Canada MS SQL and Couchbase databases for all production and lower environments. This role will be a hands-on role and it is expected that this role will also be working with and providing guidance to 3rd party outsourced L1 and L2 DBA’s to maintain the database application infrastructure operations on a daily basis and work with IT Infrastructure team and application development team members to ensure production environments are highly available. The role will ensure all applicable incident, problem and change management (ITIL) processes are followed according to Best Buy Technology Group standards.

As a member of the DBA team monitoring and tuning the database environment for is one of the primary responsibilities the team is involved in. The DBA team will need to perform capacity planning to ensure all database environments have sufficient capacity to support current and future projects.

This role will continuously build his/her knowledge of the current database infrastructure as well as future and upcoming database technologies to provide progressive improvements and efficiencies to the database environment with which our Best Buy Canada applications operate on.


As a MSSQL Database Administrator, you will…


Database:

  • Implement and support MSSQL Server and Couchbase databases.
  • Performing in-depth analysis of the highest level technical issues.
  • Act as a primary resource in successful completion of MSSQL and couchbase database upgrades and/or migrations.
  • Patch management – review technical notes for all critical patches released for MSSQL and couchbase database environments and sure MSSQL and couchbase database are up to date with the latest critical security patching and in compliance to Best Buy Enterprise Information Protection patching policy standards.
  • Maintain the multiple staging, testing, disaster recovery, and production database environments within the Best Buy Canada space. You will ensure that each patch is properly tested in lower environments when possible before being applied into production and that lower environments are continually ready to receive new code for project and break/fix testing purposes.
  • Must be part of the rotating “on call team,” providing support to critical production system support after hours.
  • Must be able to work weekdays, weekends, and holidays as required by system support and maintenance.
  • Other duties as deemed appropriate.

Project Support:

  • Work with developers to review and optimize SQL/stored procedure calls.
  • You will work closely alongside the development and testing teams during design, execution and testing phases performing development and support ensuring any new database changes / enhancements in Best Buy Canada applications will be optimized for performance in the production environments.
  • Applying advanced problem-solving skills with the ability to craft pragmatic solutions that are scalable, secure, and stable, following Best Buy Canada’s IT infrastructure architecture as part of our project teams.

Infrastructure Monitoring/Performance Tuning:

  • Work with performance testing streams to identify potential application infrastructure bottlenecks and provide remediation plans as they relate to database.
  • Monitor and tune the database environment; one of the primary responsibilities the team is involved in. The DBA team will need to perform capacity planning to ensure all database environments have sufficient capacity to support current and future projects.

We hope you are passionate about…

  • Communication - You're able to communicate with all different types of people, both verbally and in writing.
  • Logic and critical thinking – we’re largely a data driven company, so consideration of all angles and viewpoints will set you up for success.
  • Details – nothing gets past you!
  • Continuous Improvement – you’re constantly are looking for ways to improve, and can respectfully challenge the status quo.

The experience we need…

  • MSSQL database production support experience.
  • Bachelors or Diploma in Computer Science or similar.
  • 5+ years of professional work experience within the IT infrastructure.
  • Direct experience implementing, managing, and performance tuning Microsoft SQL databases in a clustered and highly available environment.

Bonus points…

  • Bachelor's Degree, Associate's Degree, or equivalent in Business, Operations, or Logistics, or equivalent experience.
    ITIL, MCITP, etc.
    You’ve worked in an Agile environment.

We believe we have the unique opportunity to help customers enrich their lives and pursue their passions with the help of technology