Oracle Quality Assurance

JEPHTE NOUTSA

ORACLE DATABASE ADMINISTRATOR

Phone: 301-***-****

E-Mail: *******@*****.***

EXECUTIVE SUMMARY

I am an Oracle DBA 5years of experience spanning the entire life cycle of application

development on medium to very large software projects.

As an Oracle Certified Professional, I enjoy demanding projects and I always strive to implement

the best in class technical solutions. With experience across a variety of industries, I am seeking

a new challenge to call upon my technical background. I constantly work to keep abreast of

Oracle technology, and currently I am working toward my 11g OCP.

Career Highlights

Involved in each phase of life cycle (SDLC) including requirement gathering, technical

design, development, system integration phase, quality Assurance phase, production and

production support activities.

Full responsibility and expertise in database administration (DBA), performance tuning,

database backup, database recovery, database security, database optimization, data migration,

data replication, as well as configuring and supporting high-availability and 24x7 Oracle

instances and SQL-server databases.

Successfully developed and implemented client/Server applications on multiple platforms.

Actively involved in software development, implementation, software maintenance, software

support, troubleshooting, documentation, training, etc…

Experience of reverse engineering, re-engineering of business models, migrating and porting

of applications and databases across different hardware/OS/database platforms.

Good communication and cooperation skills with an aptitude to learn quickly, take

responsibility, work under pressure.

Authoritative in design, development, documentation and review according to standards.

Excellent team player and works independently. Actively participates in team meetings and

maintains good relations with everyone on the team and other teams.

Experience gained across the major Oracle versions ( 9i, 10g & 11g) and a wide range of

operating systems (SOLARIS, LINUX, AIX, HP-UX)

Oracle Database Administration Experience

Backup and recovery (using OS scripts, RMAN and Log Miner)

High availability (Oracle Dataguard, Oracle FailSafe & AIX HACMP)

RAC with ASM (on Veritas CFS)

Database level performance tuning (using OEM, statspack, tkprof and trace analyzer)

Oracle Server installation and patching

Database creation, patching and migration

SQL*Net configuration (over TCP/IP)

Replication (snapshots/materialized views)

Bulk loads and data migrations (using SQL*Loader, data pump import/export)

Unix shell scripting (Korn shell) and Windows command prompt (.bat & .cmd)

Oracle Database Development Experience

Physical database object design and implementation

Scalability design for high concurrency (using autotrace and Run Stats)

Batch load design

Education/Certification

B.A. in Accounting and Financial management, University of Yaoundé – Cameroon, 2000

Advanced Training in PC Support & Network Design with Security, Trinitech Consulting, 2004

Charter, VOIP Certification, 2007

Oracle Database 9i, 10g and 11g training, Trinitech Consulting, 2009

Oracle 11g Certified Associate, 2011

Oracle 11g Certified Professional, in progress

Employment History

MillenyumInc, Sr. Oracle Database Administrator, December 2009-present

• DBA supporting three major projects from Development to Production via Tech-Test

environments, involving daily configuration, administration all running on IBM AIX 5.2 & 5.3.

Database sizes range from 4GB to 2TB (in ODS & EDW environments).

• Backup Oracle DBA for two major projects involving periodic administration,

troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both

IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.

• Create oracle databases on configured servers using both the DBCA & Database creation

scripts.

• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus,

OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party

tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).

• Monitor database systems and provide technical support for database system issues and

application performance enhancement/improvement using both OEM (client), Oracle 10g

database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

• Data migration between databases using both Oracle 10g and 11g export/import utility and

Oracle 11g exp/imp data pump.

• Analyzing schema of databases created to collect statistics using the DBMS STATS

package.

• Use AWR/ADDM for 10g Statistics management & database tuning following creation of

new databases and periodically thereafter.

• Troubleshoot installation errors both independently and with Oracle support (via My oracle

Support)

• Application of Oracle software patches when/where necessary.

• Backup/Recovery monitoring and reporting using both command line& Oracle RMAN

• Technical documentation of all configurations, installations, implementations, monitoring

and testing projects for future utilization.

• IBM TSM (Tivoli Storage Manager) install/upgrade from version 3.1.00

to version 4.0.10.

• Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers

through the SDLC from Development to Production, via Tech-Test in Needs Assessment,

Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database

Designing (Physical & Logical) and Implementation, database user creation and database access

both at role & table levels, as well as final Project Performance Assessment/Evaluation.

• Create database Objects, Tablespaces, Schemas as needed.

• Schema migrations from Development to Production via Tech Test environments.

• Database refresh from Production to Tech Test as needed.

Maintain and administer change management policies and updating the ticketing system using

Remedy

Go-Direct Telecom, Oracle DBA, April 2007 –May 2009

• Configure. Implement & Deploy Oracle 9i (9.2.0.8) & Oracle 10g (10.2.0.4), single

instances on SunOS 5.9 using files systems for storage & VERITAS Clustering for high

availability using IBM’s HACMP

• Create oracle databases ( single instance ) on configured servers using both the DBCA &

Database creation scripts.

• Monitor database systems and provide technical support for database system issues and

application performance enhancement/improvement using both Oracle 10g Grid Control &

SQL*Plus, as well as UNIX shell scripts.

• Worked closely with Application Developers to design/create new Oracle databases/create

new schemas/database objects, as well as making database changes from DEV to PROD, via

TST following requests/demands from the development team.

• Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.

First Choice Health Network, Software Engineer, Mars 2006-January2007

• Involved in Technical design/development/Changes for Processing Data to/from Medical

Boards, between Departments, Maintenance of Certification, Portfolio Management.Involved

deeply in an in-house project which is helpful for the Care-Takers at the point of care which

provides answers for the most frequently asked questions, key facts and the Expert directory

service.

• Trinitech Consulting, Network admin, July 2003-Mars 2006

Build, upgrade, secure and support LAN, WAN, and WLAN networks for numerous business

clients, installing Windows 2003 Small Business Server domain controllers, setting up active

directory, DHCP, DNS, WINS and various group policies.

• Install, manage and support exchange server 2003 for various business clients for OWA.

• Perform Smartphone and Exchange Server email integration for various corporate

Clients.

• Perform hardware, drivers and firmware upgrades for mostly Dell and HP family/blade

servers

• Implement software security solutions using application packages like, Symantec, and

McAfee.

• Perform daily on site and remote network support for various business clients.

• Installed and networked Windows Operating Systems ( XP/2000/Vista) on Desktop

peripherals

• Provided fist tech support for both English and French clients

• Performed configurations, upgrades, maintenance, and troubleshooting for PC's, printers

and telephones

• Wrote custom technical documentation

• Monitored, Examined and Installed latest Microsoft updates/patches

• Installed Hardware and Software on both new as well as used Desktop and Laptop

Computers.

• Cleaned, backed up and restored data on secondary storage devices

Performed Virus and Spyware protection and removal

Contact this candidate