Oracle Manager
Resume:
Title:Database Administrator
**********@*******************.***
Document
Source below
NAME: JERRY FRIEDMAN
ADDRESS:
CITY: Dunn Loring
STATE/PROVINCE: VA
ZIP/POSTAL CODE: 22027
COUNTRY: USA
EMAIL: jkfriedman@computersourcescorp.c
PHONE: 703-***-****
CANDIDATE ID: N/A
CITIZENSHIP: US
Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Not Entered
HOMEPAGE:
HOTSKILLS:
ESUME
JERRY FRIEDMAN
7964 Arden Court
Dunn Loring, VA 22027
**********@*******************.***
OBJECTIVE
Seeking a challenging
position as an ORACLE DBA
SUMMARY Over 17 years experience, and over
10 years as a CERTIFIED and MASTER ORACLE
DBA on UNIX and Microsoft NT Operating
System Environments
HARDWARE
SUNHP
DG
IBMPYRAMID SILICON GRAPHICS
DELLTOSHIBA COMPAQ
SOFTWAREORACLE SERVERWEBDB
SQL
DESIGNERPL/SQLCORBA
JAVA/JPERLUNIX
SEDTOADCOM/DCOM
AWKCRATIONAL ROSE
PATROLXMLEXCEED
MS ACCESSSQL FORMSER/WIN
SQL SERVEREASHTML
KORN SHELLJDEVELOPERORACLE APPL.
SERVER
EDUCATION M.S
. Courses in Management
Information Systems,
University of Maryland,
College Park, MD
B.S
. in Mechanical Engineering, Drexel
University,
Philadelphia, PA
Other Formal Training:
Oracle Server 7.3, 8, and 8I DBA Masters and
Certification Program, Oracle Corporation
SQL and PL/SQL
Architecture
Database Design
Database
Administration
Backup and Recovery
SQLNet
Client/Server Implementation
Performance Tuning
SQL Server 6.5, Microsoft
Corporation
S-Designor, Sybase
Corporation
PowerBuilder, Powersoft Corp.
Oracle Forms 3.0, Oracle
Corporation
IEF, Texas Instruments, Inc.
HP-UX, Hewlett Packard
Corporation
EXPERIENCE
Database Administrator, Computer
Sources, March 1997
to Present
HIGHLIGHTS As an on-site Oracle DBA for
eOriginal, Inc., Thomson Consulting, AT&T
(World Partners),and Global One (Sprint),
I have created and administered databases
and data warehouses throughout the world.I
am currently the DBA for an e-commerce
application.I have installed Oracle
Enterprise Edition Server 8I for both
SOLARIS and WindowsNT 4.0 operating systems
.I define the parameters in the Oracle
parameter file (initxxxx.ora) for each
database to customize the database,
depending on the storage and transaction
requirements.The initialization file is
checked by Oracle during the database
startup.I create the Oracle database
instance, including the processes and the
System Global Area (SGA).I create the data
dictionary by executing the Oracle
catalog.sql and catproc.sql scripts during
the database creation.I also execute the
catexp.sql script.I create the database
tablespaces, datafiles, logfiles, and
rollback segments using customized database
creation scripts.I monitor and query the
databases V$ dynamic performance tables
using customized scripts in SQLPlus and
Server Manager, and also use Oracle
Enterprise Manager (OEM), the OEM
Performance Pack, and other third-party
tools such as Quest Software's TOAD, and
BMC's Patrol.I tune the applications' SQL
and procedures/packages, partition large
tables, analyze tables and indexes, and
rebuild indexes as needed.I execute the
utlbstat.sql and utlestat.sql scripts to
capture and analyze the statistics from the
database's V$ and other system tables.I
also run the utltkprf.sql script with
explain plan to provide by session
statistics or explain individual statements
for database performance and application
tuning.I optimize the SQL executed from
the explain plans by adding hints to the SQL
statements by tracing user sessions and
developing an explain plan to show the
parsing of the SQL, which includes the full
table/index scans.I created new indexes or
changed the positioning of the tables's
columns in the indexes, pinned procedures
and packages in the shared pool, cached
tables in memory, and revised the SQL
statements to optimize response time for
queries.I ensured data integrity by adding
creating and enabling constraints on the
tables.I have installed all Oracle 7.3,
8.0, and 8I Server versions on the server
and client, and installed and configured
Net80 for Oracle 8 and SQLNet version 2 for
Oracle 7.3, modifying the tnsnames.ora file
on the client using the SQL Easy Config GUI
and modifying the listener.ora file on the
server.I write dynamic SQL scripts and
PL/SQL procedures, functions, and packages
for various database administration tasks.
I create users, create synonyms on objects,
create roles and grant privileges to users,
perform imports and exports to and from
various users and databases, and schedule
backup jobs on the servers.For remote
databases, I use FTP to transfer files to a
local server or workstation, and Telnet and
Remote Console to work directly on remote
servers.I monitor user and system
tablespaces, adding datafiles when
necessary.I monitor the rollback segments
and redo log file switches, and create
database links and read-only (one-way)
replication or snapshots between servers.I
compare schemas on databases for table and
column differences, write views for reports
and ad-hoc queries, and review alert logs to
determine database errors after database
crashes.I created the repository for the
OEM and utilize the OEM tools to manage and
monitor the databases and perform various
administrative tasks.I recover databases,
tablespaces, or datafiles when necessary.I
have shell and batch scripts scheduledto
perform hot (online) backups of 24x7
production databases, cold backups of other
production, development, and test databases,
and exports to ensure that no important data
is lost.Production systems are in
archivelog mode and essential databases are
in hot backup mode.I performed recovery
when data was lost using the by rolling back
and rolling forward the necessary archived
redo logs.
Database
Administrator, RMS Jan 1995 - March
1997
As an on-site Oracle DBA at the Department
of Navy, I was responsible for installing
and upgrading the Oracle7.2 RDBMS, SQLNet
Version 1, and the WindowsNT operating
system.I also installed Designer/2000,
Developer/2000, and Discoverer/2000,
including the Oracle Data Browser.I
designed the database, including table, log,
rollback segment, and tablespace sizes, and
created a repository for the Designer/2000
tool.I created the database through the
Oracle dbbuild.sql, catalog.sql,
catproc.sql, and catexp.sql scripts, which
created the controlfiles for the database.
I edited the parameter file to ensure that
multiple controlfiles were created on
multiple drives to safeguard against a
single point of failure.In addition, I
backed up the controlfiles to trace whenever
I added a database or performed a hot or
online backup of the database.If a
controlfile is corrupted, another could be
used to restart the instance without the
need for database recovery.I utilized the
reengineering feature of Designer/2000 to
modify the database structure back into the
repository to update the physical data
model, which generated Forms 4.5 code for
the application programmers.I allocated
system storage and planned future storage
requirements for the database system,
creating tablespaces, datafiles, tables,
views, clusters, and indexes.As the
application changed, i.e., new tables,
fields, etc., I modified the database
structure and propagated the new structure
to the remote databases.I created users
and maintained system security by creating
roles and granting privileges to the users
for the roles.With this, I could control
the user create, insert, select, update, and
delete privileges for system and user
database objects.I was responsible for
monitoring and optimizing the performance of
the database and the servers.I planned for
backup and, when necessary, recovered
database files.I also archived data from
the archive logs to tape or a remote disk.
I utilized the Oracle Administrative Toolbar
to perform various administrative duties on
a regular basis.I customized and tuned the
initxxxx.ora parameter files, in particular
the shared pool size and database block
buffers, which comprised the majority of the
System Global Area (SGA).As a general
rule, I maximized the size of the SGA and
limited paging of the system resources.I
tuned the databases and application by
analyzing the estat report and explain
plans.I rewrote the SQL and reexamined the
explain plans which optimized the response
times of the queries and server resource
usage ofthe SQL statements.I created
indexes on fields in tables with numerous
hits.I clustered tables where applicable.
I pinned procedures in the shared pool, and
optimized the logical hits on the server.I
wrote scripts to lessen the amount of time I
spent maintaining the databases.I
performed imports and exports from Oracle's
Data Manager tool, administered user roles
and privileges, and performed daily backups
on the servers.I monitored database
tablespaces, adding datafiles when
necessary.I also dropped existing and
recreated larger redo log files when log
switches occurred too frequently.
Database Administrator, Vistech, Jul 1993 -
Jan 1995
As an on-site Oracle DBA for the Department
for Interior, my main responsibility was
database administration and, in particular,
tuning in an UNIX operating system.I ran
the scripts and procedures which provided a
report of system wide database performance
statistics.I checked the latch, rollback
segment, and dictionary cache statistics
from the report generated from the estat
script, and made changes to the parameters
in the initxxxx.ora parameter file as
appropriate.I also checked the logical and
physical reads and determined the hit and
pin ratios, and tried to increase the ratio
above 95%.I tried to distribute the hits
across datafiles and disks.I also checked
the buffer busy waits, the average size of
the redo entries, the DBWR checkpoints,
sorts, and recursive calls.I used the
"where" clause often in the SQL statements
to limit the full table scans, and created
indexes to limit full table scans on large
tables. I created databases, allocated
system storage, and planned future storage
requirements for the database system,
creating tablespaces, datafiles, tables,
views, and indexes.As the application
changed, I modified the database structure.
I created users and maintained system
security in the database.I was responsible
for monitoring and optimizing the
performance of the database and the
servers.I documented all DBA
responsibilities in a Database Administrator
Standard Operating Procedures document.
Database Administrator, Vistech, Apr 1991 -
Jul 1993
As an on-site Oracle DBA at the Department
of Labor, I was responsible for database
design and development in an UNIX operating
system.IEF was used as the database design
tool.I met with the functional analysts
and obtained system requirements for the
design of the system.I designed the entity
relationship diagrams and determined the
type of relationships between the entities
and the primary and foreign keys.I
designed the conceptual data model and
generated the physical data model.I
created and maintained the database, the
instances, and the schemas.I had separate
schemas for development, testing, and
production.I also kept an export file
(.dmp) of every version of the database for
version control.I created the system and
user tablespaces, keeping the tables and
indexes in separate tablespaces.I created
and maintained user accounts on the
databases.I also tuned the SQL statements
in the applications.I planned for backups
and, when necessary, recovereddatabase
information from the log files.I also
maintained archived data on tape or remote
disk.I read alert logs and trace files to
troubleshoot problems with the database.
Database Administrator, Andersen
Consulting,Apr 1989
- Apr 1991
As an on-site Oracle DBA for the Department
of the Navy, I was responsible for creating
and administering large databases on an IBM
RISC6000 server in an UNIX operating system
environment.Performed functional analysis
and developed functional requirements for
the application.Used Knowledgeware's IEW
tool to design the entity relationship
diagrams for the application, which included
over one hundred tables, and the conceptual
database model.Generated a physical model
of the database from the conceptual model.
Migrated data from an existing mainframe
system to the new client server system.
Wrote a naming standards document based on a
National Institute of Standards and
Technology naming convention.
Database Administrator, Hewlett Packard
Company,Dec 1986 - Apr 1989
Responsible for the database administration
and production support of the financial
accounting applications and databases for
over 25 divisions of HP.Responsible for
DBA tasks such as database creation,
maintenance, controlling user access,
allocating resources, developing and
implementing backup schedules, and
referential integrity definition.While at
HP, I received extensive training in both
system and database administration.
Systems Engineer/Database Administrator,
Digital Equipment Corp
.,
Jun 1982
- Dec 1986
As a database administrator for DEC, I was
responsible for data entry, data migration,
and data management of large databases.I
was also responsible for backup and recovery
of tables containing millions of rows of
data.Initially, I was a systems engineer
for DEC, and was responsible for the
maintenance and troubleshooting of hardware
and systems.During my tenure at DEC, I
received extensive training in computer
systems and database management.
B
Contact this candidate