Sr Oracle Database Developer

Responsibilities

• 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
• 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

Skills

• 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

Benefits

• 🏫 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
• 📝 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)