Post Job Free

Resume

Sign in

Manager Oracle

Location:
Alpharetta, GA, 30005
Posted:
June 23, 2010

Contact this candidate

Resume:

[pic]

REMY LAWAL

**** ******* **. ********** **. 30005 Cell Phone 770-***-****

Objective

I am looking for a challenging and rewarding assignment as a senior

ORACLE database administrator

Professional Summary

Oracle Certified Professional (OCP) with more than 10 years of Oracle

database administration experience through version 11g; Oracle 10g

/11g RAC and high volume transaction experience at Intralot and IBM;

UNIX experience including Solaris, AIX, HP-UX and Linux. and

Production support of (VLDB) Very Large Database Environment.

Professional Experience

Intralot, Inc. (November 2009 to January 2010)

Senior Oracle DBA

Responsible for Oracle architecture, design, implementation and

administration.

. Oracle DBA - installed Oracle software and created, upgraded,

refreshed migrated, maintained and implemented Oracle databases.

. Maintained Oracle High Availability RAC (10g and 11g), ASM,

DataGuard and Standby databases.

. Created, monitored and managed databases and table spaces,

oracle partitioning.

. Responsible for database performance tuning and Distributed

Transaction: Oracle Streams and Advanced Replication as well as

physical database design.

. Performed daily DBA administration tasks including backup and

recovery using RMAN, managing disks and files systems/raw

device, applying patches and providing technical support for

developers.

. Worked with OEM and Oracle Grid Control.

. Monitored database resources, created database schemas, and

created and maintained login ID's.

. Performed Oracle version upgrades and patch installs. Initiated

and monitored exports, imports and data pumps. Utilized UNIX

commands and scripting techniques.

. Troubleshot and researched errors. Provided 24x7 on call

rotation.

Technical Environment: UNIX, AIX 5.3.x, Solaris, HP-UX 11.0 and 11i,

Windows NT, Windows 2000, Windows 2003, Oracle 7.3.4.x, 8.0.5.x,

8.0.6.x, 8.1.6.x, 8.1.7.x, 9.0.x, 10g, 11g, OAS 4.0.8.x, Oracle

Applications Release 11i, SQL*Plus, SQL*Net, Net8, SQL*Loader, PL/SQL,

import/export, stored procedures, triggers, Unix shell scripting,

Apache, BMC SQL-Backtrack, Oracle Enterprise Manager, Quest Software

Toad, Microsoft desktop applications - Word, Excel, Access, Project.

IBM GLOBAL SERVICES (November 2000 to April 2009)

IBM Accounts:

Delta Technology

Senior Oracle DBA

Responsible for Oracle architecture, design, implementation and

administration:

. Performed daily Oracle DBA tasks in an environment with Oracle

High Availability RAC (10g and 11g ), ASM, RMAN, OEM, Oracle

Grid Control, Data Guard and Standby databases.

. Created, monitored and managed databases, table spaces and

oracle partitioning.

. Performed database performance tuning and physical and logical

database design.

. Responsible for backup & restores, allotting system resources to

users.

. Responsible for database performance tuning and Distributed

Transaction: Oracle Streams and Advanced Replication as well as

physical database design

. Managed system security and data integrity as well as disks and

files systems.

. Applied patches and provided 24x7 technical support for

Application DBA/Developers.

. Monitored and tuned database resources and activity.

. Created and maintained database schemas and login Ids.

. Performed Oracle version upgrades and patch installs.

. Initiated and monitored exports, imports and data pumps.

. Utilized UNIX commands and scripting techniques.

Technical Environment: UNIX, AIX 4.3.x, Solaris, HP-UX 11.0 and 11i,

Windows NT, Windows 2000, Windows 2003, Oracle 7.3.4.x, 8.0.5.x, 8.0.6.x,

8.1.6.x, 8.1.7.x, 9.0.x, 10g, 11g, OAS 4.0.8.x, Oracle

Applications Release 11i, SQL*Plus, SQL*Net, Net8, SQL*Loader, PL/SQL,

import/export, stored procedures, triggers, Unix shell scripting,

Apache, BMC SQL-Backtrack, Oracle Enterprise Manager, Quest Software

Net Recorder monitor tool, SQL-Navigator, Microsoft desktop

applications, Word, Excel, Access, Project, Tivoli Storage Manager and

Legato Net Worker

Case New Holland

Senior Oracle DBA

Responsible for Oracle architecture, design, implementation and

administration:

. Performed daily Oracle DBA tasks in an environment with Oracle

High Availability RAC (10g), ASM, RMAN, OEM, Oracle Grid

Control, Data Guard and Standby databases.

