Install, upgrade and patch development and QA Oracle database systems. Monitor performance and suggest options to increase performance. Design and develop packages, procedures, functions and triggers based on customer requirements. Provide technical support and guidance to developers. Analyze client requirements and documented technical specifications. Work with Oracle consultant to design and implement multi-master system using Golden Gate Veridata. Install and configure Oracle Cloud Control 13c to monitor and maintain Oracle systems. Assist USCG sustainment database team with Oracle database administration, maintenance, troubleshooting, tuning, installation, and backup/recovery running on Linux servers.

Architected new report process to use Oracle Steams and not do a full nightly data push for reporting. Developed and implemented sustainable data archive policy and process. Installed Jasper Server and developed reports using iReport to replace the data extract requests for personal reports. Train and manage database staff in all areas of data services including Oracle, MySQL and MS SQL. Implemented a quarterly patching process. Identified issues with data duplicated on multiple Oracle instances. Began upgrade process to 11g and identifed issues with legacy systems. Documented databases systems as well as process and data flow. Implemented on call rotation for database staff. Started process of vitalizing all Oracle database server as well as testing consolidation of instances to lower licensing costs.

Extract and transform data from multiple sources for ingestion. Massage data to ensure duplication is avoided. Capture business rules and develop a business rules document. Install, upgrade, and patch Oracle instances. Monitor server performance, tune database servers and applications, and perform backup and recovery. Provide consulting solutions to various clients in database design, database server configuration, data warehouse implementation, server performance tuning, and application tuning. Develop, monitor, and enhance database backup procedures. Design and re-engineer databases that make up the JTDS (Joint Terrain Data Services). Define database requirements and designed data model for JTDS and the Air Force ERP (Environmental Restoration Program) and Adrec (Administrative Records Information Repository). Provide technical support and guidance to developers. Analyzed client requirements and documented technical specifications. Used case tools to build the data model. Developed Oracle database stored procedures, packages, and triggers to process business rules and data logic. Ensure data consistency from data loads from other data sources. Supervise staff of developers that include web programmers, GIS analyst and other database administrators. Evaluate hardware, system backup software, and procedures as well as disaster recovery procedures for sites.

Administer and maintain three production and two development Oracle 9i instances on Solaris 8 and 9. Administer two production Oracle 9i Application servers. Apply IAVA Oracle database and Application patches. Evaluate database tools, GIS packages and development tools. Monitor and enhance backup procedures. Maintain legacy Oracle application while gathering requirements for future development. Develop and redesign functions, procedures and packages. Ensure data consistency from data loads from other data sources. Provide technical support and guidance to end-users.

Administer and upgrade five development and three production Oracle instances as well as two production SQL Server 2000 instances. Develop and maintain backup policy and disaster recovery policy. Provide technical assistance to network and systems administrators as well as personnel accessing the systems. Review and develop security policies. Support application developers designing and redesigning PL/SQL functions, procedures, packages and triggers. Install and evaluate database tools and products. Install, upgrade and administer Citrix MetaFrame server and wireless network.

Installed, upgraded and administered Eastern Federal Lands Highway Division (EFLHD) Oracle production database and Oracle Application Server. Designed and maintained Crystal reports and Enterprise Reporting server for EFLHD. Designed LA County First Responder SQL Server 2000 database. Configured replication for EFLHD based on security roles and customer needs. Performed extraction, transformation and loading (ETL) for production and development systems. Installed, configured and administered ArcSDE and ArcIMS development systems. Performed database design / redesign and documenting for new and existing systems. Configured and evaluated different RDBMS as well as development tools. Programmed PL/SQL packages and procedures as well as Java and JSP.

Mainly focused on a contract for USAMMA (United States Army Medical Material Agency) by developing procedures for data collection, cleansing and implementing rules to manipulate data for end users. Designed table structures and program PL/SQL packages, procedures, and triggers. To improve performance-- redesigned the MIDRP (Military Infectious Diseases Research Program) database. Installed and configured data replication to ensure system availability. Monitored and maintained client production and development databases while programming PL/SQL procedures and packages. Designed relational database schemas for efficient data storage and retrieval as well as performed data manipulation on existing data to conform to new business rules. Performed upgrades and maintenance on Oracle databases and the company accounting Costpoint System. Scheduled and maintained a routine backup and document policies and procedures. Performed database and application tuning while planning for possible growth.