Senior Database Engineer

Position: Senior Database Engineer

Start Date: April 3, 2025
Clearance: Unclassified, eligible for DoD SECRET
Hours: 8:00 AM – 5:00 PM, Monday – Friday (excluding Government Holidays)
Place of Performance: Remote
Years of Experience: 8+
Education/Certification Requirements: Bachelor's Degree in Computer Science, Engineering, Management Information Systems, or an equivalent field

Overview

The candidate will support Oracle data transformation and migration services to transfer historical order, customer, and reference data from a production clone of the environment. Responsibilities include exporting data from the cloned environment and importing it into the new environment.

Specific Duties

• Perform data transformation to align with DMP requirements, including but not limited to:
  • Editing queries to meet size limits and specific formatting requirements.
  • Creating Materialized Views (MVs) to support the migration effort.
  • Editing and executing external scripts (e.g., PowerShell) to process, parse, and transform loader (.ldr) exports into XML (Base64-encoded attachments) before transferring data from Out-of-Band (OOB) sources.
  • Developing queries to meet import requirements.
  • Optimizing queries to ensure efficient data retrieval and processing.
  • Leveraging manual or automated processes to export data from the cloned environment and import it into production.
• Validate import formats for various data types, including but not limited to:
  • JSON and XML formats.
• Ensure data transformation and export meet required formats, including but not limited to:
  • Transforming columns into XML rows within SQL execution.
  • Using external PowerShell scripts to convert loader exports into XML.