. Created, monitored and managed databases table spaces and oracle

partitioning.

. Performed database performance tuning and physical and logical

database design.

. Responsible for backup & restores, allotting system resources to

users.

. Managed system security and data integrity as well as disks and

files systems.

. Responsible for database performance tuning and Distributed

Transaction: Oracle Streams and Advanced Replication as well as

physical database design

. Applied patches and provided 24x7 technical support for

Application DBA/Developers.

. Monitored and tuned database resources and activity.

. Created and maintained database schemas and login Ids.

. Performed Oracle version upgrades and patch installs.

. Initiated and monitored exports, imports and data pumps.

. Utilized UNIX commands and scripting techniques.

SQL Server DBA

. Planned for a SQL Server installation, and then installed an

instance of SQL Server.

. Managed files and databases, including determining resource

requirements.

. Chose a login security method, configured a login security,

planned and implemented database permissions, and described how

to secure SQL Server in an enterprise network.

. Performed and automated administrative tasks and created custom

administrative tools.

. Backed up databases, implemented a backup strategy, and restored

and refreshed databases.

. Monitored and optimized SQL Server performance.

. Transferred and migrated data into databases. Maintained the

high availability of SQL Server.

Technical Environment: UNIX, AIX 4.3.x, Solaris, HP-UX 11.0 and

11i, Windows NT/2000/2003, Oracle 7.3.4.x, 8.0.5.x, 8.0.6.x,

8.1.6.x, 8.1.7.x, 9.0.x, 10g, OAS 4.0.8.x, SQL*Plus, SQL*Net, Net8,

SQL*Loader, PL/SQL, import/export, stored procedures, triggers,

Unix shell scripting, Apache, BMC SQL-Backtrack, Oracle Enterprise

Manager, Quest Software Net Recorder monitor tool, SQL-Navigator,

Microsoft desktop applications, Word, Excel, Access, Project,

Tivoli Storage Manager and EMC storage

Aventis Pharmaceutical

Oracle/SQL Server DBA

. Responsible for Oracle and SQL Server database administration

tasks including installation, performance tuning, backup &

recovery, creating and monitoring database schemas, and

security.

. Managed files and databases, including determining resource

requirements.

. Performed physical and logical database design.

. Performed Oracle version upgrades and patch installs.

Troubleshot performance and Oracle networking issues.

. Utilized UNIX commands and scripting techniques.

Technical Environment: UNIX, AIX 4.3.x, Solaris, HP-UX 11.0 and 11i,

Windows NT/2000/2003, Oracle 7.3.4.x, 8.0.5.x, 8.0.6.x, 8.1.6.x,

8.1.7.x, 9.0.x, 10g, OAS 4.0.8.x, Oracle Applications Release 11i,

SQL*Plus, SQL*Net, Net8, SQL*Loader, PL/SQL, import/export, stored

procedures, triggers, Unix shell scripting, Apache, BMC SQL-Backtrack,

Oracle Enterprise Manager, Quest Software Net Recorder monitor tool,

SQL-Navigator, Word, Excel, Access, Project, Tivoli Storage Manager

and Legato Net Worker

Merial Inc.

Oracle/SQL Server DBA

Oracle/SQL Server and Oracle Applications DBA

. Performed Oracle and SQL Server database administration tasks.

. Responsible for Oracle architecture and administration, LAN/WAN

design and implementation, client/server three- tier

Architecture.

. Interacted with the user community, developers, and technical

departments to promote information sharing, coordinate

enterprise information architecture, develop physical data

models, assist in the coordination of development methodologies

and tools, and provide data management operations to ensure the

security, quality, performance, and accessibility of corporate

informational resources.

. Also performed Oracle Applications DBA tasks. Administered

development, integration, training, patching and production

databases.

. Administered Oracle servers on UNIX and Windows platforms.

. Researched, reviewed, applied and tested modifications to all

databases.

. Managed storage requirements for databases-related components -

capacity planning.

. Administered and maintained procedures for ensuring the security

and integrity of all databases.

. Conducted systematic performance tuning including database

server tuning and database related component tuning.

Proactively automated routine DBA tasks.

. Maintained detailed documentation of database standards and

procedures.

Development Team Support

. Rebuilt and refreshed development, integration, training,

patching databases for developers and end-users upon scheduled

requests.

. Reviewed, recommend, test, and implement physical data model

changes.

. Provided technical assistance to software development and

support staff for both customized and packaged applications.

. Analyzed performance issues and recommended solutions.

. Initiated and monitored exports and imports. Performed database

recoveries.

Technical Environment: Oracle 7.x/8.x/8i/9i Database/RDBMS Oracle

