Skills Summary

Extensive experience in project management of IT teams, enterprise relational database solutions, online application development, web enablement of applications for federal government, department of defense and civilian organizations.

Key Skills and Knowledge

• Database Administration
• Database Optimization
• Database Design and Integration
• Data Conversion
• Data Migration
• Database Security

Databases

• Oracle 8i, 9i, 10g, 11g
• SQLServer
• DB2
• Sybase
• MySQL

Operating Systems

• Windows
• Solaris 8,9,10
• HP - UX
• Linux 4.5

Programming Languages Tools

• PL/SQL
• Java /Java Script
• C/C
• HTML/Dynamic HTML/XML
• PERL
• Visual Basic
• Oracle 7.3, 8.05, 8i, 9i, 10g,11g
• SAP
• CMM
• Sybase Interactive
• SAS
• Erwin
• MS Project
• OEM
• TOAD
• Oracle Forms
• Oracle 10g RAC
• Crystal Reports
• Informatica
• Business Objects
• Oracle AS10g
• Deltek Time and Expense
• Deltek Cost Point
• Cognos 8
• Impromptu
• nagement

Project Experience

Reliable Database Solutions 07/08 Present

• Implementation of two node Oracle 9i RAC system on Linux Fedora: to include the use of binary Automatic Storage Management ASM, physical Data Guard fall-over database, and RMAN backup and recovery setup.
• Upgrade of Oracle 9i RAC to Oracle 10g RAC on two node RAC installation on Linux Fedora which to include all patch updates.
• Re-deployment of using Word Press web-development application. Documentation of Oracle of Oracle tips and tricks to increase the performance of Oracle database system, enhance the current configuration of Oracle 9i and 10g database systems, and provide useful tips in the recovery from common database errors during installation and configuration.
• Configuration of Oracle 11g database RAC on Linux Fedora for testing and analysis of new system with latest Oracle Database release. Upgrade of Oracle 9i and 10g databases to Oracle 11g.

Reliable Database Solutions Confidential

• Implementation and documentation of logical Oracle DATAGAURD for standby database solution. To include: creation of stand by database adjustment of all init parameters DGMGRL monitoring and administration testing of fall-overs.
• Implementation and documentation of RMAN backup and recovery procedure for Oracle 10.2.0.4 databases using Oracle EM. To include: Script definitions scheduling with EM email notification in case of failure and testing of various recovery procedures with EM.
• Implementation and documentation of ORACLE 9i to 10g manual upgrade procedure. To include: Creation of new Oracle 10.2.0.4 database automated creation of non-oracle user accounts with privileges scripts automated creation of import utility scripts implementation of imports validation of Oracle 10.2.0.4 integrity.
• Implementation and documentation of the setup and configuration ASM instance for data storage: To include: implementation of Oracle Cluster Synchronization Service CSS setup of local and SAN RAW devices creation of ASM instance with DBCA creation of disk groups and administration of ASM with ASMCMD utility and EM.
• Documentation of Oracle 10.2.0.4 administration with Oracle Enterprise Manager EM . To include: administration of Oracle EM with EMCA and EMCTL utilities setup of EM for automated email notification of alerts definition of Oracle alert policies monitoring of database performance configuration of RMAN backup schedules and general administration tasks.
• Implementation and documentation of upgrade procedures to Oracle 10.2.0.4 on RHEL 4.5
• Implementation and detailed documentation of installing Oracle 10.2 on RHEL 4.5.
• RHEL 4.5 configuration on two Dell servers for the installation of Oracle 10.2.0.4 RDBMS. The installation included the configuration of all kernel parameters and installation of all RPMs to support an Oracle database server.
• Development of new backup and recovery procedure for Oracle 9i interim solution.
• Implementation of automatic startup and shutdown scripts for Oracle 9i RDBMS and listeners.
• Implementation of Oracle 9i RLS functionality on interim database server for restricted user data access.
• Movement of Oracle Web HTML suite from production servers to new interim database server.
• Development of detailed project plan for the implementation of new production suite. This project plan included: implementation of ORACLE 10.2.0.4 configuration of SAN RAW devices for ASM instance building of Oracle ASM instances build of individual databases migration of Oracle 9i databases to Oracle 10g implementation of Oracle logical DataGuard solution implementation of EM configuration implementation of RMAN backup and recovery procedures.
• Build of new Oracle 9.2.0.8 RDBMS server for interim solution on RHEL 4.5 64bit. Build included full documentation of Oracle 9.2.0.4 installation upgrading Oracle 9.2.0.4 to Oracle 9.2.0.8 and implementation of all CPU patches. This implementation was completed for a re-configuration of Oracle 9i to improve system performance.
• Patching of Oracle 9.2.0.8 databases with CPUJAN 2008 and CPUAPR 2008 patch sets.
• Patching of DELTEK CostPoint 6 on Windows 2003 servers to include with re-publication of application over Citrix servers.
• Patching of DELTEK Time Expense 71 on Windows 2003 servers to include redeployment over BEA Weblogic web servers.
• Developed scripts to automatically monitor the status of Oracle 9.2.0.8 database instances and Oracle listener process, which sent out email notification upon failure.
• Took over daily monitoring and maintenance procedures from Fujitsu Corporation of NANA Development Corporations DELTEK financial system. This included monitoring and administration of a single production and two development/test suites. The suites installed on RHEL 4.5 and Windows 2003 servers. Software packages administrated were DELTEK CostPoint 6 DELTEK Time Expense 7.1 DELTEK Datacall Cognos 7 Impromptu and Oracle 9.2.0.8 RDBMS.

