SUMMARY

Confidential is a Principal Oracle DBA and Apps DBA with several years of experience. Throughout his career, Philip has worked as an Oracle DBA, Apps DBA, Technical Lead, Middleware Admin OBIEE/SOA/Weblogic and Architect. In addition, he has minimized development downtime and resource time by automating Oracle Applications cloning, patching and migration procedures via shell scripts and developing RICE components. As a well-versed Principal Oracle DBA and App DBA, with extensive knowledge and experience, Philip has the technical and communication skills to be a great addition to your organization.

TECHNICAL EXPERTISE

• Database ERP Core Skills: Oracle DBA Core, Oracle Apps Development: Unix, RICE: Functional Configuration HRMS, OTL, OTM, OAB and Payroll Oracle E-Business Suite Release 12, 11i, 11.5.10, 11.5.8, 11.0.3 Financials GL, AP, AR, FA Procurement OE, Inventory, iStore, Configurator HRMS HR, Payroll, OTL, SSHR, OAB, OTA , Sungard
• Database: Oracle 8x, 9i, 10g, 11g, SQL SERVER 2000/2005
• Operating Systems: HP-UX 11.0, AIX 6.0, Solaris 10.6, RH EL 4.0 and 5.0, Windows NT 4.0 and Windows 2000 and Window Server 2007 to latest.
• DBA, SOA Dev. Tools: Oracle Enterprise Manager OEM , Grid Control, RMAN, RAC, SQL, SQL Loader, Forms, Reports, SSO/OID, SSL, TOAD, Sql Navigator, Reports Forms 4.5, 6i, 9i OC4J, JSP, OBIEE, PL/SQL, UNIX Scripts, Oracle Discoverer, Fusion Middleware FMW Weblogic, B2B, OBIEE and Identity Manager -OAM , JDeveloper, Eclipse, Java. Oracle SOA/DB 10g to 11g.
• Productivity ,Change
• Management Software
• Methodologies: MS Office Suite, MS Project, Visio, PowerPoint: Change Management: CVS, GDD, VSS Test Director, Pantagon, Kintana, Changeman Methodologies: AIM, SOX, Security, On Demand Oracle Best Practices. GridControl and OEM.
• Hardware: Sun Sparc, HP-RP74xx, Sun -Ultra series, EMC storage, IBM RS6000, DELL.
• HA/MA Technology: DataGuard, RAC, F5 HD Load Balancing, Web Farm, Concurrent Manager and PCP.
• SOA: BPEL,OBIEE, B2B, Webmethods, WebLogic 10g FMW 10g/11g and SCA Components build, deployment, configuration and Installation. SOA upgrades from 10g to 11g.
• Backup Recovery: RMAN, Third Party tools: ConVault, BCV, Omniback,
• dataprotector

PROFESSIONAL EXPERIENCE

PAE Consulting

• Provide all Oracle consulting for all EBS Infrastructure/Capacity Planning, Oracle Apps, Oracle eBusiness, SOA Fusion Middleware Including Security SSO and Application Integrations with EBS and other applications, and Oracle DBA including project definition, deliver and test for new installations, conversions and migrations.
• Customers are medium and large scale industries. Provide leadership in all areas of ORACLE Best Practices.

Confidential

Sr. Oracle DBA/Technical Architecture Team Lead

• Responsible for support and design of State's Benefits Application UILINK which is a critical business system used to provide State of Nevada, South Carolina, North Carolina and Georgia benefits package to individuals and State employees.
• Responsible for ensuring availability and performance of the databases
• Responsible for implementation and release of database changes as submitted by the development team
• Interacts with development teams, business owners, and various levels of management
• Ensure high availability and performance requiring 24x7 pager support on a rotational basis including weekends on planned outages.
• Worked also as part of a team that delivers a high availability service -- with the architecture team
• Installed and configured Oracle OEM grid control and Oracle DataGuard for use on the project.
• Pro-actively monitor database systems to ensure secure services with minimum downtime wrote a number of in-house scripts that generates alerts via emails capture/review developer codes for compliance.
• Responsible for improvement and maintenance of the databases to include application DDL rollout and upgrades
• Provides Data Modeling via Ca Erwin, created Data flow to explain conversion strategies. Assisted developers with Conversion writing standard scripts for them to leverage while maintaining development Standards.
• Responsible for performing tuning of codes and identifying code bottlenecks assist developers in code re-writes and changes.
• Developed and trained developers in DataMasking utility Leveraging Oracle Tool to ensure PII information are secured.

Confidential

Sr. Oracle Application DBA/Technical Architecture Team Lead

