Oracle Manager

Moses G Koda

Marietta, GA *****

*******@*****.***

Mobile: 404-***-****

OBJECTIVES: Seeking for a position as Oracle Database Administrator on Unix

or Windows platform

SUMMARY - PROFESSIONAL EXPERIENCE:

. Over 5 years of IT experience and over 3 years of Oracle DBA experience

in Oracle 11g/10g and 9i

. Expert on diagnosis and obtaining recommendation on Database Resource

Utilization and Performance using ADDM.

. Good at troubleshooting Applications to database connectivity, loading

and using Java Database Connectivity (JDBC) drivers.

. Worked on 10g New Features: Data Pump, Automatic performance and

diagnostics, 10g RMAN Features.

. Upgrading the DB from 10 to 11g.

. Planning and scheduling Backups using RMAN, Hot Backups and Logical

Backups. Has got good experience in Disaster Recovery.

. Planning Backup/Restoration Strategy for 24x7 Production Support.

. Has working experience as 24x7 Production DBA on Sun Solaris(Unix) and

Linux.

. Has working experience on Large databases and management of Multiple

Databases.

. Installation and Configuration of Oracle databases 11g, 10g, 9i on Sun

Solaris, Created and managed Oracle database.

. Good understanding of Oracle Database architecture and has worked on all

versions 11g, 10g and 9i.

. Managing Database Structures, Storage Allocation, Table/Index segments,

Rollback segments, Constraints, Database Access, Roles and Privileges and

Database Auditing.

. Experience in Database design including creations, modification, and

deletions of table spaces, data-files, and schema's. Create Schema

(Tables, Indexes, views, sequences, synonyms, roles, and users).

. Experience in analytical and Troubleshooting skills and Problem solving,

. Proficient in Unix Administration part pertaining to DBA i.e. User

maintenance, Performance Monitoring of CPU, Disk and Memory usage, and

File system monitoring.

. Experience in Unix Shell Scripting for automating the DBA tasks.

. An impressive communication and creative problem solving skills.

. Flexible to adopt new environment and willing to learn new technology.

TECHNICAL SKILLS:

Operating Systems: Dos, Windows 98, 2000, Windows NT, UNIX Sun Solaris

Databases: Oracle 9i, Oracle Database10g R2, Oracle 11g

Utilities: Oracle Enterprise Manager (OEM), Recovery Manager (RMAN),

Statspack,

Data Pump, Export/Import, SQL Trace, Explain Plan,

Training: Developer 2000 (SQL, SQL *PLUS, PL/SQL), Java, EE, JDBC

EDUCATION:

Bachelor of Science (B.Sc) - Computer Science

Oracle 9i /Oracle Database 10g, Oracle 11g & Developer 2000 (SQL, SQL *

PLUS, PL/SQL), Java Programming, Java database connectivity ( JDBC)

UNIX - Sun Solaris, Red Hat Linux

PROFESSONIONAL WORK EXPERIENCE:

September 2008 to May 2010

Georgia Department of labor

Junior Oracle Database Administrator

Environment: Oracle 9i, 10g and 11g on Red Hat Linux, Windows NT.

Responsibilities:

. Responsible for all aspects of Oracle DBA support including install,

configure and maintain highly available Oracle 10g

. Worked from project inception to completion on strategic, high-tech

modern initiative.

. Responsible for maintaining, supporting and troubleshooting Oracle 10g

instances running on UNIX

. Created 10g, 11g DBs on Linux using DBCA and also manually. Worked

on Large Database of size 1.3 Terabyte.

. Upgraded the DB from 10g to 11g, Managing, Monitoring RMAN Backup for

PROD DBs and HOT backups for DEV DBs. Cloning of the Database from one

box to another.

. Managed Oracle Data Extraction, Transformation and Loading (ETL) using

SQL Loader and Datapump import and Export utilities.

. Monitored Indexes and Identified the Unused Indexes, rebuilt damaged

indexes for performance improvement

. Setting up and Managing Flash Recovery Area. Worked on 11g Flashback

Technologies: Flashback version query, Flashback Transaction Query,

Flashback Table. Configured and Enabled Flashback Database.

. Day to Day General Administration (Tickets by PVCS Tracker):-

Tablespace Management, Undo Management, Managing Users, Resources,

Managing User Privileges and Roles.

. Implemented Auditing the Database. Tuned the Slow SQL queries.

. Monitored DB Performance using STATPACK, TKPROF, SQLTrace, Explain

Plan. Monitored Common Wait Events for DB.

October 2007 - September 2008

Movius Interactive Corporation

Test Engineer

Environment: UNIX- RED HAT, WINDOWS

Responsibilities:

. Effectively provided operational, testing and System Support for

Voicemail Systems

. Acted as initial point of contact for Voicemail applications issues as

assigned by Supervisor

. Specified and maintained the required deployment and testing

environment for Movius Voicemail Infrastructure

. Performed unit testing, component integration testing, systems and

acceptance testing, and regression testing

. Identified and corrected problems while following business rules and

keeping proper documentation

. Implementing changes and management support to ensure adherence to

business, user and functional requirements

. Installed and configured Voice mail systems and new patch releases for

testing and Quality Assurance

. Designed and developed test procedures which enumerated the conditions

and use cases to be tested

. Executed Test cases, evaluated test results, worked on correcting

problems and eliminating defects

. Prepared input to written documentation for technical methods,

procedures, functions or processes to support the installation,

operation, training, and maintenance of information technology systems

and applications

. Gathered and documented system requirements necessary for software

installation and functioning

. Participated in multiple projects, software release testing and

documentation

. Attended and contributed in mandatory weekly departmental meetings

July 06 to August 2007

Systems Software Development Inc, Atlanta, Ga

Oracle Database Administrator

Environment: Oracle 10, Sun Solaris, Windows

. DBA activities including creation, management, startup and shutdown of

Oracle databases, management of data files, redo log files, control

files, tablespaces, segments, extents and data blocks & physical

storage, creation, monitoring and management of database users,

granting/revoking of system/object privileges, management of roles &

resources and setting of init.ora parameters

. Assisting developers in SQL queries development and testing using

Explain Plan, SQL Trace, TKPROF

. Responsible for Capacity Planning using OEM and Statspack

. Oracle upgrade from 9i to 10g using DBUA, installing 10g, Writing

shell scripts for Alerts, Backup and monitoring

. Running shell scripts to create database from a template and manually

creating database

. Writing export scripts to move data from development to test to

production environments

. Providing Remote Support for the Production Databases

. Creating databases using Optimal Flexible Architecture (OFA)

. Responsible for migration of data and implementing structural changes

from development servers to production servers using Export, Import,

Copy command and database links.

Contact this candidate