PROFESSIONAL SUMMARY:

• 15yrsexperience in Oracle DBA, Apps DBA7,8,8i,9i RAC,10g,11gR1,R2,ExaData.
• Expertise inOracle ApplicationsDBA - Oracle E-Business Suite DBA (Release 10.6, 10.7, 10.7 SC, 10.7NCA, 11i, R12.0.2,R12 .0.4, R12.1.1,R12.1.3Oracle E-biz) along with Oracle ApplicationServer10gAS R2,R3,WebLogic Admin 10.3.x, Oracle Fusion11g (11.1.1.4,11.1.1.5,11.1.1.6) with DB11gR2 RAC(12.0.2),11gR1 RAC, 10g RAC, 9i RAC, 8i, 8, 7 in IBM AIX, SUN SOLARIS, HP UNIX, Red Hat LINUX AS, Oracle Linux 5, SuSE Linux and Windows 2008,2003, 2000/NT environments.
• Worked in ORACLE CORP, CISCO,FIRST DATA,CAP GEMINI,NYCHA,MASTERCARD,HDNL(FEDEX),WIPRO,BIRLASOFT,CALSOFT,CISCO,INGRAM,IMCetc
• Expertise in Oracle Applications Installation/ Maintenance/ Upgrade/ Migrations (Data & Programs)/Patching/ Cloning/Backup & Recovery/DR Set up/24x7 Support andSystem Administrationin Financials, Manufacturing, Distribution, HRMS, CRM, MLS/NLS, BIS, EDW module in UNIX, Linux, Windows, client Server GUI, 3Tier, ICA,NCA environments.
• Expertise in overall Oracle Fusion/SOA/WebLogic Architecture with load balancing.
• Excellent analytical, interpersonal and communications skills and demonstrated ability in achieving project milestones and objectives accurately and on time with ITIL standards.
• Well versed with the offshore-onshore business model and proven client interaction and leadership skills including managing,, mentoring and motivating others to achieve project deadlines and budgets.
• Full Life Cycle implementation of backend database configuration (Installation, Setup, Tune, Backups, Patching) and provide the full database tier, Middle Tier support to all phases of software development (Development, QA and Production)

TECHNICAL SKILLS:

Apps Software: Oracle Apps version 10.6, 10.7 SC prod 16.1, 10.7 NCA, 11.01, 11.0.2, 11.0.3, 11i (11.5.1, 11.5.2, 11.5.3, 11.5.5, 11.5.8, 11.5.9, 11.5.10.2),R12.0.4, R12.1.1,R12.1.3in Financials, Manufacturing, Supply Chain, Distribution, Localization, HRMS, CRM, BIS, EDW, MLS / NLS,Oracle SOA Suite 10.x, Fusion,OBIEE 10g, OBIEE 11g,OBIA, Informatica, DAC, OWB,Fusion 11g,ODI,OSB,ESB, BPEL,OEM Grid Control 10g/11g/12c,GoldenGate,MAXIMO

Hardware: SUN Ultra Enterprise, SUN Fire Servers, IBM-AIX RS/ 6000, HP9000, HP-ITANIUM, DELL Power Edge 2300, Pentium, Intel Linux, Compaq, SuSe Linux, NetApp Storage, EMC storage. X86-64 IBM series, EVA storage, IBM SVC SAN HMC,ExaData.

Operating System: IBM-AIX 4.3.3,5.3,5.5.1.0Sun Solaris UNIX 2.5.1, 2.6, 2.8, 8.0, Win95/NT/2000/98/95, REDHAT Linux 6.2, 5.5,AS 2.1, 3.0, 4.0, HP-10, CISCO Linux, SuSeLinux,VMWare,Cent OS, Oracle Unbreakable Linux etc.

RDBMS: Oracle 7.x and Oracle 8.0.4/8.0.5, 8i, 9i with RAC Clusters, 10g with RAC Clusters, 11gR1 with RAC Clusters, 11gR2with RAC Clustersalso with ASM10g,11g.

Languages: SQL,PL/SQL, HTML, CGI, PERL, C, JAVA, JAVA SCRIPT, JDBC, PRO*C, COBOL, FORTRAN, UNIX Shell Scripts,Apex.

