Senior Full Stack Developer (4 Months)
$145,600–$166,400 year
RemoteUnited States
Job Summary
Lead the migration of enterprise SQL Server databases to PostgreSQL, ensuring data integrity, performance, and minimal downtime. Convert and optimize complex T-SQL logic into PostgreSQL/PL/pgSQL, while developing backend services in C# and Node.js. Design migration strategies using AWS tools like DMS and SCT, and build cloud-native applications within AWS leveraging Lambda, ECS, and Terraform. Contribute to the modernization of the application data access layer, including development in C++ where required, and support automated deployment pipelines through GitLab CI/CD. Collaborate with architects and stakeholders to deliver migration milestones and platform enhancements. This 4-month remote role supports Innosphere's high-impact database modernization initiative for candidates residing in Canada.
Required 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
- Must currently reside in Canada
- Be legally authorized to work in Canada
Desired 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.