• Responsible forsupport and development of FTD's Oracle EBS critical business systems Including databases and application middleware that are used to provide FTD's HR, expense, and time reporting processes, Clarity and LongView applications.
• Install, configure, and support a FTD Oracle EBusiness Suite EBS release 12 instance, including the installation of the application and database software, which implements HRMS, iExpense, Time Labor, and Payroll modules.
• Support data separation and migration of existing FTD EBS data from an existing EBS R11 instance into the new FTD R12 instance
• Work with internal application support team and external application integrators to install, configure, and troubleshoot FTD EBS R12 instance.
• Cross train experienced Oracle database administrators in skills required to support and maintain the FTD EBS R12 environment
• Document FTD EBS R12 environment, maintenance procedures, and operational processes
• Automate EBS related maintenance processes shutdown/startup, backups, monitoring
• Administer and maintain Oracle database instances supporting production applications.
• Monitor and tune system to ensure maximum system efficiency and required system availability. Resolve any problems that arise with the database.
• Participate as a member of a project team to design new products or enhancements to existing products.
• Create policies and enforced based upon attributes, including SQL category, time of day, application, user, and IP address for Database Firewall events alongside audit data.
• Advise on product architecture and database interface. Should have the aptitude to understand the business requirements and convert such requirements into an efficient database implementation.
• Meet established schedules and resolve technical or operational problems.
• Execute assigned tasks to achieve maximum levels of productivity.
• Make recommendations for technical and process improvements as they relate to our databases.
• Suggest new methods, products, procedures, and innovations that will improve corporate profitability.
• Assist in the presentation and demonstration regarding database issues on behalf of the company.
• Ensure business and technical issues in areas of responsibility are communicated appropriately to the appropriate person s or level s of the organization.
• Effectively follow the policies and procedures established by the team and department.
• Interact and work with other IT departments and departments external to IT in order to ensure that database products are developed and put into production according to planned schedules and expectations.
• Protect interests of employees and the company in accordance with company policies and governmental laws and regulations.
• Protect the data from hazards and unauthorized access.
• Perform any other duties as assigned.

Confidential

Sr. Oracle Application/WebLogic DBA/Technical Team Lead

• Maintained and Supported Oracle EBS Development, QA and Production on a multi-tier environment including istores on DMZs
• Developed complex ETL and conversion programs in PLSQL, SQLLOADER,Unix Script to argument development resource. The development were part of the legacy conversion for employees, GL Interface and Vendor conversion while assisting developers and functional team with complex development/technical issues.
• Created ad-hoc in-house scripts in Unix and Sql for monitoring and maintaining Web logic servers, databases and applications.
• Enabled and monitore alerts for Database Firewall customized security alerts and reportings also set business thresholds for applicable SOX monitoring such as auditt unathorized login reports.
• Wrote various application management strategies and standard documents including Development, Installation, Monitoring and Troubleshooting standards leveraging AIMs Methodologies for RICE Implementation.
• Designed and implemented Database capacity planning as we migrated legacy data from a new company acquisition.
• Installed and managed Oracle Fusion middleware and configured the tech stack for OBIEE, ESSBASE, Identity Management, Single sign-on, Windows authentication, and configuring Oracle Portal administration.
• Managed and administered SOA components such as BPEL, B2B and BAAM other managed services.
• Created and provided the required schema repositoriesfor OBIEE/ESSBASE reporting.

Confidential

Sr. Oracle Application DBA/DBA Team Lead

• Maintained and Supported Oracle EBS Production on a multi-tier environment including istores on DMZs
• Installed and upgraded 10g/9i database to latest Oracle DB 11g including configuration of same on Oracle EBS and Grid Controls.
• Created ad-hoc in-house scripts in Unix and Sql for monitoring and maintaining Web logic servers, databases and applications.
• Implemented robust load process for monthly Vertex and ShopVisible postal Codes uploads.
• Implemented automated post and pre-clone checklists/validationfor Cybersource/ipayment in eBusiness including iStore configurations. Implemented in-house Oracle 10g/11g/9i RMAN, NetBackup and Tape backup management integration with RMAN and created robust scripts for I/O, disk and performance monitoring including automatic db restores to ensure backup validities and planned black-outs/drills.
• Configured Oracle Data Guard 11g/10g/9i and created documentation for planning, configuration, maintenance troubleshooting using the tool.
• Configured and created documentation for in-house DBAs to troubleshoot RAC10g/11g/9i - Real Application Clusters as well as planning, designing, maintaining, installation and troubleshooting procedures.
• Configure and created documentation for Oracle11g/10g Grid Control/Oracle Enterprise Manager, Management Agent setup, Oracle Enterprise Manager Grid Console Management Console configuration same standard was adopted by client for other internal installations. Monitored Database Console, Application Server Console, Grid Control Plugins and beacons while showcasing the capacities to team.
• Designed and implemented Database capacity planning as we added new servers and memory and CPUs during our 10g to 11g upgrade and server additions admin tiers to relief performance bottlenecks on the architecture.
• Installed and managed Oracle Fusion middleware and configured the tech stack for Identity Management, Single sign-on, Windows authentication, and configuring Oracle Portal administration.

