198 Sql jobs in Canada

Job Description

Salary:

SQL Developer

We are currently building our roster of experienced and reliable subcontractors to support upcoming projects. If you take pride in your work, deliver on time, and value professionalism, wed love to hear from you.

An SQL Developerdesigns, develops, implements, and maintains database systems, ensuring data integrity and efficient retrieval.They use SQL to create and modify tables, write queries, and optimize system performance.Responsibilities include creating database schemas, writing and testing SQL code, and troubleshooting database issues.

Key Responsibilities:

• Database Design and Development:

Create and maintain database structures, including tables, stored procedures, views, and functions.

• SQL Querying and Optimization:

Write, analyze, and optimize SQL queries to retrieve data and enhance system performance.

• Data Integrity and Security:

Ensure data accuracy, consistency, and security within the database system.

• Troubleshooting and Maintenance:

Diagnose and resolve database issues, including performance bottlenecks and security vulnerabilities.

• Collaboration:

Work with other developers, project managers, and stakeholders to understand requirements and implement solutions.

• Documentation:

Document database schemas, procedures, and queries for future reference.

Skills and Knowledge:

• SQL Fundamentals:Strong understanding of SQL syntax, data types, and database operations.
• Database Modeling:Ability to design and implement relational database schemas.
• Programming Languages:Familiarity with programming languages used for database interaction (e.g., T-SQL).
• Database Optimization:Knowledge of indexing, querying techniques, and other performance optimization strategies.
• Data Management:Understanding of data warehousing, data modeling, and data integrity.
• Software Engineering:Familiarity with software development methodologies and best practices.

What We Offer:

Opportunities for ongoing work

Professional collaboration and support

Timely payments and clear expectations

Note:

This is a proactive posting to identify and connect with top talent ahead of scheduled projects.

Only qualified candidates will be contacted.

Thanks for your interest to partner with our organization.

Job Description

Challenger Motor Freight Inc. is an equal opportunity employer committed to creating a diverse and inclusive workplace. We strongly encourage applications from all qualified candidates, including women, members of visible minorities, persons with disabilities, and aboriginal peoples. If you require any accommodations at any stage of the recruitment process, please don’t hesitate to reach out to us at We are dedicated to ensuring an accessible and supportive experience for every applicant.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 SQL Server Database Developer is responsible for developing solutions in our SQL environment to support our business applications and BI Reporting platforms. You will have a strong understanding of business concepts with working knowledge in key technical tools. This position works within a team that has an impact on all divisions in the company and there is room for growth.

The individual will place a high emphasis on process improvement and logical problem-solving, using in-depth analysis of the problem statement and working diligently to build out robust reporting solutions. Furthermore, the candidate will have excellent analytical skills, an ability to summarize data in a simple manner and a desire to work closely in cross-functional teams.

The chosen candidate will be a critical thinker with the ability to work independently to complete a wide range of analysis while also being able to work in a team to collaborate and support on a wide variety of profit-related initiatives.

• 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
• Comprehensive total rewards package including company paid group benefits and individual RRSP
• Support of professional memberships and certifications

SQL Server Database Development (90%)

• Develop, test, and maintain SQL Server stored procedures, functions, tables, views, and triggers relating to vendor supported applications and custom written .NET applications.
• Create, maintain, and deploy reports in SSRS, PowerBI and vendor reporting solution.
• Champion the automation processes to create workflows with SSIS in order to manage the data warehouse.
• Automate processes and create workflows with SSIS.
• Use SSAS to design Dimensions, Measures, and Roles.
• Write complex SQL queries, functions, and triggers.
• Implement improvement modifications to complex and verbose stored procedures.
• Identify KPI’s required and add them to dashboards such as PowerBI / Analyzer.
• Use knowledge of SSRS and report design to create and deploy reports.
• Analyze and implement solutions to optimize slow performing queries or procedures.
• Provide support for on-demand data requests from user groups.
• Participate in team meetings to gather requirements and develop BI solutions suited to business needs.
• Provide data management support to .NET development team.
• Maintain documentation on system and process flow modifications.
• Perform after hours support and system upgrades when necessary ensuring critical
• systems/functions are operational.
• Performs other duties as required.

Process Improvement and Implementation – 10%

• Apply process improvement methodologies to process improvement initiatives, with an emphasis on AI and Machine Learning techniques
• Prepare process recommendation documents including presentations, process models, supporting metrics, business requirements and related impact analysis.
• Assist in the implementation of new processes with necessary stakeholders. This may include but is not limited to documenting all new processes, creating measurable goals for success, training end users, acting as point of contact for troubleshooting and ongoing process management.

