Azure SQL Migration Specialist

2 weeks ago

Montréal, Canada Aylo Careers Full time

We are an international tech leader developing unparalleled technologies for high traffic and high volume online products which includes one of the top 10 biggest brands in the world.

Our Data Warehouse Team is looking for an Azure Data Engineer/SQL Developer. You will be working as part of a team within a dynamic, fun, challenging and creative environment (**Azure Cloud** & On-premise) in order to achieve team-oriented goals.

**What you'll be doing**:

- Building data migration solutions (including from on-premise to cloud), building pipelines, Managing physical database design and implementation
- Resolving complex issues involving: database performance, database capacity, resiliency, stability, replication, and other key aspects of distributed database technology.
- Researching and recommending solutions that best meet business needs and enterprise operational requirements
- Review, test, update and document detailed disaster recovery/business continuity plans for key production SQL Servers

**What you'll need to be successful**:
**Must Haves**:

- Experience with developing on Azure Cloud environment, minimum 4+ year, specifically with Azure SQL DB (or equivalent), Synapse, Data Factory (ADF), Blob Storage, Data Lake.
- Design and Develop **ETL/ELT pipeline processes**.
- Experience with Azure Dedicated and Serverless Spark pools
- Familiarize with basic self-integration runtime and Azure cloud networking
- Experience with developing on on-premise Microsoft SQL Server 2017 and above, minimum 4+ year
- Database, Tables, Pipelines Design, Database Management, Requirements Analysis, Teamwork, Presenting Technical Information, Training, Operating Systems.
- Excellent knowledge of T-SQL with minimum of 4+ years of experience
- Experience in writing Stored Procedures / Functions.
- Experience with SSIS, SSAS.
- Good knowledge of GIT
- Database, Tables, Pipelines Design, Database Management, Requirements Analysis, Teamwork, Presenting Technical Information, Training, Operating Systems.
- Ability to perform minor **DBA tasks**if needed (Indexing, Query Tuning, Manage Database security, etc.).
- Knowledge of indexes, index management, statistics, integrity checks, configuration, patching.
- Basic Knowledge of **HADR technologies (Replication, Log shipping, etc.) **is a plus**.**:

- Excellent communication skills in English

**Nice to Haves**:

- Strong analytical and problem solving skills.
- Share technical expertise with team and provide recommendations to implement design and code reviews.
- Self-motivated and able to work independently with mínimal supervision.
- Good communication skills in managing technical information with the team.

**As an equal opportunity employer, we celebrate diversity and are committed to creating an inclusive environment for all employees**

