Database Architect - SQL Server Enterprise
Database Architect - SQL Server Enterprise
Posted on :
27-02-2025
Employer Active
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
RemoteDA2 Closes 03/03
Must be US Citizen Green Card EAD. No H1B
Introduction
The Texas Workforce Commission (TWC) requires the services of one (1) Database Architect Level 2 hereafter referred to as Worker(s) who meets the general qualifications of ITSAC Database Architect Level 2 and the specifications outlined in this document for TWC.
This is a remote position. Ideal candidates must have a secure dedicated workspace with Internet service ability to maintain a reliable consistent work schedule and be available for weekly meetings and group collaboration via Microsoft Teams and other applications during regular business hours. Position may require team members to come into the office for scheduled meetings and there may be unscheduled requests with seventytwo (72) hour notice for any TWC business need. If applicable the work location will be at 101 E. 15th Street Austin Texas 78778.
Scope/Description of Services
The Worker(s) will provide the following services:
Perform Database Architect work as a member of the Data Governance team overseeing one or more projects concurrently. Document the “as is” schemas currently in use at TWC in Structured Query Language (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 extracts the data from the existing system for reporting purposes. Create data models and reverse and forward engineer data models in an Amazon Web Service 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. Perform other duties as assigned to maintain operations.
REQUIRED/PREFERRED SKILLS:
Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity. Years ( leave no
blanks) Years Skills/Experience Vendor Comments (as
applicable) 47 Database Architect Role 47 Data modeling in SQL Server Enterprise Edition 47 Analyzing and generating technical requirements and design 47 Creating and maintaining data models 47 Database development experience utilizing RDBMS 47 Design a SQL Server database for high usage/high availability transactional system 47 Database tuning techniques 47 Analyzing source databases source data source database referential integrity and profiling source data 47 Experience with data mining and archiving 47 Experience with MS SQL Server DBMS 47 Experience with managing RDBMS in AWS or Microsoft Azure 47 Creating source to target mapping database documentation 47 Assist with migrating data from legacy database to new target database
Preferred:
Years Skills/Experience Vendor Comment (as
applicable) 5 More than one type of RDBMS (DB2 SQL Server Oracle) 5 Experience with case management or educational systems State of Texas experience 3 Experience with REST API Services 3 Experience in Amazon Web Services Texas Workforce Commission experience
Must be US Citizen Green Card EAD. No H1B
Introduction
The Texas Workforce Commission (TWC) requires the services of one (1) Database Architect Level 2 hereafter referred to as Worker(s) who meets the general qualifications of ITSAC Database Architect Level 2 and the specifications outlined in this document for TWC.
This is a remote position. Ideal candidates must have a secure dedicated workspace with Internet service ability to maintain a reliable consistent work schedule and be available for weekly meetings and group collaboration via Microsoft Teams and other applications during regular business hours. Position may require team members to come into the office for scheduled meetings and there may be unscheduled requests with seventytwo (72) hour notice for any TWC business need. If applicable the work location will be at 101 E. 15th Street Austin Texas 78778.
Scope/Description of Services
The Worker(s) will provide the following services:
Perform Database Architect work as a member of the Data Governance team overseeing one or more projects concurrently. Document the “as is” schemas currently in use at TWC in Structured Query Language (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 extracts the data from the existing system for reporting purposes. Create data models and reverse and forward engineer data models in an Amazon Web Service 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. Perform other duties as assigned to maintain operations.
REQUIRED/PREFERRED SKILLS:
blanks)
applicable)
Preferred:
applicable)
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
