About this role
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.
All your information will be kept confidential according to EEO guidelines.