| TWK_2038 Database Architect2 position with State of Texas | Remote in Texas State | Migrating of high-usage transactional system from a legacy platform experience Required at Remote, Remote, USA |
| Email: [email protected] |
| Share profiles along with Job ID number S E K H A R @ TEKWINGS. COM Note: If this email is not relevant to you, sorry for your Inconvenience Share profiles before: 01 /12/2024 @ 2:00 PM (CT). Requirement details: Internal job ID:TWK_2038Database Architect 2 State of Texas This position is eligible for telecommuting from anywhere in the state of Texas. Candidate must be residing in Texas or willing to relocate to Texas by their start date. This is a remote position Public Sector (State / Federal / Local Govt.) Client Experience Preferred Local to Texas profiles Preferred. Job Description: 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 TWC 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. Minimum Requirements: 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: 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 -- Thanks & Regards Sekhar | Sr.IT Technical Recruiter Tekwings LLC Email : [email protected] / [email protected] New Mobile : +1 ( 214) - 628 - 2379 Note: Facing issues with my old number: 469-900-0456 Hangouts: [email protected] / [email protected] LinkedIn Group: https://www.linkedin.com/groups/10421204/ LinkedIn: https://www.linkedin.com/in/sekhar-u-27b11a166/ Keywords: rlang information technology microsoft Connecticut Idaho |
| [email protected] View all |
| Wed Jan 03 20:46:00 UTC 2024 |