> Markdown version of [/jobs/ext/3091616-senior-database-migration-engineer-secret-clearance](https://www.wearedevelopers.com/jobs/ext/3091616-senior-database-migration-engineer-secret-clearance). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Database Migration Engineer (Secret Clearance) - **Company:** Solerity - **Location:** Scott Air Force Base, IL, United States (Remote available) - **Experience:** Expert - **Salary:** $130,000.0 - $145,000.0 - **Contract:** Permanent contract - **Skills:** Legacy Database, Application Programming Interfaces (APIs), Amazon Web Services, Apache HTTP Server, Bash Shell, Business Intelligence Development, Cloud Computing Security, Cloud Engineering, Configuration Management, CompTIA Security+, Cyber Security, Information Systems, Databases, Continuous Integration, Data Architecture, Data Dictionary, Data Integrity, Extract Transform Load (ETL), Relational Databases, Database Development, Database Security, Failover, Python (Programming Language), Key Management, PostgreSQL, Liquibase, Microsoft Security Essentials, Microsoft Software, Microsoft SQL Server, MySQL, Oracle (Applications), Windows PowerShell, Query Optimization, Role-Based Access Control, Software Engineering, SQL Stored Procedures, SQL Databases, Teradata SQL, Software Vulnerability Management, Data Logging, Scripting, Sql Optimization, System Availability, Database Optimization, Change Data Capture, Indexer, Git, SC Clearance, Database Migration, Amazon Relational Database Service, Gitlab-ci, Information Technology, Devsecops, Database Tools and Utilities - **Published:** September 26, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/18445877?backUrl=%2Fcareer%2F18445877%2FSenior-Database-Migration-Engineer-Secret-Clearance-Illinois-Scott-Air-Force-Base ## About the Role * Eight (8+) or more 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. * Experience with AWS Database Migration Service, AWS Schema Conversion Tool, native database utilities, or comparable migration technologies. * Advanced SQL and database-development skills including schemas, stored procedures, functions, triggers, views, indexing, and query optimization. * Experience converting schemas and remediating incompatible data types, queries, procedural code, and application dependencies. * Experience developing migration validation, reconciliation, and data-quality controls. * Experience with database performance tuning, backup, recovery, replication, high availability, and production stabilization. * Experience scripting database and migration activities using SQL, Python, Bash, PowerShell, or a comparable language. * Experience using Git and automated database deployment or CI/CD processes. * Knowledge of database security, access control, encryption, auditing, secure configuration, and vulnerability remediation. * Strong technical leadership, troubleshooting, documentation, and stakeholder-communication skills. * Active Secret security clearance or the ability to obtain and maintain one, as required by assigned duties and contract requirements. Education / Workforce Qualification * 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: Certified Cloud Security Professional (CCSP), CyberSec First Responder (CFR), Federal IT Security Professional-Manager (FITSP-M), GIAC Security Essentials Certification (GSEC), CompTIA Security+, or Systems Security Certified Practitioner (SSCP). 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, blue-green, or phased migration techniques. * Experience with Oracle and PostgreSQL/Aurora modernization; familiarity with Teradata or other large-scale enterprise data-warehouse platforms is beneficial where applicable. * Experience supporting analytics or BI platforms, including Apache Superset, using migrated relational data sources. * Familiarity with containerized application environments and infrastructure-as-code processes used by cloud/DevSecOps teams. * AWS, PostgreSQL, Oracle, Microsoft, Security+, or related database/cloud certifications. Work Location Hybrid. Remote work may be authorized consistent with program requirements. Personnel must be available for required on-site migration planning, testing, cutover, classified-system access, technical reviews, or meetings at Scott AFB, Illinois. ## Description 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, PowerShell, Liquibase, Flyway, or comparable technologies. * Integrate database changes, migration scripts, validation routines, and deployment controls into established GitLab 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/DevSecOps engineers, cybersecurity personnel, testers, functional analysts, operations staff, and Government stakeholders. ## Related Videos - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [AWS Migration within 3 months](https://www.wearedevelopers.com/videos/196-aws-migration-within-3-months) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Postgres in the Age of AI (and Devin)](https://www.wearedevelopers.com/videos/1042-postgres-in-the-age-of-ai-and-devin) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer)