Summary

• Fourteen years of experience in the Oracle DBA/Architect/ Oracle Financial Application DBA/ Test/Development field.
• Extensive experience Oracle database/SAP design, implementation and Administration.
• Successful deployment and Administration of mission-critical Oracle databases across Africa, Europe and North America, to the benefit of clients in the telecommunications and Financial services sectors.
• Capacity Planning, Performance tuning, backups Hot, Cool, Incremental, full backup , security issues, users account maintenance. Production, Test and Development DBA work logical and physical schema design, data mapping, data modeling, and database design using manual and automated tools, writing store procedure.
• Upgrade 11.5.10 all system requirements, including analysis, installing, troubleshooting
• Upgrade 11.5.10 migration to production environments JDK/Java/HTTP/Web analysis, installation, management, tuning, troubleshooting, upgrades
• Monitor Multiple JVM's
• Forms/Reports Servers, Concurrent Managers, Administration Server, Patch Management, OAM, Mobile/Web to Go, Oracle Lite analysis, installation, management, tuning, troubleshooting
• Oracle Apps Workflow administration Rapid Cloning DATABASE/APPS Oracle Apps Cloning Oracle Apps Auto config Oracle Apps multi node/multi-tier management Oracle Apps load balancing Running troubleshooting utilities
• Oracle Apps log/out files management from Concurrent Managers, Java, http and other tmp files generated by the system
• Well versed in the design and support of terabyte, data warehouses and thousand user-plus operational systems, Real Application Cluster. Exceptional performance tuning skills and in-depth knowledge of Oracle internals and Unix system internal Hp Unix, AIX, Sun Solaris, Linux
• Patches, code promotion using PVCS, Kintana and cloning
• DBA for Inter-later and Wireless, Local line, CLEC License by the ICC to operate telecommunication, telephone company
• Database creation, analysis, performance troubleshooting, tuning, patches, Database upgrades, Database export/imports, Database tablespaces, tables, indexes and other db objects reorganizations and management.
• Database security and auditing Database backups/recovery Database Disaster/Recovery planning and execution Disk allocations and capacity planning.

Environment

Databases: Oracle 6.0 through to 8i, 9i, 10g including Oracle Parallel Server, partitioning, replication and standby databases. Informix, Sybase, Test Development and Production Database

Hardware: AT T 3bs Simplex and Duplex, Motorola Delta UNIX, HP 9000/HP-UX, Digital Alpha/DEC UNIX, IBM RS6000/AIX, SUN, Intel/LINUX, Intel/Windows NT, Mitell2000 ATT 7500 Switches, Suma four Switches, Sun-Solaris

Unix Tools: Shell scripts C, Bon K

DBA Tools: Netbackup, Tivoli, Platinum DBVision, Quest SQLab, and Quest Spotlight for Oracle, Precise, SQL, RMAN, Oracle Enterprise Manager, Concurrent Manager, and WebDB. Oracle Discoverer 3.1.36 Oracle9iAS, Portal 3.0.7, ssl TOAD, Oracle Express Administrator 6.3.2 Oracle Express Objects 2.2 Oracle Personal Express 5.03 - 6.3.2 Oracle Batch Manager 6.3.0.1 Oracle 9i 9.2.0.1 JDeveloper

Data Warehousing: PL/SQL, Pro C, Brio Query, Oracle Discoverer Oracle Developer 2000, Oracle Warehouse Builder ORACLE Financial

Manufacturer/Distribution: 12i,11i GL, AR, OE, HR, AP, PO, SO, MSC, INV, FA, BOM, ASCP, APPWORX, PVCS KINTANA, SSO Oracle Sales Analyzer 6.3.2.1 Oracle Financial Analyzer 6.3.2.1 Oracle Express Workflow. Analyzer 6.3.2.2, Oracle Workflow

Work History

Confidential

DATABASE SUPPORT

• Data collection
• Data loading and update
• Maintaining Oracle Database from release 11G
• SQL tuning and Database tuning, RMAN BACKUP, using of Oracle

Confidential

DATABASE SUPPORT

• Maintaining Oracle Database from release 9 to 10GR2/11G
• SQL tuning and Database tuning, RMAN BACKUP, using of Oracle

Confidential

DATABASE SUPPORT

