Seneca Resources
We are seeking a
Senior Database Developer
with deep expertise in
Microsoft Access to Cloud SQL migration
for a public sector modernization initiative in Austin, TX. The ideal candidate will combine
hands-on technical expertise
with the ability to work closely with program users and stakeholders, ensuring seamless migrations, optimized database performance, and long-term maintainability. This role is
onsite
in Austin and offers the opportunity to drive meaningful digital modernization within the public sector. Key Responsibilities Lead the modernization of legacy Microsoft Access databases into scalable, cloud-native SQL platforms. Collaborate with users to analyze existing data structures, design schema transformations, and define migration strategies. Develop and execute ETL pipelines using tools such as
SSIS, Azure Data Factory, or AWS DMS . Optimize performance through schema refactoring, execution plan analysis, and batch workflow monitoring. Create migration runbooks, data dictionaries, technical documentation, and deliver knowledge-transfer sessions. Ensure all database interfaces (administration, reporting, and data entry) meet
EIR Accessibility
standards. Support post-migration operations, including validation, troubleshooting, and performance tuning. Required Skills & Experience 10+ years
designing and maintaining advanced Microsoft Access databases (normalized tables, queries, forms, reports, VBA automation). 10+ years
in relational database design, schema refactoring, ER modeling, and translating Access models into SQL schemas. 10+ years
migrating legacy databases into
cloud SQL services
(Azure SQL, PostgreSQL, AWS RDS, or equivalent). 8+ years
developing ETL solutions with
SSIS, Azure Data Factory, AWS DMS, or similar tools . 8+ years
producing migration documentation, data dictionaries, and knowledge-transfer deliverables. 8+ years
with RDBMS administration tools (TOAD, SSMS, SQL Developer). 8+ years
configuring and monitoring large-scale data integration and batch processes. Preferred Qualifications 6+ years with
CI/CD tools
(GitHub, JIRA) and Agile methodologies. 6+ years working with
data visualization tools
(Power BI, Tableau). 3+ years in
healthcare or public health environments . Strong knowledge of
Agile practices
in public sector IT projects. Seneca Resources is proud to be an
Equal Opportunity Employer , committed to fostering a diverse and inclusive workplace where all qualified individuals are encouraged to apply.
#J-18808-Ljbffr
Senior Database Developer
with deep expertise in
Microsoft Access to Cloud SQL migration
for a public sector modernization initiative in Austin, TX. The ideal candidate will combine
hands-on technical expertise
with the ability to work closely with program users and stakeholders, ensuring seamless migrations, optimized database performance, and long-term maintainability. This role is
onsite
in Austin and offers the opportunity to drive meaningful digital modernization within the public sector. Key Responsibilities Lead the modernization of legacy Microsoft Access databases into scalable, cloud-native SQL platforms. Collaborate with users to analyze existing data structures, design schema transformations, and define migration strategies. Develop and execute ETL pipelines using tools such as
SSIS, Azure Data Factory, or AWS DMS . Optimize performance through schema refactoring, execution plan analysis, and batch workflow monitoring. Create migration runbooks, data dictionaries, technical documentation, and deliver knowledge-transfer sessions. Ensure all database interfaces (administration, reporting, and data entry) meet
EIR Accessibility
standards. Support post-migration operations, including validation, troubleshooting, and performance tuning. Required Skills & Experience 10+ years
designing and maintaining advanced Microsoft Access databases (normalized tables, queries, forms, reports, VBA automation). 10+ years
in relational database design, schema refactoring, ER modeling, and translating Access models into SQL schemas. 10+ years
migrating legacy databases into
cloud SQL services
(Azure SQL, PostgreSQL, AWS RDS, or equivalent). 8+ years
developing ETL solutions with
SSIS, Azure Data Factory, AWS DMS, or similar tools . 8+ years
producing migration documentation, data dictionaries, and knowledge-transfer deliverables. 8+ years
with RDBMS administration tools (TOAD, SSMS, SQL Developer). 8+ years
configuring and monitoring large-scale data integration and batch processes. Preferred Qualifications 6+ years with
CI/CD tools
(GitHub, JIRA) and Agile methodologies. 6+ years working with
data visualization tools
(Power BI, Tableau). 3+ years in
healthcare or public health environments . Strong knowledge of
Agile practices
in public sector IT projects. Seneca Resources is proud to be an
Equal Opportunity Employer , committed to fostering a diverse and inclusive workplace where all qualified individuals are encouraged to apply.
#J-18808-Ljbffr