MS SQL Administrator; Senior Systems Analyst

Position: MS SQL Administrator (Senior Systems Analyst)

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 Power Shell, 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 Dev Ops 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 Solar Winds 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…