SUMMARY

• Specialized in Oracle Applications R12/11i Database and System Administration with 6 over years’ experience in Oracle under UNIX environment.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications
• Experienced and proficient with Oracle E - Business suite application (R 12 12.1.3/12.1.1/12.0. x, 11.5.7, 11.5.8, 11.5.9 and 11.5.10) and Oracle Applications Server (9i/10g) in Sun Solaris, Oracle Enterprise Linux,Red Hat Linux, AIX and Windows environment
• Expertise in upgrading Oracle Applications from 11.5.10.2 to 12.0.4/12.1.1/12.1.3
• Performed database installation and upgrades. Experience in setting up HTTP Load Balancing
• Expertise in Implementing SSL for Oracle E-Business Suite Applications
• Expertise in implementing Shared APPL TOP and PCP
• Expertise in troubleshooting Workflow and Notification Issues
• Implemented Sabrix Taxing Software and integrated with 12.0.4 Applications
• Expertise in installing Discoverer and integrating to ERP Applications
• Implemented 10g Grid Control and applied Applications Management Pack for monitoring Applications
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues
• Proficient in Oracle tools and utilities (Net8, Svrmgr, WebDB, OAS 4.0.8, Data Browser, Developer Suite, Export, Import, SQL*Loader, PL/SQL, OEM, IA, SQL Navigator, DB Artisan, ER Studio, Glance, SQL Expert) in UNIX (Sun Solaris, AIX, HP-UX) & Windows environment.
• Experience in general troubleshooting, fire fighting, development of scripts, documentation, issue resolution, and TAR/SR support
• Well versed in implementing System Management and Monitoring procedures
• Strengths include skills in Shell Programming, SQL, SQL*Loader, Import/Export and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings
• Experience in Security Management and Database Auditing
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX)
• KBACE, Vertex Payroll Tax Patching
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues
• Jinitiator to JRE upgrade
• Skilled in handling a heavily customized 11i applications and upgrades
• Applying RDBMS and Application patches. Sound knowledge in AD Utilities
• Enabling Multi Org, MRC, NLS settings
• Monitor system performance, identify bottlenecks and ensure problem resolution
• Capable of tuning SQL using EXPLAIN PLAN, tracing at user level and TKPROF
• Work independently to ensure that the databases are operating efficiently and ensure proper backup and disaster recovery methods are maintained
• Experienced in Space Management, Memory Tuning and Application Tuning
• Troubleshooting expertise for all tiers (client, middle-tier, database)
• Create and Maintaining the Technical Notes and Documentation.
• Efficient Team Player, hard working, good in analytical and logical problem solving abilities with excellent communication skills.

TECHNICAL SKILLS

Hardware Platforms: Sun SPARC (E10000, E3500, E250, SUN Ultra and R Class), IBM AIX, IBM compatibles (IBM AIX 5L/4.3), Dell poweredge

Operating Systems: RedHat Linux 4/3, Oracle Enterprise Linux 5.5, UNIX (HP UX 11/10.1/10.20 , Solaris 8/2.4/2.6/2.7 , SCO, IBM AIX 5L/4.3), MS-WINDOWS XP/2000, MS-WINDOWS NT 4.0 Enterprise edition

Database: ORACLE 11g/10g (10.2.0.3), 9i (9.2.x), 8i (8.1.x)/8.0

Forms Servers: Developer 10g/9i, dev2000 (1.6.1 and 1.3.2, 1.5.1), Dev6i

Application Servers: 10gAS (10gR2, 10gR3), IAS (10222)

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Applications: Oracle Applications R 12 12.1.3/12.1.1/12/0. x, 11i (11.5.7, 11.5.8, 11.5.9, 11.5.1011.5.10.2 ), JDA, Vertex, EZTax, Moneta

Modules: AOL, GL, INV, AR, AP, PO, Iprocurment, HRMSSupply chain modules,Order Management, Install Base, iStoreIPayments, BI Dash board

GUI: DEVELOPER 6i, ADI, OAM, OEM, Kintana, Quest Stat

