Senior Database Developer (SQL Server, PostgreSQL)

Remote

Actively hiring, first seen by us 2 days ago

Pay: Pay not listed
Work setting: Remote — work setting source
Work setup in the employer’s posting: TELECOMMUTE
From the employer’s posting
Employment: Not stated

What you’ll work on

Port SQL Server schemas to Aurora PostgreSQL, keeping structure and constraints intact
Convert T-SQL stored procedures, functions, triggers and views to PL/pgSQL
Convert T-SQL queries in C# code and update the .NET data access layer for PostgreSQL
Use DMS, SCT and GenAI tools for data migration and schema conversion
Design and run tests covering functionality, data integrity and performance

From the employer’s posting

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

Convert T-SQL queries embedded in C# application code to PL/pgSQL-compatible syntax

Leverage AWS Database Migration Service (DMS) for data migration and replication between SQL Server and Aurora PostgreSQL

Design and execute test plans covering functional correctness, data integrity, performance benchmarking, edge case and regression testing

Tools in this posting

C#
Python
SQL
AWS
PostgreSQL
SQL Server

Source

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

Check the employer’s page ↗

Posting record

Report an error

Actively hiringFirst seen by us 2 days ago, still listed, and not a repost of an earlier posting.

Status in our records: Live
First seen by us: Nov 1, 20262 days ago
Recorded sightings: 4
Last seen by us: Nov 4, 2026
Employer says posted: Sep 29, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 2

Early. Similar jobs usually come down between day 5 and day 54.

From 10,733 similar postings that came down. Coming down is not always a hire.

EPAM Systems is hiring

656 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

Your next step

Check the employer’s posting for the current role and application details.

Already applied? Track this application

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025: $139,500
Expected change, 2025 to 2035: 9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Job description

View original posting ↗

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

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Location not supplied.

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Open source at careers.epam.com ↗Read the full description ↓

AI answers unavailable

We couldn’t identify enough role detail in this saved description to support an AI answer. Read the full posting