oracle database administrator

ORACLE

**g CERTIFIED PROFESSIONAL

Clarisse Guefack

***-*** *********** ****** ****, L5A 3N6 Mississauga, Ontario

Phone: 905-***-****

Email: ***********@*****.**

Summary: over 6+ years of experience in all phases of software development, testing and implementation of business applications and 4+ years experience in database administration. Extensive experience in database installations, capacity planning as well as physical and logical design

• Developed strong skills in managing and maintaining Oracle database in mix Unix( AIX, SUN SOLARIS, HP-UX, LINUX) and Windows environment

• Extensive experience in installing, managing and maintaining Oracle 9i and 10g RAC

• Mastered Oracle Database Performance tuning, SQL, PL/SQL programming, RMAN and backup/ recovery, Hot Standby, Disaster Recovery, Replication, Oracle Parallel Server

• Extensive experience using Packages, Procedures, Triggers and Functions.

• Good communication and interpersonal skills

• Fluent in English, French and German both written and spoken

Skill/Tools:

Hardware: IBM RS 6000 (R30; R50; P-690), Sun E5500, Sun E6500, HP 9000

Operating System: Windows NT 4.0 / 2000, HP UX, Sun Solaris

Languages: SQL, PL/SQL, Shell Scripts, KORN shell, Rational Rose, JAVA

RDBMS: Oracle 7.x/8.0.x/8i/9i/10g

Oracle Tools: SQL*Loader, Oracle DataPump, ADDM, TOAD, RAC, Erwin 3.5.2,RMAN ,ASM(Automatic Storage Management, SAN,NetBackup Developer2000, SQL Developer, Forms 4.5 and 5.0 reports 2.5 and 3.0

Reporting Tools Oracle Discoverer 9iAS, Cognos, Hyperion/Brio, Crystal Reports

EXPERIENCE

RPM Tech, Mississauga, ON

Oracle Database Administrator Feb. 2008 - Pres

I’m part of a team responsible of the billing system project. I installed, designed, created, and configured Oracle 10.2.3 databases on Solaris 9 now in production. I designed the physical and logical layout of the database using ErWin. I optimized and tuned the system using various custom scripts and tools including GRID Control, AWR, DBMS_STATS, TkPROF, 10046 Event Trace and EXPLAIN PLAN. I was responsible of following:

• Wrote shell scripts for daily, weekly and monthly database monitoring.

• Wrote PL/SQL procedures and triggers to audit databases and maintain data integrity

• Tuned SQL and PL/SQL statements to maximize server response time and network bandwidth utilization. Conducted weekly load of external data using Oracle SQL* Loader.

• Performed cold and hot database backup and recovery operations using RMAN and NETBACKUP

Techno, Mississauga, ON

Oracle Database Administrator 2006 - 2008

In this position, I was part of the Data Warehouse team responsible of a 10 TB two nodes oracle 9.2.5 RAC analytical database, 3TB two nodes oracle 9.2.5 RAC operational production database and multiple RAC development and test databases all running on AIX OS. In this task, I used various tools such OEM, Explain Plan, TKPROF, Toad, and custom shell scripts for the daily monitoring and performance tuning of these instances. I shared the weekly based on-call rotation, to this effect I was responsible for all duties related to the general maintenance of the database including troubleshooting, monitoring, online backup and recovery. I also provided technical support to the ETL developer’s team for optimal Load response time. Other duties included:

Project Experience: As a Programmer/Analyst I was involved in the following:

• Assisted in migration effort of the production Oracle 9.2.5 RAC database from RS 6000(7038-6M2) servers to RS 6000(P-690) servers

• Monitored and managed database space utilization and growth. Allocated and planned disk storage, modified database structure upon developers’ request.

• Led several tuning efforts using Statspack, SQL tuning, and the wait events interface that resulted in significant improvements in response time for application, ad-hoc queries and data migration modules. Implemented tables and indexes partitioning

• Installed and configured oracle10g DATAGUARD on Sun Solaris 2.8 OS consisting of a production database with two standby databases

• Implemented physical tapes RMAN backups and restores procedures trough NETBACKUP and TSM media management layer

Fraunhofer Berlin, Germany

Oracle database Administrator 2004 – 2005

I was responsible for upgrading Oracle 8.0.5 to Oracle 8.1.5 on a SunOs/ Sparc platform. Further responsibilities included creation of database objects such as tablespaces, tables, indexes and views. I enrolled users and managed the security activity into the database by administrating roles and privileges. Furthermore, I was responsible for tuning the instance in order to enhance the performance of the system. I analyzed trace and log files information to determine and resolve problem areas using UTLEBSTAT, UTLESTAT, TKPROF and other tuning tools.

Hyperion/Brio and Oracle Developer 2003 – 2004

• Designed Tables, Views, and Triggers based on the on the business requirements

• Modified existing views to create or replace complex queries and reports

• Involved in requirement gathering and analyzing business requirements, developed and formatted queries and reports. Maintained Version Control Using VSS

• Developed Stored Procedures using PL/SQL to transfer processing load to the backend server. Used MS Excel to export the data and modify it based on the client

• Designed and developed various types of reports, modified Late and Missing reports

• Identified and Resolved problems and Unit Testing and QA of reports.

Innotech Berlin, Germany 2002-2003 Sotfware Engineer

• Analysed business/system requirements and participated at all stages of the development life cycle of an integration of GPS in a German highway

• Modelled and designed of a navigation system (Global positioning System) for the German highway system with use of UML(Rational Rose)

• Identified different GPS scenarios using case diagram, class diagram, sequence diagram and state diagram in the Unified Modelling Language Rational Rose

• Implemented and tested of design artifacts with use of proper object oriented methodologies such as Java programming language

EDUCATION

Bachelor of Computer Science, University of Berlin, Germany 2005

Oracle Certified Professional Database Administrator 10g

Contact this candidate