Job description

Position Title: Senior Database Developer - Legacy Access to Cloud SQL Migration Location: Austin, TX Clearance Requirements: None Position Status: Contract (12 months, with strong likelihood of extension) Pay Rate: Competitive, based on experience Position Description 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. This is a high-impact role where you will lead the transformation of legacy Access databases into scalable, cloud-native SQL environments. 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. About Seneca Resources At Seneca Resources, we are more than just a staffing and consulting firm-we are a trusted career partner. With offices across the U.S. and clients ranging from Fortune 500 companies to government organizations, we provide opportunities that help professionals grow their careers while making an impact. When you work with Seneca, you're choosing a company that: • Invests in your success and celebrates your achievements. • Connects you to meaningful projects with leading organizations. • Provides competitive pay, comprehensive health, dental, and vision coverage, 401(k) retirement plans, and dedicated recruiter support. 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.

Requirements