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.

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential

DATABASE SUPPORT

Responsibilities:

• 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

Responsibilities:

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

Confidential

DATABASE SUPPORT

Responsibilities:

• 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 Confidential 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.