Overview
Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
100% Travel
Skills
AWS Database Migration Service
Agile
Amazon RDS
Amazon Web Services
Batch Processing
Cloud Computing
Code Refactoring
Continuous Delivery
Continuous Integration
DMS
Data Entry
Data Extraction
Data Integration
Data Structure
Data Visualization
Database
Database Design
Extract
Transform
Load
Forms
GitHub
Health Care
JIRA
Knowledge Transfer
Microsoft Access
Microsoft Azure
Microsoft Power BI
Microsoft SQL Server
Microsoft SQL Server Management Studio (SSMS)
Microsoft SSIS
Migration
Modeling
MySQL
Normalization
PostgreSQL
Public Health
RDBMS
Remote Desktop Services
Reporting
SQL
SQL Azure
Tableau
Toad
Training
VBA
Workflow
Job Details
Role: Database Administrator
Location: Locals Austin, TX (Hybrid)
We are seeking a Senior Database Developer with 10+ years of experience in Microsoft Access and cloud-native SQL to lead the migration of legacy Access databases into modern, high-performance SQL platforms. The role involves working closely with program users to analyze existing data structures, design and execute schema transformations, develop ETL pipelines, implement validation checks, prepare cut-over plans, and guide stakeholders through a seamless data transition.
Required Qualifications:
- 10 years Proven experience in designing, developing, and maintaining advanced Microsoft Access databases, including:
- Creation of normalized table structures
- Sophisticated queries for data extraction and manipulation
- Intuitive data entry forms
- Comprehensive reports
- 10 years Expert-level knowledge of relational database design, normalization, ER modeling, schema refactoring, and translating Access data models into scalable SQL schemas.
- 10 years Hands-on experience with Microsoft Access, including table design, complex queries, forms, reports, and VBA for custom functionalities/workflow automation.
- 10 years Experience migrating legacy databases into at least one major cloud SQL service (e.g., Azure SQL Database/Managed Instance, PostgreSQL, AWS RDS for SQL Server/MySQL).
- 8 years ETL tool experience with SSIS, Azure Data Factory, AWS Database Migration Service (DMS), or equivalent.
- 8 years Experience creating migration runbooks, data dictionaries, and delivering training/knowledge-transfer sessions.
- 8 years Experience with RDBMS admin/console tools such as TOAD, SSMS, and/or SQL Developer.
- 8 years Experience configuring data integration and batch processing solutions in Azure Data Factory and/or SSIS, monitoring data ingestion processes, reviewing query plans, and identifying problem areas in execution plans.
- 8 years Experience migrating data from legacy databases to modern target databases.
Preferred Qualifications:
- 6 years Hands-on experience with CI/CD methodology, GitHub, JIRA.
- 6 years Hands-on experience with data visualization/reporting tools such as Power BI or Tableau.
- 6 years Experience working in Agile Development Methodologies.
- 3 years Prior experience in healthcare or public health domains.
- 3 years Experience implementing Agile methodologies and best practices for one or more State of Texas agencies.
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.