SUMMARY

• Specialized in Oracle Applications R12/11i Database and System Administration with over 10 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.
• Lead and maintain efficient and highly available operation of WebLogic,SOA suite and Portal environments.
• Manage, administer and control system responsibility.
• Lead, install, configure and manage user interface and application Program interfaces, certificate, keys and secure connections between external entities and EBS for B2B transactions..
• Lead, install, configure and manage the use of OAM/with web applications, including those of Oracle and Custom - built.
• Experienced and proficient with Oracle E-Business suite application (R12 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, Red Hat Linux, AIX and Windows environment
• Experience in Hang Analysis of Oracle Databases, Creating System State Dump, AWR analysis,SQL Tuning and Trouble shooting,RMAN configuration,Trace files analysis, Backup and Recovery skills Dataguard,Setup DB upgrades in very Complex PROD environments.
• Expertise in upgrading Oracle Applications from 11.5.10.2 to 12.0.4/12.1.1
• Familiarity with protocols - HTTP, ftp, sftp, certificate/key based authentication, ssl
• Expertise in Windows - batch files, scripting, setup/configuration of web applications on IIS
• 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 Vertex Taxing Software and integrated with 11.5.10.2 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, Data Browser, Developer Suite, Export, Import, SQL*Loader, PL/SQL, OEM, IA, SQL Navigator, 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
• Lead/supervisory experience, responsible for leading the technical team, making assignments and being the point of contact for technical questions in regards to the project
• 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)
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues
• 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 dat 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.
• Coordinate with offshore resources

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, 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, 7.3.2, 6.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 R12 12.1.1/12/0.x, 11i (11.0.3,11.5.7, 11.5.8, 11.5.9, 11.5.10,11.5.10.2),Vertex

Modules: AOL, GL, INV, AR, AP, PO, Iprocurment, HRMS,Supply chain modules,Order Management, Install Base, iStore,IPayments, BI Dash board

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

Oracle Tools: OEM/OAM, SQL*PLUS And third party tools like 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

Sr. Oracle Apps DBA/APPS DBA Team Lead

Confidential, Goleta,CA

Responsibilities:

• Oracle Applications DBA experience in Oracle products, both production and development,Patch,QA and Stage environments.
• Installed Oracle Enterprise Manager (OEM Cloud Control 12c) to manage around 100 Oracle databases.
• Cloning the Development and Test EBS databases from Production.
• Moving the Custom code to Production from QA .
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Experienced and proficient with Oracle E-Business suite applications (12.2.3 and 12.1.3) and Oracle Applications Server (11g) in Exadata Quarter RAC Machines.
• Expertise in implementing Shared APPL TOP and PCP.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Very strong in Auto Patch(ADOP), Upgrade, Cloning and Oracle Applications Manager.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Expertise in configuring Workflow Mailer and applying security patches.
• Exposure to Fusion Middleware components like SOA and Weblogic.

Sr. Oracle Apps DBA/APPS DBA Team Lead

Confidential, Dallas,TX

Responsibilities:

• Oracle Applications DBA experience in Oracle products, both production and development,Patch,QA and Stage environments.
• Installed Oracle Enterprise Manager (OEM 11g) Grid control to manage around 100 Oracle databases.
• Running backup scripts in SQL*Server using SSMS(SQL Server Management Studio).
• Managing Web Servers using IIS .
• Installing/Upgrade of Peoplesoft tools 8.49 and Managing Peoplsoft Databases HRMS,HRQC,HRDEV90.
• Cloning the Development and Test EBS databases from Production.
• Moving the Custom code to Production from QA .
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Experienced and proficient with Oracle E-Business suite applications (12.1.1, 12.1.2, 12.1.3) and Oracle Applications Server (11g) in Red Hat Enterprise Linux..
• Expertise in implementing Shared APPL TOP and PCP.
• Worked on most of the Application modules like Financial, AR, AP, PO, IREC, OE, GL, INV, GRC, OM, Manufacturing, HR Payroll, Time & Labor and Workflow etc.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Very strong in Auto Patch, Upgrade, Cloning and Oracle Applications Manager.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Expertise in configuring Workflow Mailer and applying security patches.
• Mananging Peoplesoft HRMS 9.1 and MySQL databases.

Sr. Oracle Apps DBA

Confidential, ristol,VA

Responsibilities:

