> Markdown version of [/jobs/ext/2542398-sql-migration-sme](https://www.wearedevelopers.com/jobs/ext/2542398-sql-migration-sme). 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).

---

# SQL Migration SME

- **Company:** Semper Valens Solutions, Inc.
- **Location:** San Antonio, TX, United States (Remote available)
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Amazon Web Services, Cloud Computing, Cloud Database, Information Systems, Databases, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Mapping, Query Languages, Disaster Recovery, PostgreSQL, Microsoft SQL Server, SQL Azure, MySQL, Oracle Databases, Performance Tuning, SQL Stored Procedures, PL-SQL, SQL Databases, SQL Server Integration Services, Transact-SQL, Scripting, Google Cloud, Azure Data Factory, Informatica Powercenter, Database Performance, Database Migration, Amazon Relational Database Service, Information Technology, Database Backup
- **Published:** August 24, 2026
- **Apply:** https://www.clearancejobs.com/jobs/9114034/sql-migration-sme

## About the Role

* 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

## Description

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., * 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


## Related Videos

- [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Migrating half a million users to a new payment service provider](https://www.wearedevelopers.com/videos/730-migrating-half-a-million-users-to-a-new-payment-service-provider)
- [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)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app)

## Related Articles

- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)
- [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)