Senior Oracle SQL/PLSQL Developer for TSDS Data & ETL

Valiant Technologies LLC; Austin (TX); On-site; USD 83,000 - 117,000; Full time

Job summary

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

The ideal candidate will excel in Oracle performance tuning, complex SQL queries, JSON processing, and have experience with SQL Server, MySQL, Jasper Reports, and Java/.NET troubleshooting within an Agile environment.

Qualifications

• Extensive experience designing and tuning Oracle SQL/PLSQL.
• Strong JSON processing and data modeling skills.
• Experience with SQL Server and MySQL databases.
• Familiarity with Jasper Reports and ETL tools.
• Proven ability to work in Agile teams.

Responsibilities

• Design, develop, and optimize Oracle SQL/PLSQL procedures and packages.
• Write complex queries to minimize SGA, PGA, and temp tablespace usage.
• Build BULK COLLECT based PL/SQL solutions and JSON data handling.
• Develop ETL processes and data mappings across systems.
• Create and troubleshoot Jasper Reports and reporting pipelines.
• Collaborate with teams to ensure accurate data processing.

Skills

Oracle SQL/PLSQL

JSON processing

SQL Server

MySQL

Jasper Reports

ETL

Agile

Java/.NET troubleshooting

Tools

ETL tools

Job description

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

The ideal candidate will excel in Oracle performance tuning, complex SQL queries, JSON processing, and have experience with SQL Server, MySQL, Jasper Reports, and Java/.NET troubleshooting within an Agile environment.