Job Description
An iconic Canadian company with over 100 years of helping companies grow and succeed in Canada, we provide national dedicated fleet solutions, general freight services, managed transportation, fulfillment & distribution, and home delivery. With a national network of terminals, cross-docks, and distribution centers, we are one of Canada’s largest and most trusted supply chain service providers. Driven to exceed customer expectations, and supported by technology and innovation, we bring simplicity to complex logistics challenges. We work with intelligent and focused leaders who are driven to create an outstanding customer experience in partnership with Canadian leading brands. Canada Cartage is deep rooted in family values with an entrepreneurial culture where ideas are welcomed, growth is fostered and high performance is championed. A recognized thought leader and founded in 1914, Canada Cartage dominates the industry by delivering innovative fleet solutions. Position Summary The role is to provide administration and support to Microsoft SQL databases, including production, development, testing, and staging, for enterprise and in-house applications at Canada Cartage. Core systems include Transportation Management System, Fleet Management System, Document Management System, Telematics Management System, Radius Portal, Great Plains, and others. Schedule: Monday to Friday. 40 hours. Afterhours when req. What you will do Monitor performance and manage parameters to provide optimal response time to front-end users Manage the execution and completion of back-end jobs and services on production servers Manage the replication of data from source databases to replicated destinations to ensure data availability for business reporting Work closely with the Infrastructure Team to ensure database backup completion Troubleshoot database errors and perform root cause analysis to determine the cause of issues and either fix or provide recommendations toward solutions Monitor and document security and compliance threats that may affect the production databases, such as unauthorized access, data loss, and long-running queries Support the Infrastructure team in server patch update and projects as required Produce reports on database usage, volume growth, and query execution time When assigned, provide support to the development team in database design, query optimization, and production deployment. When assigned, develop queries and stored procedures for applications to interact with databases. What You’ll Bring 3 years Along with the following Skills & Competencies: Azure Data Warehouse and SQL as Managed Service BizTalk SSIS Excellent troubleshooting, analytical, and problem-solving skills Good communication skills (written, verbal, and listening) Hands-on experience with database administration, data manipulation languages, and core principles of database design MS-SQL Power BI, SSRS QL Server databases, preferably in Quest Spotlight SQL Server database backup, recovery, log shipping, and transactional replication Why people love working for Canada Cartage Cohesive team and a positive, hard-working atmosphere. Meaningful opportunities for career growth. Company wide recognition initiatives designed to recognize employees when they demonstrate outstanding customer service, teamwork and our core values. Perks - discounted hotels, car rentals, entertainment, gym memberships, phone plans, electronics, to name a few Fun events throughout the year, like summer barbeques and driver-appreciation week that regularly bring us together. We give back to the communities in which we operate by volunteering and donating to local charities. We are a strong company that weathers the storm through pandemics and recessionary periods, so that we can benefit from good economic environments. We are a top employer! Canada Cartage has been recognized on the Forbes list of Canada’s Best Employers for six straight years in a row. Trucking HR has announced that Canada Cartage has again been selected for the 8th year in a row, as one of Canada’s Top Fleet Employers. In addition, we have been recognized as an Employer of Distinction for the 4th year in a row. This serves to reinforce Canada Cartage’s reputation as an employer of high quality. We’ve been acknowledged by Forbes 2023, as one of Canada’s Best Employers for Diversity Come work with an industry leader! Canada Cartage is committed to adhering to the objectives and requirements outlined in the Accessible Canada Act (ACA). We are determined in meeting the accessibility needs of persons with disabilities in a timely manner, through the implementation of the requirements of the ACA and its applicable regulations. If you require accommodation under the ACA at any point in your application or employment duration, please let us know. We would like to thank all those expressing an interest in this position; however only the candidates selected for an interview will be contacted. Before you start with us, we will conduct a criminal record check, verify your education, and check your references.Committed to employment equity, Canada Cartage Systems LP encourages applications from Aboriginal people, members of visible minority groups, and women. Postuler/Apply Now #J-18808-Ljbffr