Job DescriptionRequired Clearance - Active Secret ClearancePosition 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. Additional InformationAll your information will be kept confidential according to EEO guidelines.