[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)