Brief Job Description The Senior Database Developer will support the Texas Education Agency (TEA). This role designs, develops, modernizes, and supports enterprise database solutions, with deep expertise in Microsoft SQL Server, relational database design, data modeling, and normalization. The Senior Database Developer will lead Oracle to SQL Server migrations, develop complex stored procedures, optimize performance, and deliver reporting and data extraction solutions. The position works with development, architecture, and business teams to deliver scalable, secure, and high-performing solutions. The role also uses AI-assisted tools such as GitHub Copilot in database design, development, migration, testing, optimization, and documentation.
Responsibilities
- Provide technical expertise in database architecture, design, development, migration, implementation, and optimization.
- Own the full software development life cycle (SDLC), from requirements and design through deployment and support.
- Design and maintain relational databases, including data modeling, normalization, relationships, and data integrity.
- Modernize legacy databases to improve design, performance, and maintainability, and to reduce technical debt.
- Lead Oracle to SQL Server migrations, including data mapping, ETL, transformation, conversion, reconciliation, validation, and testing.
- Develop and support reporting and complex data extraction using SQL Server and stored procedures.
- Maintain high standards for code quality, security, and performance through code reviews and best practices.
- Drive agile delivery by breaking work into increments, taking part in sprint ceremonies, developing and reviewing code, and working closely with the project team.
- Use GitHub Copilot and AI-assisted development to speed up development, improve quality, and automate repetitive tasks.
- Foster a culture of continuous improvement, innovation, and accountability.
Requirements
Minimum Qualifications
- 8 years of strong hands-on experience in database development, including database architecture, design, and implementation.
- 8 years of experience with ETL, data migration, and relational databases (SQL Server and Oracle).
- 8 years of experience communicating effectively with customers and sharing design ideas with teams, both verbally and in writing.
- 5 years of experience in SQL performance tuning.
- 5 years of experience estimating work accurately and delivering on time.
- 5 years of experience with Agile/Scrum and traditional SDLC methodologies.
- 5 years of experience with DevOps practices, CI/CD pipelines, and version control (e.g., Jenkins, Bit Bucket).
- 5 years of experience with unit testing.
- 3 years of experience using AI tools across design, development, and testing processes.
Preferred Qualifications
- 3 years of experience working with the Texas Education Agency (TEA) and TEA applications.
- 3 years of experience with containerized applications.
- 3 years of experience with .NET (C#, ASP.NET, API, .NET Core).
Additional Requirements
- Candidates may be required to submit to and pass a criminal background check.
Work Location and Schedule Location: William B. Travis State Building, 1701 North Congress Avenue, Austin, Texas 78701. Schedule: Full time, Monday through Friday, 8:00 AM to 5:00 PM, excluding State holidays. Evening, weekend, or holiday work may occasionally be required. Work Arrangement: Hybrid, up to 90% remote, with occasional onsite meetings in Austin, TX.