about the role
remote position, Romania only
We're looking for a Senior Data Architect 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.
There are two data architect seats: one leading the MSSQL track and one leading the Oracle track. You'll own the database modernization for your track, from preparation and conversion through performance, rehearsals and cutover.
what you'll do
- Lead the conversion of MSSQL or Oracle schemas and database code objects to PostgreSQL.
- Define data migration, reconciliation (row counts, checksums) and validation approaches.
- Own database performance against legacy baselines, including tuning onPostgreSQL.
- Work with the team on converting inline and embedded SQL in the applications.
- Design cutover and rollback, run rehearsals and dry runs, and write cutover runbooks.
- Guide the data engineers on conversion, testing and CDC reconciliation.
- Run knowledge-transfer sessions with the customer’s DBA and operations teams.
requirements
must have skills:
- 8+ years in database engineering or data architecture.
- Hands-on migration from MSSQL or Oracle to PostgreSQL at scale.
- Deep knowledge of T-SQL or PL/SQL and PL/pgSQL.
- Strong performance tuning skills (query plans, indexing, configuration).
- Experience with replication and cutover/rollback design for production databases.
- Fluent English, comfortable working directly with client DBAs and stakeholders.
nice to have skills:
- CDC experience (AWS Kinesis, Kafka, Debezium or AWS DMS)
- Schema conversion tooling (e.g. AWS SCT, ora2pg or similar)
- Managed PostgreSQL on AWS (RDS or Aurora)
- Experience with both MSSQL and Oracle.
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.