In this role, the developer will be responsible for developing innovative SQL & PL/SQL solutions to improve the performance, integrity and security of the clients databases, driving data quality initiatives, and pre-emptive production support.
Requirements
- Write packages, stored procedures and functions, and triggers
- Read, understand and improve upon existing SQL and PL/SQL code
- Unit test code, and identify and fix bugs
- Define and create data structures for schemas including tables, views, indexes etc.
- Assist in developing deployment scripts for releases
- Participate in the full SDLC including design, coding, testing and production releases
- Experience with PHP development
- Experience with jQuery, HTML5, and development using JavaScript frameworks e.g. Bootstrap
- Experience with implementing REST API
- Experience with Git/GitLab/GIT Bash
- Experience with Agile development cycle
- Analyze legacy data and production support issues; determine areas of improvement and propose remediation; execute pre-emptive data remediation; analyze and report the improvements/results
- Generate weekly status updates, technical documentation, and milestone reports that show the benefits of data quality and pre-emptive data remediation