Oracle DBA

Eric Mensah

*** ******* *****, *********, ** ****1

Cell: 443-***-****, E-mail: *******@*****.***

OBJECTIVE

Sharp, quick learner, results-oriented Oracle DBA/Web Developer/Large Systems and Enterprise Application programmer with over 8 years of IT development and project management experience seeking a fast growing organization to start a new career for my skills, knowledge, and experience to be utilized through hard work, sincerity and dedication.

EXPERIENCE SUMMARY

Over six years experience with Oracle and five years five years as Oracle DBA

Hands-on mainframe experience

Thorough understanding of Dataguard

Experienced with Database Security Management

Thorough understanding of Physical and Logical standby databases

Experience with RAC installation on UNIX/Linux environment

Experience with System Development Life-Cycle (SDLC)

Experience with project management

Experience with OLTP

Experience with website design/development and maintenance

Experience with TCP/IP networking

Experience with Web Servers and DNS configuration

Experience with User Interface design

Experience of Oracle 9i, 10g and Oracle 11g

Executing all Oracle database tasks for Client Database Service Level guarantees

Experience with Monitoring, troubleshooting & resolution of failed tasks

Experience with Installation, maintenance, troubleshooting, patching, administration, performance tuning, upgrading and database creation

Perform database backup and recovery tasks using RMAN (strong Oracle RMAN backup & recovery skills)

Develop and document database and strategies, tools, performance tuning methods, and backup and recovery methods for staff.

Responsible for installing Oracle software & creating Databases, schemas, database storage – tablespaces and datafiles.

Refreshing development & test schema/tables using Export/import, Datapump

Advance level knowledge of creating and maintaining Tables, Partitioning, indexes,

Participate in a DBA team-environment supporting mission-critical databases on both UNIX and Windows operating systems.

Create, maintain and modify tables, indexes, and other objects. Design, develop,

Performance Tuning of Oracle Database & SQL, PL/SQL Queries. Conversant with AWR, ADDM

User Account Management, creating database users, quota, roles, privileges etc

Writing shell, batch scripts, SQL scripts

Experience with VMware installations, creating Virtual Machines, and Guest OS on both Windows and Linux Hosts.

EDUCATION

B.S - Information Science and Systems May 15, 2010

Morgan State University, Baltimore - Maryland

AA - Web Design Specialist May 21, 2004

Montgomery College, Rockville - Maryland

TECHNICAL SKILLS

OS:

IBM System z/OS, Windows 2003/2008R2 Server, Windows 7, Vista, XP, 2000, 98, MAC

UNIX/LINUX: SUN (Solaris and x86, Sparc), AIX, HPUX, Red Hat, CentOs, etc.

Software:

Oracle 11g, 10g, 9i, PeopleSoft, MS Visio 2010, MS Office 2007 Suite, SSH, Active Directory, Remedy Ticketing System, Adobe CS4 Suite, SharePoint, Microsoft Project, Drupal, Joomla, Moodle, Visual Studio 2008, FTP

SQL Plus and PL/SQL, 3270 Terminal Emulator

Programming Skills:

COBOL, JCL, C/C++, Java, HTML/XHTML, XML, CSS, ColdFusion, ASP.NET, JavaScript, PHP, KSH, Perl, Shell, .NET

WORK EXPERIENCE

ISHGO-ONE CORP. August 2007 – May 2011: Oracle DBA

Install and configure Oracle 9i and Oracle 10g on Windows and UNIX

Installed Oracle 9i, 10g and 11g on Sun Solaris 10, Linux and Windows, applied patches; upgrade Oracle server and application tools, maintained the software at the latest stable release level and tested and verified the installed components.

Performed RAC installation and configuration on UNIX/Linux environment

Apply Oracle Critical Patch Update (CPU) patches on our databases every quarter.

Data Modeling with MS Visio

Setup RMAN to backup production databases.

Use RMAN to perform database recoveries and migration when necessary.

Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4-11.1.0.6.

Write scripts/procedures/triggers in PL/SQL to determine all relationships/constraints in the database

Managed and executed inserts and updates

Write and test RMAN backup and recovery scripts

Helped to developed scripts to monitor database and system performance

Helped to streamline the database and increased the overall efficiency and performance level

Assisted in creating documentation for designing and implementing scripts for extracts and reports

Under supervision tune SQL queries using table indexing and table partitioning and correct database fragmentation

Ensuring users can use basic SQL * Plus and PL/SQL

Using DBCA to create database

Performing database exports and imports data between servers and from Windows to UNIX or LINUX and vice versa.

Creating and multiplexing Redo Logs

Switching database into archive log mode for Point in Time recovery

Creating and managing users and granting them privileges etc.

Design and implement a backup and recovery using operating system (OS) copy command or recovery manager (RMAN)

Performance Tuning – Install, configure and use of STATSPACK, AWR and ADDM to diagnose performance problems.

BALTIMORE SUN, Baltimore MD, 3/2005 – 11/2007

Database Administrator

Responsible for controlling and maintaining the company’s information system databases. Responsible for performing daily, weekly, and monthly checks of all databases, for database security and access management (creating and assigning roles to users), monitor application performance and tuning.

Modeled Data using MS Visio

Performed backups on a regular basis for safekeeping and recovery purposes using Oracle Backup utilities including, the Import and Export utilities and the recovery manager (RMAN).

Provided first level support for help desk work tickets and manage all calls logged regarding the databases, performed periodic database maintenance, such as de-fragmentation by means of reorganizing the database.

Worked with application developers and users as a first line to solve problems and provide solutions to programming questions and offer possible solutions and consulting services. Other responsibilities included the following;

Oracle Installation and upgrading Software and Database

Creating Database.

Managing REDOLOGS.

Created Oracle instances with appropriate initialization parameters.

Modified Tablespaces and object storage.

Exported data from old systems and import into new databases.

Setup backups and performance monitoring scripts using cron jobs.

Created Users, assigned Privileges and Roles

Altered, Modified and Created Tables, Views and Sequences

Documented migration process, database creation, monitors, and load scripts.

Administered BACKUP and RECOVERY

Developed shell scripts for automating system level and database level backups.

Created and maintained UNIX scripts for startup, export, shutdown, instance creation

INTERN: Serial and Government Publications-Library of Congress, Washington DC. Feb. 2004 - May 2004.

Volunteered to intern for the 18th Century Newspaper of the Library of Congress

Updated and maintained website

Read index cards of the newspaper periodicals and holdings for each state of the U.S.A, as well as other countries worldwide

Proofread and edited over 800 pages

ACTIVITIES & AWARDS:

Certificate: IBM - Master the Mainframe Contest 2010

3RD Place: Graphic Communications - Association of Information Technology Professionals (AITP) National Collegiate Conference, 2010

Winner: Office of Residence Life – M.S.U, Richard E. Robinson Talent Show, 2005

Certificate: Serial and Government Publications Division - Library of Congress.

Certificate: 2002 Diversity Leadership Workshop-City of Rockville.

Member: Association of Information Technology Professionals

REFERENCE: References will be provided upon request.

Contact this candidate