Job Description
Company: Solerity
Location: Columbus, OH
Workplace Type: Hybrid
Employment Type: Full-time
Pay / Compensation: $130k – $145k
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.
- Platform Migration: Lead migration of legacy relational databases to approved AWS managed database platforms, including Amazon Aurora PostgreSQL or Aurora MySQL using AWS Database Migration Service (DMS), AWS Schema Conversion Tool (SCT), and native database utilities.
- Database Conversion & Optimization: Convert and remediate database schemas, data types, stored procedures, functions, triggers, sequences, indexes, and queries for target-platform compatibility. Analyze execution plans, workloads, locks, connections, and database metrics to resolve performance and scalability issues.
- Validation & Automation: Develop and execute migration-validation and reconciliation procedures to verify record counts, referential integrity, and functional equivalence. Develop database and migration automation using SQL, Python, Bash, or PowerShell.
- Secure Delivery & Integration: Integrate database changes, migration scripts, and deployment controls into established GitLab CI/CD processes. Implement database-specific security controls including least privilege, encryption, auditing, and STIG/RMF compliance.
- Technical Leadership: Prepare and maintain database architecture diagrams, data models, and operational runbooks while providing technical leadership and mentoring to database administrators, developers, and cloud engineers.
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.
- Experience migrating Oracle, PostgreSQL, MySQL, SQL Server, or comparable enterprise relational databases to cloud-managed database platforms.
- Advanced SQL and database-development skills including schemas, stored procedures, functions, triggers, views, indexing, and query optimization.
- Experience scripting database and migration activities using SQL, Python, Bash, or PowerShell.
- Knowledge of database security, access control, encryption, auditing, secure configuration, and vulnerability remediation.
- Active Secret security clearance or the ability to obtain and maintain one.
Preferred / Bonus Qualifications (if applicable)
- 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, blue-green, or phased migration techniques.
- Experience with Oracle and PostgreSQL/Aurora modernization; familiarity with Teradata or other large-scale enterprise data-warehouse platforms.
- AWS, PostgreSQL, Oracle, Microsoft, Security+, or related database/cloud certifications.
Education Requirements
- A bachelor’s degree in Computer Science, Cybersecurity, Data Science, Software Engineering, Information Technology, Information Systems, or a related software-engineering discipline; OR
- One of the following current certifications: CCSP, CFR, FITSP-M, GSEC, CompTIA Security+, or SSCP.
Benefits & Perks
- Medical, dental, and vision coverage
- Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA)
- 401(k) and company-funded life insurance
- Generous Paid Time Off (PTO)
- Tuition and training assistance
- Financial rewards for employee referrals, pet insurance, and employee discount program
Solerity is an equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities. Solerity is a VEVRAA Federal Contractor.