Title:John Hansen
abp3wt@r.postjobfree.com
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE: IN
ZIP:
CANDIDATE ID: 2867316
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 317-***-****
EMAIL: abp3wt@r.postjobfree.com
HOMEPAGE:
HOTTEST SKILLS: oracle, database, unix, sql, medical, delphi, programming, doctor,
molecular, pharmacy, database administrator, linux, simulation, solaris, sun micro,
market, marketing, statistics, cancer, chemist
REVISION: 08-SEP-02
RESUME:
25847
Sha He 5808 Sedgegrass Crossing
Carmel, IN 46033 317-***-**** abp3wt@r.postjobfree.com RESUME
Sha He
5808 Sedgegrass Crossing
Carmel, IN 46033
(daytime)
(night & Fax)
abp3wt@r.postjobfree.com
U.S.
permanent resident
OBJECTIVE
To obtain an Oracle DBA position with a dynamic company that will utilize my
experience of Oracle DBA and Unix Administrator.
CERTIFICATION
Oracle 7.3 Certified Database Administrator.
COMPUTER SKILLS
Oracle DBA (one and half years)
Database: Oracle 7.3 and 8. (Software installation, database creation,
migration, design, administration, backup, recovery and performance tuning)
Platforms: Windows NT, Unix, and Linux.
Oracle Tools: PL/SQL, SQL*PLUS, SQL*LOAD/Export/Import, Server
Manager,
Oracle Design/2000, Oracle Enterprise Manager, Oracle Forms 4.5, Oracle
Reports
2.5, and Unix shell scripting.
Programming Language: SQL, PL/SQL, Unix shell scripting and Visual
Basic.
Unix administrator for Sun Solaris system (ten months)
Administering file system, devices, and users.
Backing up and restoring files and file systems.
Installing third-party software.
Monitoring system performance.
EXPERIENCE
Sept. 1999
-PresentUnix administrator and Research AssociateDepartment of Physics of Indiana University
-Purdue University at Indianapolis,
Indianapolis, Indiana
Unix administrator for the nuclear magnetic resonance center.
Responsible for everything of an intranet built of four Sun microsystems to
control three NMR instruments and to process data and molecular modeling for
external and internal users.
Biophysics research: Determining protein 3-D structures by nuclear
magnetic resonance and computer simulations and molecular modeling methods.
Jan. 1998
-Aug. 1999 Oracle DBA and Post-doctoral fellow
Metabolic Magnetic Resonance Research and Computing Center
of Department of
Radiology, University of Pennsylvania Medical School, Philadelphia,
Pennsylvania
Oracle DBA. Jobs and responsibilities included:
1). Participating in the development of the Oracle databases of animal studies
and
patient management for the Department of Radiology;
2). Oracle software installation on Unix (Oracle 7 Server) and Window NT
(Oracle
8
Server);
3). Database design, physical capacity planning, creating tables and indexes;
4). Using PL/SQL to write database triggers, procedures, and functions;
5). Administering daily operation, creating users and roles, granting
privileges,
maintaining system security and database availability;
6). Planning backup procedure and taking physical backup (using operating
system)
and logical backup (using Oracle Export/Import utility) on Unix environment,
and
using Recovery Manager on NT;
7). Responsible for disaster recovery;
8). Monitoring database performance, tuning SQL statement, SGA, storage space
and
memory;
9). Responsible for troubleshooting of user errors, software problems and
potential
hardware problems;
10). Responding to the requirements and needs of end-user, supporting and
training
database users;
Maintaining and troubleshooting of the hardware and software for the
computers in the laboratories.
Biomedical imaging research: Developing the magnetic resonance
spectroscopy and magnetic resonance imaging methods for cancer diagnostics and
gene therapy evaluation.
Feb. 1999
-June 1999 Oracle DBA training and workshop
Mo's CompuTech, Inc
. (an Oracle Alliance company), Philadelphia,
Pennsylvania
Oracle DBA training. The training courses included using SQL and
PL/SQL, Database Administration, Backup and Recovery, Performance Tuning,
Oracle
software installation, creating databases on NT and Unix, Using Oracle
Utilities, Unix environment and Shell Programming, Oracle Web Server, SQL*Net
configuration, Oracle Forms and Oracle Reports.
Jan. 1993
Jan. 1998Research AssistantDepartment of Radiology
of the University of Texas Southwestern Medical
Center,
Dallas, Texas
Biomedical imaging research: Developing the noninvasive
methods--single
photo emission computed tomography and nuclear magnetic resonance--for in vivo
physiological study, which involved the intensive use of the various programs
for data process, graphic, statistics, and imaging under Unix, Windows, and
Mac
environment.
Sept. 1987
--Nov. 1992Assistant ProfessorDepartment of Radiology and Nuclear Medicine of West
China University of
Medical
Sciences, Chengdu, Sichuan Province, P.R.China
March 1982
--Aug. 1984Research ScientistChinese Institute of Drug Control, Hangzhou, P.R.China
EDUCATION
Ph.D
. Jan. 1993Jan. 1998 in Radiology
Department of Radiology of University of Texas Southwestern Medical Center,
Dallas, Texas, U.S.A.
M.Sc
. Sept. 1984--Aug. 1987 in Nuclear Chemistry
The Institute of Nuclear Research of Chinese Academy of Sciences,
Shanghai,
P.R.China
B.S
. March 1978--Feb. 1982 in Pharmacy
School of Pharmacy of Zhejiang University,
Hangzhou, P.R.China
HONOR
May 1998
-April 1999 National Research Service Awards Post-doctoral fellow
REFERENCES
David S. Nelson, Computing Director
Metabolic Magnetic Resonance Research and Computing Center of Department of
Radiology
University of Pennsylvania Medical School
Tel: 215-***-****
abp3wt@r.postjobfree.com
David Shi, Oracle InstructorMo's CompuTech, Inc
.
Philadelphia, Pennsylvania;
Oracle DBA
MS 0195
Database Marketing Department
MBNA America Bank
Wilmington, Delaware
abp3wt@r.postjobfree.com
Roger King, Oracle InstructorMo's CompuTech, Inc
.
Philadelphia, Pennsylvania;
Oracle DBA
RD Consulting, Inc
.
Queens, New York
Tel: 718-***-****
abp3wt@r.postjobfree.com
Connie Ely
Administrative Assistant
Department of Physics
Indiana University
-Purdue University at Indianapolis
Indianapolis, Indiana
Tel:317-***-****
abp3wt@r.postjobfree.com