Oracle Developer
Resume:
Title:Owner
********@****.***
Document
Source below
NAME: Sara Liu
ADDRESS:
CITY:
STATE/PROVINCE: NJ
ZIP/POSTAL CODE:
COUNTRY: USA
EMAIL: ********@****.***
PHONE: 732-***-****
CANDIDATE ID: 108008
CITIZENSHIP: Requires Sponsorship
EDUCATION: Master Degree
EXPERIENCE: 3
WILL RELOCATE: Open
RELOCATION INFO:
JOB WANTED: Direct
RATE NEEDED:
HOMEPAGE:
COMMENTS: Dear Human Resources Director,
I am looking for a challenging permanent position as Oracle DBA/Developer. I am now
authorized to work in the US with OPT.
Currently I am working as Oracle DBA/Developer at Netweb Vision Inc., and I got my
Masters degree in Computer Science on this May. I have been working on oracle database
for three years, and I am an Oracle 8 Certified DBA. I am keenly interested in this field
and feel that my academic background and working experience, which detailed on the
attached resume, would be of interest to your organization. You can also reach my resume
at:
http://www-ec.njit.edu/~hl2/DBA_Sara.htm
I would appreciate the opportunity to personally discuss employment
HOTSKILLS:
ESUME
Objective: Seeking a permanent position in database admiministration/software
development. Anticipate high motivation and full challenging development.
Qualifications:
--Over three years hands-on working experiences as database developer/administrator on
platforms such as Sun Solaris, IBM-AIX and Windows NT/2000. Expertise in internet/intranet
based multi-tier applications and computing theory applications using Object Oriented
methodologies.
--Experienced programming in Java, SQLJ, UNIX Shell Scripts, PL/SQL, SQL*Plus, Pro*C,
C/C++, HTML, PHP
--Database: ORACLE 8i/8.0/7.x, SQL Server 6.5, MS Access, MySQL.
--Operating Systems: UNIX (Sun Solaris 5.6/2.6, IBM-AIX 3.2), Windows NT/2000, Windows
98/95.
--Application Tools: Oracle Designer6i, JDeveloper, Borland C++ Builder, Jbuilder, OEM,
TOAD, SQL*Loader, Export/Import
--Oracle8
Certified Database Administrator
--Strong skills in communication, organization and documentation as well as ability in
problem solving and troubleshooting. Self-starter, fast-learner and excellent team-worker.
Working Experience:
Oracle Database Developer/Administrator
Netweb Vision Inc
., South Plainfield, NJ Jan 2001Aug 2001
Worked as Oracle DBA to support development environment for an n-tier web-enabled
eBusiness system based on J2EE technology. Performed typical DBA tasks to ensure reliable
and scheduled availability of development and testing database under Sun Solaris
/Windows2000 platforms. Assisted with development and maintenance of database scripts.
Supplied client support and participated application development.
Primary responsibilities include:
--Installed Oracle8.1.6/8.0.6 database servers and clients. Configured SQL*Net and Net8
for network computing. Provided data administration support through project
implementation.
--Used Oracle Designer 6i to implement data modeling and physical / logical database
design based on business and end user requirement.
--Planned for and implemented database disaster recovery strategy by deploying standby
databases. Implemented database & application backup and recovery plan. Developed database
backup, restore and recovery procedures. Performed physical and logical database backup.
Devised backup strategies and wrote UNIX shell scripts for backups
--Performed database tuning at the application level by tuning the SQL statements written
by the application developers. Modified database design to remedy design loopholes which
caused poor database performance. Consulted with application developers regarding optimal
use of Oracle RDBMS technology and assisted in recommending and overseeing Oracle RDBMS
enhancements.
--Performed Database server tuning at the Database Server level, for example, solved CPU
bound problems leading to database crashes, performed memory tuning and solved Disk I/O
contentions. Monitored and tuned production environment when volume of data impact
performance utilizing OEM SQL Analyze, OEM Performance Manager, SQL Trace, TKPROF,
Utlbstat.sql/Utlestat.sql, etc.
--Used SQL, PL/SQL, SQLJ and Java to implement database applications, such as stored
procedures, packages and triggers. Worked closely with Manager of Database Development to
develop database processes utilizing advanced PL/SQL.
--Participated in coding database application modules using Java, SQLJ and PL/SQL. Data
retrieving and analyzing tools were written for other team members as part of large
application developing.
--Participated in dynamic web pages development. Used JavaScript, HTML, JSP to develop
front-end web pages upon end user requirements.
Oracle Database Administrator/Developer
Bank of China, China
July 1997- Oct 1999
Managed three production databases as well as standby database on Oracle 7.x/8.0 for bank
transactions under UNIX Sun Solaris and Windows NT platforms. Ensured maximum availability
of database resource for the organization and its customers.
--Database Administration: created and modified database structures and objects, backup
and recover databases. Performed physical and logical database design. Maintained system
security, Monitored databases operating on UNIX Solaris and Windows NT 4.0.
--Database Upgrade and Migration: upgraded production databases from Oracle 7.2 to 7.3
and migrated staging databases from Oracle 7.3.4 to 8.0.5.
--Database Backup and Recovery: experienced in hot-backup, cold-backup, logical backup,
complete backup and incomplete backup.
--Database Tuning: Thoroughly analyzed the physical and logical layout of the databases,
examined the system environments, proposed and implemented changes associated with data
files on semaphores, Oracle SGA configuration and some applications.
--Database Analysis and Design: Worked with data modeler and developers to design and
implement data warehouse database. Analyzed logical and physical layout of Oracle database
and OS environment for data warehousing. Proposed and implemented primary database
structure with maximum data warehouse performance and availability.
--Development Applications: Participated in coding for database warehouse application
modules using C++, PL/SQL. Supported developers in adding new features and modifying and
enhancing existing features for applications developed with C, Pro*C, PL/SQL.
Database Developer
Jie-Yun Application Software Company, China July 1996- July 1997
--Used Oracle SQL*Plus, PL/SQL, Pro*C to develop stored procedure, triggers, packages and
views for an Oracle database.
--Developed utilities for application database cleanup, SQL Loader and import/export by
using PL/SQL and Shell Script.
--Participated in the database system design, creation, implementation and query
optimization
--Resolved technical issues for custom objects and interfaces relative to the Oracle
Applications environment
--Modified existing customizations (reports, tables, triggers, interfaces, forms)
relative to the Oracle Applications environment
--Designed, Developed and Tested new customizations based on business requirements
--Tested new releases of custom objects and interfaces
--Developed appropriate documentation to facilitate current support, development,
upgrades, or migrations.
Responsible for the following database administration activities:
--Logical and physical implementation of relational database in a distributed environment
--Performance tuning and security management on database
--Conducted data import/export and loading
--Troubleshooting day-to-day operations
Academics Projects:
--On-line stock trade system database design
--Used PHP/MySQL to simulate a web-based Airline Ticket Reservation System
--Used J2EE to implement an E-business application system
--Used Java Applet to implement Tic-Tac-Toe game, Chat Room, Tape Shop simulation,
distributed client/server computing simulation, etc.
Education:
M. S
. in Computer Science May 2000May 2001
New Jersey Institute of Technology,
Newark, NJ
--Attended at Fairleigh Dickinson University,
Teaneck, NJ Jan 2000- May 2000
B. S
. in Computer Science Sep 1992 -Jul 1996
Qingdao University, College of Architecture and Engineering,
Qingdao, China
Contact this candidate