Tools: and Utilities: Oracle Tools OEM/OAM, SQL*PLUS And third party tools like Clear orbit, Jet forms, Quest Software (TOAD, SQL Lab) etc

Advanced Technology: Distributed Databases (Advanced Queuing, Materialized views), High Availability Options (Real Application Cluster (RAC) and Standby Databases) and Performance (Database, locking, parallel execution, partitions and SQL tuning)

PROFESSIONAL EXPERIENCE

Confidential, Centennial, CO

Sr. Oracle Apps DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to R12.1.3
• Provided go-live support for upgraded Oracle Applications
• Cloning and Patching of Oracle Databases and Oracle Applications 11i/R12
• Troubleshooting the issues raised by user community and development
• Jinitiator to JRE upgrade
• Responsible in platform migration of Oracle Applications R12.
• Performed System Administration activities
• Worked on Java Mailer configuration and Workflow Administration
• Monitoring the file systems on production environments
• Resolving issues related to Web server, forms, reports, Discoverer.
• Perform Applications administration using AD utilities
• Discoverer 10g Installation and configuration, EUL upgrade and refresh.
• Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Developing UNIX and sql scripts for the smooth functioning of database and applications related issues
• Supported the 2- node, 3-node, 4-node RAC environment.
• Configured load balancing on Apache and Forms Servers
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs using scripts and tools like Explain plan, Tkprof & Stats pack.
• Monitored databases and applications using Oracle Enterprise Manager (OEM) /Oracle Applications Manager (OAM)
• Configured backup of ERP systems using RMAN.

Environment: Oracle Applications 11i (11.5.10.2), R12.1.3, Oracle 10g/11g, Sun Solaris10, Oracle Enterprise Linux, RHEL, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, San Diego, CA

Sr. Oracle Apps DBA

Responsibilities:

• Monitoring the Oracle applications and provided 24x7 On-call support
• Managing the patches and dealing with Oracle Support for many production and test/development Instances.
• Cloning of Oracle Applications 11i RAC to RAC and RAC to Non RAC.
• Upgraded Oracle Applications from 11.5.10.2 to R12
• Upgraded 9i database to 10g (10.2.0.4) database
• Post go-live support of Oracle Applications R12
• Maintenance of 10g databases and other non-ERP Databases
• Implemented parallel concurrent processing in R12
• Configured ASM on one of the Prod OLTP instance.
• Cloning DEV and UAT instances from Production for testing
• Providing support for Oracle applications and also JDA, Vertex, EZTax, Moneta, Ariba.
• Implementing and troubleshooting of forms server, report server, Discoverer server, Web Server.
• Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Worked on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listeners running, disk space availability, checking for errors in alert logs etc.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc
• Worked on Application system Administration. Activities like user setup, defining responsibilities, values sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs.
• Implemented Dataguard (Physical Standby database set up in production)
• Successfully implemented 3-node RAC setup and made the environment stable
• Configured load balancing on Apache and Forms Servers
• Applied the patchsets, oneoff patches, opatch to the Development and production servers
• Monitoring of databases using 10g OEM grid control
• Implemented the Oracle E-business suite Application Management Pack on OEM
• Implemented Shared APPL TOP
• Troubleshooting the issues raised by oracle ERP from both user community and development
• Taking care of the performance issues both at the database level and applications level
• Scheduled the backups using RMAN and disk backups
• Recovering the databases at critical situations
• Worked with Oracle Support on resolution of SRs
• 24x7 on call support for Oracle ERP applications and production databases

Environment: Oracle Applications 11i (11.5.10.2), R12, Oracle 10g, Sun Solaris10, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, St.Louis MO

Sr. Oracle Apps DBA

Responsibilities:

