Senior Database Developer (SQL Server, PostgreSQL)

Overview

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

Ukraine

With us you can:

• Work on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in Ukraine
• Receive the necessary equipment to perform your work tasks
• Change projects and technology stacks within EPAM
• Gain experience in various business domains (Insurance, E-commerce, Healthcare, Finance, Travelling, Media, Artificial Intelligence, and more)
• Relocation opportunities may be available for eligible candidates, depending on the role and openings at other EPAM locations
• Participate in volunteer, charity programs and communities (both technical and interest-based)

We focus on your professional growth:

• You can plan your individual career path together with your manager
• Receive regular feedback from colleagues
• Improve your English for free with certified teachers (Speaking Clubs, client interview preparation courses, etc.)
• Get the opportunity to undergo free training and certification in AWS, GCP, or Azure Clouds
• Use the internal E-learn training program (18,200+ specialized training and mentoring programs)
• Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resources
• Study at EPAM Solution Architecture School with the instructors who are practicing architects
• Develop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and more
• Participate in internal communities (500+ meetups, technical discussions, brainstorming sessions, online events and conferences annually)

What we offer:

• Vacation and sick leave (including a sick leave without a medical certificate)
• A wide range of Voluntary Medical Insurance programs providing both medical treatment and various preventive options (including sports activities)
• Medical insurance for family members at corporate rates
• Company support during significant life events (childbirth or adoption, marriage, etc.)
• Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic training
• E-kids program - a free programming language training program for EPAMers' children

[epamgdo] Ukraine (Remote)

Kindly note that this role supports remote work, but only from within Ukraine.

[epamgdo] Ukraine (benefits may differ)

Kindly be advised that the set of benefits, including learning, certification, and other opportunities, may vary depending on the role you apply for. Our recruiter will be able to share more details about the specific opportunity during your general interview.

[epamgdo] Ukraine (About EPAM)

EPAM strives to provide its global team of over 62,350 professionals in more than 55 countries with opportunities for professional growth from day one of collaboration. Our colleagues are the source of EPAM's success, so we value cooperation, strive to always understand our clients' business and aim for the highest quality standards. No matter where you are, you will join a dedicated, diverse community that will help you realize your potential to the fullest.