We are seeking a Senior Database Developer with deep expertise in SQL Server to Aurora PostgreSQL migration and modernization. The consultant will lead the porting of database schemas, code objects and application data access layers from Microsoft SQL Server to Amazon Aurora PostgreSQL, using AWS migration and GenAI-assisted tooling. The role is highly hands-on, covering schema conversion, stored procedure migration, application code updates (C# / .NET) and end-to-end validation in a non-production AWS environment. All activities must align with AWS cloud-native best practices for database modernization.
Responsibilities
- Port Microsoft SQL Server database schemas to Amazon Aurora PostgreSQL, ensuring structural integrity, data type mapping and constraint parity
- Convert T-SQL stored procedures, functions, triggers and views to PL/pgSQL equivalents in Aurora PostgreSQL
- Identify and resolve incompatibilities between SQL Server and PostgreSQL syntax, data types and behavioral differences
- Convert T-SQL queries embedded in C# application code to PL/pgSQL-compatible syntax
- Update the C# application's data access layer to support communication with PostgreSQL (e.g., Npgsql, Entity Framework Core for PostgreSQL)
- Collaborate with application development teams to ensure seamless integration between the updated data layer and Aurora PostgreSQL
- Leverage AWS Database Migration Service (DMS) for data migration and replication between SQL Server and Aurora PostgreSQL
- Use AWS Schema Conversion Tool (SCT) along with Atx Tool / AWS Transformation Tool, Amazon Q and other GenAI-assisted tools to automate and accelerate schema and code object conversion
- Validate tool outputs and manually resolve conversion gaps where automated tooling falls short
- Deploy converted schemas, code objects and data to a non-production AWS Aurora PostgreSQL environment, configuring instances, parameter groups, security settings and connectivity
- Confirm compilation, execution and communication of all migrated SQL code objects and updated C# application code with Aurora PostgreSQL
- Design and execute test plans covering functional correctness, data integrity, performance benchmarking, edge case and regression testing
Requirements
- 3+ years of expert-level experience with Microsoft SQL Server (T-SQL), including stored procedures, functions, triggers, views and complex queries
- Advanced to expert proficiency in PostgreSQL (PL/pgSQL) and Amazon Aurora PostgreSQL
- Expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT)
- Advanced skills in C# / .NET Data Access Layer development with Npgsql, Entity Framework Core and ADO.NET
- Background in cross-platform database schema migration from SQL Server to PostgreSQL
- Competency in database modernization testing, including compile validation, functional testing and performance benchmarking
- English proficiency at B2 level or higher
Nice to have
- Familiarity with Atx Tool / AWS Transformation Tool, Amazon Q and GenAI-assisted migration tools
- Knowledge of AWS Aurora configuration, including parameter groups, replication, HA and Performance Insights
- Skills in Amazon CloudWatch for database monitoring and alerting
- Proficiency in Python for scripting and automation of migration tasks
- Understanding of CI/CD for database deployments