Manager Oracle

Jennifer Rea [pic] DBA

Tel. 516-***-**** Email: *******@*****.***

Summary:

. Masters in Computer Science with 6 years of experience as Financial

Trader for the Shanghai Futures Exchange.

. 5 years experience in Oracle database administration, security and

systems management.

. Experienced in 10g Oracle DataGuard and RMAN

. Experienced in 11g Oracle RAC, ASM

. Extensive experience in PL/SQL, SQL programming, backend processing

and application support.

. Data Loading External Files, SQL Loader and Import.

. Experienced in business client support and user application support.

. Experienced in all aspect of Oracle Database Technology

. Experienced in PL/SQL, Packages, Procedures, Functions, Materialized

Views, Triggers etc

. Experienced in SQL, Bash, Javascript, HTML, XML,PERL, AJAX and PL/SQL

Web Tool Kit.

Oracle work encompassed:

. Oracle Database setup, configuration and maintenance

. Creating, loading and managing database

. Build the indexes for new tables

. Extensive experience with database Backup, Recovery

. Experience with Backup and Recovery procedures using RMAN

. Hands on experience of database backups and Recovery strategies using

RMAN, Export/Import, and Transportable Tablespace. Disaster recovery

for monitoring and backing up the Oracle databases

. Manage security and roles

. Extensive knowledge on 10g release

. Experience on oracle import export utility and data pump

. Database upgrade and migration from 9i to 10g

. Experience in Database Administration in Oracle versions 9i, 10g, and

11g + ASM

. Installed, configured, created and upgraded Oracle environments

. Strong in knowledge of oracle data-dictionary, configuration of Oracle

Enterprise Manager (OEM) tools

. Extensive experience with SQL, SQL tuning

. True team player; maintained client/customer relationships by

providing timely, superior quality products and services;

understanding of client/customer needs, opportunities and satisfaction

criteria

TECHNICAL SUMMARY

Operating Systems: UNIX, Linux, Windows NT/2000/XP/2003, DOS, Red Hat 4,5

Languages: Pascal, C, C++, C#, Perl, SQL, PL/SQL, BASH,

PERL, HTML, MS-DOS, BASIC,

FORTRAN, ASP.net, UML

Database: Oracle 9i, 10g, 11g, Excel, Access, MS SQL, MySQL

Networking/Backup: Oracle Enterprise Manager (OEM), Troubleshooting on

2003,2000,XP,NT, Recovery Manager (RMAN), Enterprise

Backup Utility (EBU)

Utilities: SQL Loader, External Files, TOAD, SQL Navigator, Instance

Manager, Knowledge Xpert, Erwin 3.5/4.1,Veritas Backup Exec,

Microsoft Project 2000, Project Central, Crystal Reports

5.x, Oracle SQL Developer, JDeveloper and Toad Data Modeler.

TOAD, SQL*Plus

Link Share Corporation, NY

Oracle DBA 10/07 - present

. Performance tuning of database indexes, analyzing objects and finding

bottleneck SQL statements to enhance speed and performance.

. Checking row migration and chaining.

. Support all users on database, application issues and access control

. Install, configured and maintained Oracle 10g on Linux Red Hat 5

. Clone database for Production, Development, QA testing environments

. Create and Maintain materialized view (snapshot)

. Installed, patched, and configured Oracle 10g Monitoring Oracle

database and Oracle Internet application server using external and

internal alert system every few minutes and fix the issues.

. Managed tablespace

. Monitoring database in OEM and OS level

. Setup email to automatically send daily database monitoring

information or alert.

. Reviewing and approval all company's project DDLs and deploy all DDLs

on QA environment and production environment.

. Tune at the database and statement level in production using AWR,

ADDM, and SQL tuning advisor to improve system performance

. Performed user and security administration activities, such as

enrolling users, granting privileges to users, and maintaining system

security

. Utilized RMAN for backup and recovery strategy

