Database Engineer

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

This is a 6 – 12-month contract with our client in the consulting industry

We are looking for a hands-on Database Engineer (SQL) to build and execute the SQL transformation layer in AWS RDS for an enterprise legacy data migration project.

Key Responsibilities

• SQL Data Transformation: Write, test, and execute transformation scripts directly within AWS RDS to convert legacy data into required import formats.
• Data Reconciliation & Audit: Perform row-count checks, key-field reconciliations, and referential integrity validations before generating import files.
• Document Mapping Support: Assist in extracting and linking unstructured files (incident photos, inspection PDFs) to their corresponding migrated records via file shares.
• Reusable Script Framework: Develop a modular transformation framework that can be reused across multiple legacy system migration waves.
• Governance & Lineage: Document mapping logic, transformation rules, and data lineage to maintain complete audit readiness.
• Stakeholder Collaboration: Work closely with System Leads, internal IT, and platform vendors to validate data schemas and obtain signoffs.

Minimum Requirements

• Advanced SQL: Proven expertise writing, tuning, and troubleshooting complex data transformation queries in relational databases.
• AWS RDS & S3: Hands-on experience executing transformation logic directly inside AWS RDS and using S3 for staging.
• Enterprise ETL/Migration: Demonstrated experience extracting, cleansing, and mapping structured data between enterprise schemas under strict project timelines.
• Document & Metadata Linkage: Practical experience linking unstructured files (PDFs, images) to relational database records.
• Data Quality & Reconciliation: Strict adherence to data auditing standards, row-count verifications, and using Excel-based mapping templates.