Oracle Manager
Resume:
Title:Lee Hecht Harrison
********@*****.***
Document
Source below
Name: Joyce Miin
Address:
City: Ann Arbor
State: MI
Zip/Postal Code: 48103
Country:
E-mail: ********@*****.***
Primary Phone:
Background
Most Recent Job Title: Oracle DBA
Most Recent Employer: Jaguar Land Rover/Ford/Tata
Career Level: Senior (Non-Manager)
Availability or Timeframe:
Authorized to work in the US: Yes
Security Clearance:
Do you have transportation:
Over 18: Yes
Education: Masters
Languages Spoken: Chinese, English
Job Preferences
Desired Salary: Open
Willing to Relocate:
Desired Job Titles:
Desired Job Types: Contract, Employee
Work Status: Full Time
Desired Shifts: 1st Shift
Desired Travel: 10%
Category: Information Technology or Systems
Company Size:
Company Type:
Industry:
View Emails To Candidate close
Email Status close
close
Forward Candidate(s) Status close
Saving close
Save To:
Note:
Resume Reserve and LeadLink data may only be used for contact directly related to
employment. Use of these free online services is subject to the Terms of Use. Resume
Reserve and LeadLink Terms of Use prohibit automated extraction of data, marketing, or
fees of any kind. Resume Reserve data is private and may only be used by authorized
individuals. Access codes for resume viewing and job lead posting are issued and owned by
LHH and will be revoked if misused.
Send questions to: *******@***.***
To review the Terms of Use, click here.
Copyright c 1997- Lee Hecht Harrison, Inc.
JOYCE(Jong) MIIN
Information Specialist
********@*****.***
SUMMARY:
Professional background of over ten years experience in all aspects of Oracle database
administration in a fast growing 24/7 environment.
Oracle Certified Professional (OCP 7.3.4, 10G and Oracle RAC Administration) Database
Administrator with extensive background in Oracle database management. Master of Science
Degree in Computer Information Systems.
Have completed many projects with full life cycle.
Team player attitude with the ability to work independently.
Ability to effectively communicate with peers and management.
TECHNICAL SKILLS:
Applications MS Office, PeopleSoft, SCT Banner Languages SQL, PL/SQL, Shell Scripting
Databases Oracle 7/8i/9i/10g/11g, Oracle RAC, MS SQL Server 2000, Sybase Utilities RMAN,
Export, Import, Data Pump, SQL*Loader, OEM, Grid Control Tools Toad, Erwin, VPN,
Hummingbird Operating Systems Sun Solaris UNIX, Windows XP/NT, UNIX, Linux, HP-UNIX.
PROFESSIONAL EXPERIENCE:
Ford/Jaguar Land Rover/Tata, Dearborn, MI
Oracle DBA
Work as Independent Consultant, 1/2009 till present
Responsibilities/accomplishments:
Assist in the IT transition /migration of Jaguar Landrover from Ford Motor Company (SWIFT
project).
Work with developers to define and maintain an environment for application development
and testing.
Upgrade Oracle 10G to 11G using DBUA.
Upgrade desktop server RAM to 2G, add in 2nd hard drive to make more space for install
VMware etc
Install VMware, create virtual machine RAC1, RAC2
Install and configure Oracle Enterprise Linux in Virtual Machines
Install Oracle Clusterware, Oracle RAC, and ASM by using Oracle Database clustering
technologies.
Backup recovery using Recovery Manager (RMAN)
Keep abreast of Oracle s direction and latest technologies.
Certified in Oracle RAC Administration
Environment: Oracle 9i, 10g, 11g, AIX, SESU, Red Hat Enterprise Linux, Oracle Enterprise
Linux, VMware server, workstation.
XEROX-EDS,
Pontiac, MI
8/2008
12/2008Oracle DBA, Information Specialist
Work as an EDS - HP employee at remote site for Xerox Rochester, New York.
Responsibilities/accomplishments:
Work on Oracle 9i, 10g databases server in UNIX Sun Solaris environment.
Assist in the development and modification of XCS databases to meet Xerox production
needs
Manage extensive modifications
Provide on-going support
Review other DBA s scripts and executions
Environment: Oracle 9i, 10g, UNIX Sun Solaris.
GM Ren Center
-EDS, Detroit, MI
3/2007
7/2008
Oracle DBA
Responsibilities/accomplishments:
Provide on going technical database support for the GM OnStar in the areas of database
design, database security, data integrity, creation and maintenance of physical data
models, database backup and recovery, performance tuning, and troubleshooting.
Support GM PCI SolidCore implementation and participate in project planning and technical
implementation. This support includes the following Application activities; Install Oracle
server, performance tuning, CPU patches and upgrades, setups, monitoring, TAR support with
Oracle Corporation, script review and execution, capacity planning, troubleshooting and
maintenance. Create SolidCore databases, set up hot backup, archive log etc.
Implement GM Web Destination Entry project (called eNAV) also participate in the
processes for extracting, cleaning the data to the Data Warehouse. Communicate formally
with customers priorities, commitments and changes to plans.
Support projects as required (launches, upgrades, product transfers, etc.)
Coordinate with Vendor DBAs as required.
Recommend and justify upgrades and implementation of new features and tools.
Participate in reviews of database changes. Participate in reviews of processes against
the data.
Write Korn Shell scripts to extract data, compress it, ftp to destination server,
determine mount point, volumes etc for the project.
Environment: Sun Solaris, Oracle 9i, 10g, Export, Import, HP-UNIX, EMC SRDF and BCV
technologies
GM Global Sales Services Marketing (GSSM
)-EDS, Troy, MI
7/2006
2/2007
Oracle DBA
Responsibilities/accomplishments:
Support the GM Global Sales Services Marketing (GSSM) Business to Customers (B2C) sub
contract.
Provide 24/7 supports of Oracle databases on UNIX servers for 33+ General Motor s
websites. This environment was a multiple global vendor environment that posed many
challenges.
Write/modify UNIX scripts; adhere to existing promotion processes in Oracle 9i, HP and
Sun Solaris OS environment.
Provide On-call support.
Provide solution, back out plan, verification plan to each operation service request.
Use Oracle OEM for part of solutions. For example: set up repository tablespace and user
for Oracle OEM change manager to compare databases.
Apply Oracle Patches.
Start and stop Oracle application server concurrent manager to load and publish data.
Use RMAN to retrieve archived redo logs, and then set up logminer to trace user
activities.
Environment: Oracle RMAN, LogMiner, 9i, OEM, HP-UNIX
Automatic Data Processing,
Ann Arbor, MI Hosting Center,
6/2005
4/2006Database Engineer
Responsibilities/accomplishments:
Analyze, maintain complex cost effective enterprise database solutions to meet more than
four thousand established hosted system architecture requirements for availability,
manageability, recoverability, monitoring, scalability, security and reliability.
Provides ongoing support of the databases and database servers for systems which includes
performance monitoring, performance tuning, troubleshooting and client support in
production of Oracle UNIX SUN Solaris, NT environment and MS SQL server.
Support operation room activities for client 1 outage or escalated critical cases.
Perform database administration on all database systems and maintain all client database
Provide on-call support.
Create, restore MS SQL database.
Archiving, backup / recovery, refresh, cloning, import/export and remove obsolete
database Oracle databases.
Use Veritas NetBackup 5.1 to restore files, which is not in the current system.
Environment: Sun Solaris, NT, MS SQL server, Oracle 8i, 9i, Veritas NetBackup
Michigan Information Technology,
Southfield, MI
02/ 2004
06/2005Consultant
Responsibilities/accomplishments:
Support on company s Oracle 9i projects.
Provide on-call support as needed, ongoing support of the databases and database servers
for systems, which includes performance monitoring, performance tuning, troubleshooting
and client support.
Perform database design and development, database administration, software design and
development, and customer support.
Administration of database objects such as indexes, tables, views, constraints, and
stored procedures.
Create and Administrate of database users
Environment: Oracle 9i, Window NT.
ClubPhoto.com
(San Jose, CA)
3/01
-01/04Contractor
Responsibilities/accomplishments:
Research and evaluate new tools/technologies for database relocation.
Prepare and perform database capacity studies and planning for management review and
approval. The project was on and off and did not finish because of company s financial
difficulties.
Washtenaw Community College, Ann Arbor, MI
1/1998
2/2001PeopleSoft/SCT Banner/Oracle Database Administrator
Responsibilities/accomplishments:
Work with consultants to implement PeopleSoft and SCT Banner ERP software.
Support PeopleSoft and SCT/Banner2000 implementation in a UNIX SUN Solaris
environment, save million dollars for the implementation. Go live within time frames.
Install, configure Oracle 8.0.5 database server on SUN Solaris.
Perform disaster recovery and restore data files when required. Often have to work
overtime and perform duties after hours to be successful with these production support
issues.
Apply patches on Oracle Database Server v7.3, OCP in 7.3.4
Perform production and test database changes such as modifying objects, tables, indexes,
and views to ensure data integrity and object security.
Troubleshoot Oracle database problems.
Work with Oracle Corporation on technical support issues.
Install, configures Oracle 8.0.5 client on PC in Windows 95 environment.
Clone PeopleSoft, SCT pre-production database to be production database on the same or
different UNIX machines.
Work as part of a team and to perform a full range of database analysis and management
tasks.
Perform PeopleSoft and SCT Patches, Fixes and Upgrades as required.
Create PeopleSoft/SCT Banner databases and set up user Ids, and securities. (Create and
maintain users, roles and, assign privileges and permissions).
Receive an award for finishing implementing new student system before the scheduled due
date.
Environment: PeopleSoft, SCT Banner, Oracle 7.3, Sun Solaris
Sybase, Inc. professional services employee, Southfield, MI,
01/1997
01/1998,
Associate Consultant
Responsibilities/accomplishments:
Perform database design and development, database administration, software design and
development life cycle, and customer support using a variety of Sybase software products
including SQL Server, SQL Anywhere, Power-Designer, and PowerBuilder.
Assign to the following projects while at Sybase:
Work on a PeopleSoft HRMS implementation for DMB&B.
Function as one of the PeopleSoft HRMS implementation team leaders.
Design, build, test and analyze database to support Human Resource activities.
Use PeopleSoft import manager tool to manipulate, transfer and clean data sets within and
between these systems while assuring data consistency and quality.
Work on the Jockey Club Project and was assigned to work on debugging complicated stored
procedures. Receive high marks from team/group leader.
Work on the State of Michigan Commissary Project to help improve the performance and make
changes to the Daily Sales Report.
Improve the performance of the report and satisfy the clients request to their
satisfaction.
Environment: Sybase, SQL Anywhere, Power-Designer
Lab Consultant/Graduate Assistant
at Eastern Michigan University09/95
12/96
Accomplished the following:
Design and maintain the CRS library database.
Conduct ICPSR database requests and file transfers, set up Caucus conferences for staff
members.
Develop and maintain the CRS database using MS Access, Telnet and FTP, and set up Caucus
in UNIX.
Perform Internet searching and downloading of information, assisted with workshops,
assist with the use of scanners, and install a variety of software on both Macintosh and
Windows PCs.
On a Graduate School Project functioned as a Project Leader and convince a local
corporation (SSC) to allow a team of EMU students to develop a software system to meet
their requirements. Lead the team in the analysis of an old reporting system and develop
the specifications for a replacement system that the team developed using MS Access in a
Windows 95 environment.
Environment: MS Access, FTP, Macintosh, and Windows
EDUCATION
Master of Science
in Computer-based Information Systems
Eastern Michigan University,
Ypsilanti, MI 1996 GPA 3.53/4.00
PROFESSIONAL TRAINING
Oracle 11G new features for administrator
Oracle RAC administration
Oracle 10G administration workshop I and II
Oracle 9i new features
UNIX System Administration
Introduction to Networking
Oracle Reports
SCT/Banner2000 General/Student Technical Training
Oracle 8 Network Administration
Oracle SQL Statement Tuning
Oracle 8 Performance and Tuning
Oracle Advanced SQL
Oracle 8 Backup and Recovery
Introduction to Oracle and PL/SQL
Sybase Adaptive Server Enterprise 115
Sybase Professional Services-Application Workshop
Fast Track to Sybase SQL Server 11
Relational Database Design
Client/Server Architecture
Database Management Systems
Introduction to Sybase
DBA
Contact this candidate