ORACLE DBA

Ngoh Tezoh

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

Tel: 301-***-****

Personality Traits.

Experience working both independently and collaboratively in a team oriented structure.

•

Detail oriented individual with strong analytical approach to solving problems

•

Ability to prioritize and execute tasks in a timely manner with minimal supervision.

•

Flexible and adaptable to new tools, technologies, environment and learning.

•

Good communicate and strong interpersonal skills

•

Objective: Enthusiastic and self motivated seeking a position as an Oracle DBA in a growing

organization to utilize my experience and knowledge in an environment that encourages innovative

thinking, recognition and career development.

Career Summary;

Database Installation, upgrade and migration, shell scripting and documentation

•

Used RMAN for backup and recovery operations.

•

Performed daily database administration on production to ensure availability

•

Database Monitoring and security enforcement.

•

Have good experience in creating database objects, space management and Storage allocation.

•

Export/Import of oracle databases using Datapump utility.

•

Database maintenance by applying required patches and software updates.

•

Database upgrade from 10g to 11g.

•

Worked with Oracle Enterprise Manager (OEM) for Monitoring and scheduling Oracle database

•

operations.

Exposed to high availability involving Oracle RAC and Data guard.

•

Oracle Database Administration 10g, 11g on UNIX/Linux, AIX, and Solaris environment.

•

Tracing, troubleshooting with database performance and tuning issues.

•

Clone production databases to create a test and development environment using script. and RMAN

•

method.

Migrated database object within and across platforms.

•

Good OS and database trouble shooting skill.

•

Resolvit LLC, washington DC

September 2013 – present.

Managing user administration, schema creation, import/export operations, performance tuning, backup and

recovery of Oracle databases.

Key responsibility: Operation support DBA on Linux and Windows 2003 platforms.

Responsibilities:

Provided day to day and weekly DBA on call rotation support for Production environment.

•

Worked on Database upgrades from 10g to 11g for 30 databases in span of 3 months.

•

Created databases, users, roles, profiles, tablespace, tables, and other database objects. Managing

•

users access rights and users resource quotas.

Used RMAN to performed database backups and recovery. Designed strategies for backup,

•

restoration and recovery of production databases.

Performed Daily Logical backups using expdp/impdp utility.

•

Monitored Database and Tablespace Growth and checked Space Availability at the OS and database

•

level.

Used Export/Import to do table level and full database defragmentation.

•

Loaded data using SQL Loader from Text files into Database daily.

•

Applied Critical Patch Update on all Oracle Components quarterly.

•

Tuned the production database for Optimized results using utilities such as AWR reports, ADDM

•

reports, ASH reports, Explain Plan, SQL Trace, STATS PACK and Provided recommendations

based on advisors. Analyzed the trace files Using TKPROF utility.

Refreshing the Non production environments with data from the production databases.

•

Analyzed storage options, recommends storage hardware and configuration for optimal DB

•

performance.

Converted data files across different platform using RMAN convert, Transportable Tablespace

•

(TTS) and Data pump (expdp/impdp).

Provided solution and maintained the databases for troubleshooting by using trace files, alert log

•

and Oracle Mata links.

Resolved Database Security issues by creating and assigning appropriate roles and privileges to

•

users. Managed Users by authenticating, auditing and encrypting for security and integrity of the

company.

Involved in capacity planning for all the Production and Stage Servers (Performance Analysis,

•

Storage Growth and Automatic Storage Management.

Configured, setup and Maintained Oracle Data Guard on 11g to control Primary and Standby

•

Databases and also to ensure disaster recovery using various data protection modes.

Partitioned Large tables and indexes to increase database performance, creating and modifying

•

indexes, and analyzing trace files.

Performed Migration by using Data Pump utilities Expdp/Impdp, SQL Loader and Transportable

•

Tablespace techniques for availability and satiability.

Environment: Red Hat Linux, Sun Solaris 9.0, PL/SQL Developer V6, TOAD, ASM, Data guard, Oracle

11g/10g/9i RAC, Plan view, SQL*PLUS, OEM, Grid Control.

SYNERGIE INTERIM – Antwerpen, Belgium

August 2010 May 2013

Synergie is a recruiting, staffing, outplacing and training agency. Helping people to work is the primary

mission of Synergie. As part of the team of 10 DBAs on site, I was involved in creating multiple databases,

managing storage structures and objects, database backups and recovery, monitoring and security

enforcement, optimizing database performance to customers. Upgrading and configuring the Oracle

environment.

Responsibilities:

Provided 24 X 7 Production database operation support and monitoring. Worked closely with the

•

Application team.

Monitored Database availability and performance.

•

Setup RMAN Repository, performed physical backup using RMAN. Also designed Backup and

•

recovery strategies. FRA and Flashback Technology were implemented.

Performed Logical backups using full export and DATAPUMP utility.

•

Evaluated new RDBMS features and enhancements in Oracle 11g like Data recovery advisor,

•

tablespace encryption, invisible indexes, flashback transaction, case sensitive password,

transportable tablespace, eternal tables and partitioning for possible integration into infrastructure

and applications.

Tuned the database using SQL query optimization, Autotrace, Vmstat, Explain Plan, AWR, ASH,

•

ADDM and SQL Tuning Advisor to gathering statistics.

Performed Physical and Logical Design of the database which includes Database creation, tables

•

spaces creation, table and index partitioning and also mapping of different objects with disks

Provided root cause analysis to identify database issues such as contention and abnormal application

•

locks.

Cloned databases as needed for testing purposes.

•

Data Center Migration options used are Cross Platform migration, Transportable Tablespace,

•

Export/Import with Data Pump and Application specific methodology to capture changes and

replay.

Applying quarterly Patches for Database & Upgrading Database Versions from 10g to 11g

•

Configured Data guard and have good experience in Trouble shooting issues in Data guard

•

Environment. Graceful switch over from production to standby databases.

Maintained and provided Database Security through DDL/DML by authenticating, auditing user

•

actions in the database, altering passwords of users and granting and revoking system/object

privileges and roles in database.

Performed Data loading operations using SQL Loader (from flat files into tables in the database).

•

Environment: SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* LOADER, Windows NT/2000, DBCA,

Data Guard, HTML, UNIX, Linux 4.0, Oracle 11g/10g, Enterprise Manager Console (OEM), SQL

Developer, Putty, RMAN, SQL*Plus, PL/SQL.

EDUCATION; BSc. Banking and Finance

Oracle Certified Associate 11g

Technical skills:

Operating System: Windows 2003, Solaris, Red Hat Linux 5.0, 5.4

RDBMS: Oracle 8i, 9iR2, 10gR1 & R2, 11gR1 & R2

Tuning Tool: TKPROF, EXPLAIN PLAN, AWR,ASH, STATS PACK and ADDM

Backup Tool: Cold, Hot backup, RMAN, Import/Export

Tools: SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader

Script: Having knowledge of UNIX\Linux shell script,,

Language: Having Knowledge of SQL, PL/SQL.

Virtual Machine: VM Ware server 2.0 to 2.2, Oracle VM Virtual box 4.0

Environment: Oracle 10g/11g R2 server, SQL server.

Contact this candidate