Confidential

SR. SOA 11g Middleware Administrator

• Analyzed, tested, and implemented physical database design supporting various business applications including base definition, structure, documentation, long-range requirements, and operational guidelines.
• Supported B2B OSB component of Oracle e-Business in relation to trouble-shooting, performance tuning, instance stabilization through optimizing queries, and memory, command line optimization and executions.
• Ensured data recovery, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management.
• Audited the current environments, providing capacity planning and best practices for the future production/development/test environments, including establishing new standards and procedures.
• Planned, scheduled and supervised the work of internal DBA Offshore staff.
• Led, reviewed and participated in development of quality entity relationship diagrams, data flow diagrams, database normalization schemas, logical to physical database mapping, data table parameters, etc.
• Reviewed the physical model created from the logical model, ensuring data structures and databases comply with standards, guidelines, and procedures.
• Monitored file system space, database allocation, and data integrity, verifies efficient use of disk storage, reclaims dead space, optimizes space allocation and avoids out-of-space conditions.
• Developed and maintained a backup and recovery strategy for all databases. Performs regular random drills to test disaster recovery scenarios.
• Provided daily Oracle Applications 11i / Oracle 10g DBA technical administration and support, including change management requests, monitoring, performance tuning, backup and recovery.
• Installed and managed SOA Middleware components for Dev, Stage and Production instances
• Applied Middleware Patches to patch level the instances
• Upgraded SOA 11.1.1.3 to 11.1.1.5 including schema components upgrades using RCU, Patch Upgrade assistance,etc.
• Migrated SOA queues and artifacts to Stage and PROD for developers
• Configured DataSources, JMS Adapters and JMS Modules connection pool, factory and Partitions as part of SOA Project CM
• Monitored BPEL alert logs proactively fixing issues to avoid user outages. Worked with DBA team to resolve database issues.

Confidential

SR. SOA 11g Middleware Administrator

• Installed SOA Middleware components for Dev, Stage and Production instances
• Applied Middleware Patches to patch level the instances
• Upgraded SOA 11.1.1.3 to 11.1.1.4 including schema components upgrades using RCU, Patch Upgrade assistance,etc.
• Migrated SOA queues and artifacts to Stage and PROD for developers
• Configured DataSources, JMS Adapters and JMS Modules connection pool, factory and Partitions as part of SOA Project CM
• Created CM spreadsheet with various checklists for documentation and conduct meetings to appraise Technical Team leads, DBAs, Developers and Project Managers on statuses and documentations.
• Developed Unix startup scripts and error detection on logs for proactive monitoring of the servers
• Configured servers for performance tuning and best practices including securing and auditing web services using SOA 11g, specifically, HTTP authentication and WS- Security.
• Installed and Supported B2B OSB component of Oracle e-Business in relation to performance tuning, instance stabilization through optimizing queries, and memory, command line optimization and executions logs and alert error tracking in addition to in-house cache flushes and database maintenance.

Sr. Oracle Apps DBA

Responsibilities Accomplishments:

• Designed and configured EBS Infrastructure/Capacity Planning for PFT Implementation on a multi-node architecture. Upgraded RDBMS and application to latest CPU, JDK/JRE patch levels.
• Installed and configured new R12 on 11g database for new Financial and CRM --DMZ for iStore implementation.
• Configured and implemented Oracle OEM DataGrid for efficient maintenance of the instances.
• Configured RMAN for hot clones, backup and recovery, set up customization tops routinely cloned and applied SR recommended patches.
• Wrote several proactive monitoring scripts for both Database and Application Server Tiers. Wrote several instance management documents such as development standards for developers, patch and cloning documentation issues and patch logs
• Mentored client staff on how to administer all of the above.
• Improved Connect:Direct for business critical data migrations and ETL by developing unix scripts that are scheduled to perform routine business operations.
• Developed OBIEE Repositories for various reporting layers Presentation, Physical and Business models including applying interactive dashboards and drill down capabilities using global filters with security setups.
• Evaluated, designed, build up, applied, and supported Business Intelligence technical solutions using Oracle Business Intelligence Enterprise Edition OBIEE / Siebel Analytics.
• Generated and planned executive level dashboards, complex reporting, and metadata modeling.
• Carried to the project during the Vision and Strategy, Architecture, and Development phases.
• Analyzed business problems and design proper solutions utilizing Oracle BI Enterprise Edition OBIEE
• Worked as lead technical architecture as both AppsDBA and developer in the design and development of dashboards and reports.

