Description
Database Architect 2
[Austin, TX, 73301] | 2024-01-08 12:02:48
Share Job
Job Code : 2024-MY3TECH0006
Database Architect 2
Austin, TX (Remote within US)
8 months Contract with possibility to extension
Client 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 Client in SQL Server databases and Oracle 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.
- Create scripts for data conversion and migration from legacy systems to new database platform.
Required Skills and Qualifications:
| Years | Skills/Experience |
| 3 | Data Architect Role |
| 5 | Data modeling in SQL Server Enterprise Edition |
| 5 | Analyzing and generating technical requirements and design |
| 7 | Creating and maintaining data models |
| 7 | Database development experience utilizing RDBMS |
| 7 | Design a SQL Server database for high usage/high availability transactional system |
| 5 | Database tuning techniques |
| 7 | Analyzing source databases, source data, source database referential integrity and profiling source data |
| 3 | Experience with data mining and archiving |
| 7 | Experience with MS SQL Server DBMS |
| 3 | Experience with managing RDBMS in AWS |
| 5 | Creating source to target mapping database documentation |
| 5 | Assist with migrating data from legacy database to new target database |
Preferred Skills and Qualifications:
| Years | Skills/Experience |
| 5 | More than one type of RDBMS (DB2, SQL Server, Oracle) |
| 5 | Experience with case management or educational systems |
| 3 | Experience with REST API Services |
| 3 | Experience in Amazon Web Services |
| 3 | Appian Record Types |
Education
Any Graduate
- Posted On: 10-Apr-2024
- Experience: 5+ years of experience
- Openings: 2
- Category: Database Architect
- Tenure: Contract - Corp-to-Corp Position