Solerity

<p>Key Responsibilities</p>
<h2><strong>Migration Assessment, Planning &amp; Execution</strong></h2>
<ul>
<li>Lead end-to-end database migration activities including discovery, assessment, planning, schema conversion, data movement, validation, cutover, rollback planning, and post-migration stabilization.</li>
<li>Assess legacy database platforms, schemas, data volumes, stored procedures, functions, triggers, indexes, interfaces, application dependencies, security controls, and performance requirements.</li>
<li>Develop migration strategies, technical plans, schedules, risk assessments, source-to-target mappings, validation criteria, cutover procedures, rollback procedures, and operational runbooks.</li>
<li>Lead migration of legacy relational databases to approved AWS managed database platforms, including Amazon Aurora PostgreSQL or Aurora MySQL where implemented.</li>
<li>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.</li>
</ul>
<h2><strong>Database Conversion, Compatibility &amp; Performance</strong></h2>
<ul>
<li>Convert and remediate database schemas, data types, stored procedures, functions, triggers, sequences, indexes, queries, and proprietary database features for target-platform compatibility.</li>
<li>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.</li>
<li>Develop and optimize SQL queries, views, functions, stored procedures, indexes, and other database objects supporting application and reporting requirements.</li>
<li>Analyze execution plans, workloads, locks, connections, database metrics, and resource utilization to resolve performance and scalability issues.</li>
<li>Define database-layer requirements for availability, resiliency, replication, backup, recovery, failover, and performance within the approved IGC cloud architecture.</li>
</ul>
<h2><strong>Validation, Automation &amp; Secure Delivery</strong></h2>
<ul>
<li>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.</li>
<li>Identify data-quality issues and coordinate cleansing, correction, exception handling, and remediation activities with the appropriate data owners and technical teams.</li>
<li>Develop database and migration automation using SQL, Python, Bash, PowerShell, Liquibase, Flyway, or comparable technologies.</li>
<li>Integrate database changes, migration scripts, validation routines, and deployment controls into established GitLab CI/CD and configuration-management processes.</li>
<li>Implement database-specific security controls including least privilege, encryption, secrets management, logging, auditing, secure configuration, vulnerability remediation, and applicable STIG/RMF evidence.</li>
</ul>
<h2><strong>Documentation &amp; Technical Leadership</strong></h2>
<ul>
<li>Prepare and maintain database architecture diagrams, data models, data dictionaries, source-to-target mappings, configuration documentation, migration reports, cutover documentation, and operational procedures.</li>
<li>Provide technical leadership and mentoring to database administrators, developers, cloud engineers, and migration team members.</li>
<li>Collaborate with application developers, ETL/data engineers, BI developers, cloud/DevSecOps engineers, cybersecurity personnel, testers, functional analysts, operations staff, and Government stakeholders.</li>
</ul>
<h1><strong>Required Qualifications</strong></h1>
<ul>
<li>Eight (8+) or more years of experience in database engineering, database administration, database development, data architecture, or database migration.</li>
<li>Demonstrated experience leading complex enterprise database migrations from assessment through production cutover and stabilization.</li>
<li>Hands-on experience with Amazon Aurora PostgreSQL, Aurora MySQL, Amazon RDS, or comparable managed relational database services.</li>
<li>Experience migrating Oracle, PostgreSQL, MySQL, SQL Server, or comparable enterprise relational databases to cloud-managed database platforms.</li>
<li>Experience with AWS Database Migration Service, AWS Schema Conversion Tool, native database utilities, or comparable migration technologies.</li>
<li>Advanced SQL and database-development skills including schemas, stored procedures, functions, triggers, views, indexing, and query optimization.</li>
<li>Experience converting schemas and remediating incompatible data types, queries, procedural code, and application dependencies.</li>
<li>Experience developing migration validation, reconciliation, and data-quality controls.</li>
<li>Experience with database performance tuning, backup, recovery, replication, high availability, and production stabilization.</li>
<li>Experience scripting database and migration activities using SQL, Python, Bash, PowerShell, or a comparable language.</li>
<li>Experience using Git and automated database deployment or CI/CD processes.</li>
<li>Knowledge of database security, access control, encryption, auditing, secure configuration, and vulnerability remediation.</li>
<li>Strong technical leadership, troubleshooting, documentation, and stakeholder-communication skills.</li>
<li>Active Secret security clearance or the ability to obtain and maintain one, as required by assigned duties and contract requirements.</li>
</ul>
<h1><strong>Education / Workforce Qualification</strong></h1>
<ul>
<li>A bachelor’s degree in Computer Science, Cybersecurity, Data Science, Software Engineering, Information Technology, Information Systems, or a related software-engineering discipline; <strong>or</strong></li>
<li>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).</li>
</ul>
<h1><strong>Preferred Qualifications</strong></h1>
<ul>
<li>Experience supporting USTRANSCOM, Department of Defense logistics, or another mission-critical federal system.</li>
<li>Experience migrating large or highly available databases with minimal downtime using change-data capture, replication, blue-green, or phased migration techniques.</li>
<li>Experience with Oracle and PostgreSQL/Aurora modernization; familiarity with Teradata or other large-scale enterprise data-warehouse platforms is beneficial where applicable.</li>
<li>Experience supporting analytics or BI platforms, including Apache Superset, using migrated relational data sources.</li>
<li>Familiarity with containerized application environments and infrastructure-as-code processes used by cloud/DevSecOps teams.</li>
<li>AWS, PostgreSQL, Oracle, Microsoft, Security+, or related database/cloud certifications.</li>
</ul>
<h1><strong>Work Location</strong></h1>
<p><strong>Hybrid.</strong> 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.</p>


Senior Database Migration Engineer (Secret Clearance)

Senior Database Migration Engineer (Secret Clearance)

This job is no longer available

Talents

Recruiters

About