Database Migration Expert

6 days ago


Old Toronto, Ontario, Canada Momentum Financial Services Group Full time
Job Description

Momentum Financial Services Group is a leading provider of financial services in North America, committed to delivering innovative solutions to meet the evolving needs of consumers and business owners.

We are seeking a seasoned Database Migration Expert with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to join our dynamic team and contribute to the success of our cloud-based data initiatives.

Key Responsibilities:

  • Lead the migration of SQL Server databases to different platforms like PostgreSQL, MongoDB, and MySQL, ensuring smooth data transfer and compatibility.
  • Develop migration plans and strategies, minimizing downtime and ensuring data integrity during the process.
  • Collaborate with teams to analyze data dependencies, identify challenges, and implement solutions for compatibility issues and performance optimization.
  • Set up data replication and synchronization between SQL Server and other databases for real-time integration and consistency.
  • Design and implement data transformation pipelines using Azure Data Factory (ADF) and other ETL tools to map, convert, and validate data across platforms.
  • Conduct thorough testing to ensure accuracy and completeness of migrated data, addressing any quality issues.
  • Provide support and guidance to teams throughout the migration process, troubleshooting and resolving issues as needed.
  • Install, configure, and build SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), and SSRS (SQL Server Reporting Services) as needed for data migration and reporting purposes.
  • Implement complex SQL Always On configurations, including multi-subnet deployments from on-premises to cloud environments, and configure chained merge and transactional replication on top of SQL Always On for advanced data synchronization.
  • Document migration procedures and train teams to ensure ongoing support and maintenance.
  • Stay updated on database migration trends and technologies, recommending improvements to enhance efficiency.
  • Ensure compliance with data security and regulatory requirements throughout the migration.
  • Utilize.NET and PowerShell skills for scripting and automation tasks related to database migration and administration.

