about the role
remote position, Romania only
We're looking for Data Engineers to join a 40-week, milestone-based program for one of our clients, a multi-brand software company: converting its applications to a target .NET version and migrating its MSSQL and Oracle databases, including change-data-capture (CDC) feeds, to PostgreSQL.
We have several seats across the MSSQL and Oracle tracks: most focus on database conversion and testing, and some focus on CDC reconciliation on Kafka and AWS Kinesis.
what you'll do
- Convert MSSQL or Oracle schemas and code objects (procedures, functions, views) to PostgreSQL.
- Run performance and integration testing on the converted databases.
- Reconcile data with row counts and checksums.
- Convert CDC publishers to use PostgreSQL as the source, preserving existing formats.
- Reconcile CDC feeds on Kafka and AWS Kinesis and monitor replication lag.
- Take part in rehearsals and dry runs, and contribute to cutover runbooks.
requirements
must have skills:
- 3+ years in data or database engineering.
- Hands-on experience with PostgreSQL and MSSQL and/or Oracle.
- Strong SQL, including T-SQL or PL/SQL and PL/pgSQL.
- Experience with data validation and reconciliation.
- Scripting skills (Python, PowerShell or similar).
- Good English, comfortable working with client engineers.
nice to have skills:
- CDC pipelines with Kafka and/or AWS Kinesis
- Debezium, AWS DMS or similar replication tools
- Database performance tuning
- Previous MSSQL or Oracle to PostgreSQL migration projects
Curious to find out more? We are excited to meet you!
Application form
about HEITS
HEITS.digital is a forward-thinking digital solutions consulting company that partners with clients across industries to solve challenges using high-end, Agile-driven software development teams. Leveraging expertise in AI, UX, Mobile, Full Stack, Operations, and QA, we help customers unlock new business insights through advanced machine learning techniques and technology.
By joining HEITS.digital, you become part of a culture that values both intellect and compassion, supporting every team member's growth while delivering impactful digital transformations. We have partnered with large corporates and innovative startups, and we're passionate about building solutions that matter. Dynamic work environment solving impactful problems with cutting-edge technologies.
Collaborative culture emphasising personal and professional growth. Opportunities to work on diverse projects across industries and tech stacks. Engage with passionate, high-performing teams that balance innovation with mutual respect.