Database Engineer (SQL) at Ovations Technologies

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.