Core Responsibilities
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, establish rigorous unit testing routines, and integrate database releases into automated CI/CD pipelines. As part of RESPEC’s forward-looking engineering philosophy, you will actively harness AI-assisted development tooling (such as GitHub Copilot) to accelerate coding cycles, automate recurring tasks, and produce clean technical documentation.
Required Technical Experience
8+ Years of Demonstrated Experience
Enterprise Database Engineering & Architecture: Proven track record designing, building, normalizing, and scaling robust enterprise-grade relational database architectures.
ETL, Data Migration & Multi-Platform RDBMS: Deep technical mastery managing complex data pipelines and migration initiatives involving both Microsoft SQL Server and Oracle environments.
Technical & Stakeholder Communication: Demonstrated excellence communicating architectural concepts, schema designs, and technical tradeoffs to clients, leadership, and cross-functional teams across written documentation and verbal design sessions.
5+ Years of Demonstrated Experience
SQL Performance Tuning & Optimization: Deep hands-on proficiency identifying execution bottlenecks, profiling complex queries, indexing, and optimizing stored procedures for high-volume enterprise workloads.
Agile SDLC Delivery & Work Estimation: Consistent track record delivering software releases on schedule within structured Agile, Scrum, and traditional SDLC lifecycles, backed by accurate effort estimation.
Modern DevOps, CI/CD & Testing: Proven experience operating within collaborative DevOps workflows, using enterprise version control and automation tools such as Jenkins and Bitbucket, complemented by rigorous unit testing routines.
3+ Years of Demonstrated Experience
AI-Assisted Engineering Practices: Direct hands-on experience leveraging modern AI developer tools (such as GitHub Copilot or equivalent assistive platforms) across database design, scripting, unit testing, and technical documentation.
Preferred Qualifications
Candidates with prior direct experience developing or supporting applications within the Texas Education Agency (TEA) or broader Texas state agency systems are strongly preferred.
Experience deploying and maintaining database components alongside containerized applications (Docker/Kubernetes) is highly desirable, as is a working familiarity with the modern Microsoft application stack, including .NET, C#, ASP.NET Core, and RESTful web APIs.
Work Model
Work Arrangement: Hybrid — primarily remote with the flexibility to work up to 90% remote, subject to direct client manager approval and operational requirements.
Candidates must be available for periodic on-site meetings, planning sessions, or technical milestones in Austin, Texas.
Client Office Location: William B. Travis State Building, 1701 North Congress Avenue, Austin, TX 78701.
Work Schedule: Standard business hours are Monday through Friday, 8:00 AM to 5:00 PM Central Time
All your information will be kept confidential according to EEO guidelines.