Oracle Manager

Resume For: Lynnwood Brown

Job Title: Database Administration

PUBLICATIONS:

Oracle Database Administration On UNIX Systems

Publisher: Prentice Hall ISBN: 0-13-244666-9

Oracle8 Database Administration On Windows NT

Publisher: Prentice Hall ISBN: 0-13-927443-X

LANGUAGES APPLICATIONS OPERATING SYSTEMS:

Oracle Enterprise Manager, Oracle Advanced Replication, Oracle Recovery Manager, J2EE

JDBC, C, PRO*C, HTML, PERL, Various versions of UNIX including Linux, AIX, AUX, HPUX,

Solaris, UNIX Shell script, SQL, PL/SQL, DOS Windows NT 2000 2003, Brio Query Analyser

Server, ORACLE RDBMS versions 7, 8i and 9i, 10g, 11g, ORACLE*FORMS 4.5 ORACLE

REPORTS 2.5, Oracle 9ias, Oracle 11i, Brio Server query, CRM applications Clarify Clearsupport

ClearQuality, Erwin Data modeling, TCP IP, MVS, VM, Macintosh, JCL, SNA, VTAM, NCP,

NETWARE, SharePlex, Visual SourceSafe, Oracle Transparent Gateway, SQL-Server, MySQL,

OBIEE 10g/11g, WebLogic, ONTAP7

HARDWARE:

UNIX AIX AUX HPUX based workstations (IBM, HP, Apple, SUN), Linux, MS Windows NT DOS

based PCs, IBM mainframes, Token Ring, Ethernet, FDDI, protocol analyzers, LAN analyzer,

CISCO routers, NetApp filers.

EXPERIENCE:

8/04 - Present

Network Appliance (NetApp) - Senior DBA responsible for several projects in the Engineering

Database Services group:

DataMart Migration

•Lead migration team to migrate the 10TB data warehouse to an Oracle 11g RAC system, using

Oracle data pump (migrate legacy data) and Golden Gate (for replication of new

incoming data)

•Explain data flow and schema

•for datamart to end users (hadoop -> datamart where obiee is used to mine the data), end users

will mine the data using Oracle Business Intelligence (OBIEE 11g)

•Installl and configure Oracle Business Intelligence Enterprise Edition 11g (OBIEE) and clustered

OBIEE 11g

•Document system end user management of OBIEE using Weblogic and OEM

•Document and train junior DBA to support the installation and end user management of OBIEE

11g.

•Install Oracle Golden Gate 11g