**In this role you may be exposed to adult content

  • IT Implementation Specialist

    3 days ago

    Montréal, Canada MSP Corp Full time

    **IT Implementation Specialist - Level 3**: Full Time; Hybrid position Groupe Access - Montréal, QC, CA As one of the leading Cyber Security and information technology (IT) services firms in Canada, we have an assortment of services to offer our varied clientele, large or small. This also means we are always looking for qualified & dynamic IT...

  • Administrateur de Bases de Données

    4 weeks ago

    Montréal, Canada Itergy Full time

    French description to follow - **Database administrator / DBA MS SQL Server** A Microsoft (MS) partner, Itergy has built an enviable reputation with its skills in the design, integration and management of MS architectures for large and very large enterprises, always according to industry best practices. Our strong Managed Services and Project Management...

  • Consultant Cloud Azure

    4 days ago

    Montréal, Canada Avanade Full time

    Description de poste Notre équipe d'infrastructure Azure joue un rôle essentiel dans ce que fait Avanade de mieux : la réalisation de projets exceptionnels et complexes ayant un impact mondial, ainsi que l'aide à la transformation des entreprises de nos clients grâce à l'innovation numérique. Nous sommes un groupe en pleine croissance, composé de...

  • IT Cloud Specialist

    4 weeks ago

    Montréal, Canada MAXON Computer Full time

    If you want to be a Maxonian and help bring the best 2D and 3D visual effects, motion graphics, gaming, AR/MR/VR, visualization and design software to the market, then we should have a chat. WHO WE ARE: Packed with brilliant, passionate people, Maxon is deeply rooted in the creative industry and committed to empowering the artistic community. We are...

  • Data Base Administrator

    1 week ago

    Montréal, Canada Explorance Full time

    Join a Montreal-based SaaS company that helps organizations around the world create a personalized journey of impact and fulfillment for their people. Explorance offers innovative Experience Management (XM) solutions because we believe that each experience matters. Will we be your next one?_ - To be an Explorer means to join one the #1 ranked workplace in...

  • Technicien Architecte Azure

    4 weeks ago

    Montréal, QC, Canada MSP Corp Full time

    Il y a plus de 30 jours Identifiant de la demande: 1033 Que vous soyez à la recherche d'un changement de carrière en TI, que vous soyez une entreprise ayant besoin de soutien en TI ou de personnel en TI, laissez Group Access Powered by MSP Corp . être votre prochaine étape vers le succès ! En tant que l'une des principales entreprises de...

  • Administrateur de Bases de Données

    4 weeks ago

    Montréal, Canada Itergy Full time

    French description to follow - **Database administrator / DBA** A Microsoft (MS) partner, Itergy has built an enviable reputation with its skills in the design, integration and management of MS architectures for large and very large enterprises, always according to industry best practices. Our strong Managed Services and Project Management teams support our...

  • Sdet

    7 days ago

    Montréal, Canada DiamondPick Full time

    **Job Title: SDET** **Location: Montreal, QC (onsite Hybrid)** **Skills Required**: - 8+ years of relevant professional experience as Software Developer Engineer in Test (SDET) Full Stack (FE + BE) automation developer with proficiency in designing, developing & implementing End to End automation frameworks - Expert in various automation tools &...

  • Architecte de solutions Azure Emplacement Montréal, Québec

    3 weeks ago

    Montréal, QC, Canada Victrix Full time

    Description : Coordonner les phases d’analyse, de développements et d’intégration des projets de migration de charge vers Azure en collaboration avec le responsable du client et le gestionnaire de projet. Tâches et responsabilités : Produire la documentation requise en appui aux stratégies, scénarios et mise en œuvre; Excellente connaissance...

  • Etl Talend Principal Consultant

    5 days ago

    Montréal, Canada Source Mantra Full time

    **Role: ETL TALEND Principal Consultant** **Location: Montreal, Canada - Onsite** **Duration: Full Time** **Visa Status: TN Visa - Citizen Of Canada** **Need 10+ Years of Experience/With Passport No & LinkedIn Mandatory - Full Time Role - Onsite** - **Minimum Qualification**:_ - Bachelor’s Degree in Computer Science or in “**STEM**” Majors...

  • Database Engineer

    4 weeks ago

    Montréal, QC, Canada Talent Toppers Full time

    We are urgently looking for “ Database Engineer ” for one of the fastest growing “Cloud Engineering Company”. Job Overview: Role: Database Engineer Experience: 8 - 12 Years Type: Permanent Work Mode: Remote Roles And Responsibilities: In this role as an experienced Database Engineer, you will have opportunity to work with our customers in...

  • Specialist Solution and System Integration

    4 weeks ago

    Montréal, Canada Canadian National Railway Full time

    At CN, we work together to move our company—and North America—forward. Be part of our Information & Technology (I&T) team, a critical piece of the engine that keeps us in motion. From enterprise architecture to operational technology, our teams use the agile methodology to automate and digitize our railroad ensuring our operations run optimally and...

  • Vmware Sme

    5 days ago

    Montréal, Canada Q1 Technologies Full time

    VMWare services, Microsoft Azure Cloud, Azure services, Integrations, Experience in Migration to Azure **Good-to-Have**: Proficiency in French Language, BFSI domain **Roles & Responsibilities**: 2 Lead technical discussions with senior customer executives that drive decisions and implementation approaches. 3 Review and manage technical requirements and...

  • Développeurs Oracle PL/SQL

    3 weeks ago

    Montréal, Canada CGI Full time

    Le projet de notre client a pour mission de protéger les vies humaines et de protéger les biens. À cette fin, il effectue un travail de prévention en informant la population. Nous sommes à la recherche d'une nouvelle ressource pour se joindre à ce projet. Vous êtes Développeur (se) Oracle PL/SQL, prenez part à ce projet et faites une différence !...

  • Développeurs Oracle PL/SQL

    3 weeks ago

    Montréal, Canada CGI Full time

    Le projet de notre client a pour mission de protéger les vies humaines et de protéger les biens. À cette fin, il effectue un travail de prévention en informant la population. Nous sommes à la recherche d'une nouvelle ressource pour se joindre à ce projet. Vous êtes Développeur (se) Oracle PL/SQL, prenez part à ce projet et faites une différence !...

  • Développeurs Oracle PL/SQL

    4 weeks ago

    Montréal, Canada CGI Full time

    Le projet de notre client a pour mission de protéger les vies humaines et de protéger les biens. À cette fin, il effectue un travail de prévention en informant la population. Nous sommes à la recherche d’une nouvelle ressource pour se joindre à ce projet. Vous êtes Développeur (se) Oracle PL/SQL, prenez part à ce projet et faites une différence !...

  • Développeurs Oracle PL/SQL

    3 weeks ago

    Montréal, Canada CGI Full time

    Le projet de notre client a pour mission de protéger les vies humaines et de protéger les biens. À cette fin, il effectue un travail de prévention en informant la population. Nous sommes à la recherche d’une nouvelle ressource pour se joindre à ce projet. Vous êtes Développeur (se) Oracle PL/SQL, prenez part à ce projet et faites une différence !...

  • Développeurs Oracle PL/SQL

    4 weeks ago

    Montréal, Canada CGI Full time

    Le projet de notre client a pour mission de protéger les vies humaines et de protéger les biens. À cette fin, il effectue un travail de prévention en informant la population. Nous sommes à la recherche d'une nouvelle ressource pour se joindre à ce projet. Vous êtes Développeur (se) Oracle PL/SQL, prenez part à ce projet et faites une différence !...

  • Développeurs Oracle PL/SQL

    4 weeks ago

    Montréal, Canada CGI Full time

    Le projet de notre client a pour mission de protéger les vies humaines et de protéger les biens. À cette fin, il effectue un travail de prévention en informant la population. Nous sommes à la recherche d’une nouvelle ressource pour se joindre à ce projet. Vous êtes Développeur (se) Oracle PL/SQL, prenez part à ce projet et faites une différence !...

  • Data Sphere Lab

    1 week ago

    Montréal, Canada McGill University Full time

    Please refer to the job aid for instructions on how to apply. Hiring Unit: - Desautels Faculty of Management_ - Position Summary - Job Description - As the help desk specialist, you will be responsible for: - Troubleshooting and debugging data issues and providing technical support to McGill Desautels students. - Understanding core needs of Instructor...