. Completed export and import of different databases using Oracle Export

/ Import utilities and datapump

. Provided all kinds of DBA support to development teams as well as

production support to various applications

. Created and maintained different database entities included

tablespaces, data files, redo log files, rollback segments and

renaming/relocating of data files on servers.

. Modified database structures including tablespaces, tables, views,

triggers, stored procedures as well as configuration and storage

allocation to support application enhancement

. Developed Scripts to monitor the storage usage, object status for

daily job. Provided 24*7 on call support regarding production related

database issue

. Index compression

Environment: Linux Red Hat 5, Oracle10g, SQL*Plus, TOAD

IT Solutions Xchange, NY

Oracle DBA 07/05-10/07

. Installed and upgraded Oracle database

. Configured folders and granted user access

. Created or clone Oracle databases in production, development, testing

and staging environments

. Generated SQL script to create or drop database objects including:

tables, indexes, sequences, and synonyms

. SQL programming

. Resolved connectivity issues and any issues related to database for

developers

. Performed backup and recovery using RMAN

. Managed Import/Export Depending upon Requirement.

. Data migration loading with SQL Loader

. Monitored database activity and attended to developer/user queries and

requirements

. Provided Oracle space, change and object comparison management

. Overall performance enhancements

. Performed Oracle database administration tasks including user

administration, schema creation and maintenance, data validation,

backup and recovery procedure using RMAN

. Creation of database objects like tables, indexes, and views etc

. Create and Maintain materialized view

. Index compression for save storage

. Provide 24*7 on call

Environment: Windows 2003 Server, Oracle 9i, 10g, SQL*Plus

The Law Firm of Lawrence Rogak, NY

Windows Systems Administrator 5/02-6/05

. Setup, install or upgrade all operation systems, workstations and

servers with windows 2000 operating system. Maintain operating system

on server and workstation. Network trouble shooting, application

installation. Configuration and maintenance of backup server.

. Troubleshooting for Network and all computer systems in Microsoft

environment, Windows 2000, XP, Office 2000, XP, Outlook, Norton Anti-

system, all printers Created special templates for computer systems

. Installation and setup of MS SQL, Maintained and monitored databases.

Created user accounts and permissions. Performed and verified database

backups and recovery

. Installation and set up of all application software on the server and

workstation including maintenance of law firm's TimeMatters and

TimeSlips.

. Trained employees in use of all software

Bear Stearns-MetroTech Center, Brooklyn New York

Internship 12/00-12/01

. Assisted in supporting trade back office databases (Access) and

creating database updates.

. Maintained and monitored multiple database

. Regarding margin calls, interest payments, trader commissions

.

Long Island University-Brooklyn Campus

Graduate Assistant 5/01-12/01

. Develop and maintain a website for Long Island University

. Tutoring graduate & undergraduate students in the Computer Science

Department

.

Shanghai Futures Exchange

Trader 4/92-12/97

. Analyze market conditions and trends to determine best opportunities

to execute futures transaction orders

. Buy and sell futures based on market quotations and competition in

market As a licensed futures trader, bought and sold futures on floor

of the commodities exchange

EDUCATION

. Certified Oracle9i Database Administrator Associate

. MS in Computer Science, Long Island University

. BS in Computer Science, Shanghai Industrial University

PROFESSIONAL TRAINING

. ORACLE UNIVERSITY OCP WALL STREET PROGRAM.

. Hands on training on Oracle 9i (DBA) and 10g (DBA)

. Hands on training on Oracle 11g RAC + ASM

. SQL, Fundamental I, Fundamental II, Performance & Tuning

. PL/SQL and Data Warehousing (11g).

ACHIEVEMENTS & AWARDS:

. National Excellence as Commodities Trader in China, 1996

. Excellence in Computer Science and Integrated Information Systems from

Long Island University

AFFILIATIONS:

. Member of NYOUG

Contact this candidate