Senior Oracle SQL/PLSQL Developer

Robotic Technologies Automation; Raleigh (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

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

The ideal candidate will work with Oracle, SQL Server, MySQL, and Jasper Reports in an Agile environment, focusing on performance tuning, JSON processing, and data integration across systems.

Qualifications

• Experience with Oracle SQL/PLSQL including performance tuning and complex queries.
• JSON processing and data manipulation within Oracle databases.
• Familiarity with Jasper Reports and ETL tooling in an Agile environment.

Responsibilities

• Design, develop, and maintain Oracle SQL/PLSQL procedures, functions, packages, and database applications.
• Write and optimize complex Oracle queries to reduce SGA, PGA, and temp tablespace usage.
• 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 reporting.
• Collaborate with teams and stakeholders in Agile sprints.

Skills

Oracle SQL/PLSQL

JSON processing

Performance tuning

Agile development

Java/.NET troubleshooting

Tools

Jasper Reports

ETL tools

SQL Server

MySQL

Oracle

Job description

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

The ideal candidate will work with Oracle, SQL Server, MySQL, and Jasper Reports in an Agile environment, focusing on performance tuning, JSON processing, and data integration across systems.