• Focuses on continuous skill development and learning in following areas:
  • • SQL
    • SSIS
    • SSRS
    • Python Coding
    • R Script
    • Machine Learning
    • Data Management
    • Process Mining
    • Process Standardization
    • Six Sigma Practices
    • Low Code Development Application (Knime, Alteryx, others)
    • Change management
    • Project management
• Performs other duties as required

• Diploma/Degree in Computer Science or equivalent professional experience.
• Five years of experience developing and supporting in SQL Server environment.
• Experience with SSIS Package management
• Experience with Microsoft Power BI
• Proficiency in system analysis and design.
• Experience maintaining complex SQL queries, stored procedures, functions, and triggers.
• Proficient in Microsoft SQL 2008+, with a solid understanding of SQL permissions to maintain high level of data security.
• Experience with Low Code Development applications such as Alteryx or Knime an asset.

• Strong interpersonal and learning skills
• Able to be resourceful and seek out answers via learning forums and Google
• Able to leverage ChatGPT and similar and intelligently and safely
• Highly developed written and verbal communication skills, with the potential interest to prepare and deliver presentations
• Manages expectations and uses conflict resolution to ensure a mutually beneficial outcome for all stakeholders wherever possible
• Ability to apply critical thinking and problem solving
• Ability to translate client requirements or Use cases to actual working solutions
• Strong attention to detail
• Time management skills: ability to prioritize and comfortable in handling competing priorities
• Able to collaborate with a variety of stakeholders and work effectively with multiple departments, while also working independently at times to solve problems with ambiguous solutions
• Ability to influence various decision-making groups to form a consensus on direction
• Strong analytical skills and the ability to create detailed and accurate reports and metrics
• High level of accountability due to the nature of financial and operational analysis which is required for this role
• Resilient and able to manage change and measure performance of changes
• Proactive attitude, takes initiative to prevent issues, and has a bias towards action
• Well-organized, enthusiastic, professional and a positive team member
• A continuous improvement-focus on work

Powered by JazzHR

QsJSAyg01g

Job Description

TEHORA est présentement à la recherche d’un(e) Analyste-Programmeur SQL/PL-SQL ayant d’excellentes aptitudes techniques, d’excellentes connaissances et qui souhaite mettre à profit ses compétences au sein d’une équipe polyvalente.

Sans être exhaustifs, voici les services et livrables que devra fournir la personne retenue.

Description des travaux ou des biens livrables :

• Analyser les demandes de modification aux écrans, rapports et autres traitements du système;

• Effectuer tous les travaux de programmation en Oracle, les modifications/améliorations aux systèmes;
• Développer les stratégies et scénarios de tests, réaliser les essais unitaires, intégrés, et d’acceptation (en support aux utilisateurs);
• Améliorer la performance de certaines requêtes et/ou transactions Oracle;
• Corriger toute anomalie ou vice de fonctionnement des systèmes d’information du MSP, à la suite des essais ou pendant la période de rodage (post-implantation);
• Rédiger ou mettre à jour les dossiers fonctionnels et techniques associés à la composante informatique (outil de gestion de données ou de bases de données);
• Soutenir les administrateurs de bases de données (DBA) et les équipes de développement dans l’utilisation des outils;
• Participer à des activités de conversion de données et de simulation de mise en production;
• Effectuer le transfert de connaissances vers les ressources désignées;

Activités administratives

• Saisir le temps travaillé dans l’outil de gestion de projets;
• Fournir un état d’avancement des livrables qui lui sont confiés, selon les délais convenus avec la DGTI, au chef de projet;
• Préparer les documents nécessaires aux différentes rencontres;
• Participer aux rencontres de suivi d’équipe ou de projets ainsi qu’aux comités directeurs sur invitation.

Biens livrables à produire

• Documentation des modifications/améliorations aux systèmes;
• Livrables de projet (programmes, écrans, rapports, interfaces, etc.);
• Document de support(manuel de maintenance, manuel utilisateur, plan de récupération en cas de sinistre, etc.);
• Tout document sous-jacent aux responsabilités précédentes.

Requirements

• Détenir un baccalauréat dans le domaine des technologies de l’information (informatique, génie logiciel ou en système d’information) ou l’équivalent dans un domaine connexe. L’absence de diplôme peut être compensée par six (6) années d’expérience additionnelles en technologies de l’information.
• Posséder au moins cinq (5) années d’expérience en technologies de l’information dont au moins trois (3) ans en développement de systèmes sous Oracle;

Avoir réalisé des mandats avec l’utilisation d’au moins un (1) des outils de développement suivants:

• Oracle Developer 6i;

• Forms et reports Oracle 10 g ou 11 g;

• PL/SQL

• Avoir une expérience d’au moins six (6) mois en entretien ou développement de bases de données avec Microsoft Access, version 97 et plus.

