What are the responsibilities and job description for the Database Architect/Consultant for Texas Workforce Commission, Austin, Tx position at Pedigo Staffing Services?
Title: Database Architect/Consultant
Agency: Texas Workforce Commission
Solicitation: 5098025DA2
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 pre-selection 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 Worker’s 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 pre-approved 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 seventy-two (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 1,000 total hours estimated on Purchase Order have been depleted, whichever occurs first. Total estimated Worker hours for the services shall not exceed 2,000 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 one-year renewals to be exercised by TWC at its sole discretion.
Agency: Texas Workforce Commission
Solicitation: 5098025DA2
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 pre-selection 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 Worker’s 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 pre-approved 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 seventy-two (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 1,000 total hours estimated on Purchase Order have been depleted, whichever occurs first. Total estimated Worker hours for the services shall not exceed 2,000 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 one-year renewals to be exercised by TWC at its sole discretion.
