Senior Database Migration Engineer

Job Description

Company: Solerity
Location: Scott AFB, IL
Workplace Type: On-site
Employment Type: Full-time

About the Role

Solerity is seeking an experienced Senior Database Migration Engineer to support software development, modernization, and cloud migration initiatives at Scott AFB, IL. In this role, you will lead end-to-end database discovery, schema conversion, data migration, and stabilization from legacy relational systems to AWS cloud-managed database platforms.

What You’ll Do / Key Responsibilities

  • Lead end-to-end database migrations to AWS managed services, including Amazon Aurora PostgreSQL and Aurora MySQL.
  • Assess legacy database platforms, schemas, data volumes, stored procedures, triggers, and interfaces.
  • Utilize AWS DMS, AWS Schema Conversion Tool (SCT), and native database utilities for full-load and change-data-capture migrations.
  • Convert and remediate database schemas, queries, data types, and proprietary functions for open-source engine compatibility.
  • Perform database performance tuning, index optimization, lock troubleshooting, and resource utilization analysis.
  • Define database resilience requirements including backup, recovery, replication, and high-availability configurations.
  • Develop migration automation and validation routines using SQL, Python, Bash, or PowerShell within GitLab CI/CD pipelines.
  • Implement database security controls, least privilege access, encryption, auditing, and STIG compliance.

Requirements & Qualifications

  • Active Secret security clearance (or ability to obtain and maintain one).
  • Bachelor’s degree in CS, Cybersecurity, IT, Software Engineering, or related field (or qualifying baseline certification such as Security+).
  • 8+ years of hands-on experience in database engineering, administration, or migration.
  • Proven experience migrating enterprise databases (Oracle, PostgreSQL, MySQL, SQL Server) to AWS cloud platforms.
  • Deep expertise in Amazon Aurora PostgreSQL, Aurora MySQL, and AWS DMS/SCT tools.
  • Advanced SQL, query optimization, and schema remediation skills.

Preferred / Bonus Qualifications

  • Experience supporting USTRANSCOM or DoD logistics enterprise programs.
  • Experience with zero-downtime, blue-green, or CDC migration patterns.
  • AWS, PostgreSQL, or Oracle certifications.

Benefits & Perks

  • Comprehensive medical, dental, and vision health coverage.
  • Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA).
  • 401(k) retirement plan with company contributions.
  • Generous Paid Time Off (PTO) and tuition assistance.

Solerity is an Equal Opportunity Employer.