Senior Oracle DB Developer: PL/SQL, ETL, JSON & Reports

Valiant Technologies LLC; Raleigh (NC); On-site; USD 120,000 - 160,000; Full time

Job summary

The Texas Education Agency is seeking an experienced Senior Database Developer with advanced Oracle SQL/PLSQL expertise to design, develop, optimize, and maintain enterprise database applications, ETL processes, and reports supporting TSDS.

Ideal candidates will have deep experience with Oracle performance tuning, complex SQL, JSON processing, SQL Server, and Agile development, with knowledge of Jasper Reports and related tools for reporting and data integration.

Qualifications

• Extensive experience with Oracle SQL/PLSQL and enterprise database design.
• Strong background in SQL Server, MySQL, and JSON data processing.
• Experience with ETL processes, Jasper Reports, and reporting.
• Familiarity with Agile development and collaboration with stakeholders.

Responsibilities

• Design, develop, and maintain Oracle SQL/PLSQL procedures, functions, packages, and database applications.
• Write and optimize complex Oracle queries, focusing on reducing SGA, PGA, and temporary tablespace utilization.
• Develop PL/SQL solutions using BULK COLLECT and JSON processing.
• Store, query, transform, and manipulate JSON data within Oracle tables.
• Develop, maintain, and troubleshoot ETL processes and data mappings.
• Develop, maintain, and troubleshoot Jasper Reports and related reporting processes.
• Work with Oracle, SQL Server, and MySQL databases.
• Troubleshoot database issues involving Java and .NET code.
• Participate in Agile development, code reviews, sprint activities, and releases.
• Collaborate with teams to ensure accurate data processing and reporting.

Skills

Oracle SQL/PLSQL

Performance tuning

JSON processing

Bulk Collect

Jasper Reports

ETL tools

Java

NET

Agile

SQL Server

MySQL

Tools

Jasper Reports

ETL tools

SQL Server

MySQL

Job description

The Texas Education Agency is seeking an experienced Senior Database Developer with advanced Oracle SQL/PLSQL expertise to design, develop, optimize, and maintain enterprise database applications, ETL processes, and reports supporting TSDS.

Ideal candidates will have deep experience with Oracle performance tuning, complex SQL, JSON processing, SQL Server, and Agile development, with knowledge of Jasper Reports and related tools for reporting and data integration.