Job Description
Company: Solerity
Location: Versant Media
Workplace Type: On-site
Employment Type: Full-time
About the Role
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 database migration activities including discovery, assessment, planning, schema conversion, data movement, validation, cutover, rollback planning, and post-migration stabilization.
What You’ll Do / Key Responsibilities
- Migration Assessment & Planning: Lead end-to-end database migration activities including discovery, assessment, planning, schema conversion, data movement, validation, cutover, rollback planning, and post-migration stabilization.
- Cloud Migration Execution: Lead migration of legacy relational databases to approved AWS managed database platforms, including Amazon Aurora PostgreSQL or Aurora MySQL using AWS DMS, SCT, and native utilities.
- Database Conversion & Performance: Convert and remediate database schemas, data types, stored procedures, functions, triggers, sequences, indexes, and queries for target-platform compatibility while optimizing SQL performance.
- Validation & Automation: Develop and execute migration-validation and reconciliation procedures to verify record counts, data relationships, and business rules utilizing SQL, Python, Bash, or PowerShell.
- Security & Delivery: Implement database-specific security controls including least privilege, encryption, secrets management, auditing, and STIG/RMF compliance within GitLab CI/CD pipelines.
Requirements & Qualifications
- 8+ years of experience in database engineering, database administration, database development, data architecture, or database 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.
- Advanced SQL and database-development skills including schemas, stored procedures, functions, triggers, views, indexing, and query optimization.
- Experience with AWS Database Migration Service, AWS Schema Conversion Tool, or comparable migration technologies.
- Experience scripting database and migration activities using SQL, Python, Bash, or PowerShell.
- Active Secret security clearance or the ability to obtain and maintain one.
Preferred Qualifications
- Experience supporting USTRANSCOM, Department of Defense logistics, or another mission-critical federal system.
- Experience migrating large or highly available databases with minimal downtime using change-data capture, replication, or blue-green strategies.
- Relevant cloud, database, or security certifications (AWS, PostgreSQL, Security+, etc.).
Benefits & Perks
- Medical, dental and vision coverage
- Health Savings Accounts and Flexible Spending Accounts
- 401(k) and company-funded life insurance
- Generous Paid Time Off (PTO)
- Tuition and training assistance
- Financial rewards for employee referrals and pet insurance
Solerity is an equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities. Solerity is a VEVRAA Federal Contractor.