Database Migration Specialist

1 month ago

Old Toronto, Ontario, Canada Momentum Financial Services Group Full time
Job Title: Lead Database Administrator

Momentum Financial Services Group is a leading provider of financial services in North America, committed to delivering innovative solutions that meet the evolving needs of consumers and business owners. We're seeking a seasoned database administrator 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.

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.
Qualifications:
  • 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.
Additional Information:

All your information will be kept confidential according to EEO guidelines.

*Notice to Ontario Applicants – Momentum Financial Services Group is committed to accommodating applicants with disabilities up to the point of undue hardship during the recruitment, assessment, and selection process. If you are selected for an interview, please notify Momentum Financial Services Group if you require accommodation in respect of the materials or procedures used at any time during this process. If you require accommodation, we will work with you to determine how to meet your needs.

Note to Internal Applicants: All internal applicants are required to notify their current manager regarding interest in applying for this role.

  • Database Migration Specialist

    1 month ago

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

    Job Title: Lead Database AdministratorMomentum Financial Services Group is a leading provider of financial services in North America, committed to delivering innovative solutions that meet the evolving needs of consumers and business owners. We are seeking a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features,...

  • Database Migration Specialist

    1 month ago

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

    Job Title: Lead Database AdministratorMomentum Financial Services Group is a leading provider of financial services in North America, committed to delivering innovative solutions that meet the evolving needs of consumers and business owners. We are seeking a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features,...

  • Database Migration Lead

    3 weeks ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Lead Database AdministratorMomentum Financial Services Group_new is seeking a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to contribute to the success of our cloud-based data initiatives.Key Responsibilities:Migrate SQL Server databases to different platforms like...

  • Database Migration Lead

    1 month ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Lead Database AdministratorMomentum Financial Services Group_new is seeking a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to contribute to the success of our cloud-based data initiatives.Key Responsibilities:Migrate SQL Server databases to different platforms like...

  • Database Migration Lead

    1 month ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Lead Database AdministratorMomentum Financial Services Group_new is seeking a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to contribute to the success of our cloud-based data initiatives.Key Responsibilities:Migrate SQL Server databases to different platforms like...

  • Database Migration Lead

    3 weeks ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Lead Database AdministratorMomentum Financial Services Group_new is seeking a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to contribute to the success of our cloud-based data initiatives.Key Responsibilities:Migrate SQL Server databases to different platforms like...

  • Database Migration Lead

    1 month ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Database Migration and Administration ExpertMomentum Financial Services Group_new is seeking a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, and data migration to lead our cloud-based data initiatives.Key Responsibilities:Develop and implement migration plans for SQL Server databases to different...

  • Database Migration Lead

    1 month ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Database Migration and Administration ExpertMomentum Financial Services Group_new is seeking a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, and data migration to lead our cloud-based data initiatives.Key Responsibilities:Develop and implement migration plans for SQL Server databases to different...

  • Database Migration Expert

    2 weeks ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Database Migration ExpertMomentum Financial Services Group_new is seeking a seasoned Database Migration Expert to lead the migration of SQL Server databases to different platforms like PostgreSQL, MongoDB, and MySQL. The ideal candidate will have expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF).Key...

  • Database Specialist

    4 weeks ago

    Old Toronto, Ontario, Canada Alliance Search Partners Full time

    Job Title: Database SpecialistWe are seeking a highly skilled Database Specialist to join our team. As a Database Specialist, you will be responsible for providing database support related to Oracle build, migration, performance tuning, and incident resolutions.Key Responsibilities:Take ownership of and lead technical resolutions for production...

  • Database Specialist

    4 weeks ago

    Old Toronto, Ontario, Canada Alliance Search Partners Full time

    Job Title: Database SpecialistWe are seeking a highly skilled Database Specialist to join our team. As a Database Specialist, you will be responsible for providing database support related to Oracle build, migration, performance tuning, and incident resolutions.Key Responsibilities:Take ownership of and lead technical resolutions for production...

  • Data Migration Specialist

    1 month ago

    Old Toronto, Ontario, Canada Softline™ Technology Inc. Full time

    Job Title: OPGT MOD – OneJob Summary:We are seeking a highly skilled Data Migration Specialist to join our team at Softline™ Technology Inc. The successful candidate will be responsible for ensuring the smooth migration of data from our legacy system to our new Dynamics 365 CRM platform.Key Responsibilities:Develop comprehensive test plans and test cases...

  • Data Migration Specialist

    1 month ago

    Old Toronto, Ontario, Canada Softline™ Technology Inc. Full time

    Job Title: OPGT MOD – OneJob Summary:We are seeking a highly skilled Data Migration Specialist to join our team at Softline™ Technology Inc. The successful candidate will be responsible for ensuring the smooth migration of data from our current system to the new data warehouse, while also testing and validating the Business Intelligence (BI) reports to...

  • Data Migration Strategist

    4 weeks ago

    Toronto, Ontario, Canada Capleo Global LLC Full time

    Senior Data Conversion SpecialistCapleo Global LLC is seeking a highly skilled Senior Data Conversion Specialist to join our team. As a key member of our data migration team, you will be responsible for developing and implementing data migration strategies, ensuring data integrity and quality, and collaborating with clients to deliver high-quality...

  • Data Migration Strategist

    4 weeks ago

    Toronto, Ontario, Canada Capleo Global LLC Full time

    Senior Data Conversion SpecialistCapleo Global LLC is seeking a highly skilled Senior Data Conversion Specialist to join our team. As a key member of our data migration team, you will be responsible for developing and implementing data migration strategies, ensuring data integrity and quality, and collaborating with clients to deliver high-quality...

  • Enterprise Migration Specialist

    4 weeks ago

    Toronto, Ontario, Canada S.i. Systèmes Full time

    Migration Specialist Job DescriptionOur valued public sector client is seeking a skilled Migration Specialist to lead the migration of their Enterprise Documents and Records Management System Foundation project.Key Responsibilities:Develop and assist with migration process definition with business and technical resources.Provide written recommendations on...

  • Enterprise Migration Specialist

    4 weeks ago

    Toronto, Ontario, Canada S.i. Systèmes Full time

    Migration Specialist Job DescriptionOur valued public sector client is seeking a skilled Migration Specialist to lead the migration of their Enterprise Documents and Records Management System Foundation project.Key Responsibilities:Develop and assist with migration process definition with business and technical resources.Provide written recommendations on...

  • Enterprise Migration Specialist

    4 weeks ago

    Toronto, Ontario, Canada S.i. Systèmes Full time

    Migration Specialist Job DescriptionOur valued public sector client is seeking a skilled Migration Specialist to lead the migration of an Enterprise Documents and Records Management System Foundation project.Key Responsibilities:Develop and assist with migration process definition with business and technical resources.Provide written recommendations on...

  • Enterprise Migration Specialist

    4 weeks ago

    Toronto, Ontario, Canada S.i. Systèmes Full time

    Migration Specialist Job DescriptionOur valued public sector client is seeking a skilled Migration Specialist to lead the migration of an Enterprise Documents and Records Management System Foundation project.Key Responsibilities:Develop and assist with migration process definition with business and technical resources.Provide written recommendations on...

  • Avaya Systems Migration Specialist

    3 weeks ago

    Old Toronto, Ontario, Canada S I Systems Full time

    Avaya Systems Migration SpecialistWe are seeking an experienced Avaya Systems Migration Specialist to support the programming of a PBX and CM systems migration project to a new Avaya Platform.This is a fully remote position with an initial 18-month contract and possibility of extension.Key Responsibilities:Conduct customer station reviews, determine end-user...