• Maintaining Oracle Database from release 9 to 10GR2/11G
• SQL tuning and Database tuning, RMAN BACKUP, using of Oracle Developer, TOAD
• Act as liaison between Technical support and user groups
• Daily support for all developers on project
• Oracle E-Business Suite upgrade support and recommendation.
• Work with Oracle Financials and HR modules.
• Creating daily Metra procedure to archive historic Data
• Work with Oracle E-Business Suite. 11i or 12i AOL

.Confidential

TECHNICAL LEAD ON API IMPLEMENTATION AND TECH SUPPORT

Responsibilities:

• Act as liaison between Technical support, Engineering groups, user groups and senior Management on the sale and implementation of Oracle Database and it application.
• Lead Technical, user group training and knowledge transfer to tech support staff
• Support BOM, AP, AR, FA API APPS 12i

APPS AND DATABASE ADPATCH UPDATE

• Help to Migrating Data from Legacy system to ORACLE
• Core DBA daily support for multiple Databases
• data extraction from foxpro, sqlserver, exel, flat file to oracle staging and to production database
• Maintaining Oracle Database from release 8.0.5 to 10GR2/11G
• SQL tuning and Database tuning, using of Oracle Developer, TOAD
• Daily support for all developers on project
• Financial and HR patches.

Confidential

ORACLE APPLICATION/CORE DBA

Responsibilities:

• Support APPS 12i
• Help to resolve Cloning problem
• Core DBA daily support for multiple Databases
• Maintaining Database from release 8.0.5 to 11G
• SQL tuning and Database tuning
• Daily support for all developers on project
• Creating procedure to archive historic Data

Confidential

ORACLE APPLICATION DBA

Responsibilities:

• Core DBA daily support for multiple Databases 50-100 Instance
• Unix platform, setup Cron job, data extraction
• Maintaining Database from release 8.0.5 to 10G
• SQL tuning and Database tuning
• Creating procedure to archive historic Data
• Daily support for all developers on project.

Confidential

Lead Oracle Application DBA, ERP

Responsibilities:

• Act as liaison between Technical support, Engineering groups, user groups and senior Management on the sales and implementation of Oracle Database and it application.
• Lead Technical, user group training and knowledge transfer to support staff
• Support HR/Financial Application on HP/NT Platform
• Upgrade and refresh.
• Cloning, Rapid Clone, Patching, Tuning support day to day activities of the database and the application, Rman, Database and Application upgrade 9i to 10g, 11i Upgrading,
• OEM, Toad, Apache iAS 9i, single sign-On 'SSO', Managed Concurrent jobs, SSL update and implementation and upgrade of Oracle Financial and HRMS 11i, Payroll, Project accounting, human intelligent, Time and labor, federal human resources etc. Monthly HR state tax update, Financial and HR patches.
• Tables and indexes purging
• Oracle E-Business Suite installation/upgrade/operations.
• Work with Oracle Financials and HR modules.
• Work with Oracle E-Business Suite R11.5.10 AOL.
• Oracle E-Business Suite System administration and printing setup.
• Perform Oracle E-Business Suite Patch administration, review, testing, and deployment.
• Perform Oracle E-Business Suite maintenance with minimal downtime.
• Implement and configure Oracle E-Business Suite monitoring tools.
• Develop and implement security schemes for Oracle E-Business Suite.
• Measure Oracle E-Business Suite performance and availability.
• Installation and upgrading the Oracle 10g RDBMS.
• Database backup and recovery using RMAN.
• Database operations monitoring using scripts and OEM.
• Copying databases/renaming files and creating control files.
• SQL/PL SQL and UNIX shell scripting experience.
• Tuning SQL and PL/SQL.
• Physical and logical tuning of Oracle Database.
• Patch administration, review, testing, and deployment.
• Database maintenance with minimal downtime.
• Implement and configure database monitoring tools.
• Develop and implement security schemes.
• Measure database performance and availability 7/24 support .

Confidential

Lead Oracle 11i DBA

Responsibilities:

• Act as liaison between Technical support, Engineering groups, user groups and senior Management on the sale and implementation of Oracle Database and it application.
• Lead Technical, user group training and knowledge transfer to support staff
• Tuning application
• Support MRP DRP and HR/Financial
• HP-UX Oracle 11.5.5 and Database 8.1.7
• Cloning, Rapid Clone, Patching, Tuning.
• Quality Assurance, upgrading seven three tail server to 10g, 'Database, application and Web' support 10g Enterprise server Production support, 24/7, discoverer Tkprof,
• Explain plans, pl/sql, sqlloader Toad, Oracle, OEM, , and EMC storage
• Develop and maintain Oracle concurrent manager configuration and operation
• Install, upgrade, and apply patches to all databases and applications.
• Plan, design, and perform backup and recovery of all databases.
• Provide support and guidance to technical and development staff.
• Performance Tuning, Backups, Data Loads, Data Recovery.
• 24x7 Multi-Terabyte Production Environment 3 Terabyte
• Documentation and logging experience
• Organizational and time management
• Verbal and written communications
• Project Management