• Oracle Applications DBA experience in Oracle products, both production and development,Patch,QA and Stage environments.
• Cloning the Stage EBS database from Production every weekend.
• Moving the Custom code to Production from QA using SVN Install utility.
• Managing the GRC databases CCG and AACG for Governance,Risk and Compliance Manager.
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Experienced and proficient with Oracle E-Business suite applications (12.1.1, 12.1.2, 12.1.3) and Oracle Applications Server (11g) in Red Hat Enterprise Linux..
• Experienced with OEM, ASM, RAC and Data Guard.
• Expertise in implementing Shared APPL TOP and PCP.
• Worked on most of the Application modules like Financial, AR, AP, PO, IREC, OE, GL, INV, GRC, OM, Manufacturing, HR Payroll, Time & Labor and Workflow etc.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Very strong in Auto Patch, Upgrade, Cloning and Oracle Applications Manager.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Expertise in configuring Workflow Mailer and applying security patches.

Sr. System Administrator/Sr. Oracle Apps DBA

Confidential, Schaumburg,IL

Responsibilities:

• Oracle Applications DBA experience in Oracle products, both production and development environments.
• Lead and maintain efficient and highly available operation of WebLogic,SOA suite and Portal environments.
• Manage, administer and control system responsibility.
• Experienced and proficient with Oracle E-Business suite applications (11.5.7, 11.5.8, 11.5.9, 11.5.10.2 and 12.0.4,12.0.6,12.1.1,12.1.2,12.1.3) and Oracle Applications Server (9i/10g/11g) in Sun Solaris, Red Hat Enterprise Linux, AIX and Windows environment.
• Experienced with OEM, ASM, RAC and Data Guard.
• Expertise in implementing Shared APPL TOP and PCP.
• Worked on most of the Application modules like Financial, AR, AP, PO, IREC, OE, GL, INV, GRC, OM, Manufacturing, HR Payroll, Time & Labor and Workflow etc.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Very strong in Auto Patch, Upgrade, Cloning and Oracle Applications Manager.
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Experience in administering Oracle Apps 11i, databases and upgrade from 11.5.8, 11.5.9 to 11.5.10 and 11.5.10.2 to R12 (12.0.4,12.0.6,12.1.1,12.1.2,12.1.3).
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Expertise in configuring Workflow Mailer and applying security patches.
• Used KINTANA for migration of custom programs, responsibilities, custom codes etc.
• Expertise in managing application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration and printer setup.
• Troubleshoot problems related to Oracle databases and Oracle Applications 11i, R12 and perform root cause analysis.
• Experienced in Forms Load Balancing, Apache/Jserv upgrades SSL setups.
• Experienced in Multi Reporting Currencies, Multi Language Support, and Multi Organization Access Control and Multi Org setup.
• Experienced in Web technologies, coding the server side and client validation programs.

Sr. Oracle Apps DBA

Confidential, King of Prussia, PA

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to R12.1.2 and R12.1.1
• Good Knowledge on SOA, RCU, Jdeveloper, Weblogic Server,Managed Servers and Oracle Fusion middleware including BPEL, Business rules and ADF development using JDeveloper.
• Architected, installed and administered SOA Middleware components 11g Database on SOA Fusion Middleware for both SOA and BAM Servers.
• Configuring JVMs and Proxy servers for Load balancing.
• Upgraded Oracle AS from 10.1.3 to 10.1.5
• Database Upgrade from 9.2.0.6 to 10.2.0.4
• Database Upgrade from 10.2.0.4 to 11.1.0.7.0
• R12.1 Implementation on Single node and Multi node setups
• R12.1.1 to R12.1.3 Upgrade with 11gr1 to 11gr2 Database
• DMZ Setup and DMZ Clones.
• Migration of 32 bit EBS Database to 64 Bit on Linux Platform
• WebCenter 11g Installation and configuration
• SOA Suite 10g & 11g Installation and configuration.
• OA Clone from one node to another
• Performed various Apps DBA tasks
• Performance tuning of Oracle databases and EBS 11i instances.
• Rebuilding of Standby databases from Production.
• Upgrading JDK (java development Kit) & JRE
• Applying different types of Application and Database patches as per the requirements.
• Cloning of Oracle applications of Shared Appl Top and Shared Oracle Home
• Managing the backups through RMAN
• Creating Custom Tops.
• Monitoring of databases using 10g OEM grid control
• Implemented Shared APPL TOP
• Configuring Workflow mailer.
• Cloning of Oracle Applications 11i and R12.
• Single Node Clone and Mulitinode Clone.
• Applied Various Application patches, One-Off, Maintenance, Mini Pack & Family Pack.
• Applied RDBMS oracle patches for the Database Oracle Home.
• Taking Backups using RMAN.
• Upgraded JDK, Upgraded Jinitiator.
• Resolving the issues in RMAN Backup.
• Resolving day to day issues of the database and applications.
• Production support of 15+ clients under Managed Services
• Performance tuning of Oracle Database and Applications.
• 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. dis 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,
• Worked with Oracle Support on resolution of SRs
• 24x7 on call support for Oracle ERP applications and production databases

