user avatar

SQL Migration SME

Semper Valens Solutions

Posted today

Job Requirements

Remote Canyon Lake, TX
Secret Polygraph Unspecified
Mid Level Career (5+ yrs experience)
Salary not specified
Join Premium to unlock estimated salaries

Job Description

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
group id: 90939080
Find Semper Valens Solutions on Social Media
Recruiters
user avatar
About Us
Semper Valens Solutions, INC. is a Service Disabled Veteran Owned Small Business (SDVOSB) providing Enterprise Architecture solutions and Full Life-cycle Support Management to the DoD community. Semper Valens works closely with our customers to solve complex challenges that span engineering, intelligence, technology, and leadership. We provide system engineering and integration methods, techniques, and tools to help intelligence, defense, and commercial entities build and integrate some of the nation's most sophisticated information technology, communications, and mission systems. When complex technical solutions are needed, you need subject matter experts that can help guide your decisions. You need to know that you are exploring the complete range of options, so you can deliver the right solution at the right cost. Semper Valens provides highly knowledgeable engineering expertise to ensure that your mission is successful.

Semper Valens Solutions Jobs


Job Category
IT - Database
Clearance Level
Secret