Requirements:

  • Bachelor's degree in Computer Science or related field.
  • 15+ years of experience in database administration and migration, with expertise in SQL Server and other platforms.
  • Extensive hands-on experience with Microsoft SQL Server, PostgreSQL, MongoDB, and MySQL, including installation, configuration, and administration, with proficiency in advanced SQL features like PolyBase for seamless data integration.
  • Familiarity with cloud platforms such as Azure or AWS and experience with cloud-based database migration services is desirable.
  • Knowledge of.NET for scripting and automation tasks.
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration skills.
  • Microsoft certifications, such as MCSE: Data Management and Analytics, Azure Administrator Associate, or Azure Solutions Architect Expert, are a plus.


  • Toronto, Ontario, Canada Cockroach Labs Full time

    About the RoleCockroach Labs is seeking a highly skilled Senior Software Engineer to lead the critical initiative of creating an effortless, seamless customer journey from other database solutions to CockroachDB and our cloud offerings.Key ResponsibilitiesContribute to the growth of CockroachDB by bringing expertise and commitment to excellence to help build...


  • Toronto, Ontario, Canada Cockroach Labs Full time

    About the RoleCockroach Labs is seeking a highly skilled Senior Software Engineer to lead the critical initiative of creating an effortless, seamless customer journey from other database solutions to CockroachDB and our cloud offerings.Key ResponsibilitiesContribute to the growth of CockroachDB by bringing expertise and commitment to excellence to help build...


  • Old Toronto, Ontario, Canada Cockroach Labs Full time

    About the RoleCockroach Labs is a leading provider of cloud-native, distributed SQL databases, and we're seeking a seasoned software engineer to join our team. As a Senior Software Engineer - Database Migration Tooling, you will play a critical role in creating an effortless, seamless customer journey from other database solutions to CockroachDB and our...


  • Old Toronto, Ontario, Canada Cockroach Labs Full time

    About the RoleCockroach Labs is a leading provider of cloud-native, distributed SQL databases, and we're seeking a seasoned software engineer to join our team. As a Senior Software Engineer - Database Migration Tooling, you will play a critical role in creating an effortless, seamless customer journey from other database solutions to CockroachDB and our...


  • Old Toronto, Ontario, Canada S I Systems Full time

    Job DescriptionJob Title: Senior Oracle Database Administrator for Large-Scale Database Upgrade ProjectJob Summary:We are seeking an experienced Senior Oracle Database Administrator to provide support on a large-scale database upgrade project from versions 12c to 19c using RAC and ASM for one of our major banking clients.Key Responsibilities:Provide on-going...


  • Old Toronto, Ontario, Canada Amazon Full time

    About the RoleWe are seeking a highly skilled Database Solutions Architect to join our team at Amazon. As a key member of our Cloud Database team, you will be responsible for designing and implementing scalable and secure database solutions for our customers.Key ResponsibilitiesThought Leadership - Develop and maintain expertise in Amazon Web Services (AWS)...


  • Old Toronto, Ontario, Canada Amazon Full time

    About the RoleWe are seeking a highly skilled Database Solutions Architect to join our team at Amazon. As a key member of our Cloud Database team, you will be responsible for designing and implementing scalable and secure database solutions for our customers.Key ResponsibilitiesThought Leadership - Develop and maintain expertise in Amazon Web Services (AWS)...


  • Toronto, Ontario, Canada VDart Inc Full time

    About the RoleWe are seeking a highly skilled Senior ETL Developer to join our team at VDart Inc. as a Data Migration Expert. In this role, you will be responsible for designing, developing, and implementing ETL solutions for data conversion and migration.Key ResponsibilitiesDevelop and implement ETL processes for data migration and conversionDesign and...


  • Toronto, Ontario, Canada VDart Inc Full time

    About the RoleWe are seeking a highly skilled Senior ETL Developer to join our team at VDart Inc. as a Data Migration Expert. In this role, you will be responsible for designing, developing, and implementing ETL solutions for data conversion and migration.Key ResponsibilitiesDevelop and implement ETL processes for data migration and conversionDesign and...


  • Toronto, Ontario, Canada VDart Inc Full time

    About the RoleWe are seeking a highly skilled Senior ETL Developer to join our team at VDart Inc. as a Data Migration Expert. In this role, you will be responsible for designing, developing, and implementing ETL solutions for data conversion and migration.Key ResponsibilitiesDevelop and implement ETL processes for data migration and conversionDesign and...


  • Toronto, Ontario, Ontario, Canada Delpath Full time

    Lead Database Administrator - Oracle MigrationsLocation Address: Hybrid Contract Duration: 12 monthsThe Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight into critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect,...


  • Old Toronto, Ontario, Canada ALLTECH CONSULTING SVC INC Full time

    Job Summary:We are seeking a highly skilled Senior Database Administrator to join our team at ALLTECH CONSULTING SVC INC. As a key member of our technical team, you will be responsible for the planning, execution, and maintenance of our Oracle database environments.Key Responsibilities:Collaborate with our technical team to design and implement database...


  • Old Toronto, Ontario, Canada ALLTECH CONSULTING SVC INC Full time

    Job Summary:We are seeking a highly skilled Senior Database Administrator to join our team at ALLTECH CONSULTING SVC INC. As a key member of our technical team, you will be responsible for the planning, execution, and maintenance of our Oracle database environments.Key Responsibilities:Collaborate with our technical team to design and implement database...


  • Toronto, Ontario, Canada NTT DATA, Inc. Full time

    We are seeking a highly skilled Cloud Migration Expert to join our team at NTT DATA, Inc. in a key role that will drive the success of our clients' digital transformation initiatives.About the Role:Design and implement cloud migration strategies for clients, leveraging expertise in Google Cloud Platform (GCP) services.Collaborate with cross-functional teams...


  • Toronto, Ontario, Canada NTT DATA, Inc. Full time

    We are seeking a highly skilled Cloud Migration Expert to join our team at NTT DATA, Inc. in a key role that will drive the success of our clients' digital transformation initiatives.About the Role:Design and implement cloud migration strategies for clients, leveraging expertise in Google Cloud Platform (GCP) services.Collaborate with cross-functional teams...


  • Old Toronto, Ontario, Canada Amazon Full time

    About the RoleWe are seeking a highly skilled and experienced professional to join our Amazon team as a Migration and Modernization Specialist. As a key member of our team, you will be responsible for driving large-scale migration and modernization of technology infrastructure and applications to AWS within one of Australia and New Zealand's most innovative...


  • Old Toronto, Ontario, Canada Amazon Full time

    About the RoleWe are seeking a highly skilled and experienced professional to join our Amazon team as a Migration and Modernization Specialist. As a key member of our team, you will be responsible for driving large-scale migration and modernization of technology infrastructure and applications to AWS within one of Australia and New Zealand's most innovative...


  • Old Toronto, Ontario, Canada Amazon Full time

    About the RoleWe are seeking a highly skilled and experienced Database Specialist to join our team at Amazon. As a key member of our Cloud Solutions Architecture team, you will be responsible for developing and executing go-to-market strategies for our Database services.Key ResponsibilitiesDevelop and execute GTM programs and initiatives at scale with...


  • Toronto, Ontario, Canada SAP Full time

    About the RoleThe Client Migration Specialist will play a critical role in ensuring contractual compliance and retirement programs for our clients. This involves working closely with customers to ensure their contractual agreements are aligned with SAP's policies and regulatory requirements.Key ResponsibilitiesAssist clients in ensuring their contractual...


  • Toronto, Ontario, Canada SAP Full time

    About the RoleThe Client Migration Specialist will play a critical role in ensuring contractual compliance and retirement programs for our clients. This involves working closely with customers to ensure their contractual agreements are aligned with SAP's policies and regulatory requirements.Key ResponsibilitiesAssist clients in ensuring their contractual...