Database Administrator 3

Senior Database Developer - MS Access & Cloud SQL Migration

Location : Austin, TX - On-site

Duration : 10+ months

Position Overview

We are seeking an experienced Senior Database Developer to lead the migration of legacy Microsoft Access databases into modern, cloud-native SQL platforms. This role will work closely with program users to analyze existing data structures, design and execute schema transformations, build ETL pipelines, and manage cut-over plans. The developer will also provide technical assistance to ensure ongoing performance, security, and compliance with accessibility standards.

This is a hands-on role for a highly technical professional with a track record of transforming Access environments into scalable, enterprise-grade SQL solutions.

Key Responsibilities

• Analyze existing Access databases to design scalable relational data models in cloud SQL environments.
• Lead schema transformations, data migration, and ETL process design using tools such as SSIS, Azure Data Factory, or AWS DMS.
• Build and validate migration runbooks, technical documentation, and data dictionaries.
• Develop intuitive, normalized table structures, complex queries, data entry forms, and reports in MS Access during transition phases.
• Optimize SQL queries, stored procedures, and execution plans for performance tuning.
• Provide user training and knowledge transfer sessions to ensure smooth adoption of the new environment.
• Evaluate and recommend best practices for database performance, storage, security, and disaster recovery.
• Ensure compliance with EIR Accessibility standards , providing accessible interfaces for database input, reporting, and administration.
• Support users with technical assistance, report generation, and issue resolution.
• Collaborate with IT, program staff, and vendors to ensure migration success and long-term sustainability.

Required Qualifications

Preferred Qualifications

Why This Role

This is a rare opportunity to lead a critical modernization initiative -helping transform legacy systems into scalable, cloud-ready platforms that directly support public health programs. You'll work in a collaborative environment where technical expertise is valued, and your work will have a visible impact across the organization.