| Location | Austin, TX |
Solicitation number: 70127076
Working title: Senior Database Developer
Title/level: Developer/Programmer Analyst 3
Category: Applications/Software Development
Agency: Texas Education Agency (TEA)
Number of positions: 1
Work schedule: Full time
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
| Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. | ||
| Years | Required/Preferred | Experience |
| 8 | Required | 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 |
| 8 | Required | Agile Development |
| 4 | Required | Strong experience in storing, querying, manipulating JSON data in Oracle database tables |
| 4 | Required | Strong experience in creating complex queries and views using data stored in JSON format |
| 4 | Required | Optimizing performance of stored procs and views accessing data stored in JSON format |
| 5 | Preferred | Knowledge of JIRA/BitBucket |
| 2 | Preferred | Experience in Nomad |
| 2 | Preferred | Experience with Texas Student Data System (TSDS) |
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
| Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. | ||
| Years | Required/Preferred | Experience |
| 8 | Required | 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 |
| 8 | Required | Agile Development |
| 4 | Required | Strong experience in storing, querying, manipulating JSON data in Oracle database tables |
| 4 | Required | Strong experience in creating complex queries and views using data stored in JSON format |
| 4 | Required | Optimizing performance of stored procs and views accessing data stored in JSON format |
| 5 | Preferred | Knowledge of JIRA/BitBucket |
| 2 | Preferred | Experience in Nomad |
| 2 | Preferred | Experience with Texas Student Data System (TSDS) |