Reliable Database Solutions Confidential

• Developed and implemented detailed cross-over plan for the take over of DELTEK financial systems from Fujitsu Corporation.
• Interviewed and documented all maintenance procedures of Fujitsu technical personnel as they were performed in both the US and Off-shore.
• Reviewed, documented, and provided alternative solutions for all anomalies related to Oracle 9.2.0.8 RDBMS configurations, data replication implementations, and backup/recovery procedures in place.
• Reviewed all documentation from Fujitsu Corporation for planned take over of the following systems: DELTEK CostPoint 6 DELTEK Time Expense 7.1 DELTEK Datacall Cognos 7 Impromptu BAE Weblogic and Oracle 9.2.0.8 RDBMS.

Reliable Database Solutions Confidential

• Performed security hardening of Oracle 10.2.0 RDBMS system to Defense Information System Agency Oracle STIG requirements. The security review and implementation included: hardening of user accounts, definition and setup of secured policies, review and restriction of Oracle packages and procedures, setup of secured network communications, setup and configuration of wallet identification, restriction of administrative level accesses, and setup of auditing on defined policy violations. Dec 07
• Installation of Oracle 10g for production database system. To include configuration of Oracle Enterprise manager, email notification of Oracle Alerts, Policy definition to meet stated database monitoring goals, growth analysis to define necessary storage requirements for 12 month period, setup of Flashback database, and configuration and testing of RMAN backups for multiple failure scenarios. Dec 07

Reliable Database Solutions Confidential

