SUMMARY:

• Hands-on Oracle EBS solution design, implementation, and management experience, designing for all tiers of a solution.
• Over 20 years of experience as Oracle Manager, Oracle DBA, Apps DBA, Developer
• Strong track record of carrying projects through from design through implementation on time and on budget.
• Proven track record of successfully establishing business relationships and working effectively with cross functional teams at all levels within the organization.
• Managed Technical team on various projects
• Installed, Upgraded Patched Oracle eBusiness Suite R11 and R12
• Installed and Configured Oracle OEM Grid Control system for monitoring and management.
• Installed and Configured Oracle Discoverer 10g.
• Support and Manage Oracle eBusiness Suite R11 R12
• Architect Backup Recovery strategies for clients.
• Support Manage MS SQL Server Databases
• Has excellent written and verbal communication skills

SKILLS PROFILE:

RDBMS

• Oracle 7 11gR2
• MS SQL Server, MS Access

ERP

Oracle EBusiness Suite R11 R12

Application and Development Tool

Oracle Discoverer, Oracle Designer, Oracle Developer, MS Visual Basic, Crystal Report, Erwin, SQL Navigator, TOAD, Oracle ADI

Business Intelligence

Discoverer, Noetix

Operating System Administration and Hardware Support

• HP-UX, Sun Solaris IBM AIX
• Linux RedHat Enterprise, OEL, Fedora, SUSE , Oracle Linux
• Windows 2000, 2003, LDAP, Active Directory

Query Programming Languages

SQL., PL/SQL, SQR reporting, Java, C, C , Visual Basic, Perl, Assembly Language, UNIX shell script, HTML, Basic and Fortran

Web Development Tools

HTML, VRML, Javascript, MS FrontPage, NetObjects Fusion, MS Internet Information Server, Oracle Web Application Server, Apache

WORK EXPERIENCE:

Powerwave Technologies, Santa Ana, CA 03/2005 - Present

Sr. Oracle Apps DBA

• Successfully negotiated and saved three quarters of a million dollars in Oracle Support annually for Oracle EBS, Agile, Hyperion, and PeopleSoft.
• Responsible for managing the direction and administration of Oracle ERP resources and ensure service continuity and availability. Provide strong technical leadership as needed, directing development in PL/SQL and other technologies in the Oracle landscape.
• Ensure compliance with all financial and legal obligations in accordance with Governance and SOX requirements.
• Manage and maintain IT SOX controls and act as point of contact for audits.
• Work with internal departments and external organizations to make effective and timely decision in alignment with departmental direction.
• Work closely with business customers to implement projects including the development of plans, management of resources and deliverables in the EBS applications portfolio.
• Provide direct oversight and direction on critical technology initiatives and project management. Review, evaluate and recommend new technologies and software upgrades.
• Oversee negotiation and administration of vendor, outsourcer, and consultant contracts and service agreements.
• Oversight of consultants and contractors assigned to projects or maintenance activities.
• Evaluate employee performances, manage staff and resources within budget and schedule.
• Maintains staff by recruiting, selecting, orienting, and training employees developing personal growth opportunities.
• Serve as the primary technical lead responsibility for production support on 24 x 7 basis for all company databases and Oracle ERP related systems and responsible for the day to day system support and project planning and management of technical activities.
• Responsible for database strategy, including standards, design, maintenance, replication, archiving, access and security, to support departmental and Company needs.
• Perform project management duties in support of database and related application initiatives including requirements and resource planning, scheduling and task identification.
• Perform project lead responsibilities for assigned projects.
• Determine long-range requirements for database sizing, forecasting, planning and design in conjunction with application team, end users and senior management.
• Review and recommends changes to database replication and interfaces to support corporate application needs.
• Lead IT Change Management meetings and facilitates and coordinates organizational change activities.
• Routinely audit database systems to ensure compliance with SOX, established systems policies, standards, configuration guidelines and security rules as required by the company.
• Ensure proper security procedures and measures are in place and maintain to prevent unauthorized access to database systems and related applications.
• Optimizes databases and table configurations for configuration, performance and cost efficiency.
• Develop and maintain the disaster recovery / business resumption planning process for all databases.
• Responsibility include staffing, conducting performance appraisals, training and developing subordinates, promotions, salary increases, terminations, disciplinary actions, etc.
• Upgraded Oracle Applications 11.5.9, 11.5.10.2 to R12.1.3.
• Upgraded Oracle databases from version 8i, 9i, 10g to 11GR2.
• Migrated Oracle ERP from HPUX to Linux
• Installed and configured shared APPL TOP for load balancing.
• Installed and configured iSupplier and iCustomer through DMZ to support external suppliers and customers.
• Installed, and configured Oracle OEM10g Grid Control for databases monitoring and management.
• Upgraded Discoverer 4.1 to Discoverer 10g.
• Implemented Oracle Applications Brazil and India Localization
• Responsible for all Oracle EBS interfaces.
• Responsible and manage data conversion when merging other company legacy system.
• Installed and configured Noetix Reporting System on MS SQL Server.
• Installed and configured Quest Foglight and Spotlight for system monitoring and management.
• Installed, configured, and managed databases for Agile 5.X to 9.X.
• Installed, configured, and managed databases for PeopleSoft.
• Established UNIX shell scripts for automated cloning, backup, monitoring, and disaster recovering.
• Designed and configured various backup and disaster recovering using HP and EMC snapshot/snapclone
• Manage and maintain all production and non-production databases, including performing backups, recovery and validation, as well as instance management, cloning and patch management.
• Ensure optimal database performance and tuning including with metrics and statistics reporting.
• Monitor database systems and promptly resolves communication problems ensuring high database reliability and availability.