•Setup replication to capture incoming data using Oracle Golden Gate (trail files, etc

•Debug and fix all problems associated with Golden Gate

HP Quality Center/ALM Implementation

•Provide DBA support for HP Quality Center project

•Migrate single instance pilot QC/ALM database to a RAC environment running on the Red Hat

linux platform (RHEL5)

•Create HA solution using Oracle Data Guard/standby datamase.

•Document all processes and procedures used and train DBA team to support the system

Support the Burt/PerForce team:

•Choose and procure servers that will be used for the project

•Implement Control Data Capture for the Burt-N-Oracle project.

•Document all processes and procedures involved with implementing CDC.

Support the Engineering Metric Data Collection and Reports team:

•Upgrade from Oracle 10g to Oracle 11g the databases used for capturing/storing data

associated with building the NetApp ONTAP operating system

•Replicate data to the report server using Oracle Golden Gate

•Create highly available system using Oracle Data Guard/standby database.

Backup and Disaster and Recovery Project

•Created and documented the backup and disaster recovery strategy for NetApp's Database

services group. This strategy is used to backup all application data that uses either a

MySQL or Oracle database managed by NetApp's Database Services group.

•Developed methodology for reducing the time to backup and recover very large databases using

NetApp's Snapshot technology. Testing showed that very large databases are

backed/recovered in minutes rather than hours.

•Developed scripts to implement data protection by replicating database backups to multiple sites

using NetApp SnapMirror technology and Linux shell scripts

ASUP Project, All NetApp filers are able to send system health data to the central databases in

Sunnyvale, CA. (called the ASUP database) - Provide support for ASUP database infrastructure:

•Improve database performance and availability using AWR/ADDM

•Implement database hot backups

•Work with end users on SQL statement tuning

Engineering Project tracking (MySQL on VMWare)

•Install/configure MySQL InnoDB on VMWare ESX

•Create scripts for backup and recovery using MySQLDUMP

•Recover dropped tables

•Enable binary logging to setup Master database, unique servfer ID for Slave database and

create user for replication

All projects include the following activities:

•Create project plan

•Create diaster recovery strategy with the application team

•Create project list of activities/tasks, responsible person/group, schedule/completion dates and

project status

•Install Oracle Enterprise Manager 11g (OEM) to monitor all databases and setup email alert

notification

•Choose and procure servers that will be used for the projects

•Create/test backup and recovery scripts using Recovery Manager (RMAN) and shell scripts

•End user management including working with customer to define user groups and which

privileges they need and which tables users can access based on the group they are in

•Database Performance and tuning, including: Monitor system performance using OEM/SQL and

shell scripts, SQL statement tuning, creating EXPLAIN plans using Tkprof/Hints/indexing,

AWR/ADDM analysis, adjust database performance parameters to improve system

performance.

•System Performance/tuning including: capture operating system performance using vmstat, sar,

TOP, adjust operating system parameters to improve system performance.

•Index data to improve query performance

•Create/test triggers, procedures and functions written in PL/SQL

•Ceate/test/execute programs written in cshell, bourne or bash script

•Indexing data to improve query performance

•System tuning using AWR/ADDM

•Document application schemas using Erwin Data Modeler

•Work with junior DBA to define project task, timelines and provide guidance for

application/database rollout

•Application/database capacity planning for storage space and system/CPU utilization

MySQL projects/activities

•Migrate MySQL v4 and v5 to Oracle 11g

•Dump MySQL data

•Create SQAL*Loader scripts to load dumped data to Oracle

•Create scripts to sanitize the MySQL data prior to loading into Oracle

•Create end user accounts

•Assist end users with tuning/indexing the data

12/03 - 8/04 (Contractor)

Network Associates, Inc. Oracle DBA UNIX administrator (Contractor). Network Associates has

ported their intrusion detection product from the MySQL RDBMS to the Oracle RDBMS.

DBA System support for development, QA and professional services.

• Install configure and support Oracle 9.2 on the Windows 2000 and the Sun Solaris platforms

• Install and configure Solaris 5.9 operating system on the Sun 450, 440, 880 and Sun 220R

servers

• Configure disk IO subsystem to optimize database performance

• Install and configure Oracle Enterprise Manager (OEM) to manage QA and development

databases

• Optimize SQL queries to improve database application performance and use PL SQL to write a

transaction counter for the IDS product.

• Work with NAI professional services to install and configure NAIs Intrusion Detection System

(IDS v1.9) with Oracle RDBMS v9.2 at customer locations including Ameriquest

Corporation and QUALCOMM Corporation.

• Work with technical publications group to document Oracle RDBMS best practices for the

Network Associates IDS product for Oracle on Solaris and the Windows operating

systems.

6/94 - 12/03

University Of California at Berkeley Extension Instructor.

•Develop instructional applications using SQL*PLUS, PL SQL, ORACLE*FORMS 3.0 4.0 and

ORACLE*REPORTS 1.0 2.0.

•Develop and teach the course Introduction To Oracle for DBAs.

•Upgrade Oracle DBA course material from Oracle8i to Oracle9i

8/03 - 11/03

ASYST Technologies Oracle DBA (Contractor). ASYST manufactures wafer transport systems

that use a MySQL or Oracle database as a data repository.

•Migrate from MySQL v3 to Oracle v9.2. Includes extracting data from MySQL database and

loading into the Oracle database using SQL*LOADER and PL SQL.

•Reduce the amount of storage required to support the Oracle 9.2 database.

• Minimize the storage required to install and configure Oracle 9.2 on Windows 2000 to support

the ASYST Semiconductor Transport System.

• Query SQL statement tuning using TKPROF

• Implement database high availability solution using Oracle Data Guard

• Application schema design and analysis using Erwin

• Write update system installation and training documentation

4/03 - 6/03

HP Oracle Performance DBA for the Cost Cross Convergence System (Contractor)

• Migrate data warehouse from Oracle 8.1.7 to v9.2.0.2

• Migrate database from HPUX 11.0 to Suse Linux SLES7

• Correct database fragmentation

• RDBMS system tuning using Oracle STATSPAK

• Implement database high availability solution using Oracle standby database

5/02 - 11/02

World Savings Bank Senior Oracle DBA in the Internet Systems Group (Contractor)

Migrate Oracle RDBMS from v8.1.7 to v 9.0.1

•Write database encryption algorithms using Oracle Obfuscation Toolkit to implement the data

encryption standard (DES) for the World Saving Online Banking web application.

• Write and test recovery manager (RMAN) backup and recovery scripts

• System tuning using Oracle ESTAT BSTAT and STATSPACK

• SQL statement tuning indexing using the Oracle trace facility and TKPROF

• Write scripts, procedures and triggers to load ASCII data into the database using Oracle

SQL*LOADER and PL SQL

• Support the production and QA (quality assurance) systems

• Install and configure Oracle Transparent Gateway for Microsoft SQL-Server. This allowed for

the creation of management reports using data from the Oracle and the SQL-Server

databases.

• Write scripts in JAVA (J2EE) to test Oracle JDBC drivers

• Install, configure and support Oracle 11i applications AR, AP and General Ledger.

• Install Oracle 11i patches using the utility ADDPATCH

• Upgrade Oracle database from 8.1.6.1 to 8.1.7.3 for Oracle Financials 11.5.3

• Load Oracle payables interface tables using SQL*LOADER

• Use Oracle 11i financials Purge Archive utility to offload end of month data.

12/99 - 4/02

StorageWay Inc. Lead Oracle DBA and Quality Assurance. StorageWay is a leading storage

systems provider using SAN technology. (Contractor)

• Install and configure Oracle8 and Oracle8i and Oracle9i on the Sun Solaris, HPUX, AIX and

Linux platforms

• Install and configure Solaris 2.7 and 2.8. Install and configure HPUX 10 and 11.

• Install Oracle 11i application development tools Oracle Forms Forms Server 6i and Oracle

Reports Reports Server, Oracle 9iAS application server.

• Install and configure MS SQL-Server RDBMS on Windows NT

• Install and configure IBM DB2 RDBMS on the Sun Solaris platform

• Write scripts using UNIX shell, PL SQL, SQL*LOADER and SQL*PLUS to generate and collect

database statistics for benchmarking

• Write the StorageWay Oracle database backup utility. The shell script is used to automate

database backup with or without Oracles RMAN utility.

• Develop interface between Oracle RDBMS and Veritas Netbackup.

• Install and configure Veritas cluster (VCS) and Veritas Volume Manager with fast IO on the

EMC Symmetrix SAN to support RDBMS fail-over testing.

• Configure IBM AIX server to support the Oracle parallel server (OPS using IBM HACMP).

• Install and configure Rational ClearCase problem and change management software.

• Develop and conduct Oracle database training courses for StorageWay engineers, consultants

and marketing

• Support multiple large databases. Database size and activity are approximately 3 TB at 150

TPS

• Develop and implement table and index partitioning for databases over 500 GB (VLDB).

• Develop reports server using SNAPSHOT replication.

9/01 - 12/01

HP Lead DBA for the Cost Cross Convergence System. The system allows HP to gather product

cost information and use this information to determine the selling price for a product or service.

(Contractor)

•Design input schema and output star schema to support the data warehouse application

• Write data loading scripts using PL SQL, SQL*LOADER and UNIX shell script (HPUX 11.0)

• Install and configure HPUX 11.0 on HP K, N and L machines.

• Write database backup and recovery utilities using RMAN

• Install and tune databases in US, Brussels and Singapore to support the system

• Write scripts to monitor both database and operating system utilization

• Design application data model using Erwin

• Implement master to master data replication using Quest Software SharePlex

• Use end user reporting requirements to design star (constellation) schema for the warehouse

data marts

• Install and manage MS Visual SourceSafe to support the developers and QA testing.

• Install and configure Oracle RDBMS on Red Hat Linux as a report server solution.

• Install and configure Oracle application server (Oracle 9ias) to support Oracle Reports

• Implement cascade replication to push data from the US database to the databases in Brussels

and Singapore.

• Consolidate data from HP Brussels and HP Singapore databases into the HP US data

warehouse.

• Implemented table and index partitioning for large tables and indexes in the data warehouse.

3/99 - 8/01

HealthCentral.Com Lead Oracle DBA. HealthCentral is an online pharmacy. (Contractor)

•Install and configure Oracle8i on Red Hat Linux and Sun Solaris

• Write scripts in SQL and UNIX shell script to perform hot, cold and logical backups of the Oracle

database.

• Implemented reports server using Oracle SNAPSHOT replication.

• Develop scripts to monitor database and system performance.

• Tune SQL queries using table indexing and table partitioning

• Write scripts in JAVA (J2EE) to test Oracle JDBC drivers

• Develop database table-indexing strategy to improve response of the HealthCentral.Com web

site.

• Lead DBA supporting the development, QA and production databases.

• Develop scripts procedures triggers in PL SQL to determine all relationships constraints in the

database. The resulting report is used to correct the table relationships determined from

using Erwins reverse engineering feature.

10/98 - 3/99

SkillsVillage.Com Lead Oracle DBA. SkillsVillage is in the IT Contracting business. (Contractor)

• Install Oracle 8i production and development databases on Solaris. The production database

supports the SkillsVillage web site.

• Install and configure Solaris 2.7 operating system.

• Configure Tomcat application server to run with Apache HTTP server.

• Implemented database replication to develop report server to support HR and finance.

• Developed management reports as part of the SkillsVillage distributed reporting system using

Brio Query, Brio Server and PL SQL.

• Develop process to move database changes from test to production.

• Develop code and test hot backup scripts.

• Install and configure Oracle Financials 11.0.3 applications AR, AP and General Ledger.

• Perform database space management using Oracle Financials 11.0.3 Purge Archive utility

• Upgrade 8.0.5 database to version 8.0.6 to support Oracle Financials 11.0.3

8/97 - 1/99

GTE Internetworking Oracle DBA and project management for the Internet traffic usage based

billing project. This system replaces all GTE Internetworking systems used for collecting and

aggregating Internet traffic. The information that is provided by the system is used by GTEs billing

organization to invoice its clients for web hosting services that are provided by GTE. (Contractor)

• Supervise team of 3 application development programmers, one quality assurance tester the

UNIX network specialist

• Supervise the delivery of the systems web interface and reports.

• Develop billing reports using Brio Query

• Develop project schedules and deliver the system on time

• Develop training course to support system rollout

• Report project status to upper management

• Design the application schema using Erwin.

• Design, code and test all routines for bulk loading of data into the repository. All scripts are

written using UNIX shell script, SQL, PL SQL, SQL*LOADER and PRO*C where

appropriate

• Implement backup and recovery strategy to support the 24X7 operation of the repository billing

system.

2/97 - 8/97

FullTime Software Inc. Oracle DBA and application implementation support for the Clarify

products ClearSupport and ClearQuality. (Contractor)

• Installation of Clarify CRM products ClearSupport and ClearQuality for Fulltime Softwares

customer support group (CleasrSupport) and ClearQuality for the engineering group.

• Installation and tuning of Oracle databases to support the sales tracking applications AURUM

and SalesLogic.

• Implement database backup and recovery strategy for all Oracle databases.

• Datamining using Brio Query Server.

7/95 - 2/97

Clarify Inc - Proactive Support. Work with Clarify clients, consultants and support personnel to

resolve Oracle RDBMS related issues.

• Design code test database performance analysis scripts for memory management, disk IO

management and CPU management. The analysis scripts collect data that is specific to

the Clarify application (such as database fragmentation due to row chaining and

migration).

• SQL and PL SQL statement tuning for all Clarify Oracle client applications. To tune the Clarify

application the SQL statements are analyzed using the utility TKPROF. The results of the

analysis are used to determine if the indexing criterion is correct.

• Write database performance analysis utilities using SQL*PLUS, PL SQL and PRO*C. The

utilities are used by Clarify customers and consultants to evaluate Oracle RDBMS

performance.

• Designed coded test UNIX shell script used to automate the installation of Clarify Oracle

RDBMS reducing the system installation time from eight hours to one hour.

• Install and configure ClearSupport and ClearQuality on Oracle, SQL-Server and Sybase

database platforms

2/95 - 7/95

Wells Fargo Bank, Business Load Division. Oracle DBA (Contractor)

• Migrating all client server applications (Visual Basic and PowerBuilder) from using Oracles

SQL*NET v1 to SQL*NET v2. This includes installing configuring both SQL*NET for TCP

IP (UNIX) and SQL*NET for Netware (SPX IPX).

• Upgrade all Oracle RDBMS from v7.0.16 to v7.1.4. This includes upgrades for Oracle RDBMSs

on both UNIX (Solaris HPUX) and Novell NetWare.

• Write scripts to gather performance data for the Oracle RDBMS. Analyze the performance data

and recommend implement tuning strategies.

• Debug end user applications written in Oracles SQL*PLUS, PL SQL and PRO*C.

11/94 - 3/95

InfoWorld Inc Oracle DBA supporting the InfoWorld On-line Registration System. (Contractor)

• Install configure Oracle RDBMS server on the SGI Challenge S

• Monitor and tune the database servers memory management and disk IO subsystem.

• Create management level reports based on the captured registration data. The datamining tool

Brio Query is used to extract, format and analyze the data.

• Load external ASCII data into database data warehouse using PL/SQL and SQL*LOADER.

9/94 - 2/95

DHL, Consultant to the manager of finance. Oracle DBA (Contractor)

• Install SQL*NET for UNIX (AUX) and SQL*NET plus Oracle Reports 2.0 on the Macintosh

clients therefore creating a client server environment.

• Write SQL*LOADER scripts. The scripts load flat ASCII data from the Macintoshs FileMaker Pro

database into the Oracle database creating the data warehouse.

• Write triggers procedures using PL SQL to support data validation during the SQL*LOADER

session.

• Develop management level reports of captured data using Brio Query Analyzer.

• Extract data for Oracle and Informix databases using Brio Query Analyzer and ODBC.

• Migrate Oracle database from the AUX UNIX operating system to the Windows NT operating

system.

10/92 - 9/94

Oracle Corporation, Senior Technical Consultant, Oracle World Wide Technical Support: The

group is responsible for resolving all customer problems related to using the RDBMS.

• Install Oracle v6 and Oracle v7 on all UNIX platforms (HP, RS 6000-AIX, SUN, Pyramid, Intel

etc

• Write scripts to gather performance related data and use the data to advise clients on how to

tune their RDBMS.

• Write scripts to gather network information (shell, PL SQL and SQL*PLUS) and give advice to

Oracle customers to resolve RDBMS, NET8 and installation problems.

• Debug customer applications written with Oracle tools Oracle*Reports 1.0 2.0, Oracle*Forms

2.3 3.0 4.0, PRO*C, SQL*LOADER, Oracle*Graphics and SQL*Menu 4.0 5.0.

• Design code test management scheduling system using Oracle*Forms 4.0 and Oracle*Reports

2.0, SQL*PLUS and PL SQL.

7/91 - 10/92

Sun Microsystems, Network Products Assurance. QA testing of LAN to mainframe

communications product based on IBM SNA technology. (Contractor)

• Install test Suns SNA 3270 RJE, APPC and BSC 3270 gateway and terminal emulation

software on all Sun hardware platforms.

• Configure and test terminal gateway emulators over FDDI, token-ring, ethernet (802.3) and

SDLC.

• Write programs in C to test the LU6.2 3270 gateway API (application programming interface).

• Configure IBM 3745 (NCP) 3172 to support dial-up lines, dedicated lines using modem

eliminators, leased lines for point - point and multi-point telephone line communications.

• UNIX system administrator for the SunOS Solaris-IBM test system.

• Review product documentation for accuracy and develop product test plans.

8/78 - 7/91

IBM Corporation, in the areas of systems engineering (marketing), manufacturing and product

development. Activities included:

• Implement network management strategy for the US Department Of Energy. The software

included NetView, NPM, Information Management (using SMP E to install the products),

C and REXX.

• Storage management analysis using SMF RMF. The results where used to implement systems

managed storage (DFSMS) using RACF, DFHSM, DFDSS and DFP in a MVS

environment.

• Design code test programs written in C, Fortran, assembler and SQL (DB2) for implementation

of machine factory automation.

• Supervise team of technicians engineers responsible for implementing factory machine

automation at IBM locations in Manassas, Va. and Paris, France.

EDUCATION:

BSEE, 1978 City College of New York, Union College graduate courses in business

administration. IBM Courses in programming, marketing and systems management. Oracle

courses in client server implementation database management and application development.

AFFILIATIONS:

Northern California Oracle Users Group

IEEE

PERSONAL:

Telephone number: 408-***-****

EMAIL: **************@*****.***

References furnished upon request.

Contact this candidate