Microsoft SQL Database Administrator (12 Month Contract)

In 1985, Ed McNally founded Big Rock Brewery Inc. (“Big Rock”) to contest the time's beer trends. Three bold, European-inspired offerings forged an industry at a time heavy on easy drinking lagers and light on flavour.

Today, our extensive portfolio of signature beers, ongoing seasonal offerings, ciders (Rock Creek Cider® series) and custom-crafted private label products keep us at the forefront of the craft beer revolution and still proudly contesting the beer trends of today.

Summary

This role is a 12 month contract, onsite 5 days a week.

Love solving complex technical challenges and making systems run like a well-crafted brew? Join our team as a Database Administrator (Microsoft SQL Server) and put your technical expertise to work in a fun, collaborative brewery environment.

You'll be responsible for keeping our Microsoft SQL Server databases secure, reliable, and performing at their best while supporting business-critical applications, reporting solutions, and data-driven decision-making. You'll also play an important role in developing and maintaining enterprise reporting solutions, including SSRS reports and Power BI dashboards that help teams make informed business decisions.

Working alongside passionate colleagues and partnering with both internal teams and external clients, you'll have the opportunity to tackle interesting IT challenges, optimize systems, and make a meaningful impact—all while being part of a culture that values innovation, teamwork, and enjoying what we do.

Responsibilities

• Administer, monitor, and maintain Microsoft SQL Server databases.
• Ensure database performance, availability, and security through regular monitoring and maintenance.
• Perform database tuning, backup, restoration, and support disaster recovery business continuity planning.
• Troubleshoot and resolve database issues, including performance bottlenecks and system outages.
• Optimize database performance through indexing, query tuning, and routine maintenance activities.
• Manage database security, user access, and permissions.
• Support software deployments, upgrades, database migrations, and system enhancements.
• Develop, maintain, and optimize SQL queries, stored procedures, and database objects.
• Develop, maintain, and optimize core reporting solutions using SQL Server Reporting Services (SSRS), Power BI Report Server (PBIRS ) and Report Builder .
• Design, build, and maintain interactive Power BI dashboards and self-service business intelligence solutions using optimized SQL data sources.
• Collaborate with internal and external stakeholders to gather reporting requirements and deliver scalable reporting and dashboard solutions.
• Support reporting solutions, including SSRS, PBIRS, Crystal Reports, and ERP reporting requirements.
• Communicate directly with external clients to troubleshoot issues, gather requirements, provide technical support, and deliver database-related solutions.
• Develop and maintain database documentation, reporting procedures, and technical standards.
• Participate in system maintenance activities and provide support for critical database incidents as required.

Qualifications

• Minimum two-year post-secondary diploma in Computer Science, Information Technology, or a related discipline, or an equivalent combination of education and relevant experience.
• Experience administering Microsoft SQL Server databases in a production environment.
• Strong knowledge of Microsoft SQL Server, SQL Server Management Studio (SSMS), and Transact-SQL (T-SQL).
• Experience with database backup and recovery, performance tuning, best practices, and security management.
• Experience designing, developing, and maintaining reports using SQL Server Reporting Services (SSRS), Power BI Report Server (PBIRS) , and Report Builder .
• Experience developing interactive dashboards and visualizations using Power BI .
• Experience communicating with external clients or customers to provide technical support and resolve issues.
• Knowledge of ETL (Extract, Transform, Load) concepts, data transformation, and data integration best practices.
• Knowledge of high availability and disaster recovery solutions is considered an asset.
• Experience with Microsoft Windows Server and Azure MS SQL PaaS environments.
• Familiarity with PowerShell or other scripting languages is considered an asset.
• Experience with SAP Business One (SAP B1) and Crystal Reports is considered an asset.
• Strong analytical, troubleshooting, organizational, and problem-solving skills.
• Excellent verbal and written communication skills with the ability to build positive relationships with both internal and external stakeholders.

Perks & Benefits

• 100% employer-paid comprehensive Health & Dental benefits
• Company TFSA program
• $600 annual Beer Spending Account
• Birthday off with pay
• AwardCo employee recognition & reward program
• Perkopolis membership
• 30% discount on GoodLife Fitness memberships (no enrollment fee)
• Annual safety boot allowance (eligible positions)
• Free on-site parking
• Casual dress code
• Employee discounts at our brewery restaurant
• Access to our on-site employee taproom
• Community gardens at our Calgary brewery
• Weekly Beer O'Clock socials
• Employee-centric culture with regular social events and team celebrations
• Opportunities for professional growth and career development