Database Administrator Cloud & Migration Specialist

POSITION REQUIREMENTS:

We are seeking an experienced Database Administrator with a strong AWS cloud background who will also work in Microsoft Azure environments. The primary focus of this role is assisting with the migration of DB2 data to Microsoft SQL Server and maintaining SQL Server databases to support the operations of the clients primary database systems.

This role will play a key part in the migration from DB2 to SQL Server, as well as the ongoing synchronization between legacy data sources and the CITS system. The legacy data source resides in Azure SQL, and the CITS system uses PowerPlatform CDS/Dataverse. You will manage a bidirectional sync between these data sources, handle data type conversions, resolve collisions in dual-source environments, and ensure overall system integrity.

The ideal candidate will also support distributed applications that typically operate on batch updates, which will be impacted by the migration. Experience converting Oracle databases to Microsoft SQL Server is highly desirable, and familiarity with Amazon Relational Database Service (RDS) is required.

Key Responsibilities:

• Assist in migrating DB2 and Oracle data to Microsoft SQL Server in Azure and AWS environments.

• Maintain, monitor, and optimize Microsoft SQL Server databases for operational efficiency.

• Manage bidirectional synchronization between Azure SQL and PowerPlatform CDS/Dataverse.

• Perform data type conversions and resolve collisions in dual-source database systems.

• Support distributed applications impacted by database migrations and updates.

• Utilize best practices for cloud database management, including AWS RDS and Azure SQL environments.

• Collaborate with application and infrastructure teams to ensure seamless integration and performance.

Required Skills and Experience:

• Strong AWS cloud experience, including Amazon RDS management.

• Experience with Microsoft Azure services, including VM and on-premises SQL Servers.

• Expertise in Microsoft SQL Server, including SQL Server Management Studio, Azure Data Studio, and SQL Server Integration Services (SSIS).

• Experience migrating or converting Oracle databases to SQL Server.

• Familiarity with Azure Service Bus and other integration tools.

• Understanding of dual-source data synchronization, collision management, and data type conversions.

• Strong troubleshooting, problem-solving, and communication skills.

Preferred:

• Hands-on experience with cloud migrations between AWS and Azure.

• Knowledge of PowerPlatform CDS/Dataverse integrations.