Senior Enterprise DB Migration Engineer (AWS)

Solerity, Inc.; Illinois; Hybrid; USD 140,000 - 200,000; Full time

Benefits offered by this job

Health Insurance

401(k)

Paid Time Off

Tuition Assistance

Referral bonuses

Pet Insurance

Employee discount

Job summary

Solerity is seeking a Senior Database Migration Engineer to support IGC software-development, application modernization, and database development activities. You will lead end-to-end migrations from discovery through post-migration stabilization, assess legacy platforms, and develop plans, mappings, and runbooks.

Experience with AWS DMS and SCT, Aurora PostgreSQL or Aurora MySQL, and strong SQL skills is required. A clearance may be required.

Qualifications

• Eight+ years of experience in database engineering, administration, development, data architecture, or migration.
• Demonstrated experience leading complex enterprise database migrations from assessment through production cutover and stabilization.
• Hands-on experience with Amazon Aurora PostgreSQL, Aurora MySQL, Amazon RDS, or comparable managed relational database services.
• Experience migrating Oracle, PostgreSQL, MySQL, SQL Server, to cloud-managed database platforms.
• Experience with AWS DMS, AWS SCT, native utilities, or comparable migration technologies.
• Advanced SQL and database development skills including schemas, stored procedures, and optimization.
• Experience developing migration validation, reconciliation, and data-quality controls.

Responsibilities

• Lead end-to-end database migrations from discovery to stabilization.
• Assess legacy databases, schemas, data volumes, and dependencies.
• Develop migration strategies, plans, schedules, risk assessments, and runbooks.
• Use AWS DMS, SCT, native tools and scripts for full-load and CDC migrations.
• Create validation, reconciliation, and data-quality controls; automate migrations with SQL, Python, Bash, or PowerShell.
• Collaborate with development teams and stakeholders to ensure smooth migrations.

Skills

Database migration

AWS DMS

SQL

Leadership

CI/CD

Python

Git

Aurora PostgreSQL/MySQL

Documentation

Education

Bachelor’s degree in Computer Science or related field

Certifications (CCSP/CFR/FITSP-M/GSEC/SSCP)”

Tools

GitLab CI/CD

Liquibase

Flyway

AWS DMS

Python

Bash

PowerShell

Job description

Solerity is seeking a Senior Database Migration Engineer to support IGC software-development, application modernization, and database development activities. You will lead end-to-end migrations from discovery through post-migration stabilization, assess legacy platforms, and develop plans, mappings, and runbooks.

Experience with AWS DMS and SCT, Aurora PostgreSQL or Aurora MySQL, and strong SQL skills is required. A clearance may be required.