Database Architect/Consultant for Texas Workforce Commission, Austin, Tx

Pedigo Staffing Services; Austin (TX); Remote; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled Database Architect/Consultant to join their Data Governance team. This remote position offers the opportunity to work on high-impact projects, focusing on database architecture, data modeling, and migration strategies. Ideal candidates will have extensive experience with SQL Server and RDBMS, ensuring high availability and performance of databases. You will play a crucial role in documenting existing systems and defining the architecture for new transactional systems. This role is perfect for those who thrive in collaborative environments and are looking to make a significant impact in the field of data governance.

Qualifications

• 4+ years as a Database Architect with experience in SQL Server and RDBMS.
• Proficient in data modeling, migration, and database tuning techniques.

Responsibilities

• Oversee database architecture and migration projects for TWC.
• Document existing schemas, data interfaces, and impacts of legacy systems.

Skills

Database Architect Role

Data modeling in SQL Server Enterprise Edition

Analyzing technical requirements and design

Creating and maintaining data models

Database development with RDBMS

Designing SQL Server databases for high availability

Database tuning techniques

Analyzing source databases and data integrity

Data mining and archiving

Experience with MS SQL Server DBMS

Managing RDBMS in AWS or Microsoft Azure

Creating source to target mapping documentation

Migrating data from legacy to new databases

Experience with REST API Services

Experience in Amazon Web Services

Tools

SQL Server

AWS

Oracle

Job description

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:

1. 4 years, Required - Database Architect Role
2. 4 years, Required - Data modeling in SQL Server Enterprise Edition
3. 4 years, Required - Analyzing and generating technical requirements and design
4. 4 years, Required - Creating and maintaining data models
5. 4 years, Required - Database development experience utilizing RDBMS
6. 4 years, Required - Design a SQL Server database for high usage/high availability transactional system
7. 4 years, Required - Database tuning techniques
8. 4 years, Required - Analyzing source databases, source data, source database referential integrity and profiling source data
9. 4 years, Required - Experience with data mining and archiving
10. 4 years, Required - Experience with MS SQL Server DBMS
11. 4 years, Required - Experience with managing RDBMS in AWS or Microsoft Azure
12. 4 years, Required - Creating source to target mapping database documentation
13. 4 years, Required - Assist with migrating data from legacy database to new target database
14. 5 years, Preferred - More than one type of RDBMS (DB2, SQL Server, Oracle)
15. 5 years, Preferred - Experience with case management or educational systems State of Texas experience
16. 3 years, Preferred - Experience with REST API Services
17. 3 years, Preferred - Experience in Amazon Web Services
18. 1 years, Preferred - Texas Workforce Commission experience

Scope/Description of Services
The Worker(s) will provide the following services:

1. Perform Database Architect work as a member of the Data Governance team, overseeing one or more projects concurrently.
2. Document the “as is” schemas currently in use at TWC in SQL Server and Oracle databases.
3. Document existing data interfaces in the legacy system.
4. Document existing downstream impacts of the legacy system.
5. Document database processes that currently extract data from the existing system for reporting purposes.
6. Create data models and reverse and forward engineer data models in an Amazon Web Service SQL Server environment.
7. Define and document the technical architecture of the new transactional system, including the physical components and their functionality.
8. Perform other analysis and documentation tasks as required to facilitate and support this migration project.
9. Provide oversight and design of the migration and conversion of legacy data to the new database.
10. Create scripts for data conversion and migration from legacy systems to the new database platform.
11. Perform other duties as assigned to maintain operations.

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.

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 Texas law. TWC will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s).

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.