← Back to jobs

My3Tech Logo
Database Architect

My3Tech

 

Austin, TX 73301, USA

Posted On: 2 days ago
Experience: 5+ years
Availability: Hybrid
Openings: 2
Category: Database Architect
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

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.
  • Reverse engineer, forward engineer, and create 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 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.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs