Logo
Helishores Inc

Database Administrator

Helishores Inc, Austin, Texas, us, 78716

Save Job

Overview

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.

#J-18808-Ljbffr