Confidential

Lead Consultant: Oracle 11i DBA

Responsibilities:

• Act as liaison between Technical support, Engineering groups, user groups and senior Management on the sale and implementation of Oracle Database and new fixtures application .
• Lead Technical, user group training and knowledge transfer
• Support two test environment, two development environments, and Two Production environment In Oracle Manufacturing, Distribution 'Advance Supply Chain Planning' 'Memory Base Planning', Application 11.5.5, 11.5.9, 8i, 9i Daily Application analysis.
• Concurrent Job setup, application update, Review Developer code for promotion from test to development and production, Use Kintana Software to promote software and PVC for version control and Monthly releases.
• Test Director report
• Uses Appworx to perform application daily routine 'Oracle Distributor Planning' 'DRP and Oracle Manufacturing Planning MRP Plan and weekly plans', Patch application, upgrade from 11.5.5 to 11.5.9, 8i to 9i, Tuning the memory base plan database and application.
• Setup manager Concurrent application, download and upload forms, menus, set value, flex field-using AOL.
• Tuning the database and applications BOM, INV, CRM, MRP, OM, PO, AR, AP, GL, MFG
• Application Organization setup
• Daily operation and maintenance of all database/applications: Job schedules, recovery planning with system Admin, disaster recovery, and backups Monitor jobs. Work 7/24.
• Database migration from 8.1.7 to 9i and application from 11.5.5 to 11.5.9
• Database and application cloning
• Advance Planning and Scheduling ODP and ASCP
• Oracle Workflow configuration and admin

MConfidential

Senior Consultant

Responsibilities:

• Oracle Financial Application 11i, 8i, 9i DBA
• Schedule Cron Job: Backups Hot and Cold .
• Concurrent Schedule Job report.
• Weekly update 24x7 Multi-Terabyte Production Environment 7 terabyte
• Data warehouse - Veritas Cluster Server
• Netbackup using Tivoli Software and. On Production Database
• Maintained and update documentation on Production system/database/application move.
• Installed Oracle 10g and used the Enterprise manager performance tool 'Advance Events'.

Confidential

Senior DBA Principle Consultant

Responsibilities:

• Performed feasibilities studies for Web base Oracle database and reported to executives. Case tools implementation SRC with SBC
• Designed, Installed and implemented Oracle Application database and third parties application program on the top of Oracle database.
• Installed Oracle Database, GSM Wireless VOIP server, satellite catapults, SS7
• Pre-pay wireless system, Third party Web base application, trained the new DBA and their technical staff.

Confidential

Senior DBA Principle Consultant

Responsibilities:

• Senior Oracle DBA in a team of 10 DBAs.
• Jointly responsible for the design, Administration and maintenance of more than 50 distributed databases on HP-UX Sun Solaris platforms AIX and Oracle Financial/Manufacturer application. Full spectrum of Oracle databases supported, from OLTP systems supporting several thousand concurrent users to terabyte.
• Planned, Re-designed, Re-organized and re-configured Oracle Database for Motorola CMS project, Re-install all Financial Manufacturing model GL, AR, OE, HR, AP, PO, INV etc., and the entire custom model.
• Designed, installed, administered, and maintained multiple Oracle 7, 8, and 8i
• Tuned database and Oracle Applications utilizing PL/SQL packages.
• Helped to move developed and test database to production database,
• Designed cloning Production Database
• Put in place disaster recovery, applied vertex to AR Monthly applied patch to automate the backup hot, cold, export full and incremental trigger, data loading.
• Helped in capacities planning in reconfiguring and upgrading the system the HP 9000 system.
• Performed database and application cloning.
• Helped in managing Oracle database web link to database and the application.
• Responsible for daily monitoring and maintenance of the database Web server and OEM.
• Setup concurrent manager job, purge application common and output directory Monthly.
• Mentored Jr. DBAs.
• Provided daily reports on extents, free and used space, lock report, database listener reports.
• Worked on application icon through web, helped to upgrade the database from 8.0.3 to 8.4.0, 8.0.5, 8.0.6 and 8i. Vertex and Monthly vertex update fifty State Monthly Tax update .
• Responsible for performance tuning.
• Utilized Oracle Application Server OAS Oracle Java products JDBC, JDeveloper, Java. Stored Procedures, HTML, WebDB server, XML apps, Advance Queuing AQ , Oracle Web Application OWA , Database Access Descriptor DAD , and Web Agent/Listeners etc.
• Oracle 8i Advanced Replication.
• Wrote UNIX shell scripts.
• Manage Test, Development and All production Database.
• Installation application of Patches on Test, Development and Production Database
• Oracle Financial Application is release 11 11i, and Apps upgrade migration from 11 to 11i SAP/Oracle admin, OEM performance monitor packages Oracle 9i application
• Installed, configure, enterprise manager tools to help in daily management, database tuning, capacities planning, and performance management.
• Weekly index rebuild for some indexes also help create auto script Database on Sun Solaris, VAX/VMS, SGI, IRIX, with Provide assistance to development teams with Oracle based systems.
• Involved in a conversion project from DB2 to Oracle database.
• Provided support on people soft implementation
• Provided daily support as SAP Oracle DBA.

