Overview
On Site
Full Time
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12+ month(s)
Skills
Power BI
SQL Server
Agile development
PostgreSQL
SSIS
Tableau
Data Visualization
CI/CD
relational database design
Oracle SQL Developer
Data mapping
TOAD
Business Intelligence (BI) Reporting
data normalization
Azure Data Factory
Data ingestion
Query Optimization
Batch Processing
Azure SQL Database
ETL Pipelines
Database Migration Specialist (MS Access / SQL)
MS Access
Microsoft Access VBA
AWS RDS
Database Migration
Legacy Database Migration
SQL Schema Design
ER Modeling
AWS DMS
Data Dictionary
SQL Server Management Studio
Execution Plans
Database Console Tools
Job Details
Solution IT Inc. is looking for Database Migration Specialist (MS Access / SQL) for one of its clients in Austin, TX (Hybrid/ T&F onsite)
Job Title: Database Migration Specialist (MS Access / SQL)
Required Skills
- 10+ years of experience designing, developing, and maintaining advanced MS Access databases, including normalized table structures, queries, forms, reports, and data extraction/manipulation.
- 10+ years of expert-level relational database design experience: normalization, ER modeling, schema refactoring, and translating Access data models into scalable SQL schemas.
- 10+ years of experience with Microsoft Access, including VBA for custom functionalities and workflow automation.
- 10+ years of experience migrating legacy databases into at least one major cloud SQL service (Azure SQL Database/Managed Instance, PostgreSQL, AWS RDS for SQL Server/MySQL).
- 8+ years of ETL tool experience with SSIS, Azure Data Factory, AWS Database Migration Service (DMS), or equivalent.
- 8+ years of experience creating migration runbooks, data dictionaries, technical documentation, and delivering training or knowledge-transfer sessions.
- 8+ years of experience with RDBMS admin/console tools such as TOAD, SSMS, and/or SQL Developer.
- 8+ years of experience configuring data integration and batch processing solutions in Azure Data Factory and/or SSIS; monitoring ingestion processes and performance, reviewing query plans, and identifying problem areas.
- 8+ years of experience migrating data from legacy databases to new target databases.
Preferred Skills & Experience:
- 6+ years of hands-on experience with CI/CD methodology, GitHub, JIRA.
- 6+ years of experience with data visualization/reporting tools such as Power BI, Tableau.
- 6+ years of experience with Agile Development Methodologies.
- Prior experience in healthcare or public health projects.
- Experience implementing Agile methodologies and best practices for State of Texas agencies.
Work Site: Austin, TX
Duration: 12 months
Expected Start Date: Immediate
Number of Positions: 1
Please send your responses back to
About Solution IT
Solution IT is a national IT consulting company specializing in: Technology Staffing and Oracle E-Business Solutions based in Boston, Massachusetts.
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.