Overview
Remote
$80 - $90
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required
Skills
Database Administration (DBA)
SQL Server
Azure SQL
Azure SQL Managed Instance
Platform as a Services (PaaS)
Infrastructure as a Service (IaaS)
Virtual Machines
Disaster Recovery
Performance Tuning
Database Development
Azure Migration
Azure Data Factory (ADF)
Azure Data Lake
T-SQL
Job Details
Resource 1 is in need of an Azure SQL Database Migration Engineer for a remote 1-year contract (plus extensions). Individual will oversee and execute the migration of our client's SQL Server infrastructure from SQL Virtual Machines (VMs) on Infrastructure-as-a-Service (IaaS) to Azure SQL Managed Instances (MI) on Platform-as-a-Service (PaaS). Migration will include a lift-and-shift of 50 SQL Server databases, 350 SSIS packages, and Power BI dashboards/ reports. This role requires deep expertise in Azure, SQL Server administration, and migration strategies.
Responsibilities:
- Develop a comprehensive migration plan from SQL VM IaaS to Azure SQL MI PaaS, considering factors such as database size, performance requirements, and downtime constraints.
- Analyze cost/ spend in Azure and develop recommendations to right-size data infrastructure.
- Assess current SQL Server configurations, dependencies, and performance metrics to optimize for the new PaaS environment.
- Lead the execution of the migration plan, ensuring minimal disruption to ongoing operations.
- Configure and deploy Azure SQL Managed Instances, ensuring compatibility with existing applications and systems.
- Engineer ETL and data movement solutions using Azure Data Factory, SSIS on Azure, Azure Data Lake Storage, Azure Data Factory, Data Lake Analytics, Azure Blob Storage, Azure Analysis Service (AAS), and Azure Key Vault.
- Perform data migration and schema transfers, verifying data integrity and maintaining high availability during the transition.
- Conduct performance tuning and optimization of Azure SQL MI post-migration to ensure optimal database performance.
- Implement monitoring mechanisms to proactively identify and resolve performance bottlenecks.
- Implement security best practices for Azure SQL MI, including access controls, encryption, and compliance with industry standards.
- Document migration process, technical architecture, configurations, and operational procedures for Azure SQL MI PaaS.
Qualifications:
- 10+ years of IT experience.
- 3-5 years of experience with Azure, including data transformation and architecture, Azure Data Lake Services (ADLS), Data Lake Analytics, Azure Data Factory (ADF), Stream Analytics, Datacenter Migration, and Azure Data Services.
- Proven experience managing SQL Server VMs and migrating to Azure SQL MI PaaS.
- Prior experience migrating SSIS packages and Power BI dashboards/ reports to Azure.
- Understanding of SQL Server internals, performance monitoring, and tuning/ optimization.
- Experience with Azure SQL Managed Instances, including setup, configuration, and administration.
- SQL scripting skills and proficiency in T-SQL.
- Familiarity with cloud migration methodologies, tools, and best practices.
- Strong communication skills, including the ability to explain technical concepts to non-technical individuals.
- Knowledge of networking and permissions concepts.
Medical insurance and a 401(k) plan is offered to all eligible W2 employees.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.