Lead Database Administrator

Company Description

Momentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing store, we provide access to cash and related products to help our customers achieve their goals.

Our highly skilled workforce puts customers first in everything we do. We serve 2 million people annually with diverse and innovative financial products such as loans, cheque cashing, money transfer and prepaid cards. Through this ever-evolving suite of services, we empower customers to manage their finances and improve their lives. Wherever customers are on their financial journey, Momentum Financial Services Group provides solutions.

#Corporate

Job Description

This is an excellent opportunity for a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to join a dynamic team and contribute to the success of our cloud-based data initiatives. If you meet the above qualifications and are passionate about database administration and cloud technologies, we encourage you to apply.

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 current manager regarding interest in applying for this role.