Senior Database Developer

MACHINE LEARNING TECHNOLOGIES LLC; Raleigh (NC); On-site; USD 110,000 - 124,000; Full time

Job summary

The 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 have deep experience with Oracle performance tuning, complex SQL queries, JSON data processing, SQL Server, and Agile development. Experience with Jasper Reports, ETL tools, and troubleshooting Java/.NET applications is also important.

Qualifications

• Extensive Oracle SQL/PLSQL expertise required.
• Experience with JSON processing and reporting.
• Strong knowledge of ETL and BI reporting tools.
• Experience with Java/.NET applications is a plus.
• Agile development experience.

Responsibilities

• Design, develop, and maintain Oracle SQL and PL/SQL procedures, functions, packages, and database apps.
• Write and optimize complex Oracle queries to reduce resource usage (SGA, PGA).
• Develop PL/SQL solutions using BULK COLLECT and JSON processing.
• Store, query, transform JSON data in Oracle tables.
• Develop and troubleshoot ETL processes and data mappings.
• Maintain Jasper Reports and related reporting processes.
• Work with Oracle, SQL Server, and MySQL databases.
• Troubleshoot issues with Java/.NET application code.
• Participate in Agile development, code reviews, and releases.
• Collaborate with teams and stakeholders to ensure accurate data processing.

Skills

Oracle SQL/PLSQL

JSON processing

SQL Server

Jasper Reports

ETL tools

Agile development

Java/.NET

Performance tuning

Tools

Jasper Reports

Job description

Job Overview

Job ID: J54596

Job Title: Senior Database Developer

Location: Raleigh, NC

Duration: 9 Months + Extension

Domain Exposure: Banking & Finance

Client: To Be Discussed Later

Employment Type: W-2, 1099, C2C

Work Authorization: US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Bill Rate

$85/hour (C2C)

Job Type

W-2, 1099, C2C

Job Description

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

The ideal candidate will have deep experience with Oracle performance tuning, complex SQL queries, JSON data processing, SQL Server, and Agile development. Experience with Jasper Reports, ETL tools, and troubleshooting Java/.NET applications is also important.

Key Responsibilities

• Design, develop, and maintain complex 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.

Equal Opportunity Employer

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.