Huntsville, TX, US
We are seeking a DBA/ Database Developer to work from anywhere in the US on our W2 assisting our Huntsville, Texas client's efforts in migrating their DB2 data to Microsoft SQL Server in the Azure environment. This position will be responsible for maintaining Microsoft databases for operation of our client's primary database.
You will be involved with their migration from DB2 to SQL, and the ongoing sync between their legacy data source and their new system. The legacy data source is Azure SQL, and the new system is PowerPlatform CDS/Dataverse. There will be a bidirectional sync between these two data sources. This DBA position should be versed in data type conversions that need to occur between the two systems, familiar with managing collisions that may occur in a dual data source system and generally help manage this setup.
They also have ongoing support needs for their distributed applications. These systems are typically updated on a batch basis and will be impacted by their migration.
What specific software do you need to know
• SQL Server Management Studio
• Azure Data Studio
• Azure service bus
• SQL Server Integration Services (SSIS)
• Azure experience across VM's and on-premises SQL Servers