Manager Oracle

C LE M E N T TAB I

*** *********** ****, ****** ******, M D 20905,

240-***-****, E-Mail: ***********@*****.***

Professional P rofile

I am an information technology specialist with over four years of experience

i n data processing. In particular, I specialize in Oracle database

administration, database configuration, performance tuning, database

t roubleshooting, backup and recovery, and Oracle Server programming on

both UN IX and Windows operating systems. I possess an excellent knowledge

i n the configuration, installation and upgrading of Oracle8i/9i to 10g

E nterprise Edition Server Databases. I also possess an excellent

communication skill.

WORK H ISTORY

A BC Health Services, Alexandria, VA

2011-2014

Database Administration

Managed deploy and Support Oracle database 11g Release 1 on OEL 5.x. and on AIX

5.3; My basic responsibility on these databases are as follows.

• Created, tested & deploy single instance specific database, create proactive

a dmin scripts to maintain the databases.

• Maintained about 10 databases which range from Development, System

I ntegration Testing (SIT), User Acceptance Testing (UAT) and production

environment. With size ranges from 200GB to 1TB

• I nstalled Oracle 11g Release 1 software on O EL 5.x, C reate new databases as

per customer requirement.

• Monitored the databases using scripts.

• I dentified, led, and established automation of repetitive processes to

m inimize er rors.

• Completely eliminated space er rors by implementing proactive space

monitoring and effective space allocation.

• Evaluated Oracle compression Utility to properly managed space

• Managed backup and Recovery Issues, online backup and offline backup.

• Greatly improved performance in daily t ransforms by identifying and

r eorganizing indexes on major tables.

• Monitored the Database for growth and add space to the table spaces as

r equired through proactive monitoring.

• Refresh of the integration d atabase f rom the p roduction database.

1

• Oracle database performance tuning using AWR, explain plan, tkprof a nd

O EM, event dumps as well.

• Responsible for d ata integrity and user security .

• Perform consistent system performance review. Identify problems that may occur in

t he future before they occur.

• Perform database r e-organizations as required to assist performance and ensure

maximum uptime of the database.

• Administer all database objects, including tables, synonyms, clusters, indexes, views,

sequences, packages and procedures.

C DE Software, Alexandria, VA

2009-2010

Database Administrator

Involved in an Oracle project and Part of my responsibilities involve the following:

• Applied Critical Patch Update and security patches in various environments

• Performed backups and recovery using R MAN, Import/Export, Hot/Cold

B ackups, Data Pump tools

• Checked backup and restored validity periodically from production to non-

production environment

• Created new table spaces, indexes, synonyms, procedures, functions, users,

a nd granted privileges

• Monitored user sessions and took appropriate action to kill inactive sessions.

• Performed proactive performance tuning strategies and database

a dministration. Creation of Table spaces, Monitoring Rollback and

T emporary Segments, Performed Capacity Planning, Managing Disk Space,

Optimizing Disk I/O, Optimizing the SGA, Re-org instances, I ndex Rebuilds,

H ash and composite partitions, T ransportable table spaces. Use of

STATSPACK, TKprof, DBMS_STATS, SQL Analyze, etc.

• Was responsible for creating and installing databases for various application

i mplementation, performance systems/performance audits/tuning and

designing reliability standards in stand-alone and distributed environments

t o ensure database availability, reliability, accessibility and security

B rontech Solution, Alexandria, VA

2008

Database Administration

2

As a database administrator for the enterprise production system, my responsibili ty was to

p rovide cluster support for 50 Sun Solaris servers running Oracle Enterprise Edition

databases with versions from 9.2.0.7.0 to 10g Release 2, with a total of 120 database from

p roduction, testing, development and QA environments, sizes of these database ranges from

60gb to 800gb. Provided production support, management of Oracle databases, application

schema maintenance, space management, performance tuning, backup & recovery,

t roubleshooting, establishing & monitor security aspects in all database on a continuing

basis. Designed, tested and implemented a Java-based 3-t ier Oracle Enterprise Manager

10g Grid Control solution for FannieMae Production and development environments which

is currently used by developers & Database Administrators for all related performance

issues for FANN IEMAE Re-statement Projects and many other projects. Establish access

control for user accessing OEM grid Control.

• Exploring the possibili ty of using new features added in Oracle 9i and 10G Release

2, and 11gR1.

• As a user I am comfortable & familiar with Remedy Service Process Management

(SPM) platform which provides a comprehensive, end-to-end solution for automating,

managing, and monitoring service management business processes.

• Handling Oracle 10g/11gR2 database installation for test, development & production

environments.

• Perform database backups and recoveries, reviewing operating system

configurations on DBMS and ensuring optimal performance/availability.

• Ensuring 24X7 database availability to customers.

• Planning & defining physical resources and logical devices.

• Was responsible for creating and installing databases for various application

i mplementation, performance systems/performance audits/tuning and designing

reliability standards in stand-alone and distributed environments to ensure

database availability, reliabili ty, accessibility and security.

Languages:

UN IX Shell Script (csh, ksh, awk), C, C++, MSVC, Perl, PL/SQL, Pro*C and Java

Other Software/Tools: DEC SET, Optio DCS, Noetix View, Apache, Quest, Reload Editor,

N ET8, SQL*NET, TCP/IP

Specialty:

Single database Instance, Advanced level t roubleshooting, Analysis of Oracle internal error

and dumps, Logical and physical database design, Backup and Recovery Strategy,

Performance Tuning & Optimization, Large Scale implementation for Grid Control, Oracle

U pgrades and M igration, Real time system programming and Certification Oracle patches

before rollout into production.

ORACLE PRODUCTS:

3

O racle Database (Replication, Parallelism, OLAP),

Oracle Enterprise Manager Version 2, Oracle Enterprise Manager 10g Grid Control R2,

Data Guard, RAC, Golden Gate, Oracle Stream

SOFTWARE

Oracle Enterprise L inux 5.x, AIX (3.2.5, 4.2.1, and 4.1.5), ORACLE8i SERVER (9.2.0.7.1,

t hrough 10g release 2), OEM (Oracle Enterprise Manager Grid Control), Windows NT4.0,

20004),

HARDWARE

DEC Alpha, HP 9000, Sun Solaris, PC. Oracle Enterprise Linux 5.1, cent O/S 7.0

OPERAT ING SYSTEM

UN IX (HP-UX, SunOS, Digital), VAX/VMS, Windows 95/98/NT/2000

TOOLS:

Enterprise Manager 10g Release 2 Grid Control, SQL*Net, Q*Diagnose

CERTIFICATION & EDUCATION

• Oracle Certified ASSOCIATE 11G – OCA DBA

• SQL Fundamentals I

EDUCATION:

2004-2006; Bachelor of Ar ts H istory/Political Science, University Of Buea Cameroon

TECHN ICAL EDUCAT ION

T rustech Institute of Information Systems

• Oracle 10G Training, Sept 2007 – Dec 2007

I & T Training

• Oracle 11G Workshop 1, May, 2012

• Oracle 11G Workshop 2, Oct, 2012

• Oracle 11G Int roduction to SQL Workshop, Jan, 2012

• UN IX Fundamentals 1, Oct, 2011

S trong References Available

4

Contact this candidate