Confidential

Sr. Oracle Apps DBA

• Successfully upgraded Oracle Applications 11.5.5 to 11.5.9 with Autoconfig enabled, RapidClone, Java Workflow Notification Mailer, and 9i database.
• Setup and configured Oracle Internet Procurement, Web Expense, and Workflow.
• Coordinated and performed Oracle Applications 11i Performance/Stress Testing on both database and middle tier to determine server resource allocation.
• Installed and configured Oracle Recovery Manager RMAN , Oracle Management Server, Data Gatherer, Oracle Enterprise Manager with Diagnostic Pack and Tuning Pack.
• Performed Oracle Applications performance tuning for clients, databases, and concurrent managers using Oracle Enterprise Manager, Precise Performance Tools, and custom scripts.
• Installed, setup and configured Precise Enterprise Management Tools Indepth, Insight, Interpoint, and Pulse modules for real time and historical monitoring databases and servers.
• Installed and configured Legato with Oracle RMAN for all backups.
• Created custom request set, concurrent programs, menu, responsibilities, and Oracle Alerts.
• Established refresh/cloning scripts for Oracle Application Test and Development environments from Production environment.
• Established UNIX shell scripts for backup, external interfaces and utilities scripts.
• Installed and configured Oracle databases for Human Resource Personnel Data System PDS application.
• Installed, setup and configured Oracle databases for Agile application to integrate Engineer Change Order ECO , Engineer Change Notice ECN and Bill of Material BOM with Oracle Applications.

Confidential

Sr. Oracle Apps DBA Consultant

• Only Oracle DBA and Oracle Applications System Administrator for company enterprise databases.
• Installed and configured Oracle Applications environments with Financials, Multi-Org, and Web Expense on SUN Solaris and HP-UX platform.
• Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.
• Setup system and user profiles for Oracle Applications, administer concurrent managers and reports.
• Implemented and configured Multiple-Organization Architecture, WebExpense, Workflow, and Notifications Mailer.
• Developed suite of utilities for maintenance of multiple Oracle Applications environments: environment configuration, initialize environment, automated databases, Webserver, Form servers and concurrent managers startup/shutdown process.
• Installed and configured Oracle Recovery Manager RMAN , Oracle Management Server, Data Gatherer, Oracle Enterprise Manager with Diagnostic Pack and Tuning Pack.
• Performed databases performance tuning and monitoring using shell scripts, Oracle Enterprise Manager Tuning Pack, and Diagnostic Pack.
• Created and tested shell scripts for automated cold and hot backup. Installed and configured Veritas NetBackup with Oracle RMAN for all backups.
• Recovered/restored multiple databases from physical disk failure. These failures include lost of datafiles/system tablespace/control files/on-line redo logs.
• Installed and configured databases and applications for rapid implementation system:
• - Account/Order Management - Cygent
• - Billing Management Portal Infranets and Taxware
• - Customer Service Remedy
• - Application Integration Vitria

Confidential

Oracle Apps DBA Consultant