Development Tools (GUI):Developer 2000, Htmldb, Oracle Application Express(APEX), JDeveloper Studio, ODI, BI Publisher,ADF, Informatica Power Center 8.6.1

Web Servers: Apache IAS, OAS, OWS, 9iAS, OHS (HTTP server), 10gASR2,10gASR3,Oracle Fusion Apps Tier 11.1.1.x, WebLogic Server 10.3.x, OSB 11g (11.1.1.x),WebSphere.

Tools: Enterprise Manager 2.0(All Packs),OEM Grid 10g/11g/12c with Business Intelligence Management Pack, Fusion plugins,AMP,SOA BPEL,SOA Console,OSB,AD utilities, Applications Maintenance Pack, GLDI, Workflow2.1, Xvision, Xseed, Web DBA, BMC, QUEST, TOAD, Fog Light,Telnet, Rman, Flashback Recovery, Oracle Data Guard SQL*NAVIGATOR, SQL Impact, Veritas / Precise, Putty, SQL Loader, Import / Export, Remedy, PVCS, Oracle Applications Manager, Introscope, Reflection(X), Markview, Kintana, Erwin, 170systems, Tick Mark, Fax Mgr, SQL flow, Xsign,Rman,Oracle Streams, Oracle GoldenGate,Tivoli Backup(dsmadmc) etc.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Applications DBA

Environment: Oracle 10gR2,11gR2,Oracle Applications E-biz suite R11.5.10.2, R12.1.3 in IBM AIX 6.1,11g Fusion, OBIEE 10g,11g and BI Publisher, 10gAS Portal, Clear Case, Web Logic, Web Sphere,etc.

Responsibilities:

• Upgraded OBIA7.9.6.1 to OBIA 7.9.6.4(OBIEE 10.1.3.4.1 to 11.1.1.7.0 +Informatica 9.0.1 Hotfix 2+Dac11g)
• Installing and configuring OEM 12c grid control and monitored databases, agent plugins, AMP, AMS, Fusion components.
• Solving Oracle performance issues.
• Fusion application support includes oracle Fusion 10G, 11g ( 11.1.1.7.0 ) OBIEE, BPEL etc.
• Configured Connection Pool, JMS, Data Sources, Cluster in Web Logic.
• Checking and monitoring Oracle Fusion middleware control, Web Logic Server Administration console for SOA performance and solving issues.
• Created the Web Logic Domain for application in Dev and Test Environments.
• RMAN backup monitoring and solving backup issues.
• OEM 10g, 12c monitoring on daily basis. Daily Support to Development Team and end users.
• Responsible for Oracle Application installation and configurations, patches, concurrent manager administration, cloning, upgrades and Oracle Apps SYSADMIN functions. Duties included database creation, customization updates, database tuning and reorganization, backup and recovery, general troubleshooting, script development, Forms and Report services and documentation.

Confidential

Senior Oracle Applications cum Fusion Admin DBA

Environment: s: Oracle 10gR2,11gR2,Oracle Applications E-biz suite R12.1.3 in Sun Solaris, Exa Data,11g Fusion, OBIEE and BI Publisher, Oracle SOA 10g, Fusion 11g (11.1.1.5.0, 11.1.1.6.0 ),10gAS Portal, Maximo, Markview, RMAN, BCV, ClearCase, Apex, Siebel, Web Logic, Web Sphere

Responsibilities:

• Oracle 10gR2 to 11gR2 upgrade, migrations and support.
• Oracle installation and support in ExaData.
• Installing and configuring OEM 12c grid control and monitored databases, agent plugins, AMP, Siebel plugin, Fusion components.
• Oracle Gateway and HSODBC support.
• Solving Oracle performance issues.
• Fusion/SOA application support includes oracle fusion 11g (11.1.1.5) OBIEE,BPEL etc.
• Configured Connection Pool, JMS, Data Sources, Cluster in Web Logic.
• Checking and monitoring Oracle Fusion middleware control,WebLogic Server Administration console for SOA performance and solving issues.
• BPEL Composite checking and solving the issues with SOA development team.
• Created the WebLogic Domain for application in Dev and Test Environments.
• RMAN backup monitoring and solving backup issues.
• OEM 10g, 12c monitoring on daily basis. Daily Support to Development Team and end users.
• Responsible for Oracle Application installation and configurations, patches, concurrent manager administration, cloning, upgrades and Oracle Apps SYSADMIN functions. Duties included database creation, customization updates, database tuning and reorganization, backup and recovery, general troubleshooting, script development, Forms and Report services and documentation.