7.x/8.x/8i/9i, Oracle Enterprise Manager/DBA Studio, BMC SQL-

Backtrack, Oracle Enterprise Manager, Quest Software TOAD, ERwin, UNIX

- Compaq tru64 and HP, Windows NT/Windows 2000

Square D Schneider Electric

IBM Oracle DBA

. Responsible for Oracle architecture and administration,

installs, upgrades, migrations and implementations.

. Performed daily administration tasks including backup and

recovery, rollback segments and redo logs, and managing system

security and data integrity, and disks and files systems.

. Applied patches, and provided technical support for application

developers.

Technical Environment: Oracle 7.x/8.x/8i Database/RDBMS Oracle

7.x/8.x/8i, Oracle Enterprise Manager/DBA Studio, UNIX, Sun Solaris,

IBM AIX, Microsoft Windows NT

IBM Retek Consulting Practice (November 2000 to August 2001)

Oracle Developer

. Involved in the development of Inventory Modules for RMS 10.0

Using Developer 2000 tools - Forms 6i, SQL*plus and PL/SQL on

Windows NT and UNIX platforms.

. Developed complex applications using the full functionality of

SQL.

. Designed and developed GUI interfaces to meet user requirements.

. Developed complex packages, stored procedures and triggers.

. Developed various forms, reports and graphic reports.

. Wrote triggers to enforce business rules and application

security.

. Unit and integration testing.

Signet, Inc., Atlanta GA (April 1999 to November 2000)

Oracle Software Developer

. Customized an order entry system and online billing system using

Developer 2000 tools on Windows NT and UNIX platforms.

Implemented the Oracle ERP Financials Applications solution (AP,

GL).

. Analyzed requirements, wrote the requirement analysis document,

mapped requirements, designed test scenarios, wrote test scripts

and performed integration testing. Used SQL*Loader to upload

data. Developed and maintained existing Oracle Reports, and

created customized Reports.

GSS, Inc., Atlanta, GA (November 1998 to April 1999)

Oracle Software Developer

. Developed an activity status tracking system using Developer

2000 tools - Forms 5.0, Report 3.0, Graphics 3.0 and SQL.

PL/SQL. Analyzed requirements, modeled data and created tables.

Designed and developed GUI interfaces to meet user

requirements. Developed complex packages, stored procedures and

triggers. Developed various forms, reports and graphic reports.

Technical Summary

RDBMS: Oracle 7.3.4.x/8.0.5.x/8.0.6.x/8.1.6.x/8.1.7.x/9.0.x/10g/11g;

MS SQL Server 6.5/7.0/8.0/9.0

Development Tools: SQL WorkBench, SQL-Navigator, BMC SQL-Backtrack,

Oracle Enterprise Manager, Quest Software toad, Query Analyzer, SQL

Profiler and T-SQL

Operating Systems: Linux, AIX 5..3.x, Solaris, HP-UX 11.0 and 11i,

Windows NT/2000/2003

Hardware: HP 9000, PCs, Compatibles

Computer Languages: SQL, SQL*Plus, PL/SQL Shell scripting

Applications: Microsoft Office, Oracle Applications Release 11i

Database Technologies: ORACLE (v5 to 10), Sybase, and SQL Server

Data Modeling Tools: Visio, ERwin, ER Studio and Power Designer

Oracle Tools: Oracle Enterprise Manager, Performance and Diagnostic

pack,

Oracle Client Tools: (Forms, Reports), DB Artisan, SQL*Navigator

Oracle/Utilities: Oracle RDBMS versions 5 to 10gi, SQL*Net, SQL*Plus,

Export /Import, Loader, RMAN and (TOAD) Tool for Oracle Applications

Developer

Oracle/Adv. Technologies: Replication, Multi-Threaded Server (MTS),

Query Optimization,

Distributed Databases: (SQL*Net), Data Warehouse

Oracle Database: Support ERP Applications (Baan, PeopleSoft, J.D.

Edwards One World, Siebel, SAP, Oracle 10.0.7/11.0.3,11i etc.), Blue

Martini, Cold Fusion, Application Servers (iPlanet, WebLogic), TIBCO

Messaging Service

Sybase Tools: SQL Advantage, Sybase Central, Power Designer,

Enterprise Manager, SQL Query, DTS

UNIX Tools: SAR, VMSTAT, and PRSTAT

Programming Languages: UNIX Shell, SQL, PL/SQL

Education and Certifications

B.S. University of Lagos, Nigeria

Associate degree Atlanta Area Technical School (Georgia)

OCP Oracle Certified Professional (Oracle 8/8i/9i/10g)



Contact this candidate