SQL Migration SME- AFMETS

SQL Migration SME Full Time, Remote, San Antonio, TX area Secret Clearance **This position is contingent upon contract award** Overview: Semper Valens Solutions is seeking an experienced SQL Migration Specialist to lead and execute the migration of critical database systems as part of our infrastructure modernization initiative. This role will be responsible for planning, designing, and implementing the migration of on-premises and legacy SQL databases to modern platforms (e.g., cloud-based solutions such as Azure SQL, AWS RDS, or Google Cloud SQL, and/or upgraded on-premises environments). The ideal candidate combines deep technical database expertise with strong project execution skills to ensure minimal downtime, data integrity, and performance optimization throughout the migration lifecycle. Key Responsibilities Assess existing database architecture, schemas, and dependencies to develop comprehensive migration strategies and roadmaps Design and execute migration plans for SQL Server, MySQL, PostgreSQL, or Oracle databases to target environments (cloud or on-premises) Perform data mapping, transformation, and validation to ensure accuracy and completeness during migration Develop and execute ETL (Extract, Transform, Load) processes using tools such as SSIS, Azure Data Factory, AWS DMS, or custom scripts Conduct pre-migration testing, including performance benchmarking, compatibility assessments, and risk analysis Optimize queries, indexes, and stored procedures for performance in the new environment Coordinate cutover activities, including rollback planning and post-migration validation Collaborate with application teams, DBAs, and infrastructure engineers to minimize business disruption Document migration procedures, technical specifications, and lessons learned Ensure compliance with data governance, security, and regulatory requirements (e.g., GDPR, HIPAA, SOC 2) throughout the migration process Provide post-migration support, troubleshooting, and knowledge transfer to operations teams Monitor and tune database performance following migration completion Required Qualifications Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent practical experience) 4+ years of hands-on experience with SQL Server, MySQL, PostgreSQL, or Oracle database administration Demonstrated experience executing at least one large-scale database migration project (on-premises to cloud, version upgrade, or platform migration) Strong proficiency in T-SQL, PL/SQL, or equivalent query languages Experience with ETL tools (SSIS, Informatica, Azure Data Factory, AWS DMS, or similar) Solid understanding of database backup, restore, and disaster recovery procedures Familiarity with cloud database platforms (Azure SQL Database, AWS RDS/Aurora, Google Cloud SQL) Strong analytical and problem-solving skills with attention to detail Excellent written and verbal communication skills for cross-functional collaboration About Semper Valens Solutions: Semper Valens Solutions, Inc. (SVS) is a Service-Disabled Veteran Owned Small Business (SDVOSB) providing Cost Effective Software and Systems Engineering, Field Support, Training and Full Life cycle Support Management to the DOD and VA community. At Semper Valens, our vision is to remain a creative, cutting edge and cost-effective solutions provider where our shared intellect, industry experience, and technology excellence, make a positive difference in our customer's success. Our solutions help bridge the gap between IT and business prioritizations to optimize budgets, risks and operational processes. We search for outstanding technical professionals, hiring at all levels of the experience spectrum; intermediate, journeyman and senior. Consider us for your career plan. Semper Valens Solutions is an Equal Opportunity Employer Semper Valens Solutions proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital/parental status, pregnancy/childbirth, or related conditions, physical or mental disability, genetic information, status as a Disabled Veteran, Recently Separated Veteran, Active-Duty Wartime or Campaign Badge Veteran, Armed Forces Services Medal, or any other characteristic protected by law. If you require a reasonable accommodation to apply for a position with Semper Valens Solutions through its online applicant system, please contact Semper Valens Solutions Human Resources Department at (830) 899-6870. Semper Valens Solutions is an affirmative action/equal opportunity employer - minorities, females, disabled, and protected veterans are urged to apply. Applicants have rights under Federal Employment Laws. All Jobs at Semper Valens Solutions: https://sempervalens.com/careers