Compétences représentant un atout

• Avoir une certification Oracle;
• Avoir de l’expérience en méthodologie de développement (Macroscope);

• Avoir réalisé des mandats utilisant les produits Axway XFB (Axway File
• Broker) et ADF d’Oracle (Faces et Business Components);
• Avoir participé à au moins un projet de développement de système d’information en mode Agile;
• Avoir réalisé un mandat d’au moins 6 mois dans une organisation gouvernementale ou paragouvernementale.

Benefits

• Du télétravail et de la flexibilité pour s’adapter à vos obligations familiales;
• Une culture entrepreneuriale favorisant la créativité et l'innovation;
• Horaires flexibles (selon le type de contrat de travail);
• Congés en cas de maladie et à l'occasion d'événements familiaux;
• Outils informatiques adaptés;
• Espace de travail épanouissant et motivant;
• Initiatives sociales et environnementales;
• Programme d’apprentissage en milieu de travail;
• Cheminement de carrière.

SALAIRE

Le salaire sera calculé sur la base du taux horaire moyen correspondant à votre profil.

LIEU DE TRAVAIL

Le lieu de travail sera déterminé selon le mandat, il peut être en télé travail ou chez le client.

POURQUOI SE JOINDRE À TEHORA ?

TEHORA est une firme québécoise multidisciplinaire reconnue pour l'excellence de ses services professionnels, de nature technique et de gestion de projets à l'échelle nationale et internationale. Notre mission est d'accompagner nos clients dans la concrétisation de leurs projets par l'excellence de notre savoir-faire et de notre créativité.

Depuis sa création en 2017, notre équipe de professionnels connait une croissance exponentielle en répondant aux besoins importants en gestion de projets multidisciplinaires, dans le domaine des transports, du génie civil, du TI et plus.

Nos collaborateurs travaillent sur des mandats aussi bien à l’interne que chez des clients d’envergures.

TEHORA se distingue par sa culture d’entreprise, axée sur le bonheur de ses employés et la diversité.

Chez TEHORA, chaque collaborateur est un membre important de l'équipe qui contribue à notre succès collectif. Nos membres ont la flexibilité requise pour avoir un équilibre entre le travail et leur vie privée, tout en menant une carrière enrichissante.

Nous offrons un environnement de travail motivant. La diversité des projets, la grande autonomie et l’interaction directe avec les clients sont appréciées. Une telle proximité est possible en raison de notre structure organisationnelle horizontale, qui se traduit par des relations de confiance et une communication efficace entre notre équipe et les clients.

Job Description

We are looking for an experienced SQL Developer for our client. This is a permanent position, remote! Our client is a large fintech firm with a product that you've likely used many times before.
You'll have the opportunity to work on an extremely large, internationally used payment platform. Your role will encompass managing, building, planning administrating and maintaining infrastructure services like Systems, Containers, Servers, Data Centers and Storage to ensure our client has a robust, scalable and stable infrastructure.

You Have:

• 7+ years experience working with MS - SQL data development
• Strong experience with SSRS and Stored Procedures
• Experience with visualization tools like Power BI and Tableau
• Experience working in a cloud environment (ideally Azure )
• Bonus points if you have experience with Python and Pyspark
• A B.Sc. or equivalent work experience required.

Some AWESOME selling points:

• Remote + flexible work schedule
• Competitive salary + Extended Health and Dental Benefits
• Amazing opportunity for career progression to lead
• Amazing mentorship (seriously)
• Plenty of vacay

It's a seriously awesome opportunity! If this looks interesting to you, please click the link and apply.

** Unfortunately we are only able to consider candidates who either live in Canada, or currently have an active Canadian work visa or citizenship for this role.

Job Description

We are looking for an experienced SQL Developer for our client. This is a permanent position, remote! Our client is a large fintech firm with a product that you've likely used many times before.
You'll have the opportunity to work on an extremely large, internationally used payment platform. Your role will encompass managing, building, planning administrating and maintaining infrastructure services like Systems, Containers, Servers, Data Centers and Storage to ensure our client has a robust, scalable and stable infrastructure.

You Have:

• 7+ years experience working with MS - SQL data development
• Strong experience with SSRS and Stored Procedures
• Experience with visualization tools like Power BI and Tableau
• Experience working in a cloud environment (ideally Azure )
• Bonus points if you have experience with Python and Pyspark
• A B.Sc. or equivalent work experience required.

Some AWESOME selling points:

• Remote + flexible work schedule
• Competitive salary + Extended Health and Dental Benefits
• Amazing opportunity for career progression to lead
• Amazing mentorship (seriously)
• Plenty of vacay

It's a seriously awesome opportunity! If this looks interesting to you, please click the link and apply.