• Installation and testing of newly released Oracle 11g on Red Hat Fedora 7. Development of installation documentation, required patch sets, upgrade/migration operations from previous oracle releases, and documentation of new and changed features. Sept 07 Oct 07
• Confidential
• Development detailed backup and recovery procedures for Naval Safety Center CNO, Norfolk, VA to include use of online RMAN backup and recovery scripting, use of flashback database technologies, and configuration of Oracle flashback area. Trained and tested all backup and recovery procedures with permanent staff. US Navy July 07 Aug 07
• Installation and Configuration of Business Objects Enterprise XI R2 in three tier deployment environment. Connectivity to DB2 version 6 for storage of CMS repository and target reporting databases. Configuration of BOE processing servers on Windows 2003 servers. Configuration of BOE WCA on RHEL 4 deployed over IBM Websphere application server. DOL June 07 July 07
• Developed installation and configuration guide for BOE XI R2 in three tier environment, to include: OS configurations, architectural design, step-by-step installation and trouble shooting. DOL June 07 July 07
• Installation and configuration of Business Objects' Data Integrator in two tier environment for the conversion of redesigned DB2 databases. Data Integrator is an ETL tool which support the conversion of data elements to new RDBMS systems. DOL June 07 July 07
• Developed installation and configuration guide for the deployment of Data Integrator in a Windows 2003 environment against IBM DB2 databases. DOL June 07 July 07
• Review of FDA Oracle 8.1.7 data warehouse instance for maximum performance in the delivery of drug approval processing. The review included the analysis of current disk and system allocations, initialization parameters, tablespace allocations, table design specification partitioning and use of external files, table indexing, memory processing hit ratios of library and dictionary cache. Apr 07 May 07
• Review of FDA DARRTS system's embedded SQL statements in Java application. Performed analysis of each SQL statement to determine proper use of indexing and avoid unnecessary join and sort operations in production system. Creating of new indexes to avoid full table scans and introduction the use of materialized views to avoid join operation at run-time. Apr 07 May 07
• Trained 8 Java developers in best practices of writing optimized SQL code. Covered a brief description of optimized design in an ORACLE RDBMS system, so the developers could spot potential problems in the database and OS which may cause application slow down and work with the Database Administrators and System Administrators for resolutions. Covered the analysis of a SQL statement to include both EXPLAIN PLAN and DBMS TRACE operations. Covered clauses to avoid that result in additional sort operations and the use of Oracle HINTS. Apr 07 May 07
• Developed implementation solution for tracking and archival maintenance of all data warehouse record changes across single database instance for DOL. Feb 07
• Review and correct physical design of US Marshall Personnel database system to meet system requirements outlined in US Marshall design specifications. Feb 07
• Configured Oracle 10g on Redhat Linux servers for Platinum Solutions Corporate database repository. Feb 07
• Migrated Oracle 8i and 9i databases to Oracle 10g enterprise database for Platinum Solutions Corporate Database repository. Feb 07
• Implemented GUI application for FBI security investigation system using Oracle Forms 4.5 against Oracle Enterprise database 9.2.0.7. Jan 07
• Configured Oracle 10g on Solaris 10 servers for US Navy Safety Center to included: Flashback database service for recovery of logical application failures configuration of Oracle 10g dataguard for standby database Configuration of RMAN for automated weekly compressed backup sets and daily incremental backups Installation of Oracle 10g Enterprise console for government staff Upgrade installation using Oracle OUI patch sets and Upgrade installation using Oracle Opatch patch sets. Oct 06 Dec 06
• Informix 9 conversion to Oracle 10g for US Navy Safety Center to include: Installation and configuration with Informix 9 odbc drivers and Oracle Migration Workbench version 10.1.0.4 Developed step by step instruction sets for the conversion of Informix 9 database to Oracle 10.2.0.2.0 Developed multiple shell scripts for modification of data in OMWB unloader files Developed PL/SQL scripts for record/object count comparison of conversion results and Developed PL/SQL scripts to produce converted data dictionary. Oct 06 Dec 06
• Government Oracle DBA staff training, US Navy Safety Center, to include: Configuration of Solaris 10 server for installation of Oracle 10g Installation of Oracle 10g Configuration of Oracle 10g Enterprise manager Use of Oracle Database Creation Assistance Configuration of Oracle Networking Configuration of Flashback database and archivelog modes Configuration of Oracle dataguard Configuration of RMAN recovery procedures Use in export datapump and import datapump Detailed instruction for OUI patchsets and OPatch patchsets and General training on the use and administration of an Oracle 10 database. Oct 06 Dec 06

Confidential

• Developed detailed instruction set for the installation of Business Objects XI R2 on Solaris 9 OS. Instructions sets covered: complete configuration of the OS environment parameters to support Business Objects XI creation of OS groups and users installation and creation of Oracle 9i database for Business Objects repository installation and configuration of Business Objects Server installation and configuration of Oracle Application Server 10g Oracle AS10g for deployment of Business Objects configure and connection of Business Objects server to target databases, and initial configuration of Business Object users, permissions, and universe design.
• Developed Oracle procedures for deployment of XML data streams to .net and java application servers.
• Plan, install, and administrate Solaris 9 OS systems for EXFIRS IRS contract. Developed and updated the instructional sets for installation and administration of Solaris 9.
• Develop and implement Oracle 9.2 RDBMS systems for use by EXFIRS IRS contract. Developed instruction sets for the installation of Oracle 9.2 RDBMS on Solaris 9.
• Develop and implement backup and recovery procedures for EXIFRS IRS contracts OS, application and database systems.
• Perform daily and weekly operational system checks on Solaris and Oracle RDBMS.
• Performance tuning of SQL and Oracle RDBMS to provide IRS with optimal performance.
• Test installation of new system software.
• Development of administration guides for Oracle, Solaris, and application software.
• Review Data warehouse designs for performance enhancements.
• Test and installation of new system hardware.
• Support Government SA/DBA in troubleshooting and resolution of OS and Oracle errors.

Confidential

