Senior Oracle SQL/PLSQL Developer & ETL Specialist

Quantum Technologies. LLC; Raleigh (NC); On-site; USD 120,000 - 170,000; Full time

Job summary

The Texas Education Agency is seeking an experienced Senior Database Developer to design, develop, optimize, and maintain enterprise database applications, ETL processes, and reports supporting TSDS.

The ideal candidate will have deep experience with Oracle performance tuning, complex SQL queries, JSON data processing, SQL Server, and Agile development. Jasper Reports and ETL tools are also important.

Qualifications

• Experience with Oracle SQL/PLSQL to design and maintain enterprise database applications.
• Strong knowledge of Oracle performance tuning and complex SQL queries.
• Experience with JSON processing in Oracle and with SQL Server/MySQL.
• Experience with Jasper Reports, ETL tools, and troubleshooting Java/.NET apps.

Responsibilities

• Design, develop, and maintain Oracle SQL and PL/SQL procedures, functions, packages, and database applications.
• Write and optimize complex Oracle queries, focusing on reducing SGA, PGA, and temporary tablespace utilization.
• Develop advanced PL/SQL solutions using BULK COLLECT, JSON processing, and efficient data manipulation.
• Store, query, transform, and manipulate JSON data within Oracle database tables.
• Develop and troubleshoot ETL processes, data integrations, and source-to-target mappings.
• Develop, maintain, and troubleshoot Jasper Reports and related reporting processes.
• Work with relational databases, including Oracle, SQL Server, and MySQL.
• Troubleshoot database-related issues involving Java and .NET application code.
• Perform development testing, unit testing, debugging, and technical documentation.
• Participate in Agile development, code reviews, sprint activities, and release planning.
• Collaborate with development teams, project managers, and business stakeholders to ensure accurate data processing and reporting.

Job description

The Texas Education Agency is seeking an experienced Senior Database Developer to design, develop, optimize, and maintain enterprise database applications, ETL processes, and reports supporting TSDS.

The ideal candidate will have deep experience with Oracle performance tuning, complex SQL queries, JSON data processing, SQL Server, and Agile development. Jasper Reports and ETL tools are also important.