Oracle Engineer
Resume:
Experience Summary
. Extensive background as an Oracle database administrator/system
architect, with cumulative 15+ years experience in information
technology (IT), providing business users/clients with enterprise
level, cost-effective, cross-functional, time-based, integrated,
content management solutions from an array of structured and
unstructured data sets/sources.
. Experience consulting/contracting with clients from both private and
public sectors: Quest Diagnostics Inc, US Food and Drug Administration
(FDA), Verizon Wireless, Naval Sea Systems command (NAVSEA), Military
Traffic Management Command (MTMC), Federal Aviation Administration
(FAA), Department of Commerce Administrative Management System (CAMS)
CFS data warehouse, and the Environmental Information Technology
Management (EITM) - Department of Defense (DoD) cleanup projects.
. Experience working with upper management and leading engagement
efforts with project stakeholders, government Contracting Officer
Technical Representatives (COTR), encompassing all phases of
structured systems development and support life-cycle (SDLC):
Initiation, concept, planning systems/subsystems functions, system
requirement/analysis, database design, development, integration-
testing (I&T), implementation, operations-maintenance, and
disposition.
. Experience in deploying robust applications leveraging solutions from
Oracle Enterprise Manager Grid Control, Oracle RAC, ASM, Oracle
replication, Oracle standby/data guard, backup, restore and recovery
operations usage of RMAN metadata, test planning, data
integration/extraction transformation and load (ETL), application
upgrades and data migrations.
. Experience in performance tuning information systems running online
transaction processing (OLTP), online analytical processing (OLAP),
decision support systems (DSS) applications and implementing Oracle
advanced security solutions on heterogeneous network environments.
. Experience providing expert level tier three 24/7 O&M Enterprise
System Life Cycle Management Support (ELMS), for RetrievalWare release
8.2 Commercial-Off-The-Shelf (COTS), a relevancy search and discovery
software in development, test, pre-production and production for the
Food and Drug Administration (FDA).
. Experience in documenting/designing system/subsystem specification
(SSS) documents.
. Overall, experience has been gained using an array of Commercial-Off-
The-Shelf (COTS) applications, Oracle Relational Database Management
System (RDBMS), client-server applications, and web-based products in
simple and complex High Availability (HA)/Maximum Availability (MAA)
network architectural systems on UNIX, LINUX and Windows platforms.
. Oracle certified.
Computer Skills (Tools and Utilities)
Hardware/Operating Software Tools/Applications Languages
Systems Suites
Oracle Enterprise Manager SQL*PLUS, SQL1999
Minicomputers/Macro 10g/11g R2 Grid New Features, PLSQL, HTML, XML,
Computers - RAC ASM, RMAN, AWR, ADR, Shell/Perl
Virtualization - Oracle SQL Developer, Oracle programming Java,
VMWare/LDOM Migration Workbench (OMWB), Java Server pages
UNIX Flavors LINUX TOAD, ERWIN, Imp/Exp, Data (JSP)
RED HAT RHEL3/ RHEL5 Pump, Sql*loader, Tkprof,
, SUNOS SOLARIS V2.8 Explain Plan, Designer 2000,
through 5.10, HP-UX, OAS/iAS, Sun One iPlanet Web
IBM AIX Server, Oracle Application
DOS and Server 9iAS PORTAL Version
Windows-based PCs 3.0.9 through iAS 10G Release
Dell Power Edge 2. Oracle Developer Suite
2950 (forms and reports) Versions:
Windows V3.0, V4.5, V6.0 (6i), 9i and
Windows 3.1, 95, 98, 10g
NT, 2000, 2003, 2008 Eclipse IDE - SVN (Subversion
advanced servers, Support for CM)
windows XP, and VISTA RetrievalWare 8.2 (Enterprise
Search - Index, Query &
. MS Office Suite Spider Crawler server
Microsoft services)
Word/Excel/PowerPoint Adobe Acrobat Professional
(OCR Processes)
. Visio JBOSS 4.x Application Server
. MS Project Database
Oracle RDBMS V6.0,
V7.3.2.3.1, V8.0.5,
V8.1.5/V8.1.7 through
9i/10g/11g - 11g Release 2
Grid
Oracle Exadata Database
Machine/Appliance X3-2 on
LINUX Framework Rack
Professional Experience
Quest Diagnostics, Inc Sr, Oracle Database Engineer
September - December 2013
Consultant American CyberSystems (ACS) - WIPRO Limited (Short- term
Project)
. Capture/document System Maintenance & Technical Support Documents (SMTD)
- for the systemic transfer of operations/maintenance - IT services from
Quest Diagnostic to WIPRO limited - Locally in the US and overseas/off-
shore/India
. Focus on environments with very large databases running applications with
highly visible Service Level Agreements (SLA's) covering 24/7 operations
for Quest Diagnostics: QDRS, EMPI, Case Central/NextGen, QDSS, KRONOS
Workforce, Hyperion and Informatics Data Warehouse (IDW) applications
. Coordinate/present to upper management data captured during the initial
transition shadow/primary support phases to include: Overall - Standard
Operating Procedures (SOP's) for routine database
installations/cloning/DB refresh procedures, RMAN - backup restore and
recovery procedures, Oracle Disaster Recovery procedures - leveraging EMC
Symmetrix Remote Data Facility (SDRF) solution with IBM. Overall Oracle
database framework leveraging Exadata appliance, Oracle Real Application
Clusters (RAC), and traditional file systems.
Food and Drug Administration (FDA) Enterprise Search (ES)
Engineer July 2011 - August 2013
Senior Enterprise Search (ES) Engineer Macfadden/Professional Technology
Federal Systems (PTFS)
. Provide configuration O&M support for RetrievalWare, defining application
services and libraries, references to files system libraries, relational
database management system libraries (Oracle & Documentum), and Spider 2
libraries (Crawler) websites.
. Administer and manage 40+ libraries, indexing, categorizing, classifying
data and providing secured access to users.
. Monitor and verify automated ES scheduled jobs, indexes, and sequences,
routine e-mail alerts from HP on system resources for ES servers, routine
weekend recycling, health-checks, daily indexing and batch printing
processes.
. Provide weekly status reports and high level monthly accomplishment
reports to the government Contracting Officer Technical Representative
(COTR).
. Routinely upload and update related documents pertaining to the ES
project onto the centralized FDA eRoom.
. Provide continuous systemic tier-3 support to core integrated
applications centers: Adverse Event Reporting System (AERS) indexing and
batch printing processes, Mission Accomplishments and Regulatory
Compliance Services (MARCS) indexing OCR documents, Center for Tobacco
Products OCR-Merging PDF files, FirmFinder support in test and
development environments at the White Oak Data Center (WODC).
. Troubleshoot, guide and assist users with ES related searches,
coordinating Request for Change (RFC's) and opening trouble tickets with
the Enterprise Resource Information Center (ERIC)/HP service center.
. Coordinate support with PTFS RetreivalWare vendor on software bugs and
fixes between the ES support team and network /security teams in the
Contractor Host Data Center (CHDC) in Ashburn.
. Maintain awareness to new and emerging search technologies taking into
cognizant the following search criteria: user search capabilities,
application programming interfaces (APIs), Indexing, scalability,
administration and security.
ONAMBELE-ANCHANG-ASSOCIATES IT Consultant
March 2010 - June 2011
IT Consultant (Part- time Project)
. SDTKO project in Cameroon as an independent IT consultant for a BOT
(Build Operate Transfer) project. The link below to the SDTKO
presentation will provide you with the scope of the project:
http://onambele-anchang-associates.net/about-us/
. Webmaster for the ONAMBELE-ANCHANG-ASSOCIATES law firm website. Tools
(XML, WordPress). Link to website: http://onambele-anchang-
associates.net/
VERIZON Consultant DBA Architect
October 2009 - February 2010
Oracle DBA/System Architect Insight Global Inc
. Install, upgrade/migrate Oracle RDBMS software from versions 9i through
11g for the deployment and reconfiguration of SMARTS, eHeath, MRTG and
Remedy front-end clients (Performance Management/Service Management
tools) OLTP/DSS applications to Indiana (Verizon/Spinco Project).
. Develop policy and procedures relating to database maintenance, security
and archiving.
. Develop and implement backup and restore procedures.
. Allocate present and future system storage requirements for all
databases.
. Implement Automatic Storage Management (ASM) and Oracle Active Data Guard
(Physical Standby).
DOD KBCRS project from August 2004 through April 2009 for the Environmental
Information Technology Management (EITM)
Oracle DBA system Architect KBCRS project with the following companies:
Kadix systems, Concurrent Technologies Corporation, STG, Inc and TMSI
Kadix Systems, LLC Consultant DBA System Architect
November-21-08 to April-15-2009
Oracle DBA/System Architect - Private Consultant Knowledge-Based Corporate
Reporting System (Short term contract Knowledge Transfer) (KBCRS)
. Function as Oracle DBA and system engineer for the Knowledge-Based
Corporate Reporting System (KBCRS) OLAP/DSS application.
. Has primary responsibility for administering the KBCRS database servers.
. Assigns user IDs and initial passwords and maintains logs of active
users.
. Assist in the development of reports and tools for the KBCRS web site.
Assist in developing QA filter software, monitors and tests performance
of hardware/software.
. Supports and maintains the operational KBCRS web site.
. Performs database tuning, maintains production, development, and staging
database instances.
. Assist the data modeler and Oracle developer as needed.
. Develop documentation as needed. Mentors staff in Oracle administration.
. Responsible for the maintenance of the physical and logical/ERD database
design, capacity planning, workload modeling, software upgrades, backup
restore and recovery operations, and long term strategic planning.
. Migrate MS Access 2003/2007 and Excel to Oracle 10G.
. Create PL/SQL routines to load data from disparate systems into the
Oracle database.
Concurrent Technologies Corporation DBA System Architect
September-22-08 to November-20-2008
Oracle DBA/Systems Architect - Independent Consultant Knowledge-Based
Corporate Reporting System (KBCRS)
. Provide the system design and specs for the deployment of an upgraded
Portal30 metadata repository from STG, Inc in Reston Virginia to CTC in
Pennsylvania.
. Successful installation of Oracle RDBMS software and restoration of
Oracle AS Portal30 metadata repository in Johnstown Pennsylvania.
. Usage of VMware PC clients.
. Implement Oracle Enterprise Manager (OEM) 10G Grid Control for monitoring
and ease the management of Oracle software.
Environmental Information Technology Management (EITM)
STG, Inc January-02-2005 August-30-2008 - (Full Time Employee)
STG, Inc Consultant TMSI August-04-2004 January-02-2005 (Consultant)
Oracle DBA/ System Architect STG, Inc and TMSI
. Function as DBA for the Knowledge-Based Corporate Reporting System
(KBCRS), a web-based Oracle application providing secure access to
environmental program information collected from the military services at
the Department of Defense.
. Provide back-end database and web support for the implementation of a
three-tier enterprise application on Windows 2000/2003 advanced servers
in support of the Environmental Information Technology Management (EITM)
office operating under the Deputy Assistant Secretary of the Army for
Environmental Safety and Occupational Health.
. Responsibilities include database maintenance and tuning, reformatting
and loading of data received from military component organizations,
administration of security, evaluation of data quality, testing system
throughput and other duties as requested by the Program Manager.
. Main POC for the transition of the KBCRS system from the Defense
Information Technology Security and Certification Approval Program to the
Defense Information Assurance and Accreditation Process (DITSCAP/DIACAP).
. During the various phases of the data call responsibilities include:
. Ensuring that all database schemas are appropriately established prior to
the beginning of the data calls.
. Receiving all data submissions and performing initial quality control
checks (ensuring that the proper tables, field names and data have been
used by comparing the submission to the appropriate current data
templates).
. Converting Component data from Original source (Excel, MS Access and
Oracle binary export files into an appropriate Oracle format and loading
data into the staging area of the KBCRS web site.
Department of Commerce Support Center, Consultant/Tester
January 2004 August 2004
Oracle DBA/Tester - TEKsystems
. Performed basic database support for circa 50 Oracle instances, cloning
databases as requested from application developers, monitored distributed
database updates (Oracle replication updatable snapshots), and managing
user security/access in a development environment in support of the US
department of Commerce Administrative Management System (CAMS) CFS data
warehouse.
Federal Aviation Administration, Washington, Consultant/Architect
August 2003 January 2004
Oracle DBA/Architect - TEKsystems
. Document, systems/subsystems specification (SSS) for the implementation
of a real application cluster (RAC), SAN storage arrays, fiber
channel/fabric switches, to support resource tracking program for the
Federal Aviation Administration (FAA). The purpose of the SSS is to
provide an overview of the system design, application tier functions for
development and support in the integration and testing for the (FAA-RIP)
topology phase one.
Military Traffic Management Command, Consultant DBA/Architect
September 2002 January 2003
Oracle DBA/Architect - TMSI
. Design system/subsystem specification (SSS) for enterprise implementation
plan (EIP) to support personal property carrier qualification (PPQ WEB)
and staff duty officer (SDO WEB) programs in U.S geographic area. The
purpose of the SSS is to provide a complete detailed plan for the
conversion and development of a robust system application that automates
operations for tracking activities for the U.S. ARMY military traffic
management command (MTMC).
. Implement Java/J2EE N-Tire architecture with use of public key
infrastructure (PKI), DOD class 3-server certificates for encryption and
application of secure socket layer (SSL) enabled-server for
authentication [Web Server Tier]. Use of static hypertext markup language
(HTML) pages, java servlets, and java server pages (JSPs) in a web
container. Support for business logic with enterprise Java Bean (EJB)
components to facilitate life cycle, manage persistence, resource
allocation and data access with JDBC drivers [Application Server Tire].
Configure enterprise information store (EIS) responsible for storing
local and referenced Oracle objects [Database Server Tier].
. Reverse-engineer logical data model to accommodate business rules for PPQ
WEB schema and design new logical data model for SDO WEB schema. Ensure
physical implementation with development team document systems and data
flows.
. Perform database capacity planning: Check on memory needed for Oracle to
run on servers and number of processors used for Oracle services per O/S
server. Gather performance stats, hit ratio, logical/physical hits,
minimize contention, spread of disk I/O across as many disk drives as
possible, and separation of operating system files from Oracle database
files multiplexing Control files and keeping Oracle data files away from
disk files where swapping or paging occurs.
. Manage schema objects, indexes, data segments, tablespaces, datafiles,
views, synonyms, rollback Segments, sequences, table storage parameters,
clusters and creating database Links.
. Perform data conversion from flat files into Oracle with the use of
sql*loader.
. Built and customized shell scripts to auto populate production databases.
. Ensure proper documentation of Oracle environment so as to ascertain a
reliable and recoverable Oracle database. Use of NetBackup by Veritas
Oracle agent for hot backups.
. Maintain an awareness of existing, new and emerging technologies.
BAE Systems, Washington, DC, Consultant
August 1998 June 2002
Oracle DBA (EDP Contract Services)
. Performed various tasks for the support of NAVSEA configuration
management (CM) OLTP application, contract data requests list (CDRL) DSS
application, and post shake down availability (PSA) hybrid application.
. Providing plan for database migration/upgrade, re-engineering and
implementation of system development full lifecycle, which consists of:
Strategy Analysis, Design, Documentation Build/Development, Transition
and Production/Maintenance.
. Overall goal include taking into cognizance the following factors:
database growth, optimal performance and minimizing any down time for
users.
. Task responsibilities included:
. Gather performance stats, hit ratio, logical/physical hits, implement
RAID technologies, minimize contention, spread of disk I/O across as many
disk drives as possible, separation of operating system files from Oracle
database files multiplexing control files and keeping Oracle data files
away from disk files where swapping and/or paging occurs.
. Migrations from Oracle server V6.0, to V7.3.2.3.1 to V8.0.5, upgrade to
V8.1.5 and migrate to Oracle server V9.0.1.
. Configure and test environment to determine software version
compatibility for database client/server Applications. (Patches)
. Migration from Microsoft Access databases into Oracle.
. Perform multi vendor troubleshooting; isolate whether problems lie with
O/S server, database server software or Oracle middleware software such
as TNSnames.ora, encryption for packets sent to and received from the
Navy Yard 400D7 Portal 3-tire architecture.
. Install, upgrade and test client version from developer suite V3 through
V6.0.1.
. Implement security policies for users, profiles, quotas, privileges and
roles.
. Participate in data synchronization data load sql*loader.
. Perform logical backups via export/import utilities, Oracle hot standby.
Manage schema objects, indexes, data segments, tablespaces, datafiles,
views, synonyms, rollback segments, sequences, table storage parameters,
clusters and creating database Links.
. Provide technical support to developers and front end users diagnosing
and resolving database-related application problems
. Ensure compliance with Oracle license agreement, renewal of CSI numbers.
Education
M.Sc Chemistry University of Padova Italy
Oracle 9i DBA Oracle Corporation
Certification
Oracle Certified, August 2002
Recognition
Recognition for Excellence, January 2008 STG, Inc
Professional Affiliations
Expert Exchange
Bernard T Anchang Resume
Contact this candidate