Database Developer - for the US Army, TRADOC, Newport News
InCadence Systems －
Found security problems with APEX-based oracle system. Correcting in order to gain authority-to-operate via installation, server, instance and database changes.
Provided alternative architecture (node.js, MONGODB) for the new systems, to replace the java content repository-based existing archiecture.
Reviewed and provided a better document-oriented design for the existing MONGODB-based system.
Oracle Database Administrator at the NGA
Jan 2011－Jan 2014
BAE Systems －
Developed pl/sql packages for the web application, using spatial operators.
Developed pl/sql packages for the extract, transform, and load procedures.
Improved speed of a key area where 4D to 2D geometry was performed by rewriting, using parallel pl/sql that utilized direct-path inserts with parallel processing.
Added continuous instance monitoring - in the areas of: database alerts, data content, and data 'freshness'.
Created very reliable, well-performing continuous load jobs involving web services, bash utilities, and pl/sql.
As data architect, advised the client on data retention policies and implemented procedures to ensure compliance.