• Successfully built MIS support team to manage 109 Oracle RDBMS, Application Systems, and networks throughout the United States, to include 7 centrally located support personnel and 5 regional personnel. May 2000 Oct 2005
• Recruit, evaluate, counsel, and train IT personnel in Application Development, Oracle Administration, and networking solutions. May 2000 Oct 2005
• Implemented database archiving procedures which created OS File records in XML for archiving to tape. June 2005 July 2005
• Reduce local support cost by 80 through the successful merger of 36 heterogeneous database systems into a centrally managed Oracle RDBMS. Feb 2003 Jun 2003
• Implement Configuration Management procedures to analyze, test, and document all configuration changes made to production information system for the US Navys Pollution Prevention Program. May 2000 Oct 2005
• Implement security hardening of Oracle 8.1.7, 9.2, 10.1 according to Defense Information System Agency standard Oracle STIG.
• Proctored development meetings between the DON, DOA, DAF, DOD, DLA, and 4 government contractors for the development of global RDBMS system to support Web-enabled HSMS Hazardous Substance Management System . May 2003
• Direct the development of database, OS and network recovery plans for Oracle 9.2.0.4 database on HP-UX and Windows platforms, to include: identification of failure, analysis of recovery methods, detailed recovery plan, and system recovery reporting. Aug 2004 Sept 2005
• Plan and manage the development of Oracle conversion scripts to migrate site hazardous inventory data from HSMS 2.4.1 and RHICS schemas into HSMS 3.0. Aug 2003 Present Plan and implementation of Oracle 10g RAC database for the deployment of HSMS 3.0 based in HP UX environment. Oct 2004 Sept 2005
• Direct the development of database, OS and network recovery plans for Oracle 9.2.0.4 and 10g database on HP-UX platform, to include: identification of failure, analysis of recovery methods, detailed recovery plan, and system recovery reporting. Jan 2004-Sept 2005
• Analyze, design and implement database schema for the combination of two hazardous material inventory system in Oracle 8.1.7. Using Oracle DBA Studio, Erwin, and TOAD design tools to integrate RHICS and HSMS database schemas. Mar 2000-Oct 2005
• Migration of RHICS Regional Hazardous Inventory Control System web application from Oracle 8.1.5 RDBMS to Oracle 9.2.1 RDBMS. Feb 2002 Jan 2003
• Installation and configuration of dual redundant RHICS Regional Hazardous Inventory Control System web application. Implement Oracle 8.1.5 RDBMS on Windows NT 4.0 OS and Dell 6400 platform. System used shared disk array with RAID V and controlled through Windows NT fall over to provide for RDBMS, OS, or platform failure. Mar 2000-Oct 2005
• Resolve NT4.0 networking problems and local network hardware problems in HSMS sites that affect the connectivity between servers and clients. Mar 2000-Oct 2005
• Develop security access procedure for all Oracle database under direct control to restrict access to authorized personnel only. Advise and develop plans for site security of Oracle databases to ensure safeguard and restriction of classified data.
• Advance analysis and review of all documentation related to the continual development, implementations, and maintenance to HSMS. Redesign of document to enable user and system administrator to maintain HSMS software, hardware, and backup libraries.
• Management, configuration, and implementation of database objects in a client/server environment on Windows NT, HP UNIX, and Sun Solaris platforms and over TCP/IP and Novell networks.
• Develop centralized Oracle database of all hazardous substances contained in the Navy's inventory. Develop scripts to extract data from the central RDBMS for the implementation of future HSMS sites through cross-referencing of unique local inventory information.
• Evaluate, test, and recommend new RDBMS and applications i.e. Data modeling, data retrieval, adhoc reporting tools for the production, implementation, and expansion of naval computer systems for the management of hazardous materials RHICS, HSMS, and HICSWIN .
• Configuration, implementation and management of extremely complex RDBMS in support of highly accessible user applications HSMS, RHICS . Provide recommendations, support, and develop implementation schedule in the adjustment and fine tuning of RDBMS to increase user accessibility and uptime.
• Maintenance and continual development of the naval total asset visibility web site, Regional Hazardous Material Management System RHMMS, for the regional management of hazardous materials. Web site development performed on NT 4.0 platform using IIS3.0. Data retrieved from FTP server that receives daily transmission of hazardous materials data from seven regional sites. Support included the standup and scripting maintenance of 7 client sites that provided daily uploads.
• Develop, evaluate and review software and hardware requirements of Regional Hazardous Inventory Control System RHICS . Advise on hardware and software possibilities that aided in successful implementation of RHICS developed in Java against an Oracle 8i RDBMS.
• Perform data analysis, design planning, implementation schedule, and reporting plan for the development of conversion scripts to migrate HICS DOS database developed in Dbase IV to RHICS database schema developed and implemented in Oracle 8i. Analyzed, resolve and implement changes to schedule and RDBMS design to allow for successful completion of conversion project within defined time limits. Develop detailed reporting plans to provide for the continual communication of project status to IT directory.
• Perform analysis, design, and implementation plans from requirement specifications to develop and maintain MsAccess modules for the modification of data in Hazardous Inventory Control System HICS . System operates against Sybase Runtime RDBMS on standalone PC for Naval shipboard use.
• Develop verification and conversions scripts to migrate Oracle 7.3.4 HSMS Hazardous Substance Management System database schema to Oracle 8.1.5 web based RHICS Regional Hazardous Inventory Control System database schema. Reduction in complexity of database performed to increase access time over web application for sites, which have less tracking and reporting requirements by federal agencies.