SQL Server Datacenter Migration Specialist
Worldwide
Description: 1. Assess the existing SQL Server estate, including databases, logins, SQL Agent jobs, linked servers, SSIS/SSRS dependencies, backup strategy, HA/DR setup, storage requirements, and application connectivity. 2. Develop a migration strategy for approximately 150 SQL Server servers and 200 TB of data, including migration waves, sequencing, risk assessment, downtime planning, and rollback approach. 3. Create detailed migration runbooks, cutover checklists, validation steps, and rollback procedures. 4. Automate repeatable migration tasks using PowerShell, T-SQL, dbatools, or similar automation frameworks. 5. Support SQL Server migrations using backup/restore, log shipping, Always On Availability Groups, replication, Azure migration tools, or other suitable methods. 6. Assist with Azure migration planning, including networking, security, backup, monitoring, sizing, performance, and cost considerations. 7. Migrate server-level objects such as logins, users, SQL Agent jobs, credentials, linked servers, certificates, encryption keys, and configuration settings. 8. Perform pre- and post-migration validation, including DBCC checks, row counts, application smoke testing, performance comparison, Query Store review, and monitoring. Please Include in Your Proposal: 1. A brief summary of your SQL Server migration experience. 2. Examples of large-scale datacenter or Azure migration projects you have supported. 3. Your experience with SQL Server 2019/2022. 4. Your experience with PowerShell, dbatools, or migration automation and experience with tools used or automation? 5. Your preferred migration approach for moving SQL Server workloads from one datacenter to another. 6. Your experience with Azure SQL migration options. 7. Any sample migration checklist, runbook structure, or automation approach you have used previously. 8. Examples of challenges encountered during the migration and cutover
- More than 30 hrs/weekHourly
- 3-6 monthsDuration
- ExpertExperience Level
$65.00
-
$80.00
Hourly- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:last week
- Interviewing:21
- Invites sent:0
- Unanswered invites:0
About the client
- CanadaBrampton5:07 PM
- $720 total spent4 hires, 2 active
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by