Experience

Chugach Alaska Corporation

• Executive Offices
• 400 - 500 Employee

• Sr Oracle Architect

  • Mar 2013 - Present

  • DISA STIG implementation for Oracle RDBMS 11g and 12c on OEL and RHEL 6.5 platforms.• Implementation of Oracle 12c on RHEL 6.4 platform for deployment of UCOP 3.0 database system.• Perform performance and benchmark testing of data loads using RTI DDS, RTI RTC, Oracle TimeTen in-memory database and Oracle 11g RDBMS. Redesign Oracle stack to increase data throughput and optimize real time storage.• Perform Oracle architectural analysis and documentation of current USCG Vessel, Aviation, Cell Phone, radio, personnel tracking system. This evaluation was performed to determine the issues with existing systems inability to maintain pace with current incoming tracking data. The findings where used to build an architectural design which would allow the USCG to keep pace with current and future incoming track data.• Design and implement new data structures to accept incoming data tracks from USCG Vessel, Aviation, Cell Phone, radio, personnel tracking system.• Optimization of 11g RDBMS suite to increase performance of I/O operations.• Development of implementation plan to re-platform current environment from Windows 2008 to RHEL 5.6.



Independant Consultant: Information Technologie - Oracle Database

• Senior Oracle Developer/administrator

  • Jan 2007 - Present

  Provide Oracle RDBMS Service in the following areas:-Oracle RDBMS Design/Configuration/Deployment.-Oracle RAC Design/Configuration/Deployment.-Oracle RDBMS Backup and Recovery Solutions.-Oracle RDBMS Disaster Recovery Solutions.-Oracle RDBMS and RAC optimization services.-Oracle security services. Provide Oracle RDBMS Service in the following areas:-Oracle RDBMS Design/Configuration/Deployment.-Oracle RAC Design/Configuration/Deployment.-Oracle RDBMS Backup and Recovery Solutions.-Oracle RDBMS Disaster Recovery Solutions.-Oracle RDBMS and RAC optimization services.-Oracle security services.



US Navy

• Senior Oracle Developer

  • Oct 2012 - Apr 2013

  • Document and implement changes to database objects to provide new or enhanced user functionality within Navy financial management systems. Development of EDI verification of communication between DON financial reporting systems and DOD financial reporting systems• Evaluate, review and implement data warehouse system for reporting of financials of DON. Development of ETL script for loading and verification of data warehouse RDBMS dimension and fact tables from various DON financial systems.



US Navy

• United States
• Armed Forces
• 700 & Above Employee

• Senior Oracle Architect

  • Apr 2011 - Aug 2012

  • Merge multiple Oracle databases of varying versions into single RDBMS and integrated similar data stores into a single schema.• Adapt PL/SQL code to work with new RDBMS data structures and perform optimization of code.• Analyze and developed implementation plan for re-design of application modules use of APEX 4.1 and Oracle RDBMS 11.2. • Analysis of 9 Naval Shipyard Oracle 10.2.0.5 databases for the ETL operations into a single Oracle RDBMS.• Design and implement Oracle stored procedures for the verification and processing of EDI transfers for military personnel system into Naval Shipyard personnel systems.• Design and implement changes to maintenance database structures and logic to allow for new system functionality.• Development of conversion scripts using external table structures and SQL*Loader for transfer existing data from regional systems to centralized database.• Review and analysis of Oracle 10.2.0.5 database structures for upgrade of ship repair application.• Gather statistical database performance for analysis of application responses times.• Configuration of Sun VM machines for multiple Active directory instances in Development environment.



Marine Corps Recruiting

• Armed Forces
• 700 & Above Employee

• Senior Oracle Developer

  • Jul 2010 - Oct 2011

  • Upgrade six 11.2.0.1 RAC databases to 11.2.0.2.• Implement Oracle 10.2.0.5 PSU on 9 single instance databases.• Implement Oracle 11.2.0.1 CPUJAN2011 on 5 RAC databases and 1 single instance database.• Implement DOD Security STIG hardening for 9 Oracle 10.2.0.4 RDBMS suites.• Implement DOD Security STIG hardening for 5 Oracle 11.2.0.1 RDBMS RAC suites.• Implement RMAN backup procedures for Oracle 10.2.0.4 databases and Oracle 11.2.0.1 RAC databases on RHEL 5.4 using bash scripts to perform monitoring and logging of all processes.• Reconfigured 16 Oracle 10.2.0.4 single instance RDBMS system to operate against OS layer file structure from ASM instances• Converted 8 Oracle 10.2.0.4 single instance RDBMS systems into Oracle 10.2.0.4 RAC.• Converted 6 Oracle 11.2.0.1 single instance RDBMS systems into Oracle 11.2.0.1 RAC.• Configuration of auditing for Oracle 10.2.0.4 and 11.2.0.1 per DOD STIG requirements.• Configuration of 6 Windows 2008 VMware machines for hosting of Oracle 11.2.0.1 single instance databases.• Troubleshoot and repair application developer systems and configuration of connectivity to various Oracle RDBMS systems.• Installation of Oracle 10.2.0.4 RAC two node cluster on RHEL 5.3 for support of Web-based documentation RDBMS.• Review of Technical documentation for the implementation of Web-portal to support the information technology requirements of DOD based clients.• Plan, document and implement configuration of Oracle 10.2.0.4 and 11g RAC databases to support document and information storage for DOD client.• Analysis of system security settings to meet all DISA STIG requirements for Oracle RDBMS, WebLogic application servers and RHEL OS.



