PL/SQL OR Oracle Developer

Job Description Required Clearance - Active Secret Clearance

Position Description: 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 in order to achieve the mission of the Department of State CA/CST and priorities of the client. Serve as a champion for driving data quality initiatives and pre-emptive production support and will quantify the client impact.

• 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.