• Monitoring of multiple production instances of versions R12 & 11i residing on various Operating systems such as Linux, HP-UX.
• Supported 4 highly volume based production instances and 10 dev and test systems.
• Multi-node installation of R12 applications.
• Upgraded applications from 11.5.10 CU2 to R12.
• Patching and Cloning of Oracle Applications using adpatch &Rapid clone utility.
• Monitored databases and applications using Oracle Enterprise Manager (OEM) /Oracle Applications Manager (OAM)
• Configured backup of ERP systems using RMAN.
• Developed Shell Scripts for daily monitoring of databases, Applications, RMAN backup and backup validate.
• Supported the 2- node RAC environment.
• Upgraded database from 10.2.0.4 to release 11.1.0.6
• Discoverer 10g Installation and configuration, EUL upgrade and refresh.
• Providing high database availability and data protection using Data Guard.
• Installed Oracle Data Integrator 10.1.3.5 to integrate with PeopleSoft GL modules.
• Configuring and tuning concurrent managers.
• Perform system administration tasks like application AOL object setup (users, menus, responsibilities, forms, reports, folders, request groups, request set etc.) and Purge AOL tables.
• Responsible for Java Mailer Configuration and Workflow Administration.
• Creation of new users and assigning of responsibilities.
• Successful set up of a new custom Schema and making it fully functional.
• Analysis and application of both apps and database patches.
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs using scripts and tools like Explain plan, Tkprof & Stats pack.
• Assisting users in resolving the printer related issues and setting up new printers.
• Developed Unix Shell scripts and SQL queries
• Worked on TAR, coordinating with Oracle for SEV 1/2 issues.
• Provided 24 x 7 on call support for Production databases.

Environment: Oracle Applications R12 (12.1.1/12.0.6 ), 11i (11.5.10.2), Oracle 9i/10g,Sun Solaris 8, Netapps, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential

Oracle Apps DBA

Responsibilities:

• Created and monitored the concurrent managers.
• Allocating system storage and planning future storage requirements.
• Cloning of Database and Applications as per functional requirements.
• Oracle Applications upgrades, patches using various AD utilities
• Troubleshooting and on-call support (7x24)
• Resolving system errors, diskspace problems, huge file sizes errors
• Monitoring Oracle Applications users
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc.)
• Developing UNIX and sql scripts for the smooth functioning of database and applications related issues
• Tuned the database and applications using EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF STATSPACK (advanced version of UTLBSTAT and UTLESTAT).
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Monitored the Applications and database using OAM.
• Rebuild the indexes and dropped unused indexes.
• Setting up the printers in Application environment.
• Upgraded JDK 1.1 to 1.3.1
• Troubleshooting throughout the project phases and TAR Management
• Effective use of Oracle Web cache with multiple applications.
• Capacity Planning/Management (space/machine load/network)
• Moved the objects from one instance to other using FNDLOAD.
• Performed Application admin tasks using ADADMIN utility
• Cloning of Database and Applications
• Prepare and implement system management and maintenance procedures
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server

Environment: Oracle Applications 11i (11.5.9), Oracle 8i/9i, HP UNIX TRU-64,, SQL Loader, Toad, Oracle Discoverer, JDK 1.1/1.3.1

Confidential

Oracle Database Administrator

Responsibilities:

• Installed Oracle 8.0, Forms Server, Implemented ODBC features
• Created databases & objects, configured Forms server
• Created additional table spaces, Rollback Segments, Redo log Groups for production support
• Creating the web documents using Active Server Pages 2.0
• Writing the front-end validation using the Java-Scripts/VB-Scripts.
• Configured SQL*Net for Oracle
• Created additional table spaces, Rollback Segments, Redo log Groups for production support
• Implemented more effective backup procedures of databases
• Created tables, views, Synonyms, Database links, Snapshots and Indexes
• Allocated system storage and planned for future storage requirements for the database
• Enrolled users, maintained system security, monitored user access to the database by assigning profiles and roles
• Running the database on ARCHIVELOG Mode and Mirroring control files
• Responsible for maintenance and troubleshooting the database
• Performance monitoring and tuning
• Used Data Definition Language (DDL) to create, alter and drop tables, Views, sequences, and indexes. Used Data Manipulation Language (DML) to issue SELECT, INSERT, UPDATE, DELETE statements including Sub-queries
• Created different kind of constraints on table established Referential integrity between tables

Environment: Oracle 8i, OEM, SQL*plus, Imp/Exp, RMAN, SQL, PL/SQL, SQL*loader, TKProf