Sr Oracle Database Developer

The Texas Education Agency (TEA) is seeking two qualified Sr Oracle Database Developer candidates to join the IT-SEDS team. The successful candidates will play a crucial role in supporting, enhancing, and optimizing the performance of database systems for a large-scale project. This role requires advanced expertise in Oracle SQL and PL/SQL, with a focus on performance tuning, complex queries, and working with data stored in JSON/XML formats. Candidates will collaborate with multiple stakeholders to ensure the accuracy and efficiency of reports that serve over 1,200 school districts across Texas.
Candidates must have prior experience working with state clients and in the education sector.
Key Responsibilities:

• Perform advanced database analysis and development to improve and optimize the performance of large-scale database systems.
• Utilize Oracle SQL and PL/SQL to write and optimize complex queries, stored procedures, and views.
• Focus on optimizing database performance, including reducing SGA/PGA/Temp Space usage and fine-tuning query execution.
• Work extensively with JSON and XML data formats, including storing, querying, and manipulating data within Oracle database tables.
• Provide technical leadership and innovative solutions for complex database challenges.
• Collaborate with internal stakeholders and cross-functional teams to ensure the quality and accuracy of data and reports.
• Participate in the full software development lifecycle (SDLC), following Agile-like methodologies to complete code changes for defined releases.
• Document technical solutions, processes, and reports for internal use and compliance.
• Conduct dev/unit testing to ensure code quality and functionality.

Required Qualifications:

• Expertise in Oracle SQL and PL/SQL: Extensive experience with advanced SQL concepts, including bulk collect, complex queries, and performance optimization (7+ years).
• Database Optimization: Proven ability to optimize queries, stored procedures, and views, with a focus on reducing resource usage (SGA/PGA/TempSpace) (7+ years).
• Documentation Skills: Strong ability to document technical solutions, processes, and reports (7+ years).JSON 
• Dev/Unit Testing: Experience with development and unit testing to ensure code quality (7+ years).
• Agile Development: Familiarity with Agile development practices and experience working within Agile environments (7+ years).
• JSON/XML Data Handling: Proficient in storing, querying, and manipulating JSON data within Oracle databases (4+ years).
• Complex Query/Views Creation: Proficient in creating complex queries and views using data stored in format (4+ years).
• Performance Optimization: Skilled in optimizing the performance of stored procedures and views that access data stored in JSON format (4+ years).
• Must have a bachelor's degree in computer science or equivalent