Database Migration Engineer

Blu Omega is seeking a Database Migration Engineer to support application operations and maintenance, custom development, and database administration for mission-critical internal and public-facing applications. This role is responsible for data mapping and migration from Oracle RDS in AWS and CSV exports to PostgreSQL on Google Cloud Platform (GCP)., * Create source-to-target data mapping documents by translating business rules into data transformations.

• Analyze and map Oracle database schemas to PostgreSQL tables and entities.
• Perform data profiling, cleansing, validation, and quality checks to support accurate and complete data migration.
• Develop SQL scripts, stored procedures, and data transformation processes for Oracle-to-PostgreSQL migrations.
• Migrate data from Oracle RDS in AWS and CSV exports into PostgreSQL on GCP.
• Ensure compatibility with PostgreSQL data types, relationships, constraints, lookups, enumerated values, and date/time formats.
• Collaborate with business analysts, data architects, and stakeholders to gather requirements and maintain data integrity throughout the migration lifecycle.
• Generate reconciliation reports using SQL or scripts.
• Build and tune data migration pipelines, including pipeline configuration to improve concurrency and performance.
• Implement error logging and audit frameworks in PostgreSQL.

• 3-5 years of relevant experience in data engineering, SQL development, or data migration.
• Strong experience with Oracle SQL and PostgreSQL databases.
• Experience creating source-to-target data mapping documents and translating business rules into data transformations.
• Hands-on experience with ETL processes, SQL scripting, CSV data migration, data validation, data cleansing, and reconciliation.
• Experience with PostgreSQL data types and CRUD operations.
• Experience developing SQL scripts for Oracle-to-PostgreSQL data conversions.
• Familiarity with Git or another source code repository and CI/CD processes.
• Active Secret clearance.

Preferred Qualifications

• Experience building data pipelines into PostgreSQL using GCP-native tools such as Cloud Data Fusion or Dataflow.
• Experience with Python and shell scripting.
• Experience developing ETL packages with SSIS and maintaining database objects in SQL Server.
• Experience with change data capture (CDC).
• Familiarity with AI-assisted coding tools such as Claude Code, Codex, or equivalent.
• Experience with pipeline tuning and error logging frameworks.

Salary Range: $120,000.00 - $145,000.00

Final compensation is based on technical skills, experience, education, certifications, and clearance.

Blu Omega Benefits & Perks

• Medical, Dental, and Vision coverage through national providers
• 401(k) with company match (eligible after 6 months; vesting applies)
• Company-paid Life and AD&D insurance with additional voluntary options
• Short-term disability (company-paid) and long-term disability options
• Employee Assistance Program (EAP) with 24/7 confidential support and mental health resources
• Telehealth and virtual care options available through medical plans
• Pet insurance, legal services, and identity theft protection options
• Paid Time Off (PTO) for eligible employees
• Paid federal holidays for salaried employees
• Access to wellness programs, discounts, and lifestyle benefits

Benefits eligibility and offerings may vary based on role, employment status, and program requirements.

Blu Omega is a Woman-Owned Small Business (WOSB) delivering technology and cybersecurity solutions to federal agencies and enterprise clients nationwide. Headquartered in Ashburn, VA, we support mission-critical programs across civilian and defense sectors, including health, national security, and regulatory environments. We partner with government agencies and large integrators to provide expertise in cybersecurity operations, cloud and infrastructure modernization, data and analytics, and enterprise IT support.