Talent.com
MS SQL Administrator (Senior Systems Analyst)
MS SQL Administrator (Senior Systems Analyst)British Columbia Institute of Technology • Burnaby, British Columbia, Canada
MS SQL Administrator (Senior Systems Analyst)

MS SQL Administrator (Senior Systems Analyst)

British Columbia Institute of Technology • Burnaby, British Columbia, Canada
30+ days ago
Job type
  • Full-time
  • Part-time
  • Permanent
Job description

Position Summary

BCIT’s Information Technology Services department is seeking a regular, full-time (1.0 FTE) MS SQL Administrator (Senior Systems Analyst). Working as a member of our Infrastructure & Networks team, you will support and communicate with internal and external stakeholders, support and mentor team members to develop and maintain an Enterprise Microsoft SQL system for BCIT. In this role, you will be entrusted with the design, implementation, and maintenance of our SQL Server databases, ensuring optimal performance, security, and availability. You will play a pivotal role in architecting database solutions that meet the evolving needs of our organization while collaborating closely with development teams. Duties & Responsibilities DUTIES AND RESPONSIBILITIES:

  • Design, implement, and maintain high-availability database solutions using SQL Server, ensuring optimal performance and reliability.
  • Monitor, troubleshoot, and resolve database performance issues, employing tools such as SQL Server Profiler, Performance Monitor, and Dynamic Management Views.
  • Develop and enforce database security protocols, including user access controls and data encryption methodologies.
  • Conduct regular database backups, restorations, and disaster recovery testing to ensure data integrity and availability.
  • Collaborate with development teams to optimize database queries and improve application performance.
  • Lead database migration projects, ensuring minimal downtime and data loss during transitions.
  • Mentor and guide junior DBAs in best practices and advanced database administration techniques
  • Preparing technical and user documentation.
  • Other duties as may be assigned.
  • Upon the completion of the major aspects of the project opportunities will exist for involvement in other areas of ITS’s Enterprise Technology Pillar.
Qualifications QUALIFICATIONS:

  • Institute of Technology diploma, or Bachelor’s Degree in science or business; and
  • A minimum of six (6) years’ current experience in an IT environment similar to BCIT
  • Experience with PowerShell, Windows Server, MS Clusters and MS Availability groups is a must.
  • Experience with cloud-based SQL Server solutions (e.g., Azure SQL Database or AWS RDS).
  • Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: SQL Server Database Administration.
  • Exposure to DevOps practices and tools, including CI/CD pipelines for database changes
  • Extensive experience with SQL Server versions 2016 and above.
  • Proficient in using SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
  • Experience working with internal and external stakeholders and vendors is required.
  • Familiarity with database monitoring tools such as Redgate SQL Monitor or SolarWinds Database Performance Analyzer.

Attributes:
  • Strong attention to detail, customer focused, ability to learn and adapt quickly and with ease.
  • A highly enthusiastic and effective oral/written communicator with excellent English verbal and written communication skills.
  • Well-organized with a methodical approach to work.
  • Energetic, motivated self-starter.
  • Ability to manage priorities in a busy environment.
  • Must be a team player and work well with cross-departmental groups.
  • Commitment to regular ongoing professional development including specific IT skills, professional associations, and current industry trends.
  • High level of professionalism and ethics.
  • Strong desire to meet deadlines.
Additional Information Benefits – Why you’d love working with us

  • Competitive pay
  • Minimum of twenty-five days of vacation (or more, depending on your position)
  • Competitive employer-paid extended health and dental plan – take a look at our benefit plans!
  • Defined benefit pension plan with employer contributions
  • Flexible hybrid work arrangements available
  • Professional Development funds and resources
  • Access to most BCIT Flexible Learning courses free of charge
  • Wellness and Employee Assistance programs
  • Complimentary membership with free access to the Fitness Centre, Gymnasium, and more
  • Eligibility requirements apply, benefits may vary depending on the employee group the position belongs to and whether the position offered is temporary or part-time. For more information on our generous benefits, click here!

BCIT is committed to the principles of equity, diversity & inclusion and to promoting opportunities in hiring for systemically oppressed groups who have been excluded from full participation at BCIT and the larger community. This includes Indigenous Peoples, women, racialized persons, persons with disabilities and those who identify as 2S/LGBTQIA+. All qualified candidates are encouraged to apply; however, Canadian citizens and permanent residents will be given priority.

Persons with disabilities who require accommodation for any part of the application or hiring process should contact us using our contact form. Please note that all applications must be submitted via the careers page portal. Applications submitted through the contact form will not be accepted. For additional information, please visit our frequently asked questions (FAQs) page and see how we hire.

The British Columbia Institute of Technology acknowledges that our campuses are located on the unceded traditional territories of the Coast Salish Nations of xwməθkwəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səl̓ilwətaɁɬ (Tsleil-Waututh).
Create a job alert for this search

MS SQL Administrator (Senior Systems Analyst) • Burnaby, British Columbia, Canada

Similar jobs

Senior Systems Administrator

Targeted TalentVancouver, Metro Vancouver Regional District, CA
Permanent

We are looking for an experienced.Systems Administrator (Windows).Our client is a large fintech firm with a product that you\'ve likely used many times before.You\'ll have the opportunity to work o...Show more

 • Promoted

Senior Business System Analyst - Presto Recruiting Solutions

