Senior Oracle DB Developer - ETL, JSON, Reports | Austin

Ethereum Technologies; Austin (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Texas Education Agency is seeking a Senior Database Developer to design, develop, optimize, and maintain enterprise databases and reporting solutions that support TSDS. The role emphasizes Oracle SQL/PLSQL, JSON data handling, and ETL processes across Oracle, SQL Server, and MySQL.

The ideal candidate will be proficient in Oracle performance tuning, complex SQL, and agile software development, with experience in Jasper Reports and troubleshooting Java/.NET applications.

Qualifications

• Experience with Oracle performance tuning and complex SQL queries.
• Expertise in JSON processing and working with SQL Server.
• Experience in Agile development processes and collaboration with stakeholders.

Responsibilities

• Design, develop, and maintain Oracle SQL/PLSQL procedures, functions, and packages.
• Write and optimize complex Oracle queries to reduce resources usage.
• Develop PL/SQL with BULK COLLECT and JSON processing techniques.
• Manage JSON data within Oracle tables and perform transformations.
• Develop and troubleshoot ETL processes and data integrations.
• Create and maintain Jasper Reports and related reporting processes.
• Work with Oracle, SQL Server, and MySQL databases.
• Troubleshoot DB issues tied to Java/.NET applications.
• Conduct development and unit testing and document technical work.
• Participate in Agile sprints, code reviews, and releases.
• Collaborate with teams to ensure accurate data processing.

Skills

Oracle SQL/PLSQL

Performance tuning

JSON processing

SQL Server

Agile development

Java/.NET

Tools

Jasper Reports

ETL tools

Job description

Texas Education Agency is seeking a Senior Database Developer to design, develop, optimize, and maintain enterprise databases and reporting solutions that support TSDS. The role emphasizes Oracle SQL/PLSQL, JSON data handling, and ETL processes across Oracle, SQL Server, and MySQL.

The ideal candidate will be proficient in Oracle performance tuning, complex SQL, and agile software development, with experience in Jasper Reports and troubleshooting Java/.NET applications.