What are the responsibilities and job description for the SQL Server Database Architect position at Bansar Technologies Inc.?
Job Details
DirectClient: Texas Workforce Commission (TWC)
Solicitation#5098025DA2
Title: SQL Server Database Architect
Location: 101 E. 15th Street, Austin, Texas 78778
Duration: Until 8/31/2025 with possible extension
Last date for submission: March 4, 2025 (9.00 AM-CST)
Important Note: Position will be remote. 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.
DESCRIPTION OF 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.
Minimum Requirements:
YearsSkills/Experience
4-7Database Architect Role
4-7Data modeling in SQL Server Enterprise Edition
4-7Analyzing and generating technical requirements and design
4-7Creating and maintaining data models
4-7Database development experience utilizing RDBMS
4-7Design a SQL Server database for high usage/high availability transactional system
4-7Database tuning techniques
4-7Analyzing source databases, source data, source database referential integrity and profiling source data
4-7Experience with data mining and archiving
4-7Experience with MS SQL Server DBMS
4-7Experience with managing RDBMS in AWS or Microsoft Azure
4-7Creating source to target mapping database documentation
4-7Assist with migrating data from legacy database to new target database
Preferred:
YearsSkills/Experience
5More than one type of RDBMS (DB2, SQL Server, Oracle)
5Experience with case management or educational systems State of Texas experience
3Experience with REST API Services
3Experience in Amazon Web Services
Texas Workforce Commission experience
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