Presto Recruiting Solutionsrichmond, bc, ca
Permanent

Senior Business Systems Analyst – Compensation & Claims Systems.Contract or Permanent | Canada | Remote).We are looking for an experienced.Senior Business Systems Analyst.This is a high-impact role...Show more

 • Promoted

Senior Retail Systems & Data Analyst

HCLTechVancouver, Metro Vancouver Regional District, CA
Full-time

A leading technology firm is seeking a Business Analyst with over 3 years of experience in the retail industry.This role requires a Bachelor's degree, strong skills in data analysis tools like SQL ...Show more

 • Promoted

Systems Analyst - SA165

Flexstaf ITVancouver, Metro Vancouver Regional District, CA
Full-time

Project: Southern Health Andgo Auto Call-Out Expansion.Location: Remote (within Canada only).Southern Health is expanding its staffing scheduling application, Andgo Auto Call-Out, to support more s...Show more

 • Promoted

Lead Systems Analyst(Billing Platforms)

OpenTextVancouver, Metro Vancouver Regional District, CA
Full-time

Opentext - The Information Company.OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture.As a member...Show more

 • Promoted

Senior System Administrator

Benchmark RecruitmentVancouver, Metro Vancouver Regional District, CA
Full-time

Full-time Opportunity | Hybrid, 2-3 days/week on-site in the Greater Vancouver Metropolitan Area | Must hold a valid Canadian Work Visa.This role ensures the stability, security, and performance of...Show more

 • Promoted

Oracle Business Systems Analyst - Order to Cash

InfobloxBurnaby, Metro Vancouver Regional District, CA
Full-time

Oracle Business Systems Analyst - Order to Cash.At Infoblox, every breakthrough begins with a bold.We invite you to step into the next exciting chapter of your career journey.Bring your creativity,...Show more

 • Promoted

Application Systems Analyst - Remote

Aurora Cannabis Inc.Vancouver, Metro Vancouver Regional District, CA
Remote
Temporary

Select how often (in days) to receive an alert:.Hours: 40 hours per week, Monday to Friday.Employment type: Temporary (12-Month Contract).With a smart strategy, unmatched talent and focus on our lo...Show more

 • Promoted

Senior Business Systems Analyst Role

Canada Mortgage and Housing CorporationVancouver, Metro Vancouver Regional District, CA
Full-time

Elevate your career as a Senior Business Systems Analyst focused on enterprise platforms.This role emphasizes advanced systems analysis and data integration, ensuring effective end-user support and...Show more

 • Promoted

Senior Systems Administrator

Cubic CorporationBurnaby
Full-time +1

Led by our talented teams around the world, Cubic is committed to solving global issues through innovation and service to our customers and partners.We have a top-tier portfolio of businesses, incl...Show more

 • Promoted

Senior Database Administrator with Oracle Expertise

CACI International Inc.Vancouver, Metro Vancouver Regional District, CA
Full-time

Step into a vital role as a Senior Database Administrator! Manage remote databases, optimize performance, and facilitate backups while contributing to large-scale federal financial systems.This pos...Show more

 • Promoted

MS SQL Administrator (Senior Systems Analyst)

British Columbia Institute of TechnologyBurnaby
Full-time +2

MS SQL Administrator (Senior Systems Analyst).Position Title MS SQL Administrator (Senior Systems Analyst).At BCIT , putting people at the core of everything we do is paramount.This idea is the fou...Show more

 • Promoted

Senior Systems Administrator for Microsoft 365

S I SystemsVancouver, Metro Vancouver Regional District, CA
Full-time

Enhance Entra ID security and Purview controls as a Senior Systems Administrator.This contract role offers 100% remote work in Canada, focusing on risk reduction in SharePoint Online.As a Senior Sy...Show more

 • Promoted

Senior Hybrid Systems Administrator Role

emergiTELNew Westminster, BC, CA
Full-time

Support and enhance IT infrastructure as a Senior Systems Administrator.Focus on robust hybrid environments while ensuring optimal performance and security across systems and cloud platforms.You wi...Show more

 • Promoted

Microsoft 365 Hybrid Cloud Systems Administrator — 35‑Hour Week

emergiTEL Inc.New Westminster, BC, CA
Full-time

A technology services firm in New Westminster is seeking a skilled Systems Administrator to enhance its IT department.The role requires supporting Microsoft 365 and cloud systems, ensuring security...Show more

 • Promoted

Expert SQL Server Administrator Position

Two CirclesVancouver, Metro Vancouver Regional District, CA
Full-time

Looking for a skilled SQL Database Administrator to optimize database environments.This role emphasizes SQL Server management and critical DevOps responsibilities to support dynamic operations.This...Show more

 • Promoted

Business Systems Analyst

Township of Muskoka LakesDelta, Metro Vancouver Regional District, CA
Full-time

The City of Delta’s Information Services Division is seeking a skilled Business Systems Analyst (SharePoint Administrator) to lead the administration, governance, and development of its SharePoint ...Show more

 • Promoted

Senior Systems Architect, Enterprise Cloud & Tools

Veeva SystemsVancouver, Metro Vancouver Regional District, CA
Full-time

A leading life sciences cloud company based in Toronto is seeking a Systems Architect to support engineering and product teams.The role involves providing strategic planning and hands-on execution ...Show more