We are seeking a Senior Data Integration Engineer to lead a SQL Server to Aurora PostgreSQL migration and modernization engagement powered by AWS Transform for .NET / SQL Server. This role involves porting database schemas, code objects and application data access layers from Microsoft SQL Server to Amazon Aurora PostgreSQL while validating and refining AI-generated outputs from AWS Transform alongside DMS, SCT and Kiro.
Responsibilities
- Port SQL Server database schemas to Amazon Aurora PostgreSQL to ensure structural integrity, data type mapping and constraint parity
- Convert T-SQL stored procedures, functions, triggers and views to PL/pgSQL equivalents and resolve syntax, data type and behavioral differences
- Update T-SQL queries embedded in C#/.NET application code to PL/pgSQL-compatible syntax and refine the data access layer using Npgsql and Entity Framework Core
- Operate AWS Transform for .NET / SQL Server as the primary AI agentic accelerator to submit workloads and review agent-generated artifacts
- Apply AWS DMS for data migration and replication, AWS SCT for supplementary schema conversion and Kiro for GenAI-assisted code analysis
- Deploy converted schemas, code and data to a non-production Aurora PostgreSQL environment
- Configure instances, parameter groups, security settings and connectivity to mirror production patterns
- Validate compile and execution of migrated SQL code objects and confirm communication between the updated application and Aurora PostgreSQL
- Design test plans that cover functional correctness, data integrity, performance benchmarking and regression testing
Requirements
- 5+ years of experience in database development and migration
- English proficiency at B2+ level
- Expertise in Microsoft SQL Server (T-SQL) and Proficiency in PostgreSQL (PL/pgSQL) including Amazon Aurora PostgreSQL
- Skills in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT)
- Proficiency in C#/.NET data access layers including Npgsql Entity Framework Core and ADO.NET
- Background in database schema migration across SQL Server and PostgreSQL platforms
- Expertise in database modernization testing including compile validation functional testing and performance benchmarking
Nice to have
- Familiarity with AWS Transform for .NET / SQL Server and GenAI-assisted migration tools
- Knowledge of AWS Aurora configuration including parameter groups replication and Performance Insights
- Familiarity with Amazon CloudWatch for database monitoring and alerting
- Skills in Python for scripting and automation and CI/CD for database deployments
- Familiarity with Kiro for AI-assisted code refinement workflows
We offer/Benefits
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
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.
Kindly note that this role supports remote work, but only from within Ukraine.
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.