Description

Lead technical architecture and data migration for a high-usage transactional system moving from legacy platforms to AWS.

Responsibilities

• Document existing SQL Server and Oracle schemas, data interfaces, and downstream impacts.
• Create, reverse engineer, and forward engineer data models within an AWS SQL Server environment.
• Define the technical architecture for the new transactional system, including physical components.
• Design and oversee the migration of legacy data to the new platform using custom conversion scripts.
• Map existing data extraction processes used for reporting and ensure referential integrity.

Required Skills

• 7+ years of experience creating and maintaining data models.
• 7+ years of database development experience utilizing RDBMS.
• 7+ years of experience with MS SQL Server DBMS.
• 7+ years of experience analyzing source databases, data profiling, and referential integrity.
• 5+ years of data modeling in SQL Server Enterprise Edition.
• 5+ years of experience designing SQL Server databases for high-availability transactional systems.
• 5+ years of experience creating source-to-target mapping documentation.
• 5+ years of experience assisting with legacy database migrations.
• 3+ years of experience managing RDBMS in AWS.

Preferred Skills

• Experience with DB2, SQL Server, or Oracle.
• Experience with REST API Services and Appian Record Types.

Key Skills

Education

Any Graduate