Intermediate Database Administrator

Trimac Transportation System; Calgary; Hybrid; CAD 75,000 - 90,000; Full time

Job summary

A leading transportation company in Calgary is seeking an Intermediate Database Administrator to join their IT team. The role involves the administration and maintenance of SQL Server databases, supporting various platforms, and ensuring optimal performance and security. Candidates should have a strong foundation in SQL technologies and experience with data integration and reporting tasks. The company offers a hybrid work model, comprehensive benefits, and a commitment to employee growth.

Benefits

Medical, Dental, Vision, Life Insurance

Paid vacation, sick time, and company holidays

Paid time off for volunteer activities

Pension Plan

Tuition Reimbursement Program

Continuous learning and career development

Qualifications

• 3–5 years of experience as a Database Administrator in a SQL Server environment.
• Hands-on experience with SSIS, SSRS, and SSAS.

Responsibilities

• Administer, monitor, and maintain SQL Server databases.
• Support backup and recovery procedures, database replication, and access management.
• Document database configurations and best practices.

Skills

Analytical

Problem-Solving

Communication

Education

Diploma or degree in Computer Science

Tools

SQL Server

SSIS

SSRS

SSAS

Snowflake

MongoDB

MySQL

AWS

Job description

Trimac isn't just a transportation company; it's an industry disruptor with a remarkable 80-year legacy of safely delivering products that improve people’s lives across North America.

Our workplace culture is centered on being safe, respectful, innovative and inclusive. We are committed to maintaining a rewarding work environment that allows employees to experience new opportunities and build their chosen careers. Across the company, we encourage open communication, champion integrity, celebrate individuality and cultivate diverse talents and perspectives. If you’re ready for a challenge that will help drive forward an industry leading team, we invite you to begin your journey with us.

Schedule

• Full-time, 40-hour work week (Monday to Friday).
• Hybrid work model – minimum of 3 days / week onsite at our Calgary Head Office :
• On-call support will required as part of a rotational schedule

We are currently seeking an Intermediate Database Administrator (DBA) to join our growing IT team. This role will focus on the administration, maintenance, and performance of our SQL Server databases and support other platforms such as Snowflake, MySQL and MongoDB. The ideal candidate is a detail-oriented professional with solid experience in database environments and a strong foundation in SQL Server technologies, particularly SSIS, SSRS, and SSAS.

Responsibilities

• Administer, monitor, and maintain SQL Server databases to ensure optimal performance, availability, and security.
• Support backup and recovery procedures, database replication, and access management.
• Assist in the implementation of database strategies to support resilient and efficient operations.
• Perform regular performance tuning and troubleshooting to resolve issues proactively.
• Support SSIS, SSRS, and SSAS environments for data integration and reporting tasks.
• Work closely with development, operations, and analytics teams to meet data needs.
• Document database configurations, processes, and best practices.
• Participate in projects related to database upgrades, migrations, and cloud adoption.
• Contribute to the maturation of data administration practices in the AWS cloud environments
• Stay informed on industry trends and database technology developments.

Qualifications

• Diploma or degree in Computer Science, Information Technology, or a related field.
• 3–5 years of experience as a Database Administrator in a SQL Server environment.
• Solid experience with SQL Server, including performance tuning and backup / recovery.
• Hands-on experience with SSIS, SSRS, and SSAS.
• Familiarity with database replication techniques.
• Experience with Snowflake, MongoDB, and MySQL is an asset.
• Basic understanding of cloud-based database solutions (AWS preferred).
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal abilities.
• Ability to work both independently and collaboratively in a fast-paced environment.
• Microsoft or AWS database certifications are considered a plus.

We invest in our employee’s growth through training and development programs. We offer a comprehensive benefits package such as :

• Medical, Dental, Vision, Life Insurance, and many more health and wellness benefits
• Paid vacation, sick time, and company holidays
• Paid time off for volunteer activities to help give back to our communities
• Pension Plan
• Tuition Reimbursement Program to achieve your educational goals
• Continuous learning and career development

Safety Commitments

• We make safety a part of every decision
• We make safety personal
• We have the courage to intervene

J-18808-Ljbffr

Create a job alert for this search