Senior Oracle Database Developer (Contractor) - 70127076

RESPEC•Austin, TX

6d•Remote

About The Position

RESPEC is seeking an accomplished, hands-on Senior Database Developer to support a mission-critical statewide education data project for the Texas Education Agency (TEA) and its Texas Student Data System (TSDS). In this position, you will serve as the primary database subject matter expert, taking direct ownership of architecting, optimizing, and maintaining complex database pipelines that process data across more than 1,200 public school districts. Working within an Agile-focused development lifecycle, you will optimize query performance, integrate complex JSON-based data structures within Oracle environments, and collaborate closely with cross-functional software engineering teams to guarantee data accuracy, high throughput, and system integrity.

Requirements

8+ Years of Enterprise Database & Systems Experience: Deep expertise in Oracle SQL and advanced PL/SQL programming, including practical usage of bulk collect, partitioned structures, and complex data modeling.
Proven background in database performance tuning and optimization, with specific experience troubleshooting resource-intensive queries to optimize SGA, PGA, and TempSpace utilization.
Hands-on experience developing and managing solutions in Microsoft SQL Server alongside relational database systems.
Demonstrated track record of conducting end-to-end unit testing, comprehensive test case design, and technical system documentation.
Continuous experience delivering database features within structured Agile or Scrum project workflows.
4+ Years of Specialized JSON & Optimization Experience: Practical experience storing, parsing, querying, and manipulating JSON payloads directly within Oracle database tables.
Demonstrated ability to design complex analytical queries and high-performance views that source directly from JSON data formats.
Hands-on tuning and optimization of stored procedures and views interacting heavily with nested JSON structures.

Nice To Haves

5+ years of experience utilizing Jira for backlog tracking and Bitbucket/Git for version control.
2+ years of hands-on exposure to Nomad workload orchestration.
2+ years of domain experience supporting the Texas Student Data System (TSDS) or comparable large-scale state agency education platforms.
Familiarity with JasperReports, enterprise ETL orchestration tools, or reviewing integration hooks within Java and .NET backends.

Responsibilities

Design, implement, and maintain advanced Oracle SQL and PL/SQL packages, procedures, and functions.
Actively profile query plans and tune database operations to minimize SGA, PGA, and Temporary Space consumption, ensuring seamless data flows across heavy transaction cycles.
Architect robust data-manipulation routines capable of querying, transforming, and persisting JSON structures natively inside Oracle tables and relational views.
Develop reliable data-mapping pipelines and interface with multi-database ecosystems encompassing Oracle, SQL Server, and MySQL.
Partner closely with full-stack Java and .NET application engineers to diagnose integration bottlenecks, troubleshoot application-level database interaction issues, and conduct thorough development and unit testing with complete technical documentation.
Actively participate in sprint planning, backlog grooming, and release deployments, ensuring that all data schema changes and database enhancements adhere to rigorous client software development standards.