Engineer Oracle
Resume:
Bernard. Anchang, Oracle DBA/System Engineer
BERNARD ANCHANG
Laurel MD 20708
Mobile: (571)-249- 7059
**************@***.***
Professional Summary
Bernard Anchang is a seasoned Oracle database administrator/system engineer, with
cumulative 10+ year’s experience in all phases of systems development and support life
cycle. This background includes: systems design and engineering, database design,
development, systems analysis, the implementation and deployment of both proprietary
and COTS applications using an array of Oracle client-server and web-based products.
Overall achievements include: lead for a successful upgrade of Oracle AS portal 3.0.9
through 10g (R2), development of detailed network configuration plans for database
installation with real application clustering option, database creation, performance tuning,
Oracle replication (Currently Oracle streams), backup, restore and recovery operations,
test planning, data conversion, usage of RMAN metadata, online transaction
processing(OLTP), online analytical processing (OLAP) and features of Oracle
connectivity SQL*NET, NET8, Oracle NET, ODBC, JDBC, HTTP, HTTPS, SSH
tunneling PuTTY, secureCRT, heterogeneous services (HS), Oracle advanced security
(authentication, data integrity, single sign-on) and directory naming.
This experience has been gained in simple and complex Unix/Windows high-availability
network architectural systems.
VERIZON Consultant DBA System Engineer October 2009 – February 2010
Oracle DBA/Systems Engineer Insight Global Inc. (Short Term contract)
• Install, upgrade Oracle RDBMS software for the deployment and reconfiguration of
SMARTS, eHeath, MRTG and Remedy front-end clients (Performance
management/service management tools) 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.
Kadix Systems, LLC Consultant DBA System Engineer November-21-08 to April-
15-2009
1
Oracle DBA/Systems Engineer – Private Consultant Knowledge-Based Corporate
Reporting System (Short term contract Knowledge Transfer) (KBCRS)
Function as Oracle DBA and system engineer on the Knowledge-Based Corporate
Reporting System (KBCRS). 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 and 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 security maintenance, physical and logical database design, capacity
planning, workload modeling, software upgrades, backup and recovery, and long term
strategic planning.
• Migrated 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 Consultant DBA System Engineer September-22-
08 to November-20-2008
Oracle DBA/Systems Engineer – Private 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 Charleston Pennsylvania.
• Usage of VMware PC clients.
• https://kbcrs.kadix.com/
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/ Systems Engineer 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,
2
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 call.
• 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), 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
Oracle DBA/Architect – TEKsystems
Document, systems/subsystems specification (SSS) for the implementation of a real
application cluster (RAC) on VERITAS cluster to support resource tracking
program (RTP/Citrix), a web application, 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, 09-02 01-03 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
3
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.
• Implement reliability, availability and serviceability (RAS) usage of fault
tolerance raid technologies, redundant power supply with use of additional power
hardware called redundancy kit, multiple network connections for availability,
and usage of hot-swappable components eliminating need to take system out of
service for some type of hardware servicing.
• 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),
contract data requests list (CDRL), and post shake down availability (PSA) groups
providing plan for database migration/upgrade, re-engineering and implementation of
system development lifecycle, which consists of: Strategy Analysis, Design,
Documentation Build, Transition and Production. Overall goal include taking into
cognizance the following factors: database growth, optimal performance and minimizing
any down time for users.
Task responsibilities included:
• Plan database server architecture how many database servers Instances etc.
Design database-naming, data partitioning, distributed data update schemas and
stand by production server.
• 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, implement RAID
4
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 Portals 3-tire architecture.
• Install, upgrade and test client version from developer siuteV3 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, hot backups Veritas Oracle
Agent. 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 Proper documentation of the Oracle environment so as to ascertain a
reliable and recoverable Oracle database.
• Ensure compliance with Oracle license agreement, renewal of CSI numbers.
TECHNICAL EXPERIENCE
Hardware Software Tools Languages
• IBM AIX Oracle Sql Developer, TOAD • SQL*PLUS, SQL1999
VERITAS• ERWIN, IMP/EXP, PLSQL, HTML, XML,
• HP-UX
• Minicomputers/Marco Sql*loader, FTP, OEM (Oracle Shell/Perl
enterprise manager), OMS, programming
computers UNIX
Flavors – LINUX RED OCFS, ASM, GSD, Tkprof,
HAT, SUN SOLARIS Designer 2000, Sun One iPlanet
Web Server, Oracle Application
V2.8 – 5.10
Server PORTAL V 3.0.9 – 10g
• DOS and Windows-
Release 2. Oracle Developer
based PCs
• Dell PowerEdge 2950 Suite Versions: V3.0, V4.5 and
V6.0.8.18.3. (6i).
-
Windows
Windows 3.1, 95, 98, NT, 2000,
2003 advanced servers, windows
XP, and VISTA
• MS Office Suite
• Visio
5
• 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
MS Access
Education
• Continuing Education Information Systems Strayer University.
• Bs. Chemistry University of Padova Italy
• Oracle 9i DBA Oracle Corporation.
Certification
• Oracle Certified, August 2002.
Recognition
• Recognition of Excellence, January 2008 STG, Inc.
Professional Affiliations:
Expert Exchange
6
Contact this candidate