Database Engineer; SQL

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.

• 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.

• 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.