Lead the migration of enterprise SQL Server databases to PostgreSQL while modernizing supporting application components and cloud infrastructure. Develop backend services and modernize the data access layer using C#, Node.js, and C++ within an AWS environment.
This is a remote position.
Innosphereis seekingSenior Full Stack Developersto join a high-impact database modernization initiative. The team willbe responsible formigrating 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 inC++, 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++ whererequired.
Build and support cloud-native applications and services within AWS,leveragingtechnologies such as Lambda, ECS, SQS,EventBridge, CloudFront, ALB, and Aurora PostgreSQL.
Develop andmaintainInfrastructure 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 withMicrosoft SQL Server, including T-SQL, stored procedures, triggers, SQL Agent, and query optimization.
Strong experience withPostgreSQLandPL/pgSQL, including rewriting complex procedural logic.
Hands-on experience withSQL 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 withC#and experience withNode.js.
Experience working withPostgreSQL,SQL Server, andDynamoDB.
Experience withC++, 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.
“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”