Oracle Data

LISE CALMAIRE DOOH

**** ********* ***** #***, ******, TX 75243. 214-***-****. *********@*****.***

Over 6 years of experience as an Oracle DBA with database versions Oracle 10g, 11g, 12c. I worked as a production, test and development DBA. and environments on Unix/Linux and windows OS. I possess good technical skills and work well individually as well as in team. Being an innovative thinker with extensive experience designing, testing, implementing and supporting the next generation database solution. My DBA skills include but not limited:

Data and database integrity and security.

Standby/Failover Administration.

Backup and recovery including not limited to RMAN and Data Pump.

Proficient in Database Migration, Upgrade and Patch Application

Oracle Disaster Recovery (Data Guard) and other replication methods.

Server and Database automation and monitoring with OEM.

Monitoring and Performance tuning using ASH, AWR, ADDM, Explain Plan and OEM Grid Infrastructure.

Experience in software development life cycle (SDLC) using Waterfall and Agile.

ORACLE DATABASE ADMINISTRATOR Jun. 2012 – Present

Jelani Consulting LLC - Client: EXPEDIA. INC. Dallas – Texas

I am part of a team responsible for all phases of database administration on our production environment, with emphasis on performance troubleshooting, database tuning, analytical problem solving and business customer support.

This duty has solidified my experience in not only the technical aspect of the database administrator but also the management skills necessary to address the challenge we face on the daily bases:

User creation and providing necessary Roles, Privileges and quota as per the requirement.

Database monitoring using scripts, Autosys and OEM.

Create Tablespaces and added datafiles or resized datafiles.

Implement RMAN backup and recovery strategy for all type of Critical Recovery scenarios.

Plan and Perform Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.

Configure TNSNAMES.ORA and LISTENER.ORA for SQL*NET.

Utilize Automatic Workload Repository (AWR) to generate snapshots of key performance data.

Utilize Automatic Database Diagnostic Monitor (ADDM) to reduce DB time by diagnosing key problems.

Use explain plan, AWR, ADDM and various Oracle Advisors to tune the database.

Implement and maintain Oracle Data Guard Physical and Logical standby databases for disaster recovery.

Use Remedy, Salesforces and/or SERVICE NOW software to manage tickets (create, update and follow the implementation).

Collaborate with programmers and testers on software test plans

ORACLE DATABASE ADMINISTRATOR Jan. 2011 – Apr. 2012

Jelani Consulting LLC - Client: Parexel International Greenbelt - MD

Working for one of the leading global biopharmaceutical services organization as an Oracle DBA, my responsibility includes Manage Oracle database administration assignments for diverse clients.

Performance tuning of long running batches/queries.

Performed incremental backups using RMAN.

Identify and recover the corrupted database blocks using Block recover option in RMAN utility.

Monitoring the user sessions and take appropriate action to kill the inactive sessions.

Automated Hot Backup and Logical (Export/Import) backup procedures through exp or expdp and imp or impdp.

Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.

Monitored data files, logical data storage and data growth activities Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze, DB backup logs etc.

Managed the physical database structure by Maintaining, multiplexing and mirroring data files, control files, redo log files and archived log files and creating primary database storage structure (tablespaces) and objects like tables, views, and indexes.

Created Tablespaces and added datafiles or resized datafiles.

Wrote stored procedures and triggers for database maintenance and management using PL/SQL.

Performed Flashback database using guaranteed restore point. Monitored and provided weekly reports on the server's memory, disk and CPU I/O using UNIX command-line utilities.

Database migration from MS Access database to Oracle database system.

IT INTERSHIP Feb. 2010 – Nov. 2010

VOLKSWAGEN AG Wolfsburg – Germany

Among my responsibility as an IT Intern at Volkswagen AG was to support the team by performing work as follow:

Recovery and backup of data utilizing various methods and tools.

Use operating system tools to mitigate system issues.

Development, testing, and implementation of code fixes into test environments

Assist senior team members with issue/bug investigation and resolution

Collaborate with team members at offsite locations to analyze incoming trouble tickets and recreate reported issues

Create and document workaround processes when possible.

Write SQL statements to query and update databases

Databases: Oracle 9i, 10g, 11g and 12c, RDBMS, SQL Server, MS Access.

High Availability Solutions: Oracle Real Application Clusters (RAC), Data Guard and VMware Technologies, VM box, Automatic Storage Management (ASM).

Oracle Tools: Data Pump, Recovery Manager (RMAN), Data pump Export/ Import, Oracle Universal Installer, Database Configuration Assistant, Database Upgrade Assistant, Oracle Grid Control (OEM), Toad for Oracle, SQL*Plus, TDE

Operating Systems: Unix, Sun, Linux (Red Hat, Oracle Linux6.5), Windows.

Programming: Java scripts, visual basic.

Software: Oracle Virtual Box, VMware Workstation 6.5, MS Project, MS Office suite, SQL Server MySQL, JIRA, Web Server, Photoshop, XML, HTML, FileZilla, SOE, BMC Remedy, SERVICE NOW. Word, Access, Power Point, Outlook and Adobe, Excel incl. VBA, PowerPivot and Pivot Tables.

Languages: Fluent in English, French and German.

Oracle Database 11g: Administration II -1z0-053 (OCP)

Oracle Database 11g: SQL

Oracle 11g: RMAN Backup and Recovery

Oracle 11g: Performance Tuning

Oracle 10 g and 11g: Data guard

Oracle 11g: Network Administration

Bachelor of Science, Business Management

(University of Applied Sciences)

P

Contact this candidate