Job Description
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
SKILL MATRIX
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.
- Strong experience with Oracle SQL and PL/SQL (advanced concepts such as bulk collect, handling data in JSON)
- Strong experience with writing complex optimized Oracle queries reducing SGA/PGA/TempSpace usage
- Strong experience in working with SQL Server
- Dev/Unit Testing and Documentation
- Strong experience in storing, querying, manipulating JSON data in Oracle database tables
- Agile Development
- Knowledge of JIRA/BitBucket
- Experience in Nomad
- Experience with Texas Student Data System (TSDS)