Senior Data Engineer

You will join the database migration track of a modernization program for a US-based software client. The product is a business-critical enterprise application. While the application is re-built on .NET and React, this track moves its Microsoft SQL Server database, including the business logic held in T-SQL, to PostgreSQL and proves, with evidence, that the migrated system behaves the same. All work is done on anonymized data

Responsibilities:

•   Assess the existing Microsoft SQL Server database (schema, T-SQL stored procedures, functions, triggers, jobs) and contribute to the SQL Server to PostgreSQL conversion design.
• Convert schema, data types and data to PostgreSQL, and build repeatable, automated migration tooling and scripts (schema conversion, data load, migration rehearsal)
• Monitor data quality in pipelines and provide data support to clients.
• Convert T-SQL procedural logic to PL/pgSQL, or work with the .NET team to move it into the C# service layer, with special care for date/time, time-zone and temporal behavior and for numeric precision in calculation algorithms.
• Collaborate with .NET developers on the data-access layer so that the application runs on PostgreSQL in CI, while existing integration contracts, reports and exports stay unchanged
• Design and run data validation and equivalence checks between SQL Server and PostgreSQL (row counts, checksums, query-result and business-rule reconciliation) and document the results as validation evidence.
• Benchmark and tune PostgreSQL performance (indexes, query plans, configuration) against the SQL Server baseline
• Design and build ETL pipelines for data migration from SQL Server to PostgreSQL
• Run representative migration tests on anonymized data sets, support client user acceptance testing, fix defects and retest.
• Write the migration runbook and support knowledge transfer and handover to the client team.
• Use the AI-assisted engineering tools approved for the project, and review and test all AI-generated output before it is committed.
• Participate in Agile/Scrum activities: daily stand-up, demo, retrospective, planning, etc.
• Guide and review the work of the Data Engineers in the squad.
• Perform other tasks assigned by the Leader/Manager.

General requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field
• At least upper intermediate level of English skills (written and spoken), able to work directly with a US-based client team
• 5+ years of experience in Data Engineering  or database development (including at least one database migration delivered to production, is a plus)
• Familiar with Agile development methodologies (Scrum, XP, Kanban)
• Ability to obtain deep knowledge of the project technologies and work independently with minimum guidance
• Ability to self-learn and adapt to new technologies quickly
• Careful, evidence-minded working style, and willingness to follow strict data-protection rules (anonymized data only, no client data outside approved environments)

Technical requirements:

• Strong experience in designing data flows and creating data flow diagrams
• Experience in data source design and data modeling for large-scale business applications
• Hands-on experience in data migration, including designing migration flows, data mapping and data validation (ideally Microsoft SQL Server to PostgreSQL)
• Good knowledge of data transformation (ETL) and SQL databases. Strong T-SQL and PL/pgSQL: able to read, convert and optimize complex stored procedures, functions and triggers
• Solid PostgreSQL knowledge (data types, indexing, query planning, transaction and locking behavior) and a clear understanding of how it differs from SQL Server
• Experience with the Python programming language
• Experience in database performance monitoring and tuning
• Experience with migration tooling (AWS SCT/DMS, pgloader or custom scripts) and with database change management in CI/CD (Flyway, Liquibase or similar)
• Practical experience with AI coding assistants (Claude Code, GitHub Copilot or similar), and awareness of AI output limitations and responsible AI use (data privacy, handling of sensitive client data)

Nice to have:

• Experience with AWS (Aurora/RDS PostgreSQL) and Azure SQL environments
• Experience building ETL pipelines with Azure Data Factory (ADF)
• Experience in a regulated domain where validation evidence and audit trails are required
• Familiarity with C#/.NET data access (EF Core, Dapper)
• Experience with data streaming and data replication

Perks You'll Enjoy 

• Working in one of the Best Places to Work in Vietnam
• Building large-scale & global software products
• Working & growing with Passionate & Talented Team
• Diverse careers opportunities with Software Services, Software Product Development, IT Solutions & Consulting
• Attractive Salary and Benefits
• Performance appraisals every year and performance bonus
• Onsite opportunities: short-term and long-term assignments in North American (U.S, Canada), Europe, Asia.
• Flexible working time
• Various training on hot-trend technologies, best practices and soft skills
• Premium healthcare insurance for you and your loved ones
• Company trip, big annual year-end party every year, team building, etc.
• Fitness & sport activities: football, tennis, table-tennis, badminton, yoga, swimming…
• Joining community development activities: 1% Pledge, charity every quarter, blood donation, public seminars, career orientation talks,…
• Free in-house entertainment facilities (foosball, ping pong, gym…), coffee, and snacks (instant noodles, cookies, candies…)

And much more, join us and let yourself explore other fantastic things!

KMS provides the enterprise execution layer, where work becomes outcomes. 

We are a global, AI-native technology services company focused on Enterprise Execution. We help enterprises build and modernize applications, create trusted data foundations, put AI into production, and continuously run and improve the systems that execute the work. 

Founded in 2009 in the U.S., KMS has grown to serve clients worldwide, with locations across the U.S., Vietnam, Poland, and Mexico. We are trusted by technology and business leaders for the quality of our engineering, delivery, and execution. Our mission is to help enterprises move from business intent to measurable outcomes faster — with the control, reliability, governance, and confidence required to scale. 

At KMS, we believe sustainable growth is built on the success of our clients and employees and on making a lasting contribution to our communities.

More about KMS Technology:

Website: https://kms-technology.com 

Linkedin: https://www.linkedin.com/company/kms-technology