U.S. Department of Homeland Security

• Government Administration
• 700 & Above Employee

• Senior Oracle DBA

  • Sep 2010 - Oct 2010

  • Analysis of performance issues in Oracle 10.2.0.4 RDBMS system hosted on HP-UX 11.3 servers. Determined that performance issues were related to a slow down in access to SAN storage, which could not be repaired through optimization of SAN configuration. Increased the number of Oracle process for i/o which reduced the wait times on RDBMS and resolved performance issues.• Configured Oracle Grid Control to allow for graphical monitoring of Oracle 10.2.0.4 single instance and RAC RDBMS systems.• Configuration of Windows 2003 VM machines for Oracle 10.2.0.4 Apex implementation.• Upgraded PRISM 6.3 system to PRISM 6.5 for the processing of government contract payments.• Optimization and development of DDL scripts for system analyst to correct data entry mistakes. • Text transformation of input variables from flat files with PERL scripting.



Unisys

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Oracle DBA

  • Sep 2008 - Jul 2010

  • Installation of Linux based Oracle 10.2.0.4 environment for data warehouse build from 6 online transaction databases. Source database system ranged in version from 9.2.0.8 to 10.2.0.4• Standup of new training suite which integrated revised production system into corporate training portal consisting of 6 database system, 4 application servers, 2 HP-UX servers, and 5 RHEL servers.• Conversion of monitoring, optimization and maintenance scripts of RDMBS to new standardized organizational directory structures for all RDBMS. • Conversion of Oracle 10.2.0.4 on HP-UX to 10.2.0.4 on RHEL, including conversion of data files to allow for OS differing Indian codes.• Development of conversion plan for 8 database suites, with versions of 8.1.7, 9.2.0.1, 9.2.0.8, 10.2.0.3 and 10.2.0.4. Plan included: version upgrade and patching instructions to bring all RDBMS to 10.2.0.4 with CPUJAN 2010; full life cycle upgrade processing (development, test and production); regression testing to minimize user impact.• Implement 2 VMWare ESX 3.0 servers for testing of virtualized test database for application development and modifications with guest OS of RHEL and Windows.• Movement of Oracle 8.1.7 RDBMS on HP-UX through SCP transport, re-linked all RDBMS software for standup on new host and recreation of control files for standup of database.• Development of PERL shell scripts to transform production databases into test system for analyst script development.• Configuration and documentation of Single Sign Oracle RAC system for authentication of access to entire DHS, TSA, and USCG financial systems.• Movement of Oracle 9.2.0.8, 10.2.0.3, 10.2.0.4, 11.2.0 RDBMS from 1024 SAN storage devices to NetApps 6040 SAN storage devices.



NANA

• United States
• Executive Offices
• 300 - 400 Employee

• Senior Oracle Developer

  • Feb 2008 - Jul 2008

  • 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.



Platinum Solutions

• Information Technology & Services
• 1 - 100 Employee

• Senior Oracle DBA

  • Oct 2006 - Jan 2008

  • 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 • 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. • 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.



Unisys

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Oracle DBA

  • Oct 2005 - Oct 2006

  • 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.



Serco

• IT Services and IT Consulting
• 700 & Above Employee

• Senior Oracle DBA - Project Manager

  • 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.



Evergreen Shipping Agency (America) Corp.

• United States
• Maritime Transportation
• 200 - 300 Employee

• Developer

  • Jan 1994 - Mar 2000

  • Develop detailed maintenance and support plans for 20 end user computer systems to include: management and reporting of licensed software; requirement, request, and justification documentation to maintain and purchase new software and hardware; analysis and development of backup plans to ensure data storage and recovery capabilities; document current network layout for management review, develop and recommend changes to software, hardware, and network to provide for increase productivity of system users as relating to new business procedures and objectives. (NT, WINDOWS 3.11, 95, 98). • Design, implement, and maintain 25+ terminal units for UNIX system and 3 remote server units for satellite corporate computer system. • Analyze, review and plan end user training to increase individual user’s computer skills for achieving management’s stated objectives. Develop detailed schedule of training and evaluation periods for the development of end users and reported to management on continual progress. Responsible for the training of 25+ personnel in the use and application of software to support 18 different job descriptions. • Manage user account and accessibility to LAN. Creation of role to grant both administrator and user account access to database systems ensure the protection of both corporate and personnel data over information systems. Management of NT user accounts on LAN.