Confidential

Senior DBA Principle Consultant

Responsibilities:

• Senior Oracle DBA working with a large Oracle Financial application team of developer as both applications, system DBA utilizing Oracle on IBM/AIX, Sun Solaris, Oracle Parallel Server and Windows NT.
• Planned, Re-Designed and re-organized the Oracle database and Oracle Financial GL, AP, AR, HR . test, Development, Production
• Put in place disaster recovery, applied vertex patch to HR and patch to others to automate the backup hot, cold, export full and incremental .
• Responsible for daily monitoring and maintenance of the database.
• Responsible for Database Cloning and Database Replication.

Confidential

Senior DBA Principle Consultant

Responsibilities:

• As a Senior Oracle DBA worked within large team of developers in a data bank environment, utilizing Data warehouse, Oracle Financial on HP/UX, Sun Solaris and Windows NT.
• Planned, Design and install Oracle RDBMS 7.3.3 on HP/UX 9000, Sun Solaris.
• Involved in Database Modeling including logical and physical modeling using ErWin.
• Planned and put in place backup and disaster recovery.
• Build test, development, and Production instances on distributed environment.

Confidential

Senior DBA/Principle Consultant

Responsibilities:

• Lead a team of 5 Oracle DBAs and 3 Unix System Admins.
• Jointly responsible for the design, Administration and maintenance of more than 200 distributed databases on HP-UX Sun Solaris platforms. Full spectrum of Oracle databases supported, from OLTP systems supporting several thousand concurrent users both in Europe and USA.
• Planned, design, install, upgrade, and migrate Oracle 7.1.6 interoffice 1.0.8 batter Publisher 2.0.2 to Oracle 7.3.2.3, interoffice 4.0.4 4.1.0 Production and Coris Publisher 3.0.3 on ten Sun Solaris UNIX Platform with 22 instance and 7 IBM RS6000 with 10 instances.
• Performed Backup and disaster recovery plans and remote database of 900GB of database.
• Cloned multiple databases.
• Helped trained the new DBAs.
• Completed migration in place of 2-terabyte-database object.
• Tuned all instances.

Confidential

Senior DBA/Consultant

Responsibilities:

• Modified and customize the Oracle Application Financial flexfield.
• Worked on Oracle Financial flexfield.
• Build interface for mainframe data and migrate it to AIX Oracle 7.1.4 RDBMS and Financial 10.4 environment.
• Helped in putting backup and disaster recovery together for systems and database.

Confidential

Senior DBA/Oracle Manufacturer

Responsibilities:

• Database Manager report directly to MIS Director
• Rebuild all instances.
• Tuned the AIX Database.
• Moved all raw devices to file system.
• Re-design backup and disaster recovery.
• Performed Automate backup database archiving.
• Planned, Design, create and manager Data warehouse on Unix IBM Super-PC.
• Create trigger to update the Data warehouse from main database.
• Developed, create Maintained, schedule and managed Oracle Financial concurrent manager job.
• Oracle Financial Maintained General lager, Order Entry, Invoice, Inventory, and Oracle Browser.
• Install and Maintained Informix database.
• Ingress Database data conversion to Oracle database