Senior Database Developer (SQL Server, PostgreSQL)

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

Languages