SUMMARY:

• Around 14 years of IT and over 8 yrs of specific expertise as Oracle Applications DBA. I have good experience in Production and Development support, upgrades and installs of 10.7SC, 11i, 12i Oracle Applications, as well as 8i and 9i, 10G and 11G databases. Proficient in System Analysis and Design and Development under Sun Solaris, HP - UNIX, Linux and Windows environments.
• Installing and Managing Oracle Databases, upgraded Oracle databases 10G, 9i, 8i and 7.3.4 applying the latest patch sets.
• Installed, Upgraded Oracle Applications from 10.7SC to 11.5.3 & 11.5.5, 11.5.7, 11.5.9, 11.5.10.2, 12i on Sun Solaris, HP-UX, Windows and Linux
• Providing 24/7 Production Support apart from regular support to development and Test instances
• Regular DBA activities including monitoring instances, db files etc
• Identifying bottlenecks and performance turning
• Experience in AWR and STATSPACK, import/export and SQLLoader
• Experience and knowledge with writing SQL, PL/SQL, packages, procedures and triggers, etc
• Cloning and Refreshing of the Applications and databases
• Provide users and developers support, Resolving Alerts and Oracle TAR’s
• Good working knowledge of AD utilities.
• System Administration of 11i.
• Applied Monitoring tools on the clients servers.
• Knowledge of SSO
• Excellent Remote Systems Support and Troubleshooting Exposure
• Managing Instances, Monitoring the database growth.
• Good working knowledge of iAS
• Handled customers across various Geographies of the world.
• Friendly & Co-operative Attitude, Team Player, Detail-oriented, Analytical and Self-driven Very Quick Learner.
• Outstanding Organizational, Communication & Presentation skills.
• Managing Backups and recovery
• Well versed with Managing of offshore/onshore team in Production support and handling of L1/L2/L3 tickets and Supported Oracle Financials
• Performed lead roles, done hands-on implementation, Upgrades and support for Oracle APPS DBA support activity and upgrading oracle Apps from (Version 11.5.x to 11.5.10.2(with 9i to 10g) and R12. Workflow and Discoverer troubleshooting
• Documentation and User
• Proficient with Oracle Grid Control

TECHNICAL SKILLS:

Hardware/OS: SUN SOLARIS UNIX (v5.8, 9, 10), VAX/VMS, LINUX Red Hat Enterprise AS/ES (, 2.1, 3), DEC ALPHA UNIX v4D, HP-UNIX (v11.0, v10.20), IBM AIX 6, WINDOWS NT v4.0, Windows 98, Windows 2000 Advanced Server

Data Base: Oracle 9i, 8i, 7.3.4, 10G, SQL Server 2005, 2008

ERP & Applications: Oracle R12 | 11.5.10.2 | 11.5.9 | 11.5.8 | 11.5.5 |11.5.4| 11.0.3 | 10.7 |Manufacturing, Financials etc

Special Software/Tools: Pro*C, SQL*Navigator, OEM Grid Control, TOAD, Putty, DBArtisan, Exceed, Remedy, RMAN, DBA Studio, Kintana, Symantec i3, dataguard, OAM, ETL

Languages: C, SQL, PL/SQL.

Protocols: Cisco VPN, Microsoft native VPN, Shiva-Intel VPN

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications DBA

Responsibilities:

• Providing Support to Production, Development and Test Instances on Multinode Oracle Appliccations 11.5.10.2 for Financials, HRMS and Self-Service Modules
• R12 installation and configuration
• Monitoring of Applications and databases and effective handling of tickets
• Oracle Applications System administration activities
• Monitoring and troubleshooting Workflow .
• Upgrade of databases from 9i to 10g
• Prepared and implemented Cloning, Patching strategies including application of language patches and translations.
• Daily Activities (Monitoring OS File system usage, Concurrent Managers, alert logs, Concurrent Managers logs, Tablespaces, Web, Forms and Reports Services.)
• Managing concurrent programs - setting up Personalizations and creating adhoc queries
• Managing Discoverer
• Using AD utilities extensively like ADPATCH, ADADMIN, ADMERGE, and ADCTRL etc
• Handling Application Security like users, menus, responsibilities etc for Core Financial, HR, Self-Service modules
• Migrating responsibilities, Menu, functions etc using FNDLOAD
• Establish policies and procedures for Off-Shore Support as well

Environment: Linux, Oracle9i, Oracle 10g, Oracle Applications 11.5.10.2Oracle GL, AP, AR, FA, HRMS, iStore, iProcurement, iExpenseDiscoverer, Toad, OEM Grid Control, OAM, Sql Navigator, SQL Plus.

Confidential, Jacksonville

Oracle Apps DBA/DBA

Responsibilities:

• Providing Support to Production, Development and Test Instances on 10g
• Upgrade of databases from Oracle ver 9i to 10g
• Managing the activities on the SQL Server databases version 2005 and 2008
• Daily Activities (Monitoring OS File system usage, Concurrent Managers, alert logs, Concurrent Managers logs, Tablespace usage, tns, Web, Forms and Reports Services.)
• Code Migration, Discoverer WB and WA Migrations, SR related activities and Documentation
• Good knowledge in using AD .
• Application of Database and Application patches
• Involved in cloning and Patching and database refreshes
• Responsible for 24/7 production supports.
• Responsible for providing daily maintenance supports such as proactively monitoring database activities, health check, performance tuning, daily and weekly backup
• 10g OEM grid control, ADDM & AWR, TOAD, Kintana etc

Environment: Solaris, Sql server 2005, 2008 Oracle9i, Oracle 10gOracle Applications 11.5.10.2, Oracle GL, AP, AR

Consultant -Sr. Oracle Applications DBA

Confidential, Jacksonville, Florida

Responsibilities:

• Providing Support to Production, Development and Test Instances on 11.5.10.2
• R12 installation and configuration
• Monitoring of Applications and databases and effective handling of tickets
• Oracle Applications System administration activities.
• Upgrade of databases from 9i to 10g
• Prepared and implemented Cloning strategies
• Identifying bottlenecks and performance turning of sql
• Involved in cloning and Patching and database refreshes
• Daily Activities (Monitoring OS File system usage, Concurrent Managers, alert logs, Concurrent Managers logs, Tablespace usage, tns, Web, Forms and Reports Services.)
• Code Migration, Discoverer WB and WA Migrations, SR related activities and Documentation
• Using AD utilities extensively like ADPATCH, ADADMIN, ADMERGE, and ADCTRL etc
• Establish policies and procedures for staff
• Analyze data quality and usage
• Identify user requirements and add new users as needed

Environment: Solaris, Oracle9i, Oracle 10g,, Oracle Applications 11.5.10.2Oracle GL, AP, AR, OM, HRMS, BOM,INV, WIP etcSymantec i3, Toad, OEM Grid Control, OAM, Sql Navigator, SQL Plus.

Sr. Consultant -Oracle Applications DBA

Confidential

Responsibilities:

• Took part in Upgrading Oracle Applications 11.5.9 to 11.5.10.2
• Providing Support to Production, Development and Test Instances on 11.5.9 and 11.5.10.2 instances
• Prepared and implemented Cloning strategies
• Involved in Patching and Refresh of Databases on regular basis
• Using AD utilities extensively like ADPATCH, ADADMIN, ADMERGE, and ADCTRL etc
• Involved in Planning of the upgrade and conversion from Single Node to Multi-Node
• Daily Activities (Monitoring OS File system usage, Concurrent Managers, alert logs, Concurrent Managers logs, Tablespace usage, Web, Forms and Reports Services.)
• Performance tuning of long running sql queries

Environment: Solaris, Oracle9i, Oracle 10g,, Oracle Applications 11.5.9, 11.5.10.2Oracle GL, OM,BOM,AP, HRMS, AR, Payroll etc, Toad, OEM Grid ControlOAM, Sql Navigator, SQL Plus, Sql server 2005

Principal Consultant - Oracle applications DBA

Confidential

Responsibilities:

• Upgrading oracle applications 11.0.3 to 11.5.10.2
• Implemented HRMS modules
• Experience with applying HR Global patches and updates
• Providing support to 11.5.9 and 11.5.10.2 Oracle Applications and their databases
• Managing Instances, Monitoring the database growth
• Regular Cloning and Patching of Production, development and test instances
• Instrumental in developing standards, strategies and procedures
• Daily Activities (Monitoring OS File system usage, Concurrent Managers, alert logs, Concurrent Managers logs, Tablespace usage, tns, Web, Forms and Reports Services.)
• Provided 24/7 on - call support
• Using AD utilities extensively like ADPATCH, ADADMIN, ADMERGE, and ADCTRL etc

Environment: Solaris, AIX, HP-UX 11,Windows NT, 2000,MSDOS, Linux, Oracle9i8i, Oracle Applications 11.5.9, 11.5.10.2 Oracle GL, AP, AR, HRMS, Fixed

Sr.Consultant- Oracle Apps DBA

Confidential, Omaha, NE

Responsibilities:

• Maintaining Oracle Applications 11.5.9 and its database
• Created strategies for Cloning and Patching and mentored the DBA’s.
• System administration tasks
• Perform System admin tasks, ADI installation and configuration, Application of patches, Family Packs, Mini-packs
• Mentored the junior DBA to effectively handle the cloning and subsequent maintenance of Oracle Applications.

Environment: HP-UX 11,Windows NT, 2000,MSDOS, Linux, Oracle9i8i,Oracle Applications 11.5.9,Oracle GL, AP, AROracle Configurator, Advanced planning & schedulingAdvanced Queuing

Consultant - Oracle Apps DBA/ DBA

Confidential, Virginia

Responsibilities:

• Providing 24/7 Production support to 11.5.9 Oracle Applications and their databases
• Upgrading databases from 8i to 9i, 9.2.0.3 to 9.2.0.5
• Involved in installs, upgrades, applying patches
• Refresh of Databases, Cloning and Extensive Patching.
• Provided 24/7 on - call support

Environment: SUN Solaris 2.6,2.8, HP-UX 11.0, Linux, Windows 95/98/NT2000, MS DOS, Linux, Oracle 9i, 8i, Oracle Applications 11.5.9Oracle GL,AP,AR,OM,HRMS, Oracle Purchasing

Consultant - Remote DBA

Confidential, Boise, Idaho

Responsibilities:

• Managing concurrent processes and concurrent managers.
• Upgrading databases from 8i to 9i
• Upgrading applications from 10.7SC to 11.5.3,11.5.7, 11.5.9
• Providing 24/7 Production support to 10.7SC, 11.5.3, 11.5.9 Oracle Applications and their databases
• Refresh of Databases, Cloning and extensive Patching
• Assessment of databases for the clients and provide recommendations
• System Administration of 11i.
• Managing Instances, Monitoring the database growth.
• Daily Activities (Monitoring OS File system usage, Concurrent Managers, alert logs, Concurrent Managers logs, Tablespace usage, tns, Web, Forms and Reports Services.)
• Using AD utilities extensively like ADPATCH, ADADMIN, ADMERGE, and ADCTRL etc
• Developed various scripts to automate the regular activities like start, stop concurrent managers, cleanup log and report directories.
• Maintaining Backups via crons, and plans for recovery

Environment: SUN Solaris, AIX 4.2, HP-UX 11.0, Linux, Windows 95/98/NT2000, MS DOS, Linux, Oracle 9i, 8i, 7.3.4,Oracle Applications 10.711.5.7, 11.5.9, Oracle CRM,GL,AP,AR,OM,HRMS, Oracle Purchasing

Oracle Applications DBA/ DBA

Confidential, Knoxville, TN

Responsibilities:

• Production and Development support for Oracle Applications 11.5.7
• Responsible for logical database design, sizing and implementing
• Patching the Applications
• System Administration of 11i.
• Document performance response times from current production instance
• Cloning of the Applications
• Creating TARs and follow-up with the Oracle.
• Managing concurrent processes and concurrent managers.
• Setting up of printers
• Support to Production Databases that includes Oracle database in OLTP environment and Oracle Applications Database.
• Managing Instances, Monitoring the database growth.
• Security for database and application by defining roles, views, synonyms.
• Writing Database triggers, stored procedures etc
• Creation of Schema objects & Space management

Environment: Sun Fire 15K/ Solaris 8, Windows NT/95/98/2000, Oracle 8i, 9iOracle Applications 11.5.7, SQL*LOADER, SQL*Navigator, TOADOracle Forms 6i, Reports 6i

Applications DBA /Oracle DBA

Confidential, Atlanta,GA

Responsibilities:

• Responsible for logical database design, sizing and implementing
• Physical administration and support of application databases on oracle
• Complete configuration of Oracle Application 11i and configured Forms server, Apache server and Reports server etc
• Worked with Ad hoc queries, Concurrent process
• Document performance response times from current production instance
• Meet key Current Users and document other performance pain areas
• Document scenarios for the new instance after discussions with key users
• Provided support for a number of concurrent users.
• Patching and Cloned Oracle Applications
• Support to Production Databases that includes Oracle database in OLTP environment and Oracle Applications Database.
• Additional cost cutting efforts by setting up the external monitoring, which monitors the event ranging from database issues to network glitches, as well as server failures.
• I was involved in planning backup and recovery strategy of the databases, day-to-day DBA technical support for a number of applications, including space management, database troubleshooting and diagnosis, monitoring and tuning system’s performance.
• Responsible for database security issues. Planned and allocated space for databases for various ORACLE applications.

Environment: Sun Solaris 2.6, HP UNIX 11, Windows NT/95/98/2000, Oracle 7.3 /8i