Other Assignments Include:

• Provided production support and Phase II implementations for Grants and iStore. Provided mentoring, Instance Management strategies and schedules and performance tuning and monitoring.
• Designed and configured EBS Infrastructure/Capacity Planning for Financials Supply Chain Modules Implementation on multi-node architecture - 4 Node RAC and several middle tiers load balanced across mid-Tier farms and proxies. Upgraded RDBMS and application to latest CPU patch levels Created strategies to mitigate performance bottlenecks and optimized the architecture and custom sql queries. Developed several in-house scripts for proactive monitoring of critical business processes.
• Designed cloning strategies for ten different environments and provided grid monitoring for the environments.
• Configured and maintained SOA, SSO/OID -OIM for R12 and OBIEE integration.
• Configured and maintained 10g R3 Oracle Weblogic for portal, server and integration components.
• Researched and documented upgrade path for Weblogic 10g R3 to 11g Client wanted to apply task in the next phase.
• Resolved startup script issues with startWebLogic.sh and startManagedWeblogic.sh created scripts to monitor Weblogic logs for contention issues related to port and service integrations.
• Migrated 11i instance from Windows to Linux platform and patched up existing techstacks with customer patches upgraded to auto configuration while using Oracle recommended best practices for platform migration.
• Performed several re-implementations of fresh installations of e-Business Suite for efficient use of Technology stacks and file systems. Configured Shared ApplTop to minimize instance downtime during patching and overall configuration maintenance.
• Configured High Availability with Dataguard and setup RMAN for backups and hot clones. Provided client with Security Best practices for 11i/10g instance, including securing access to default accounts, securing the network using encryption, using Single Sign On SSO , and enabling SSL.
• Documented all security practices and create daily management reports.
• Trained client staff on Installation, upgrades, migrations and maintenance of eBusiness 11i R12

Confidential

Principal Database Administrator Apps DBA

Responsibilities:

• Created and administered Sarbanes-Oxley SOX compliance in relation to Security Segregation of Duties, User Management , auditing Application Auditing , and change management Object Migration, Application Configuration, Application Patches .
• Converted table character set into utf8 to accommodate Portuguese language during data import export.
• Completed full life cycle implementation of Oracle Financials with Multi-Language MLS and Multi-Currency MRC with UTF8 Character Set.
• Provided technical architecture and DBA support on SASC/FSC eBusiness Consolidation project. SASC/FSC system runs on Oracle eBusiness suite 11.5.10.2 with Oracle database 9i / 10g RAC environment.
• Performed 11i to R12 upgrade in QA instance as part of parallel implementation for Client Stage II role out.
• Worked with the UNIX team to stage all the R12 DVDs for installation.
• Applied all the consolidated help patches for R12 including functional patches for AP, INV and HRMS modules as part of the R12 post upgrade.
• Assembled a test team to perform end-to-end testing of the R12 upgrade.
• Worked with business areas to validate and identify customizations as pre-R12 upgrade.
• Verified application module patch levels and updated the latest ATG RUP AD patches to proceed with R12 upgrade.
• Reviewed customization and applied best practice tuning approaches to resolve performance bottlenecks.
• Administered Oracle Applications, configuration and migration of Latin eBusiness application into multi-language with application localizations including managing and resolving OID,SSO and portals.
• Installed and maintained Oracle Access Manager OAM as a solution for both centralized identity management and access control, and provided an integrated standards-based solution that delivers authentication, web single sign-on, access policy creation and enforcement, user self-service, delegating administration, reporting, and auditing.
• Implemented OID, SSO infrastructure and integrated it with Oracle E-Business Suite and Active Directory architecture.
• Experienced with Fusion Middleware working knowledge
• Applied multi language patches including SPED patches for Brazil localization imported bolt-on applications such Colfax, Synchro and Markview.
• Proactively monitored production and 14 other instances made up of DEV, UAT, QA and other parallel implementations with the bolt-on application
• Upgraded and configured database application software. Monitored capacity and performance, and proactively resolve a wide range of issues.
• Assisted management in defining standards and strategies for security, SOX separation of duties via responsibilities and menu setup database objects, and backup/recovery. Managed Oracle backups through RMAN and CommVault.
• Assisted Functional and Development teams in creating a comprehensive data model for their application requirements.
• Provided lead role in technical architecture of the environment while supporting different module AOL setup as system administrator utilizing BR100 documents for profiles, responsibilities, and lookups. Flexfields, value sets, data/request groups and cm and application registrations.

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Prepared and presented Oracle Applications Release R12 upgrade strategy for ARMS. Downloaded and researched pertinent R12 patches as part of the R12 pre-patch analysis.
• Supported ongoing ARMS ERP system operations as well as new projects. ARMS ERP system runs Oracle eBusiness suite 11.5.10.2 with Oracle database 9i / 10 RAC environment.
• Administered Oracle Applications, RMAN, Remedy and other database applications.
• Upgraded 9i to 10g, co-architected new environment to retrofit 10g Clusters, ASM and 10g Database and 11.5.10.2 multiple web farms, DMZ and pcp utilizing shared appltop architecture and dual adminTiers for Parallel Concurrent Processing.
• Proactively monitored production and 14 other instances made up of DEV, UAT, QA and other parallel implementations such as Advanced Supply Chain ASCP , BI Oracle Business Intelligence Projects Family Pack PAFM etc.
• Installed and configured ATP Global Server for ASCP on multi-node Also Installed and configured same on a centralized architecture - patch leveling ASCP and setup various optimizations for Inventory, penalty factors and comparing different optimization runs.
• Installed and supported OBIEE Object Intelligence Enterprise Manager Edition on Linux
• Managed BI Administrative components with LDAP servers
• Upgraded and configured database application software and configured separate Apache Home for Portal, OID and SSO created workflows to sync user creation. Monitored capacity and performance, and proactively resolve a wide variety of issues.
• Assisted management in defining standards and strategies for security, database objects, and backup/recovery. Managed Oracle backups through RMAN and CommVault.
• Assisted Functional and Development teams in creating a comprehensive data model for their application requirements.
• Configured and mapped Oracle Spatial to third party geospatial application.

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Applied module eBusiness patches including Payroll, Benefits HR GLOBAL.drv and Critical Security Patches.
• Installed, upgraded and maintained Noetix Views on Corporate eBusiness including New Noetix Client 2. Generating of new NoetixViews and 3. Generating of the new EUL for Noetix.
• Provided Financials and HRMS production support resource on a 24/7 basis.
• Developed and implemented policies, technical procedures standards for managing the corporations eBusiness, Example Cloning, Patching and Auditing SOW standards
• Monitored and optimized the performance of Oracle applications database as a unit.
• Proactively monitored performance issues, identifying bottlenecks / root cause and providing recommendations.
• Managed and installed application patches working with Functional and Development teams in issues resolution through metalink TARs and internal trouble Tickets.
• Cloned Instances using rapid clone while preserving customizations
• Monitored concurrent manager jobs to optimize performance and throughput.
• Implemented various in-house scripts for maintaining eBusiness instances over 14 instances In-house scripts include unix and sql scripts for startups/shutdown, audits, CM Concurrent Managers , proactive process monitoring of application processes, RDBMS locks, outages and performance.
• Provided support for existing database streams on 10g. Also reviewed enhanced Oracle streams on 11g for client suggestions on an efficient event capturing, sharing and distributions relative to DML and DDL changes.

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Developed and implemented the policies, technical procedures standards for preserving the integrity and security of Oracle Applications data, reports, and access
• Assisted project teams with applying standards and resolving integration issues.
• Monitored and optimize the performance of Oracle applications database as a unit.
• Designed and configured concurrent managers and work shifts on RAC AIX 5 OS
• Registered custom applications, menus, forms, and programs through code migration procedure using FNDLOAD.
• Installed and configured ASCP on multi-node
• Set up various optimizations for inventory on Advanced Supply Chain ASCP supporting the functional analysts.
• Monitored streams between replications improved performance by reducing log contentions.
• Proactively monitored performance issues, identifying bottlenecks / root cause and recommendations. Used tools such as BMC Patrol/Oracle KM.
• Defined system setup options, profiles, descriptive and key flex field options
• Defined and configured Oracle Application printers --over 200 printers on a PASTA Configuration
• Managed and installed application patches worked with Functional and Developer team in issues resolution through metalink TAR and internal trouble Tickets
• Installed and upgraded Oracle Application modules and client software such ADI, Exceed and Desktop Discoverer.
• Cloned database and applications using RMAN recovery and Autoconfig
• Monitored concurrent manager jobs to optimize performance and throughput.
• Implemented Parallel Concurrent Processing PCP on RAC also implemented RAC on UAT instance for production break fixes and code migrations testing.
• Periodically ran maintenance processes such as archiving and purging including several proactive monitoring specifically CM and Cost Managers. Business depended heavily on the Delivery Manager therefore enhancing was appropriate for the critical nature of the CM.
• Installed, administered and maintained 10g AS for iSTORE, DISCO and SSO/ODI Servers.
• Implemented 11i 11.5.10.2 on F5 for hardware load balancing including servlets to ensure webentry points for High Availability in Forms and Database Tier.

Confidential

Oracle Applications DBA

Responsibilities:

• Performed upgrade projects from 11.5.8 to 11.5.10 CU2 on Solaris, and Implemented Hardware F5 Form Metrics Load Balancing Shared Appltop culminating from client requirement for low cost maintenance and instance availability.
• Implemented Daily Business Intelligence for the SCM and Financial modules prior to RACing/splitting the application servers.
• Implemented RDBMS RAC Data guard for non-eBusiness and created administration scripts shutdown and startups svrctl scripts for managing RAC Components.
• Performed upgrade project from 11.5.9 to 11.5.10 ATG RUP4 and technology stack upgrades including System Architecture specific to client environment and requirements.
• Technical Architecture Lead Migrated instance from a single to Multi-node Tier with a hardware Load Balancer F5 on Solaris 10 OS Sparc32 v.10 with combination of later versions
• Implemented shared appltops on NFS mounted disks across web farms supporting dedicated Apache servers for Discoverer and Configurator,
• Cloned and patched the instances working in conjunction with client Consultants in TAR resolutions and performance Issues.
• Assisted Client DBA with procedures, strategies, knowledge building and transfers.
• Monitored performance of Oracle Application Apache/Concurrent Managers and database and tuned as appropriate based on stats gathering. Tuned servers, Application Middle Tier, Custom Queries and Client Machines/Workstation.
• Implemented statistics gathering for better performance thorough put.
• Administered Oracle Applications accounts, responsibilities and printer Setups and various custom migrations and FNDLOADS/DataLoader .dld Loading of Customizations including AOL configurations, Menus and Responsibilities.
• Scheduled and monitored Performance related processes i.e. Gather Statistics, Purge and Workflow processes.
• Provided proactive and reactive support to Functional, Technical/Development, and SME s supported the TAR processes and document problem resolution via Metal ink and our in-house trouble-ticket tracker PVCS TRACKER and logs.
• Created various heath-check and house-keeping scripts such as menus, start and shut down scripts including migration scripts to handle various RICE components such as PLSQL, FORMS, REPORTS, INTERFACES and Conversions for migrations.

Confidential

Oracle Applications DBA Technical Lead

Responsibilities:

• Oracle 9i/10g iAS, 10giAS with eBusiness Suite Installation and Configuration experience Installed and upgraded more than 10 instances including Discoverer, OC4J Report and Form Servers , OID, SSO, Portal and Self Service applications with Configurator. iStore, iSupply, DMZ Architecture for b2b, b2c architectures.
• Upgraded 9i database to 10g and converted from Sun Solaris to Linux Redhat using export import procedure while applying all the necessary pre and post migration steps.
• Performed 11.5.8 upgrade and data migration from Sun Solaris to 11.5.10.2 on Linux Red Hat 4.5, Implemented Form Metrics Load Balancing Shared Appltop culminating from client requirement for low cost maintenance and instance availability.
• Performed upgrade project from 11.5.9 to 11.5.10.2 Rup3 and Technology Stack upgrade including System Architecture specific to client environment and requirements
• Cloned and patched the instance working in conjunction with client Consultants in TAR Resolutions and Performance Issues.
• Managed a TEST, UAT and PERFORMANCE/STRESS test activities to GO LIVE
• Monitored performance of Oracle Application and database, and tuned as appropriate based on Stats gathering. Tuned Servers, Application Middle Tier, Custom Queries and Client Machines/Workstation.
• Performed patches and supported SunGard Banner database for Student Information System i.e. Student, Financial Aid Module, Academic History and Admissions Recruiting.
• Administered Oracle Applications accounts, responsibilities and printer Setups and various custom migrations and FNDLOADS/DataLoader .dld Loading of Customizations including AOL configurations, Menus and Responsibilities.
• Scheduled and monitored Performance related processes i.e. Gather Statistics, Purge and Workflow processes.
• Provided proactive and reactive support to Functional, Technical/Development, and Business User Teams.
• Supported the TAR processes and document problem resolution via Metalink and our in-house trouble-ticket tracker PVCS TRACKER and logs.
• Implemented configurator, assigned users and responsibilities. Designed custom import programs for updating CZ tables.

Confidential

Oracle Applications DBA Technical Lead

Responsibilities:

• Installed an 11.5.10 Gold, Patch, TEST and UAT instances for Financials and CRM Modules on LINUX x86 Servers with Two, Three and Four Node Instances with Single, Separated and Shared Appltop architectures on Linux using RAC, ASM RedHat using both RAW DEVICES OCFS on PROD.
• Cloned and patch the instance working in conjunction with ORACLE ONDEMAND in TAR Resolutions and Performance Issues.
• Managed a TEST, UAT and PERFORMANCE/STRESS test activities to GO LIVE
• Monitored performance of Oracle Application and database, and tuned as appropriate based on statistics gathering. Tuned servers, application middle tier, custom queries and client machines and workstations.
• Administered Oracle Applications accounts, responsibilities and printer Setups and various custom migrations and FNDLOADS Loading of AOL configurations Menus and Responsibilities.
• Scheduled and monitored Performance related processes i.e. Gather Statistics, Purge and Workflow processes.
• Provided proactive and reactive support to Functional, Technical/Development, Business User Teams including Client Nicor and Implementer SME s Accenture Oracle.
• Troubleshot problems related to Oracle database, oracle Applications and perform root cause analysis.
• Supported the TAR processes and document problem resolution via Metalink and our in-house trouble-ticket tracker TEAM TRACK and logs.

Confidential

Oracle Applications DBA Technical Lead

Responsibilities:

• Created and administered Sarbanes-Oxley SOX compliance in relation to security Segregation of Duties, User Management , auditing Application Auditing , and change management Object Migration, Application Configuration, Application Patches .
• Installed 11.5.10 gold, patch, conversion and CRP instances Financials, MFG and HRMS on HP 9000 RISC 64bit Two Node -- Shared Appltop on HP-Unix architecture.
• Cloned and patched of Conference Room Pilot CRP and PATCH, DEV, CONVERSION and Production Instances.
• Converted DB characterset to UTF8 from WIS unicode
• Managed a multi-tier Oracle Application 11.5.10
• Monitored performance of Oracle Application and database, and tune as appropriate
• Administered Oracle Applications accounts, responsibilities and printers
• Provided proactive and reactive support to application, reports developers, implementation consultants and functional leads.
• Troubleshot problems related to Oracle database, Oracle applications and performed root cause analysis.
• Supported TAR processes and document problem resolution via Metalink
• Supported technical and management change processes of both Oracle and SQL Servers.
• Supported and maintained SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Worked with project team to ensure data synchronization between Oracle projects and P3 applications run on SQL Server 2000 database.

Confidential

Oracle Applications DBA- CRM/Financials/HRMS

Responsibilities:

• Maintained and supported Oracle 11i applications 11.5.9 -- development, test QA and production instances including providing system knowledge to end-users and developers.
• Configured Multi Currency Reporting MRP , Multi-Language including support for multi-language patch applications. Also configured Multi-Org supporting the functional team in all AD administrative related functionalities to implement all of the multi- functionalities.
• Completed full life cycle implementation of Oracle Financials with Multi-Language MLS for Chinese leveraging DB character set of UTF8.
• Implemented PASTA printing capability to support Chinese and Japanese font pasteurizations
• Implemented, developed and mentored several standards including: OFA directory structure, backup strategy, database administration standards, and development and naming standards.
• Resolved TAR issues while assisting the functional team and Oracle Support --obtaining script versions, executing scripts, regenerating forms/reports, flex-fields, clearing caches, re-cycling Apache and bouncing the Application processes Report/Form Server, App Listeners including application refreshes cloning , patch applications and database upgrades.
• Provided end-user support through meetings, presentations and documentations.
• Prepared and reviewed database specifications, testing and change control management programs migrations.
• Provided database/application tuning including such as reducing lock contention, modifying db parameters, balancing I/O across disk controllers, analyzing objects, pinning objects, and eliminating chained row.
• Defined and eliminated I/O bottleneck responsible for 100 CPU utilization on a 32 CPU Sun Solaris e10000 domain. Responsible for Reducing CPU Utilization from 60 monthly average to 20 monthly average.
• Assisted developers in SQL Tuning of offensive queries in several environments.
• Developed UNIX scripts for start, stop, shutdown and startup functionalities including sourcing of instances and for non-interactive patching and maintenance scripts adadmin, adpatch, adclone, adcfgclone, adautocfg, and editcontext for the XML parameter files.
• Wrote several ad hoc scripts for daily DBA activities such as backups, user creations, archiving of alert logs, verifying error entries and checking for space usages/overages.
• Tuned applications processes including: Concurrent Managers, and queries for Concurrent Programs in HR, GL, AP, AR, INV, and PO modules.
• Minimized development downtime and resource time by automating Oracle Applications cloning, patching and migration procedures via shell scripts.

Confidential

Sr. Developer

