Senior Database Developer

· The Senior Database Developer performs highly advanced computer programming work. Works independently to perform the most complex programming work and may review and evaluate programming efforts in relation to system requirements. This position requires excellent Jasper reports/ETL and SQL/PLSQL skills and ability to understand and troubleshoot issues with java/.net application code. Works closely with the development team, the project management team, and the TSDS business areas to develop and deliver high quality applications. We are seeking a team member to architect, design, enhance and maintain the assigned application and work assignments will follow a defined software development life cycle (SDLC) process using an Agile-like approach for completing code changes for defined releases. The Senior Database Developer works across multiple agency stakeholders to ensure the accuracy and efficacy of the project’s data processes and reports, in the service of Texas’s 1200 school districts.

· Application Development using SQL/PLSQL

· Strong expertise to work in SQL and relational databases (Oracle, SQL Server, MySQL)

· Experience with various ETL tools, data integration, and data mapping

· Dev/Unit Testing

· Participate in Agile development, Strong experience with Oracle SQL and PL/SQL (advanced concepts such as bulk collect, handling data in JSON)

8

Required

Strong experience with writing complex optimized Oracle queries reducing SGA/PGA/TempSpace usage

8

Required

Strong experience in working with SQL Server

8

Required

Dev/Unit Testing and Documentation

Strong experience in storing, querying, manipulating JSON data in Oracle database tables

5

Preferred

Knowledge of JIRA/BitBucket

2

Preferred

Experience in Nomad

2

Preferred

Experience with Texas Student Data System (TSDS)

DIA SOFTWARE SOLUTIONS LLC.