• Installed and configured various U.S and International Oracle Applications environments, Oracle Webserver and Form Server on IBM AIX platform. Applied patches and performed Oracle databases and Applications upgrade. Performed refresh/cloning of Oracle Application Test and Development environments with
• Production environment.
• Implemented and registered customized applications Oracle Forms, Reports, SQL Plus, shell scripts with Oracle Applications Object Library AOL .
• Setup system and user profiles for Oracle Applications administer concurrent managers and reports.
• Implemented and configured Multiple-Organization Architecture, Multiple Reporting Currency MRC , Web Expense, and Human Resource.
• Developed suite of utilities for maintenance of multiple Oracle Applications environments: environment configuration, initialize environment, automated databases, Webserver, Form servers and concurrent managers startup/shutdown process.
• Responsible for custom Oracle Applications Account Payable and Account Receivable interfaces SQL, PL/SQL, SQL Loader with proprietary e-commerce transactional system. Troubleshoot and resolved all interfaces issues including vendor/supplier transfer, vendors EDI, Purchase Order receipts, customer invoices and credit card payments.
• Installed, administered, and maintained 40 Oracle 8.0.5.X and Oracle 8i on IBM AIX and Sun Solaris servers in both development and production environments to support international startup e-commerce company.
• Responsible for backup and recovery for 40 databases using Oracle Recovery Manager RMAN and EDM Tape Management Library software from EMC.
• Installed and configured Oracle Names servers, listeners, and Intelligent Agent.
• Performed application performance tuning SQL, PL/SQL, stored procedures, SQL Loader using Explain Plan, TKPROF, DBMS SYSTEM, Oracle Enterprise Manager Top Session, and SQL Expert to support 50 Visual Basic and ASP developers.
• Performed databases performance tuning using scripts, Oracle Enterprise Manager Tuning Pack, Diagnostic Pack, and tune operating system kernel parameters.
• Installed and configured Oracle Enterprise Manager with Diagnostic Pack, Tuning Pack and Oracle Management Server.
• Installed and configured Oracle Discoverer, Application Desktop Integrator ADI , and ADE.
• Administered Discoverer Business Area, End-User-Layer EUL and designed business critical reports using Oracle Discoverer and Oracle Reports.
• Developed shell scripts and performed IBM RS6000 clustered High Availability HACMP failover test.
• Trained desktop support and computer operator on Oracle Client Products installation and maintenance process.

Confidential

Oracle DBA and Developer Consultant

• Architect and implemented Oracle applications forms and reports from character mode to Network Computing Architecture NCA .
• Installed and upgraded Oracle Financials 10.4 character mode to Oracle Financial 10.7.
• Installed, migrated, upgraded, and configured Oracle databases from 7.1.6 through 8.0.3.
• Customized Oracle Application forms and reports. Migrated from Forms 3.0 to Forms 4.5, Reports 2.0 to Reports2.5.
• Designed and implemented Profit Control System for management and decision support using Forms 4.5, Reports 2.5, PL/SQL, views, and database triggers.
• Installed, configured, and implemented Oracle database 7.3.6-8.0.3, Oracle Web Application Server 3.0-4.0, Oracle Form, Report Server, and MS Internet Information Server
• Designed and developed interface utilities SQL, PL/SQL, SQL Loader, shell scripts for end of months batch loading from UNIDATA to Oracle databases.
• Trained on-site DBA and system administrator on installation and maintenance process.

Confidential

• Installed and configured Oracle RDBMS 8.0.3 and Developer2000 Forms and Reports on Window NT.
• Performed third-party applications performance tuning and database tuning.
• Established backup and recovery strategies for both development and production databases using ArcServe.
• Trained on-site DBA and system administrator on installation and maintenance process.
• Documented installation and maintenance process.

Confidential

Oracle DBA and Developer Consultant

• Installed and configured Oracle RDBMS 8.0.3 and Developer2000 Forms and Reports on Window NT.
• Performed third-party applications performance tuning and database tuning.
• Established backup and recovery strategies for both development and production databases using ArcServe.
• Trained on-site DBA and system administrator on installation and maintenance process.
• Documented installation and maintenance process.

Confidential

Oracle DBA and Developer Consultant

Designed and developed suite of management and decision support web reporting tools using Perl and CGI, DBI/DBD modules and Apache web server.

Confidential

Lead DBA and Developer

• Lead a design team to develop integrated database architecture and GUI user applications for an automated launch vehicles processing system using Oracle databases, Designer, Developer 2000, and Oracle WebServer.
• Analyzed, data modeled, and designed logical databases for an automated launch processing system using Oracle Designer 2000.
• Designed and implemented launch vehicle mission development databases to support testing and launch processing
• Designed and developed GUI user interfaces in client/server mode and web-enabled forms using Oracle PL/SQL cartridges and Oracle Forms 4.5.
• Migrated historical data from various legacy systems Mainframe, MS Excel, MS Access, MS SQL Server, etc. into Oracle databases using SQL Loader, Pro C, Migration Utilities, and PL/SQL.
• Installed and configured Oracle databases 7.3.4 and Oracle Webserver on Digital Alpha.
• Established standard database software requirements and database design documents
• Established acceptance, qualification, and environment test software for flight critical avionics boxes in C, Visual Basic, and HTBasic programming language.

Confidential

• Electrical Engineer Designed and developed real time software for a digital signal-processing test stations in C and Assembly Language.
• Performed end-to-end system test, analyzed, and troubleshot hardware/software anomalies throughout
• integration and test phases for MILSTAR digital communication satellites system.
• Designed simulation software in C and Basic to assist satellite subsystem testing.

Confidential

Electrical Design Engineer

• Designed hardware for satellite communication terminals.
• Designed and implemented hardware/software for satellite communication terminals ATE.