Senior Data Engineer
KMS Technology12 hours ago
Ho Chi Minh City, VietnamSenior
Responsibilities
- Assess Microsoft SQL Server schemas, T-SQL procedures, functions, triggers, and jobs and contribute to SQL Server-to-PostgreSQL migration design.
- Convert schemas, data types, data, and procedural logic to PostgreSQL, including PL/pgSQL or C# service-layer implementations.
- Build repeatable automated migration tooling, scripts, ETL pipelines, data mappings, and migration rehearsals.
- Monitor data quality and provide data support to clients.
- Collaborate with .NET developers to integrate PostgreSQL into CI while preserving existing contracts, reports, and exports.
- Design and execute equivalence and validation checks using row counts, checksums, query results, and business-rule reconciliation.
- Benchmark and tune PostgreSQL indexes, query plans, and configuration against SQL Server baselines.
- Run migration tests on anonymized data, support client acceptance testing, fix defects, and retest.
- Write migration runbooks, document validation evidence, and support knowledge transfer and client handover.
- Use approved AI-assisted engineering tools, reviewing and testing generated output before committing it.
- Participate in Scrum activities and guide and review the work of Data Engineers in the squad.
Requirements
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- At least 5 years of experience in Data Engineering or database development.
- Hands-on experience with data migration, including migration flows, data mapping, and data validation; production migration experience is a plus.
- Strong T-SQL and PL/pgSQL skills for reading, converting, and optimizing complex procedures, functions, and triggers.
- Strong PostgreSQL knowledge, including data types, indexing, query planning, transactions, locking behavior, and differences from SQL Server.
- Experience designing data flows, data flow diagrams, data sources, data models, ETL transformations, database performance monitoring, and tuning.
- Experience with Python, migration tooling such as AWS SCT, AWS DMS, pgloader, or custom scripts, and database change management tools such as Flyway or Liquibase.
- Practical experience with AI coding assistants such as Claude Code or GitHub Copilot and responsible handling of AI-generated output and sensitive data.
- Upper-intermediate English proficiency and ability to work directly with a US-based client team.
- Ability to work independently, learn new technologies, follow strict data-protection rules, and work in Agile environments.
- Preferred experience with AWS Aurora/RDS PostgreSQL, Azure SQL, Azure Data Factory, regulated validation and audit trails, C#/.NET data access with EF Core or Dapper, data streaming, and data replication.
Benefits
- Attractive salary and benefits, annual performance appraisals, and performance bonuses.
- Flexible working time and training in current technologies, best practices, and soft skills.
- Short-term and long-term onsite assignment opportunities in North America, Europe, and Asia.
- Premium healthcare insurance for the employee and family.
- Company trips, annual year-end parties, team-building activities, and fitness and sports activities.
- Community development opportunities, free in-house entertainment facilities, coffee, and snacks.
Tech Stack
Categories
Data Engineering
About KMS Technology
KMS Technology provides software product development, quality assurance/testing, and AI engineering services for independent software vendors and enterprises using offshore and nearshore teams. Its consulting-led model spans DevOps, mobile app development, and automated testing, delivered through global centers in Vietnam and Mexico. Founded in 2009 and headquartered in Atlanta, the privately held company focuses on helping North American clients scale product delivery.