Senior Database Migration Engineer; Secret Clearance

Solerity is seeking a Senior Database Migration Engineer to support IGC software-development, application-modernization, and database-development activities.

• 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.

• 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.

• 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.

• 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.

• Eight (8+) or more years of experience in database engineering, database administration, database development,…