Contract: SQL Data Engineer for AWS RDS Migration

Ovations Technologies; Johannesburg; On-site; ZAR 670,000 - 1,228,000; Full time

Job summary

Ovations Technologies is seeking a hands-on Database Engineer (SQL) for a 6–12 month enterprise migration project in Johannesburg. You will build and run the SQL transformation layer inside AWS RDS to transform legacy data into import formats.

Key duties include data reconciliation, linking unstructured files to migrated records, and developing a reusable transformation framework while ensuring governance and data lineage for audit readiness.

Qualifications

• Advanced SQL skills with complex data transformations.
• Hands-on experience with AWS RDS and S3 for in-database transforms.
• Experience with enterprise ETL, data cleansing, and migration workflows.
• Ability to link unstructured files to relational records.
• Strong data quality, reconciliation, and auditing practices.

Responsibilities

• Write, test, and run SQL transformation scripts inside AWS RDS.
• Perform row-count checks, key-field reconciliations, and referential integrity checks.
• Assist in linking incident photos and PDFs to migrated records via file shares.
• Develop a modular, reusable transformation framework for multiple migrations.
• Document mapping rules and data lineage for audit readiness.

Skills

Advanced SQL

Data transformation

Data reconciliation

Governance & lineage

Stakeholder collaboration

Tools

AWS RDS

S3

Job description

Ovations Technologies is seeking a hands-on Database Engineer (SQL) for a 6–12 month enterprise migration project in Johannesburg. You will build and run the SQL transformation layer inside AWS RDS to transform legacy data into import formats.

Key duties include data reconciliation, linking unstructured files to migrated records, and developing a reusable transformation framework while ensuring governance and data lineage for audit readiness.