Confidential

Senior Oracle Applications cum Fusion Admin DBA

Environment: s: Oracle Applications E-biz suite R12.1.3 with DB 11gR2 Redhat Linux,11g Fusion, OBIEE and BI Publisher, Oracle SOA Fusion 11g (11.1.1.5.0, 11.1.1.6.0 ) SSO AIA, PIP, ADF integration, Informatica Power Center 8.6.1,RingMaster, Load Balancer, EMC storage.

Responsibilities:

• Ebiz suite R11i and R12.1.3 Cloning - RAC to RAC, non RAC with multiple middle tier.
• Installed and configured OEM 11g, 12c grid control and monitored middle tier components.
• Analyzed and applied Ebiz R 12.1.3 Recommended Patches (AD, non AD modules) and CPU patch for JUL 2012.Merged the patches based on base modules A, B, C
• Used RingMaster tool to analyze and apply Ebiz patches. Applied weekly, monthly changes.
• Involved in Web & Enterprise applications upgrading Weblogic from oracle fusion 11.1.1.5 to 11.1.1.6 (recommended patches)
• Fusion/SOA application support includes oracle fusion 11g (11.1.1.5) OBIEE,BPEL,OSB,BAM,AIA,PIP etc.Installed Oracle Application Integration Architecture Foundation Pack 11gR1 along with RUP.
• Configured Connection Pool, JMS, Data Sources, Cluster in Web Logic.
• Checking and monitoring Oracle Fusion middleware control, WebLogic Server Administration console for SOA performance and solving issues.
• BPEL Composite checking and solving the issues with SOA development team.
• Created the WebLogic Domain for application in Dev and Test Environments.
• Involved in Capacity Planning for Applications running in Web Logic Shared Platform.
• RMAN backup monitoring and solving backup issues.
• OEM monitoring on daily basis. Daily Support to Development Team and end users.
• Coordinated with Offshore DBA’s to complete regular support works.
• Responsible for Oracle Application installation and configurations, patches, concurrent manager administration, cloning, upgrades,Oracle Apps SYSADMIN functions general troubleshooting, script development, Forms and Report services and documentation.

Confidential

Senior Oracle Applications DBA

Environment: Oracle Applications E-biz suite upgraded and maintained in versions R12.0.2, R12.0.4, R12.1.3 along with ORACLE 10gR2,11gR2 in Redhat Linux in Enterprise Cluster along with legacy Oracle 10gR2 RAC and 11gR2 RAC clusters.(VMWare and standalone hosts)

Responsibilities:

• Upgraded ORACLE APPLICATIONS (Ebiz suite Upgrade R12.0.4 to R12.1.3) in Redhat Linux. Apps Tier migrated to Redhat Linux to VMWare Oracle Linux.
• Upgraded Apex 3.1 to 4.2in Ebiz suite.
• Upgraded 10g OEM Grid Control to 11g OEM Grid Control.
• Upgraded and maintained 10gR2 RAC to 11gR2 RAC (SCAN).
• Used RMAN for backup and recovery.
• Added Apps, DB Cluster nodes.
• Performed Database and Application 24by7 support.
• Performed tuning and solved performance issues.
• EMC migrations from EVA worked with SA Team.
• Applied DB, APPS patches.
• Managed Business Intelligence Management Pack within Enterprise Manager.(Fusion 11.1.1.4.0 - Oracle BI Analytics Server,Oracle BI Cluster Controller, Oracle BI Presentation Server, Oracle BI Scheduler,Oracle BI Suite Enterprise Edition,Oracle BI Data Warehouse Administration Console (DAC) Server,Hosts Running BI Components
• Worked with Sterling Integrator, Jboss, IBM Replication, TIBCO Apps team to solve the maintenance issues.
• Configured the TAF services in existing Oracle 10gR2 cluster databases.
• Configured and maintained GoldenGate Replication to and from DB2, SQL and Oracle.

Confidential

Technical Lead - Oracle Applications DBA cum SOA Administrator

Environment: Oracle Applications R12.0.4 (10g) DB RAC, Multi Apps Tier, Modules OM, INV, FA, GL, AP, AR, PO, integrated with SOA 10.1.3.4, 10.1.3.5 (10gASR3), Weblogic 11g(10.3.1) Cluster with Load Balancing environment and legacy 10g,11g Databases in SuSE Linux Platform.

Responsibilities:

• Managed multiple SOA,BPEL, BAM instances with 24x7support. SOA Apps, Web, DB tuning& purging.
• Installed and maintained OBIEE 10g suite (10.1.3.2 along with SOA 10.1.3 suite.
• Installed Business Intelligence Management Pack within Enterprise Manager.(Managed Oracle BI Analytics Server, Oracle BI Cluster Controller, Oracle BI Presentation Server, Oracle BI Scheduler, Oracle BI Suite Enterprise Edition, Oracle BI Data Warehouse Administration Console (DAC) Server, Hosts Running BI Components.
• Regular Application Server Administration, analyzing manual recovery instances.
• Installed, configured and maintained SOA Prod, Dev, Test instances with DB RAC and multiple SOA Apps Tier.
• Managed memory leak problems, sufficient heap size allocation, JVM settings, efficient connection pooling and logging levels.
• Maintained and Supported ORACLE APPLICATIONS R12 (12.0.4) in SuSe Linux with RAC in SAN environment, three Apps Middle Tier Components and integrated with Oracle SOA Suite 10g RAC and SOA Apps Cluster.
• Configured XA (high availability) in SOA along with 10g RAC cluster DB with Load Balancing.
• Working with ORACLE for sev1 and sev2 issues to solve priority issues.
• Daily Check List Monitoring and checking AWR reports to improve for performance and availability.
• Installing and testing in Test, Devenv for any patches or any new configurations and promoting to Prod env.
• Regular backup and coordinating with Admin team for snapshot backups.
• Working with Release team to implement new Releases in SOA Apps. Installed and tested 11g (10.3.1) Web Logic Server for Middle tier.
• Solving DB performance issues often with proactive Concurrent Requests based on long running concurrent requests or sql.
• Attending daily Conference Calls with client and Management.
• Upgraded SOA Apps Tier from 10.1.3.4 to 10.1.3.5(Fusion)
• Worked with development team to solve issues in pl/sql, workflow or any sql tuning along with OEM reports.
• Worked on implementing ITIL (IT Infrastructure Library) framework in the project.
• Tuned JVM configuration, monitoring, troubleshooting and tuning.

Confidential

Senior Oracle Applications DBA

Environment: Oracle Applications R12.0.4 (10gR2) DB RAC, Multi Apps Tier, Financial Modules along with Oracle 9i,10g,11gR1 Cisco Linux env.

Responsibilities:

• Supported (including on call support) 8i, 9i, 10g, Production environment Oracle Databases.
• Worked in very large databases (VLDB) in excess of 1TB.
• Maintained and supported Ebiz suite R12.0.4 Oracle Apps Prod with RAC, Dev, and Test Databases.
• Performed operations like Table, Index Partitioning, Index Organized Tables, and Materialized Views, enabling Query Rewrites on materialized views for high availability and for better performance.
• Next Generation Backup models (CDP- continuous data protection) in Falconstor and BMC restore test setup and trial with NetApp storage. Involved in DR (Disaster Recovery) set up.
• Oracle 10g Grid Computing set up and installed EM clients on each server.
• Installed Oracle 11g in Cisco Linux OS, Windows Vista for testing purpose.
• Installed reporting server with replication of schemas arriving from Production databases. Configured to filter out and not to replicate some of the less critical data/tables...
• Configured Oracle Streams for high availability.

Confidential

Senior Oracle Applications DBA

Environment: s: Oracle Apps 11.5.10.2 (GL, AP,PO), Oracle 9i, NFS, Redhat Linux env.

Responsibilities:

• 24 by 7 support Provided for all 11i Oracle Apps Prod, Dev, Test Databases and managed offshore DBA Team
• Managed and supported Oracle 9i,Oracle 10g databases
• Applied regular and issue oriented Patches after analyzing patch analysis.
• Installed 10g Discoverer with Enterprise Manager.
• Regular backup management and coordinating with Datacenter Team.
• Change Management Correspondence and documenting as per SOX policy.
• Running diagnostic patch and report analysis as and when requested by functional Team.

Confidential

Senior Oracle Applications DBA

Environment: s: Oracle Apps 11.5.10.2 (GL, AP, INV, FA, PO, OE), Oracle 9i, NFS, NIS,SUN SOLARIS with170systems, TickMark, Fax Mgr, SQL flow, and Xsign

Responsibilities:

• Providing On Call 24x7 production support for 11i Oracle Applications (E-Biz suite) environments in Sun Solaris along with third party Applications.
• Solved many issues after post upgrade from 11.5.7 to 11.5.10.2.
• Supported Oracle development teams.
• Performed daily monitoring of all Oracle databases and system.
• Applying daily patches and production CCF patches.
• Cloned production environment to test environments.
• Performed regular database maintenance and support and solving issue tasks.
• Upgraded third party tool Tick mark (Applimation) from 4.1 to 5.1 and configured in 10gAS.
• Preparing and testing for i-Supplier in DMZ install for go live in Feb2007.

Confidential

Senior Oracle Applications DBA

Environment: Oracle Apps 11.5.10.2 (GL, AP, INV, FA, PO, OE), Oracle 9i, SUN SOLARIS and Linux Red Hat AS 3.0.

Responsibilities:

• Provided 24x7 production Oracle support for all 11i Oracle Applications environments in Sun Solaris.
• Installed and maintained ORACLE APPLICATIONS (both financials, manufacturing) version 11.5.8 (11i) in Sun Solaris 2.8
• Applied required patches and family packs using adpatch, adadmin and adctrl utilities on all tiers.
• Cloned Production environment to development, test environment.
• Set up additional concurrent managers and managed concurrent processes.
• Monitored and maintained the GE oracle 9i with RAC Databases.
• Created TARs with Oracle support and solved various Oracle apps issues.
• Configured printers for Oracle Applications.
• Installed and maintained ORACLE APPLICATIONS (both financials, manufacturing) 11.5.6 (11i).

Confidential

Applications Deployment Consultant

Environment: Oracle Applications 11.5.5 (11i), Modules Financials, MFG, CRM, Forms and Reports Developer 6i, RDBMS8i, Sun Solaris 2.8, Database 40GB, 80 GB

Responsibilities:

:

• Installed and maintained ORACLE APPLICATIONS (both financials, manufacturing, CRM) 11.5.5(11i) in Sun Solaris 2.8 (50GB database).
• This is Oracle Financial R11.0.3 Upgrade Project from 10.7 Character Mode.
• Upgraded Oracle database from version 7.3.4 to 8.0.5.2.1
• Worked in a Project Implementation for testing & development environment.
• Installed Oracle Apps 10.7 databases of 10 GB each for the testing and development environment.
• Performed database tuning & checking of concurrent requests for performance, scheduling number of concurrent process for each manager and improved performance in Purchase Approval Process.
• Installed & managed Oracle Applications version 11.0.2 database, Oracle 8.0.4 Enterprise Edition with 100 Concurrent Users and Developers.
• Administered Concurrent Managers and report sets.
• Installed & configured Apps 10.6, Apps 10.6 SC, 10.7, 10.7NCA, 10.7 NCA
• Assigned parameter security rules, printer drivers, terminal security
• Defined Application users, combined specification rules, concurrent managers, concurrent programs, concurrent program executables, concurrent request types, cross-validation rules, currency, data group, help text, logical databases, parameter security rules, parameter values, print style, printer drivers, printer types, report groups, rollup groups, terminal group, value set, work shifts