SQL Migration SMEFull Time, Remote, San Antonio, TX areaSecret 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 ResponsibilitiesAssess existing database architecture, schemas, and dependencies to develop comprehensive migration strategies and roadmapsDesign 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 migrationDevelop and execute ETL (Extract, Transform, Load) processes using tools such as SSIS, Azure Data Factory, AWS DMS, or custom scriptsConduct pre-migration testing, including performance benchmarking, compatibility assessments, and risk analysisOptimize queries, indexes, and stored procedures for performance in the new environmentCoordinate cutover activities, including rollback planning and post-migration validationCollaborate with application teams, DBAs, and infrastructure engineers to minimize business disruptionDocument migration procedures, technical specifications, and lessons learnedEnsure compliance with data governance, security, and regulatory requirements (e.g., GDPR, HIPAA, SOC 2) throughout the migration processProvide post-migration support, troubleshooting, and knowledge transfer to operations teamsMonitor and tune database performance following migration completionRequired QualificationsBachelor'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 administrationDemonstrated 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 languagesExperience with ETL tools (SSIS, Informatica, Azure Data Factory, AWS DMS, or similar)Solid understanding of database backup, restore, and disaster recovery proceduresFamiliarity with cloud database platforms (Azure SQL Database, AWS RDS/Aurora, Google Cloud SQL)Strong analytical and problem-solving skills with attention to detailExcellent 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 EmployerSemper 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