Lead migration of enterprise SQL Server databases to PostgreSQL, convert and optimize T-SQL to PL/pgSQL, use AWS DMS/SCT and CDC strategies, develop backend services (C#, Node.js), contribute C++ data-layer work, build cloud-native AWS services, implement IaC with Terraform and CI/CD with GitLab, and support testing with Jest and Playwright.
This is a remote position.
Innosphere is seeking Senior Full Stack Developers to join a high-impact database modernization initiative. The team will be responsible for migrating an enterprise SQL Server environment to PostgreSQL while modernizing supporting application components and cloud infrastructure. This role is ideal for senior engineers who have hands-on experience with complex database migrations, cloud-native development, and modern AWS environments. As part of the migration effort, some developers will also contribute to replacing the existing database access layer, including development in C++, to support the new PostgreSQL architecture.
Roles & Responsibilities
- Lead the migration of enterprise SQL Server databases to PostgreSQL, ensuring data integrity, performance, and minimal downtime.
- Convert and optimize SQL Server database objects, including stored procedures, triggers, functions, views, and complex T-SQL logic into PostgreSQL/PL/pgSQL.
- Design, execute, and support database migration strategies using AWS Database Migration Service (DMS), Schema Conversion Tool (SCT), and replication/CDC-based cutover methodologies.
- Develop, maintain, and enhance backend services using C# and, where applicable, Node.js.
- Contribute to the modernization of the application data access layer, including development in C++ where required.
- Build and support cloud-native applications and services within AWS, leveraging technologies such as Lambda, ECS, SQS, EventBridge, CloudFront, ALB, and Aurora PostgreSQL.
- Develop and maintain Infrastructure as Code (IaC) using Terraform and support automated deployment pipelines through GitLab CI/CD.
- Collaborate with architects, developers, QA teams, and business stakeholders to deliver migration milestones and platform enhancements.
- Contribute to application regression testing using Jest and Playwright where applicable.
Qualifications
- Bachelor's degree in Computer Science, Software Engineering, or a related field (or equivalent practical experience).
- 7+ years of professional full stack software development experience.
- Strong experience with Microsoft SQL Server, including T-SQL, stored procedures, triggers, SQL Agent, and query optimization.
- Strong experience with PostgreSQL and PL/pgSQL, including rewriting complex procedural logic.
- Hands-on experience with SQL Server to PostgreSQL migrations, including:
- AWS Database Migration Service (DMS)
- AWS Schema Conversion Tool (SCT)
- Change Data Capture (CDC) and replication-based cutovers
- Data migration validation and reconciliation (row-level, aggregate, and business-rule validation)
- Strong backend development experience with C# and experience with Node.js.
- Experience working with PostgreSQL, SQL Server, and DynamoDB.
- Strong experience with AWS services, including Aurora/RDS PostgreSQL, Lambda, ECS, SQS, CloudFront, ALB, and EventBridge.
- Experience with Terraform for Infrastructure as Code (IaC) and GitLab CI/CD pipelines.
- Strong analytical, problem-solving, and collaboration skills.
Preferred Qualifications
- Experience building front-end applications using React.
- Experience with Jest and Playwright for automated testing.
- Experience with C++, particularly for data layer or database integration.
- Experience working on large-scale cloud-native or enterprise migration projects.
Innosphere welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates participating in all stages of the selection process.
Please note that only applicants selected for shortlisting will be contacted. All successful candidates are subject to criminal, educational, and employment background checks. Applicants must currently reside in Canada and be legally authorized to work in Canada.
At Innosphere, we value transparency throughout our hiring process. We use Applicant Tracking Systems (ATS) and AI-assisted tools to support application management and recruitment workflows. Every application is reviewed fairly, and all final hiring decisions are made by our hiring team.
Similar Jobs
.png){kind=logo}
Artificial Intelligence • Marketing Tech • Software
As a Senior Full Stack Engineer, you'll build interactive customer experiences, manage backend architecture, write well-tested code, and ensure smooth production processes.
Top Skills:
AlgoliaJavaScriptPostgresRuby on RailsReactTypescript
51 Minutes Ago
Easy Apply
Easy Apply
Marketing Tech • Real Estate • Software • PropTech • SEO
Own and improve the AI Social generative media pipeline: build and ship LLM-driven prompts/agent loops, choose and compose media (image, video, voice, music), collaborate with product/design/content, and deliver polished, production-quality social assets.
Top Skills:
Agent LoopsAWSClaude CodeCursorElevenlabsFigmaHeadless Browser RenderingLinearLlm SdksNode.jsNotionPostgresPrompt EngineeringReactShotstackTemporalTool-CallingTypescriptVeo
Big Data • Fintech • Mobile • Payments • Financial Services
Lead technical strategy and deliver backend systems for search and recommendation at scale. Collaborate with PM, design, and analytics to define and execute business-impacting projects. Own operations, availability, monitoring, and on-call practices while mentoring engineers and setting code and design standards.
Top Skills:
AWSKotlinKubernetesMySQLPythonReactSpark
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal
