SQL Server Datacenter Migration Specialist

Posted last week

Worldwide

Summary

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/week
    Hourly
  • 3-6 months
    Duration
  • Expert
    Experience Level
  • $65.00

    -

    $80.00

    Hourly
  • Remote Job
  • Ongoing project
    Project Type

Contract-to-hire opportunity

This lets talent know that this job could become full time.
Learn more
Skills and Expertise
Mandatory skills
Microsoft Windows PowerShell
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
Member since Dec 27, 2022
  • Canada
    Brampton5:07 PM
  • $720 total spent
    4 hires, 2 active

Explore similar jobs on Upwork

Symfonia data migration to SystimHourly‐ Posted 2 weeks ago
Database Administration
Database Design
Data Migration
SQL
Data Integration
SQL server architectHourly‐ Posted 2 days ago
Microsoft SQL Server Administration
SQL
Microsoft SQL Server
Microsoft SQL Server Programming
MySQL Programming
SQL Server Integration Services
Database Administration

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers 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

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo