SUMMARY:

• Professional background of over eight years productive and successful experience in all aspects of Oracle database administration in a fast growing 24/7 environment.
• Oracle Certified Professional (OCP 10g) 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, MS SQL Server 2000, Sybase

Utilities :

RMAN, Export, Import, Data Pump, SQL*Loader, OEM

Tools :

Toad, Erwin, VPN, Hummingbird

Operating Systems :

Sun Solaris UNIX, Windows XP/NT, UNIX, Linux, HP-UNIX.

PROFESSIONAL EXPERIENCE:

Independent Consultant, Confidential,MI
1/2009 till present

• 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
• Plan to install Oracle Clusterware and Oracle RAC.

Confidential,Pontiac, MI
8/2008 – 12/2008
Oracle DBA, Information Specialist

Work as an EDS - HP employee at remote site for Xerox Rochester, New York.
Responsibilities/accomplishments:

• Worked on Oracle 9i, 10g databases server in UNIX Sun Solaris environment.
• Assisted in the development and modification of XCS databases to meet Xerox production needs
• Managed extensive modifications and provided on-going support

Environment: Oracle 9i, 10g, UNIX Sun Solaris.

Confidential,Detroit, MI
3/2007 – 7/2008
Oracle DBA

Responsibilities/accomplishments:

• Support the GM OnStar project.
• Support GM PCI SolidCore implementation. Install Oracle server, upgrade it, and apply patches, Create SolidCore databases, set up hot backup, archive log etc.
• Implement GM Web Destination Entry project (also called eNAV).
• 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

Confidential,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

Confidential,MI
6/2005 – 4/2006
Database 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

Confidential,Southfield, MI
02/ 2004 – 06/2005
Consultant

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.

Confidential, (San Jose, CA)
3/01-01/04
Contractor

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.

Confidential,MI

1/1998 –2/2001
PeopleSoft/SCT Banner/Oracle Database Administrator

Responsibilities/accomplishements:

• 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.
• 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

Confidential,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

Confidential,09/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

PROFESSIONAL TRAINING

• 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