Senior Oracle DB Developer & ETL/Reporting Lead

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

Job summary

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

The role requires deep Oracle SQL/PLSQL expertise, performance tuning, JSON data handling, and experience with SQL Server and reporting tools. You will work in an Agile environment to deliver robust data solutions and insights.

Qualifications

• Deep experience with Oracle SQL/PLSQL
• Proficient in performance tuning for enterprise databases
• Strong ability to process JSON data in Oracle and other DBs
• Experience with SQL Server and reporting tools
• Familiarity with Jasper Reports and ETL tooling
• Experience debugging Java/.NET applications in a data-heavy environment
• Agile development and collaboration with stakeholders

Responsibilities

• Design, develop, and maintain complex Oracle SQL/PLSQL procedures, functions, 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, JSON processing, and efficient data manipulation.
• Store, query, transform, and manipulate JSON data within Oracle 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 Oracle, SQL Server, and MySQL databases.
• 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, PMs, and business stakeholders to ensure accurate data processing and reporting.

Skills

Oracle SQL/PLSQL

Performance tuning

JSON processing

SQL Server

Complex SQL queries

Bulk COLLECT

Agile development

Java/.NET troubleshooting

Tools

Jasper Reports

ETL tools

Job description

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

The role requires deep Oracle SQL/PLSQL expertise, performance tuning, JSON data handling, and experience with SQL Server and reporting tools. You will work in an Agile environment to deliver robust data solutions and insights.