Project: CHIPPS HRMS Oracle Payroll and FMPS Financials Project

Responsibilities:

• Provided technical designs, customization and development on break-fixes support logged in by help desk --Utilized PL/SQL, SQLLoader and Developer 2000 Forms and Reports , Perl and UNIX scripts.
• Provided in-house support on tar creations and resolutions.
• Worked as liaison between developers,business owners, system administrators and DBAs--sharing applications knowledge and coaching both technical and non-technical business team resources to resolve application issues.
• Provided support on DBA related issues.

Confidential

Sr. Techno-Functional/Designer/Developer

Responsibilities:

• Provided technical designs, customization and development on requirements from the Business Analyst and the user community, utilizing PL/SQL, SQLLOADER and DEVELOPER 2000, PERL and UNIX scripts.
• Implemented conversions and interfaces from AS400 data Inventory items and transactions to ORACLE INVENTORY, PURCHASING, ORDER ENTRY, including AR Receivables , GL General Ledger and AP Payables .
• Implemented detail technical designs on requirements for offshore developers and testers.
• Coached and mentored developers via meetings and conferences on implementation methodologies and answering 'how-to'- questions.
• Served as a liaison between developers, business owners, system administrators and DBAs, sharing applications knowledge and coaching both technical and non-technical business team resources to resolve issues within the applications suite.
• Configured oracle applications functionally for Inventory, AR, AP, OE and GL creating Flex-Fields, Value sets, Profiles and Concurrent managers, Printers and Menu, Responsibilities and Program definitions via AOL.

Confidential

Developer/Oracle Applications DBA/Project Manager

Responsibilities:

• Created and maintained a database operations handbook for frequently performed tasks and database documentation standards and procedures.
• Developed and maintained complex open interface applications for both AP and AR. These applications were based on specs/functional requirements and built using PL/SQL, Unix Shell Scripts and SQL Loader control files. The features included batch/data archival functionality, non-interactive upload of batch files to the server-side on UNIX OS. Applications were registered allowing users the 'look and feel' of existing Oracle application modules.
• Implemented and executed procedures to port Application from UNIX to Linux environment in preparation for hosting to an outsource client datacenter utilizing Oracle recommended solution for data migration.

Confidential

Application DBA/Project Manager

Responsibilities:

• Supported production, development and integration/test instances.
• Enhanced and performed SQL tuning on developer codes and performance impeded PLSQL codes.
• Developed migration procedures and DBA checklists for an 11.0.3 and 11i implementation.
• Planned and implemented 11.5.8, 11.5.9 application and 8.1.7.4 , 9.1.2, 9.2.0.4 database upgrades
• Wrote and tuned several custom stored procedures PL/SQL and triggers to enhance production functionality and performance.
• Automated processes such as backups, job scheduling using UNIX shell scripts.
• Maintained good rapport with SME Subject Matter Experts during severity supports and break fixes.
• Provided and maintained daily DBA tasks such as alert, concurrent processes, table spaces, extents and security monitoring including SQL tuning, database refresh, backup/recovery and migrations.
• Designed and performed capacity planning, disk layout, and migration for our production system to an outsourcing environment.
• Archived and purged GL data to separate historical data from OLTP transactions utilizing application's Archive and external utilities such as Outerbay and Application for data retrieval. The success of this implementation ensured effective management of data growth.
• Migrated db2 udb data to Oracle database. Re-engineered the migration back to db2 utilizing automate scripts after manual steps.
• Generated ddls and exported the data from Oracle with comma delimiter, loaded the Oracle data in db2 and created all the Oracle objects in db2 udb.

Confidential

Oracle Applications DBA

Responsibilities:

• Led the installation, configuration and maintenance of multiple Oracle Applications 11i environment for many client engagements.
• Managed and applied all necessary patches to appropriate Oracle applications.
• Assisted in the planning of production rollouts for the Oracle applications 11.0.3 11i environment.
• Led performance monitoring and fine tuning of the system for optimal performance.
• Proactively planned, implemented, and managed all aspects of Oracle databases including change management and migration.
• Planned and implemented backup and recovery procedures for the Oracle applications systems.
• Planned and implemented timely upgrades to the Oracle applications systems.
• Mentored, and trained a team of systems analysts and developers on design, build and string testing of applications.
• Assisted in interviewing and retention of Oracle application DBA's and other application team members, including client team resources as requested.

Training:

• Maintain currency by participating in Oracle Technical Network including its blogs, webinars and online seminars
• Act as mentor and contributor on upgrades to the OTN body of knowledge 2002 to Present
• De facto certified in Oracle Apps, Oracle eBusiness, and Oracle Databases, SOA Fusion Middleware JDeveloper .