SQL Database Administrator
Challenger
Cambridge, ON, Canada
2d ago

Envision :

Working for a company dedicated to personal career growth and opportunity in moving the organization forward. Challenger Motor Freight Inc.

is a Platinum Club Member in Canada’s 50 Best Managed Companies. Our success is directly attributed to our dedicated and talented team of professionals who work hard together with a common purpose to keep us on the leading edge in safety, technology, and analysis.

It’s not by chance that Challenger is a leading North American freight transportation company. In 40 years, Challenger has grown from one person with a vision and a truck to an international transportation and supply chain management company.

We win as a team when we work as a team, and succeed when our employees succeed. We want people who are resilient, team-oriented, and driven because we are laser focused on meeting commitments to our People, Customer, and Profit.

If you’re looking to work for a dynamic, fast-paced, progressive organization then apply with us.

We offer the following in our search for engaged employees looking to become part of a successful team :

  • A continuous learning environment that develops your individual career goals
  • A continuous improvement environment where all ideas are explored
  • Engaged coaches and mentors who will provide guidance but also allow autonomy
  • Team atmosphere
  • Competitive and comprehensive total rewards package including company paid group benefits and company sponsored retirement savings plan
  • Support of professional memberships and certifications
  • Standard office hours; Monday to Friday from approximately 8 : 00am to 5 : 00pm
  • The Opportunity :

    The SQL Database Administrator is responsible for planning, designing, installing, migrating, monitoring, backing up and recovering data for the SQL server infrastructure.

    This role is also responsible for designing, creating, validating, and deploying reports and analytical cubes from the business intelligent systems.

    Key Accountabilities :

  • Be a thought leader on data infrastructure to drive business outcomes.
  • Maintain, install, administer, and update various SQL server instances.
  • Architect, maintain, and update SQL Reporting Services Reports (SSRS), SQL Integration Services (SSIS) and SQL Analysis Services (SSAS).
  • Pioneer the emphasis on focusing on the voice of the customer’ and building a culture of user-centric thinking.
  • Support a culture of agile development, applying agile tools, principles, and mindset.
  • Research and develop new data integration and reporting technologies.
  • Monitor and optimize SQL server and database performance.
  • Pilot solutions adopted by the company and integrate them into the current environment.
  • Prioritize work according to company requirements of balancing self-directed project work and time sensitive end-user requests.
  • Provide data management support to development teams and provide support for on-demand data requests from user groups.
  • Administer, configure, and use tools for backing up and restoring databases to ensure business continuity.
  • Maintain database permissions ensuring a high level of system security.
  • Schedule and apply approved Windows and SQL security patches.
  • Work with business owners to plan, schedule and execute SQL Server upgrades and SQL based business application upgrades.
  • Monitor and maintain nightly data warehouse ETL packages.
  • Create documentation including architecture design, upgrade plans, database migration plans, test strategies.
  • Perform after hours support and system upgrades when necessary, ensuring critical systems / functions are operational.
  • Performs other duties as required.
  • What You Need To Be Successful In This Role :

  • Post-secondary education in Computer Science, Computer Engineering or related field
  • 3-5 years of relevant working experience is required
  • Advanced technical knowledge of MS SQL Server (including SSRS, SSIS, SSDT / BIDS), and MS Visual Studio
  • VBA Excel programming and / or .NET experience is an asset
  • Experience with MS SQL SSAS environment is an asset
  • Experience with cloud technologies like Azure is an asset
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form