Sr. Oracle Apps DBA

Confidential, Lexington, KY

Responsibilities:

• Monitoring of multiple production instances of versions R12 & 11i residing on various Operating systems such as Linux, Windows NT.
• 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)
• Installing RPMs and Changing Kernal parameters in the Unix Operating systems.
• Using Unix operating system utilities top, sar and iostat to monitor the server performance.
• Maintaining the cluster ware components OCR and Voting Disk etc.
• Implemented CRM, AP, AR, GL, IProcurement, ASCP, Fixed Assets, Cash Management, PO,BOM, WIP, ONT, HR, Workflow, Telesales, Time and Labor Etc.
• Implementing Load Balancing between Oracle Application Servers.
• Running TUMS report for Upgrading 11.5.9 to 11.5.10 Technology stack.
• Running Patchsets.sh regularly to get the latest Mini-packs available and apply them if required.
• Generate AWR, ADDM, Statspack reports regularly to know the bottlenecks in the system and send them to Oracle support for analysis.
• Maintaining the Oracle RAC database features like OCR,GRD, Voting Disk and Command utilities like VLUCFY, CRSCTL, OCRCONFIG, SRVCTL.
• Generate statspack report regularly to know the bottlenecks in the system and send them to Oracle support for analysis.
• Changing the Various parameters in init.ora to improve the performance of the Oracle Applications database
• 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.

Oracle Apps DBA

Confidential, Terre Haute, IN

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.
• Rebuild the indexes and dropped unused indexes.
• Setting up the printers in Application environment.
• Troubleshooting throughout the project phases and TAR Management
• TEMPEffective 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

Sr. Oracle DBA

Confidential, Vancouver,WA

Responsibilities:

• Installation, creation and maintenance of oracle databases for Data Ware Housing Project.
• Administered the databases EHDW, DWH, OLTP, STOR on E4000 Sun Solaris Systems and DWDV, FINANCE databases on E3000 sun Solaris 2.5.1 Unix systems.
• Created additional table spaces, Rollback Segments, Redo log Groups for production support.
• Configured SQL*Net for Oracle
• Created additional table spaces, Rollback Segments, Redo log Groups for production support
• Implemented more TEMPeffective backup procedures of databases
• Created tables, views, Synonyms, Database links, Snapshots and Indexes.

Sr. Oracle DBA

Confidential, Abelene, TX

Responsibilities:

• Administered the Databases PNEX, PCIP, PCIA on hqdev E4000 Sun Solaris System and OAPROD, DNEX, TRNEX and TNEX databases on bronco E3000 sun Solaris 2.5.1 Unix system.
• 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.

Sr. Oracle DBA

Confidential, Edison, NJ

Responsibilities:

• Responsible for installation, creation and maintenance of databases.
• The database is for Oracle Applications (Financials, Manufacturing, and HR).
• The database is approximately 100 GB and consists of around 2500 tables.
• dis database TEMPhas been replicated on a Windows NT 4.0 server.
• Tuned the database and applications using EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF STATSPACK (advanced version of UTLBSTAT and UTLESTAT).
• Responsible for designing a training course for Oracle Database Administrators for Oracle Applications.

Sr. Oracle DBA

Confidential, Edison, NJ

Responsibilities:

• As a database administrator, he was involved in creating Databases, Table spaces, Tables, Views, Indexes, Stored Procedures, Triggers, Creating users and roles on Oracle 7.1/8.0.
• He was involved in planning the size and location of initial data files, rollback segments, backup strategy and setup of initial security features and editing database initialization parameter files.
• The job involved constant monitoring and managing space, administering database security, export and import of database, recovery of the database, loading of data from non-Oracle data sources, extending database storage capacity and monitoring and tuning the database server performance by reducing disk me/O, disk contention.