Database Administrator_only local to Austin, Texas

Overview

Database Administrator – Local to Austin, Texas

Position requires on-site work in Austin, TX. Candidates should have proven experience with Microsoft Access and cloud SQL migrations, as well as data integration and reporting tools.

• Design, develop, and maintain advanced MS Access databases, including normalized table structures, sophisticated queries, intuitive data entry forms, and comprehensive reports.
• Translate Access data models into scalable SQL schemas and perform expert-level relational database design, normalization, ER modeling, and schema refactoring.
• Migrate legacy databases to major cloud SQL services (Azure SQL Database/Managed Instance, Postgre
  
  SQL, AWS RDS for SQL Server/MySQL).
• Utilize ETL tools (SSIS, Azure Data Factory, AWS DMS or equivalent) to support data integration, batch processing, and data ingestion monitoring.
• Create migration runbooks, data dictionaries, and technical documentation; deliver training or knowledge-transfer sessions.
• Support and administer RDBMS tools (TOAD, SSMS, SQL Developer) and optimize query plans and performance.
• Configure data integration workflows in Azure Data Factory and/or SSIS; monitor and optimize data ingestion processes.
• Prepare and execute data migration from legacy to target databases.

• Required – Proven experience with MS Access (table design, complex queries, forms, reports) and VBA for custom functionality.
• Required – Experience migrating databases to cloud SQL services (Azure, Postgre
  
  SQL, AWS RDS).
• Required – ETL experience with SSIS, Azure Data Factory, AWS DMS, or equivalent; ability to create runbooks and technical documentation.
• Required – Experience with RDBMS admin/console tools (TOAD, SSMS, SQL Developer); ability to review query plans and optimize performance.
• Required – Configuring and monitoring data integration/batch processing in Azure Data Factory and/or SSIS.
• Required – Experience migrating data from legacy to new target databases.
• Preferred – CI/CD with Git Hub, JIRA; data visualization/reporting tools (Power BI, Tableau);
  Agile methodologies.
• Preferred – Healthcare or Public Health experience; experience with state agency environments.

• Mid-Senior level

• Contract

• Information Technology

• IT Services and IT Consulting

Austin, TX candidates: compensation ranges and postings may be listed externally; verify current details during application.