RESPEC is actively seeking an accomplished Senior Database Developer to lead a mission-critical enterprise database modernization and migration initiative supporting the Texas Education Agency (TEA). In this role, you will be the core database authority modernizing legacy data infrastructures, architecting scalable relational solutions on Microsoft SQL Server, and orchestrating large-scale Oracle-to-SQL Server data migrations. This high-impact program underpins critical educational reporting and statewide data systems, giving you the platform to blend deep architectural craft with modern engineering practices, including AI-assisted development tools like GitHub Copilot.
You will own the complete database lifecycle from architectural planning through deployment, performance tuning, and long-term maintainability. This includes conducting relational data modeling, normalizing complex architectures, and systematically resolving technical debt in legacy schemas. A pivotal component of your work involves driving complex Oracle-to-SQL Server data migrations—encompassing end-to-end data mapping, ETL workflow engineering, validation, conversion logic, and automated reconciliation.
Beyond traditional database engineering, you will collaborate side-by-side with cross-functional software teams, cloud specialists, and agency stakeholders within an Agile/Scrum delivery model. You will build and optimize sophisticated stored procedures, lead comprehensive code reviews,