** Unfortunately we are only able to consider candidates who either live in Canada, or currently have an active Canadian work visa or citizenship for this role.

Job Description

We are looking for an experienced SQL Developer for our client. This is a permanent position, remote! Our client is a large fintech firm with a product that you've likely used many times before.
You'll have the opportunity to work on an extremely large, internationally used payment platform. Your role will encompass managing, building, planning administrating and maintaining infrastructure services like Systems, Containers, Servers, Data Centers and Storage to ensure our client has a robust, scalable and stable infrastructure.

You Have:

• 7+ years experience working with MS - SQL data development
• Strong experience with SSRS and Stored Procedures
• Experience with visualization tools like Power BI and Tableau
• Experience working in a cloud environment (ideally Azure )
• Bonus points if you have experience with Python and Pyspark
• A B.Sc. or equivalent work experience required.

Some AWESOME selling points:

• Remote + flexible work schedule
• Competitive salary + Extended Health and Dental Benefits
• Amazing opportunity for career progression to lead
• Amazing mentorship (seriously)
• Plenty of vacay

It's a seriously awesome opportunity! If this looks interesting to you, please click the link and apply.

** Unfortunately we are only able to consider candidates who either live in Canada, or currently have an active Canadian work visa or citizenship for this role.

Job Description

We are looking for an experienced SQL Developer for our client. This is a permanent position, remote! Our client is a large fintech firm with a product that you've likely used many times before.
You'll have the opportunity to work on an extremely large, internationally used payment platform. Your role will encompass managing, building, planning administrating and maintaining infrastructure services like Systems, Containers, Servers, Data Centers and Storage to ensure our client has a robust, scalable and stable infrastructure.

You Have:

• 7+ years experience working with MS - SQL data development
• Strong experience with SSRS and Stored Procedures
• Experience with visualization tools like Power BI and Tableau
• Experience working in a cloud environment (ideally Azure )
• Bonus points if you have experience with Python and Pyspark
• A B.Sc. or equivalent work experience required.

Some AWESOME selling points:

• Remote + flexible work schedule
• Competitive salary + Extended Health and Dental Benefits
• Amazing opportunity for career progression to lead
• Amazing mentorship (seriously)
• Plenty of vacay

It's a seriously awesome opportunity! If this looks interesting to you, please click the link and apply.

** Unfortunately we are only able to consider candidates who either live in Canada, or currently have an active Canadian work visa or citizenship for this role.

Job Description

We are looking for an experienced SQL Developer for our client. This is a permanent position, remote! Our client is a large fintech firm with a product that you've likely used many times before.
You'll have the opportunity to work on an extremely large, internationally used payment platform. Your role will encompass managing, building, planning administrating and maintaining infrastructure services like Systems, Containers, Servers, Data Centers and Storage to ensure our client has a robust, scalable and stable infrastructure.

You Have:

• 7+ years experience working with MS - SQL data development
• Strong experience with SSRS and Stored Procedures
• Experience with visualization tools like Power BI and Tableau
• Experience working in a cloud environment (ideally Azure )
• Bonus points if you have experience with Python and Pyspark
• A B.Sc. or equivalent work experience required.

Some AWESOME selling points:

• Remote + flexible work schedule
• Competitive salary + Extended Health and Dental Benefits
• Amazing opportunity for career progression to lead
• Amazing mentorship (seriously)
• Plenty of vacay

It's a seriously awesome opportunity! If this looks interesting to you, please click the link and apply.

** Unfortunately we are only able to consider candidates who either live in Canada, or currently have an active Canadian work visa or citizenship for this role.

Job Description

We are looking for an experienced SQL Developer for our client. This is a permanent position, remote! Our client is a large fintech firm with a product that you've likely used many times before.
You'll have the opportunity to work on an extremely large, internationally used payment platform. Your role will encompass managing, building, planning administrating and maintaining infrastructure services like Systems, Containers, Servers, Data Centers and Storage to ensure our client has a robust, scalable and stable infrastructure.

You Have:

• 7+ years experience working with MS - SQL data development
• Strong experience with SSRS and Stored Procedures
• Experience with visualization tools like Power BI and Tableau
• Experience working in a cloud environment (ideally Azure )
• Bonus points if you have experience with Python and Pyspark
• A B.Sc. or equivalent work experience required.

Some AWESOME selling points:

• Remote + flexible work schedule
• Competitive salary + Extended Health and Dental Benefits
• Amazing opportunity for career progression to lead
• Amazing mentorship (seriously)
• Plenty of vacay

It's a seriously awesome opportunity! If this looks interesting to you, please click the link and apply.

** Unfortunately we are only able to consider candidates who either live in Canada, or currently have an active Canadian work visa or citizenship for this role.