SUMMARY:

• A seasoned enterprise Senior Oracle Apps DBA with 15 years of extensive IT experience working with Oracle Apps and Oracle databases and Project Management. Can handle effectively and efficiently any Implementations, Upgrade/Migrations of any Oracle Application Versions.
• Extensive experience in Oracle Applications Releases (10, 11 and 12).
• Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, BOM, MRP, WIP, and I Procurement.
• Converted the existing table spaces structure to OATM.
• Provided support to over 20 Development, Test and Production Oracle Apps Databases Size from 500GB to 4TB and 14000 users.
• Automating scripts for DBA Tasks, Capacity Planning, Database Backup and Recovery (RMAN).
• Implemented Appworx / UC4 Job Scheduling tool for better manageability and automation of 10000 jobs.
• Successfully moved several datacenters troubleshoot firewall issues, port issues and network domain issues.
• Upgraded to Oracle Apps Release 12.1.1 from 11.5.10.2 and also the database from 10.2.0.4 to 11.1.0.7.
• Provided patching support for 11.5.10.2 in 9 foreign languages
• Implementation of Oracle Advanced Supply Chain Planning ASCP and Oracle Configurator.
• In charge of change management system and Release Magement System. Member of downtime reduction team.
• Performance tuning, large table Reorg and data purging. Analyzing traces, sql tuning, explain plans, index management, AWR reporting. Sql tuning. Gather stats.
• Implemented physical and logical Stand by database using data guard.
• Installed and configuration of Oracle Enterprise Manager 10g/11g. OEM monitoring and configuring alerts.
• Implemented Oracle Fusion.

TECHNICAL SKILLS:

Oracle Applications ERP: Oracle Apps 12.1.1/12.0.6/11.5.10.2

Oracle Databases: 7.3/8i 9i/10g/11g. PLSQL / SQL

Middleware: Oracle Application Server 9i / 10.1.2 / 10.1.3, Oracle Fusion, Web logic.

Tools: oracle warehouse builder (OWB), Oracle discoverer, oracle portal, business intelligence (OBIEE). Appwrox. /UC4 job Scheduler. HP archiving tool. Hotsos Profiler.

Operating System(s): Linux AS, Sun Solaris, Windows, HP - UX, AIX, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Senior Oracle Apps DBA

Confidential, Austin, TX

Responsibilities:

• Responsible for providing 24x7 Oracle Apps DBA support for multiple large Oracle Apps databases in production, development and test environments. Managed a team of 15 Apps DBAs for Design, Development and Production support and Performance tuning. Managing HPOV tickets, Request for Change (RFC) tickets and Approval for patching and instance maintenance.
• Implemented Oracle Applications Releases (11.5.10.2, 12.0.6 and 12.1.1) and Oracle Databases (7.x,8.x,8i.x,9i.x and 10g.x), Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, CM, HR/Payroll, BOM, MRP, WIP, and I Procurement. Oracle Advanced Supply Chain Planning and Oracle configurator.
• Project Manager for Apps DBA team and Performance team, develop process for performance improvement and proactively identify poor code and tune it, analyze traces, Index Management, AWR report, Explain plan and Hotsos performance tuning tool.
• Oracle Application DBA support, applying patches, mini-packs, family-packs and maintenance packs, upgrades, multi-tier installations, automatic routines Apps DBA task, periodic refreshes, oracle support dealing with functional, developers and end users.
• Enabled Spanish Language, Brazil Portuguese, and Simplified Chinese on Oracle Apps 11.5.10.2 and applied the requisite patches.
• Converted the existing table spaces structure to OATM .Installed OEM grid control and configured EBS databases for monitoring concurrent managers, forms sessions, database locks, invalid objects and JDBC connections.
• Creating Custom Concurrent Managers and Assigning Work shifts to it. Finding long running requests and terminate them if needed. Troubleshooting problems with web server, web listener, workflow, forms server, and concurrent managers, and database.
• Upgraded to Oracle Apps Release 12.1.1 from 11.5.10.2 and also the database from 10.2.0.4 to 11.1.0.7 in Development instances.
• Change Management / Release Management. Resulting performance boost of 20% and production downtime reduction.
• Implement and configured Appworx /UC4 Job Scheduling tool for better manageability and inter job dependency and self-compatibility. Automated 10000 jobs using UC4.
• Designed and Implemented Oracle Disaster Recovery Solutions using Oracle 11g Data guard Physical and logical. With auto failover feature.
• Installed and configured oracle Apps in RAC environment. Configured ASM on 11g.

Senior Oracle Apps DBA

Confidential, Austin, TX

Responsibilities:

• Install and maintain Oracle Applications 11.5.10.2 in complex environments such as Single-node and multi-node installations. Implemented all financial & manufacturing modules such as GL, AR, AP, PO, INV, BOM & WIP.
• Applied latest releases of the patches using AD utilities from Oracle. Cloning the instances from production to test, development instance to test & simulate technical challenges, coordinate with testing and development teams.
• Managing the concurrent Manager Queues and resolve workflow issues. Purging and reorg large tables. Implemented HP Archive tool for data archiving.
• Supported over 50 production/ development/ testing Oracle Apps environments, sizes ranging from 500 GB to 4TB GB running on 30 servers Oracle ERP, OLTP and data warehouses with OS as Linux, AIX, Solaris and Windows.
• Upgraded the Oracle Applications 11.5.8 to 11.5.10.2, database to 10.2.0.3 from 9.2.0.6 on Sun Solaris
• Installed OEM and configured alerts. Written/Modified shell / Sql scripts to monitor and maintain the Oracle Applications database.
• Monitor database alert log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization. Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.

Senior Oracle Apps DBA

Confidential, Austin, TX

Responsibilities:

• Support and maintain 16 Oracle Applications 11.5.14 instances including production.
• Responsible for patching of Oracle Applications instance and its maintenance

  Applying Apps, RDBMS patches and tech-stack patches and used lot of techniques to reduce the patching downtime. Managed system configuration using Autoconfig.

• Configure JVM and Jserv processes for load balancing.
• Performing pre-patch analysis and pre-config analysis. Apps system administration Managing application user accounts and responsibilities and database user accounts
• Change Management and Release management. Conduct performance load test.
• Bouncing the instance as per customer requirement. Monitoring the instances Worked as a shift lead in pre patch analysis and patching team. Organizing team meeting and co-ordinate with other team leads
• Administered and provided production DBA support to the several databases of Financial Data Warehouse. Supported month end, period end and Annual closings.
• Configured database for managing customer addresses using group one / Address doctor software. Implemented Trades spear compliance software to restrict shipping to blacklisted countries.
• Minimized 20% downtime by emerging patches to Patch bundle.
• Performed Oracle Gateway / HSODBC configuration for MSSQL and DB2 servers.
• Migrated Oracle Application 11.5.4 from windows to Linux environment.

Oracle Apps DBA Consultant

Confidential

Responsibilities:

• Served as Consultant Oracle APPS DBA and Project Manager at several client companies like Sony, Citibank, Emerson and GE. Managed a team of 10 Apps DBAs and Developers.
• In-charge of the Oracle Applications and has lead the Upgrade on the Applications and database from 11.5.8 to 11.5.9.
• Involved in R11.5.9, 11.5.8, 9i and Tech-stack new enhancements end to end verification

  Installation Testing.

• Tackling all the day-to-day issues for maintenance of Oracle Applications and the Databases.
• Applying family packs, Rollups, Minipack and one-off patches accordingly.

  Cloning Oracle Applications experienced with different cloning skills like manual, adclone and Rapid clone. Creating, updating and monitoring TAR activities.

• Jinitiator upgrade from 1.1.8.16 to 1.3.1.21
• Gather requirements submit proposal for clients. Design and built environments for Dev. / Test and Production.
• Management solution in Oracle database for NG Transco helping the company save significant amounts in setting up the trainee and trainer groups.
• Build new database environments, taking base lines and restoring base line, table space management, and user role management.
• Performed installation and configuration of 9iAS. Installation of OC4J.9ias Forms / Report Server configuration.

Oracle DBA

Confidential

Responsibilities:

• Provided Oracle DBA support for 6 APGENCO production databases and 15 development & test databases. Lead of a 4-member DBA team.
• Automated the Billing system using Oracle database for billing various customers. Implement solution to provide accurate billing and save lot of money for company.
• Implemented Purchase Order Management for procurement division and Inventory Management for Stores.
• Designed and created database for e-tender online request to quote.
• Created Database and provided DBA support for Apgenco online portal.
• Provided technical leadership in all areas of technical writing. Have configured scripts in Perl, PL/SQL and Unix scripts to proactively handle Database alerts in areas of Table space usage, mount point usage, Database level auditing etc.
• Cloned databases with various strategies like Hot, Cold, Logical methods and RMAN.
• Resolving issues faced by Application team by analyzing PL/SQL code etc and give resolution details and root cause analysis. (RCCA)
• Implemented backup and recovery solutions using export / import and cold and hot backups. Configure using the Cron tab.
• Mentored DBA support to the Application Developer’s in resolving the Oracle related issues.

Oracle DBA/Database Designer

Confidential

Responsibilities:

• Designed and created database for Payroll system for KTPS employees.
• Responsible for the installation and setting up of the Oracle 8i on UNIX box.
• Responsible for storage management - Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Involved in designing and creating reports using Pro*C.
• Developed database design standards and database objects naming convention.