Database ArchitectConsultant for Texas Workforce Commission Austin Tx
Database ArchitectConsultant for Texas Workforce Commission Austin Tx
Posted on :
11-04-2025
Employer Active
1 Vacancy
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
Title: Database Architect/Consultant
Agency: Texas Workforce Commission
Solicitation:DA2
Location: 101 E. 15th Street Austin Texas 78778
Duration: Optional 4 years
Visa: Must be US Citizen Green Card EAD. No H1B
Telework Policy: This is a remote position
JOB DETAILS:
REQUIRED/PREFERRED SKILLS:
The Worker(s) will provide the following services:
All work products resulting from the project shall be considered works made for hire and are the property of TWC. TWC may include preselection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. TWC will pay no fees for interviews or discussions which occur during the process of selecting a Worker(s).
In this specific instance TWC is waiving the restriction against inclusion of resumes for workers already engaged on other contracting efforts. TWC will accept resumes from incumbent vendors to TWC with incumbent Workers for TWC only.
Work Hours and Location
Services shall be provided during normal business hours unless otherwise coordinated through TWC. Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM excluding State holidays when the agency is closed. If the Vendor is headquartered in Texas this position is eligible for telecommuting from within the Continental United States. Conversely if the Vendor is not headquartered in Texas this position is eligible for telecommuting from within Texas only. Vendor employees must obtain approval in writing from their TWC supervisor to take TWC issued equipment to another continental State. Vendor employees are prohibited from taking TWC issued equipment outside of the continental United States. Such action may lead to immediate release from TWC employment.
Any and all travel per diem parking and/or living expenses shall be at the Workers expense.
The Worker(s) may be required to work outside the normal business hours on weekends evenings and holidays as requested. Payment for overtime work (required work hours exceeding the standard forty 40 hours per Business Week) will be at the quoted hourly rate and must be coordinated and preapproved through 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.
Terms of Service
Services are expected to start as soon as possible and are expected to be completed by August 31 2025 or when 1000 total hours estimated on Purchase Order have been depleted whichever occurs first. Total estimated Worker hours for the services shall not exceed 2000 hours per Worker per Term unless otherwise amended renewed and/or extended by TWC via Purchase Order Change Notice. Unused hours may be rolled over from one fiscal year to the next as necessary. Rates are fixed throughout each Term of the Contract.
Term of Contract
TWC anticipates that the Term of the Contract will be one 1 year with four 4 optional oneyear renewals to be exercised by TWC at its sole discretion.
Agency: Texas Workforce Commission
Solicitation:DA2
Location: 101 E. 15th Street Austin Texas 78778
Duration: Optional 4 years
Visa: Must be US Citizen Green Card EAD. No H1B
Telework Policy: This is a remote position
JOB DETAILS:
REQUIRED/PREFERRED SKILLS:
- 4 years Required Database Architect Role
- 4 years Required Data modeling in SQL Server Enterprise Edition
- 4 years Required Analyzing and generating technical requirements and design
- 4 years Required Creating and maintaining data models
- 4 years Required Database development experience utilizing RDBMS
- 4 years Required Design a SQL Server database for high usage/high availability transactional system
- 4 years Required Database tuning techniques
- 4 years Required Analyzing source databases source data source database referential integrity and profiling source data
- 4 years Required Experience with data mining and archiving
- 4 years Required Experience with MS SQL Server DBMS
- 4 years Required Experience with managing RDBMS in AWS or Microsoft Azure
- 4 years Required Creating source to target mapping database documentation
- 4 years Required Assist with migrating data from legacy database to new target database
- 5 years Preferred More than one type of RDBMS (DB2 SQL Server Oracle)
- 5 years Preferred Experience with case management or educational systems State of Texas experience
- 3 years Preferred Experience with REST API Services
- 3 years Preferred Experience in Amazon Web Services
- 1 years Preferred Texas Workforce Commission experience
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.
All work products resulting from the project shall be considered works made for hire and are the property of TWC. TWC may include preselection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. TWC will pay no fees for interviews or discussions which occur during the process of selecting a Worker(s).
In this specific instance TWC is waiving the restriction against inclusion of resumes for workers already engaged on other contracting efforts. TWC will accept resumes from incumbent vendors to TWC with incumbent Workers for TWC only.
Work Hours and Location
Services shall be provided during normal business hours unless otherwise coordinated through TWC. Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM excluding State holidays when the agency is closed. If the Vendor is headquartered in Texas this position is eligible for telecommuting from within the Continental United States. Conversely if the Vendor is not headquartered in Texas this position is eligible for telecommuting from within Texas only. Vendor employees must obtain approval in writing from their TWC supervisor to take TWC issued equipment to another continental State. Vendor employees are prohibited from taking TWC issued equipment outside of the continental United States. Such action may lead to immediate release from TWC employment.
Any and all travel per diem parking and/or living expenses shall be at the Workers expense.
The Worker(s) may be required to work outside the normal business hours on weekends evenings and holidays as requested. Payment for overtime work (required work hours exceeding the standard forty 40 hours per Business Week) will be at the quoted hourly rate and must be coordinated and preapproved through 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.
Terms of Service
Services are expected to start as soon as possible and are expected to be completed by August 31 2025 or when 1000 total hours estimated on Purchase Order have been depleted whichever occurs first. Total estimated Worker hours for the services shall not exceed 2000 hours per Worker per Term unless otherwise amended renewed and/or extended by TWC via Purchase Order Change Notice. Unused hours may be rolled over from one fiscal year to the next as necessary. Rates are fixed throughout each Term of the Contract.
Term of Contract
TWC anticipates that the Term of the Contract will be one 1 year with four 4 optional oneyear renewals to be exercised by TWC at its sole discretion.
Debbie Pedigo
CEO / Senior Staffing Consultant
830.433.4604
210.401.4501
Pedigo Staffing Services
We Are Connected
PedigoStaffing
Proudly serving Texans for 10 years!
CEO / Senior Staffing Consultant
830.433.4604
210.401.4501
Pedigo Staffing Services
We Are Connected
PedigoStaffing
Proudly serving Texans for 10 years!
Required Experience:
Contract
Employment Type
Commission
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.
