Senior Database Migration Engineer (Hybrid) (Secret Clearance)

Solerity is seeking a Senior Database Migration Engineer to support IGC software-development, application-modernization, and database-development activities. Migration Assessment, Planning & Execution Lead end-to-end database migration activities including discovery, assessment, planning, schema conversion, data movement, validation, cutover, rollback planning, and post-migration stabilization. Assess legacy database platforms, schemas, data volumes, stored procedures, functions, triggers, indexes, interfaces, application dependencies, security controls, and performance requirements. Develop migration strategies, technical plans, schedules, risk assessments, source-to-target mappings, validation criteria, cutover procedures, rollback procedures, and operational runbooks. Lead migration of legacy relational databases to approved AWS managed database platforms, including Amazon Aurora PostgreSQL or Aurora MySQL where implemented. Use AWS Database Migration Service, AWS Schema Conversion Tool, native database utilities, and custom scripts, or comparable approved tools, to support full-load, incremental, change-data-capture, and low-downtime migration approaches. Database Conversion, Compatibility & Performance Convert and remediate database schemas, data types, stored procedures, functions, triggers, sequences, indexes, queries, and proprietary database features for target-platform compatibility. Analyze and remediate application, ETL, BI, API, and interface dependencies affected by database-platform changes, coordinating required code and query changes with the applicable development teams. Develop and optimize SQL queries, views, functions, stored procedures, indexes, and other database objects supporting application and reporting requirements. Analyze execution plans, workloads, locks, connections, database metrics, and resource utilization to resolve performance and scalability issues. Define database-layer requirements for availability, resiliency, replication, backup, recovery, failover, and performance within the approved IGC cloud architecture. Validation, Automation & Secure Delivery Develop and execute migration-validation and reconciliation procedures to verify record counts, data relationships, business rules, transformations, calculations, referential integrity, completeness, accuracy, and functional equivalence between source and target platforms. Identify data-quality issues and coordinate cleansing, correction, exception handling, and remediation activities with the appropriate data owners and technical teams. Develop database and migration automation using SQL, Python, Bash, Power Shell, Liquibase, Flyway, or comparable technologies. Integrate database changes, migration scripts, validation routines, and deployment controls into established Git Lab CI/CD and configuration-management processes. Implement database-specific security controls including least privilege, encryption, secrets management, logging, auditing, secure configuration, vulnerability remediation, and applicable STIG/RMF evidence. Documentation & Technical Leadership Prepare and maintain database architecture diagrams, data models, data dictionaries, source-to-target mappings, configuration documentation, migration reports, cutover documentation, and operational procedures. Provide technical leadership and mentoring to database administrators, developers, cloud engineers, and migration team members. Collaborate with application developers, ETL/data engineers, BI developers, cloud/Dev Sec Ops engineers, cybersecurity personnel, testers, functional analysts, operations staff, and Government stakeholders.