Senior Cloud DB Migration Architect

Solerity, Inc.; Shiloh (IL); Hybrid; USD 130,000 - 145,000; Full time

Job summary

Solerity, Inc. is seeking a senior database migration lead to orchestrate end-to-end migrations from assessment through production cutover. You will evaluate legacy systems, plan conversions, and drive data movement to AWS managed databases such as Aurora PostgreSQL or Aurora MySQL.

You will work with cross-functional teams to ensure data integrity, performance and security while delivering reliable, low-downtime migrations in a hybrid on-site/remote environment.

Qualifications

• Eight (8+) or more years in database engineering, administration, development, data architecture, or migration.
• Experience leading complex enterprise migrations from assessment through production cutover.
• Hands-on with Amazon Aurora PostgreSQL/MySQL, Amazon RDS, or comparable services.
• Experience migrating Oracle/ PostgreSQL/ MySQL/ SQL Server to cloud platforms.
• Experience with AWS DMS, AWS SCT, native utilities, or comparable tools.
• Advanced SQL and database-development skills incl. schemas, procedures, functions, and indexing.

Responsibilities

• Lead end-to-end migration activities: discovery, planning, schema conversion, data movement, validation, cutover, rollback, stabilization.
• Assess legacy platforms, schemas, data volumes, interfaces, dependencies, security and performance.
• Develop migration strategies, technical plans, risk assessments, and runbooks.
• Lead migrations to AWS managed databases (Aurora PostgreSQL/MySQL, RDS).
• Use AWS/DMS, SCT, and scripts to support full-load, incremental, and low-downtime migrations.
• Coordinate code and query changes with development teams to ensure compatibility.

Skills

Migration leadership

Enterprise migrations

Stakeholder communication

SQL performance tuning

Security controls

Education

Bachelor's degree in Computer Science or related field

CSP/CFR/FITSP-M/GSEC/CompTIA/SSCP certifications

Tools

AWS DMS

AWS SCT

Aurora PostgreSQL/MySQL

GitLab CI/CD

Liquibase/Flyway

SQL, Python, Bash, PowerShell

Job description

Solerity, Inc. is seeking a senior database migration lead to orchestrate end-to-end migrations from assessment through production cutover. You will evaluate legacy systems, plan conversions, and drive data movement to AWS managed databases such as Aurora PostgreSQL or Aurora MySQL.

You will work with cross-functional teams to ensure data integrity, performance and security while delivering reliable, low-downtime migrations in a hybrid on-site/remote environment.