Description

SQL Database Architect

[Austin, TX, 78753] |   2022-02-08 16:41:47

Apply Now

Share Job 

Job Code : 3568522DA1

Job Title: Database Architect

Location: Austin, TX

Duration: 12 Months

TWC is migrating one of its high-usage transactional system from a legacy platform to newer technologies in the cloud and requires a Database Architect with proven experience to:

Document the “as is” schemas currently in use at TWC in Informix, and SQL Server databases.

Document existing data interfaces in the legacy system.

Document existing downstream impacts of the legacy system.

Document database process that currently extract the data from the existing system for reporting purposes.

Create data models and reverse and forward engineer data models in an AWS SQL Server environment.

Define and document the technical architecture of the new transactional system, including the physical components and their functionality.

Perform other analysis and documentation tasks as required to facilitate and support this migration project.

Provide oversight and design of the migration and conversion of legacy data to the new database.

WORKER SKILLS AND QUALIFICATIONS

Worker should be qualified to serve as a “Database Architect, Level 1” under the DIR IT Staff Augmentation Contract guidelines.

Minimum Requirements:

YearsSkills/Experience
8Data Architect Role
8Data modeling in SQL Server Enterprise Edition
8Analyzing and generating technical requirements and design
8Creating and maintaining data models
8Database development experience utilizing RDBMS
8Design a SQL Server database for a high usage/high availability transactional system
8Database tuning techniques
8Analyzing source databases, source data, source database referential integrity and profiling source data
6Experience with Informix DBMS
6Experience with MS SQL Server DBMS
2Experience with managing RDBMS in AWS
3Creating source to target mapping documentation

Preferred:

YearsSkills/Experience
4More than one type of RDBMS (DB2, SQLServer, Oracle)

***************************************
Warm Regards,

Vivek J

Sr US IT Recruiter

My3 Tech Inc,

1601 N Harrison Ave, STE # 2B, Pierre, SD 57501

Direct: 605-599-1262 | Board: 605-220-5981 Ext-118 |

E Mail: [email protected]

Education

Any Graduate