SUMMARY:

• Specialized in Oracle Applications R12/11i Database, Oracle OBIEE Administration, Siebel CRM Administration wif over 9 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.
• Manage, administer and control System Responsibility.
• Lead, install, configure and manage teh use of OAM/wif web applications, including those of Oracle and Custom - built.
• Experienced and proficient wif Oracle E-Business suite application (R12 12.2.x / 12.1.x / 12.0.x, 11.0.28, 11.5.4, 11.5.7, 11.5.8, 11.5.9 and 11.5.10.2) and Oracle Applications Server (9i/10g) in Sun Solaris, Red Hat Linux, AIX and Windows environment
• Expertise in upgrading Oracle Applications from 11.5.x to 12.1.x
• Experience wif Siebel CRM 8.1.1 Installation and Administration on Solaris 10 OS.
• Experience in configuring RMAN wif VERITAS NetBackup on Solaris/AIX OS.
• Performed database installation and upgrades. Experience in setting up HTTP Load Balancing
• Expertise in Implementing DMZ, OAM, SSL and SSO for Oracle E-Business Suite Applications
• Expertise in implementing Shared APPL TOP and PCP
• Expertise in troubleshooting Workflow and Notification Issues
• Supported Vertex Taxing Software updates, integrated wif 11.5.10.2 Applications
• Experience in installing Discoverer 10g and integrating to R12 ERP Applications
• Implemented 10g Grid Control and applied Applications Management Pack for monitoring Applications
• Expertise in RAC, ASM, RMAN and Data Guard
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues
• Proficient in Oracle tools and utilities (RMAN, ADDM, ASH, AWR, AMM, ASM, DBVerify, TkProf, NETCA, NETMGR, DBCA, svrmgrl, Export, Import, SQL*Loader, OEM) in UNIX (Sun Solaris, AIX, HP-UX) & Windows environment.
• Experience in resource planning and hardware/Infrastructure planning.
• Experience in Database Migration from one platform to another.
• Very good at VI Editor and Unix Filters and commands such as grep, wc, cut, sort, tr, head, tail
• Lead/supervisory experience, responsible for leading teh technical team, making assignments and being teh point of contact for technical questions in regards to teh project
• Very good at Unix Shell Scripting and can manage to write Windows batch scripts.
• Well versed wif 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) and certified on SOLARIS 10 OS
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues
• Experience in using OS tools like top, topas, prstat, vmstat, iostat, netstat, sar etc.
• Applying RDBMS and Application patches. Sound noledge in AD Utilities
• Certified in ITIL v3 Foundation and Good Knowledge of SDLC (Software Development Life Cycle) processes - Service Strategy, Service Design, Service Transition, Service Operation and Continual Service Improvement.
• Capable of tuning SQL using EXPLAIN PLAN, tracing at user level and TKPROF
• Work independently to ensure that teh 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 teh Technical Notes and Documentation.
• Efficient Team Player, hard-working, good in analytical and logical problem solving abilities wif excellent communication skills.
• Coordinate wif offshore resources

TECHNICAL SKILLS:

Hardware Platforms: Sun SPARC (E10000, V440, V490), IBM AIX, IBM compatibles (IBM AIX 7.1/5L/4.3), Dell PowerEdge

Operating Systems: RedHat Linux 3/4/5/6, UNIX (HP UX 11.X, Solaris 8/9/10, SCO, IBM AIX 4.3/5L/7.1), MS-WINDOWS XP/2000/2003

Database: ORACLE 12c (12.1.0.1.0 ) 11g(11.1.0.x, 11.2.0.x)/10g (10.2.0.x), 9i (9.2.0.x), 8i (8.1.x)/8.0, 7.3.2

Application Servers: 10gAS (10gR2, 10gR3), IAS (10222) 10g Forms and Reports, 10g Discoverer, 10g Identity Management Suite.

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

Applications: Oracle Applications R12.2.x/12.1.x/12.0.x, 11i (11.0.28, 11.5.4, 11.5.7, 11.5.8, 11.5.9, 11.5.10, 11.5.10.2), Siebel CRM 8.1.1.1

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

GUI: DEVELOPER 6i, ADI (Desktop and Web), OAM, OEM, Kintana

Tools: and Utilities: Oracle Tools OEM/OAM, RMAN, Data pump, SQL*PLUS And third party tools like Quest Software (TOAD, SQL Developer), Putty, RDP etc.

Advanced Technology: Distributed Databases (Oracle Streams, Advanced Queuing, and Materialized views), High Availability Options (Real Application Cluster (RAC) and Standby Databases) and Performance (Database, locking, parallel execution, partitions and SQL tuning). SSO (Single Sign-On) SSL (Secure Socket Layer)

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle EBS (11.5.8, 12.1.3), Solaris 9/10, DMZ, Data Guard

Responsibilities:

• Administer teh Oracle EBS 11.5.8 and 12.1.3 instances where database size is 2+TB.
• Administer teh Production Oracle Data Guard Physical Standby Environment.
• Have upgraded teh EBS instance from 12.1.2 to 12.1.3
• Perform Hot Backup RMAN clone of R12.1.3 EBS instances.
• Upgraded non-ERP databases from 9i/10g to 11g.
• Apply patches as requested by teh application team.
• Installed Oracle 12c Cloud Control on test server.
• Installed Oracle 10g Enterprise Manager Grid Control.
• Upgraded EM Grid Control from 10gR1 to 10gR5.
• Perform teh Action Plans of teh Oracle Support Requests
• Perform teh custom Data load jobs.
• Redacting (Data Encryption) of data using scripts.
• Port teh files between instances through Version Control System (PVCS)
• Perform migrations from DEV to UAT instances.
• Run teh EBS product specific diagnostic scripts and provide results to Development team.
• Integrated ARIBA ITK Tool wif R12 EBS.
• Very strong in Auto Patch, Upgrade, Cloning and Oracle Applications Manager.
• Troubleshooting client Jinitiator/JRE Issues.
• Perform frequent java Upgrades on teh R12 EBS Server as and when latest compatible version of Java is released.
• Prepare documentation for any patching/upgrade/maintenance tasks done on development environment and forward teh same to teh PROD DBA’s.

Confidential

Environment: Oracle EBS (11.5.10.2, 12.1.3), AIX 5.3/7.0, Oracle 11g OBIEE, DAC, Informatica

Responsibilities:

• Upgraded teh database of teh Oracle EBS from 10.2.0.4 to 11.2.0.1
• Upgraded teh Oracle EBS Version from 11.5.10.2 to 12.1.3
• Migrated teh database from Oracle 10g (10.2.0.3.0 ) to 11g (11.2.0.7)
• Have implemented an Oracle BI System integrated wif Oracle EBS
• Apply patches as requested by teh application team
• Perform EBS cloning as and when requested by teh development team
• Performance tuning of teh instance after teh EBS upgrade.
• Perform teh Action Plans of teh Oracle Support Requests
• Perform migrations from SBX (Test) instance to PROD instance.
• Created a shell script for killing runaway frmweb sessions, teh issue for which their was no solution from Oracle Support.

Confidential

Environment: Oracle EBS R12.1.x/12.2.x. Linux 5.8, Oracle 11g SES

Responsibilities:

• Worked on Oracle 10g SES (Secure Enterprise Search) integration wif R12 EBS.
• Was part of Oracle EBS 12.2 Beta Testing and have tested EBS R12.2 before it was released globally.
• Installed Endeca v2.4 and integrated it wif R12 EBS for Procurement module.
• Installed Endeca v4 and integrated it wif R12 EBS for Procurement module.
• Worked on UPK Integration wif R12 EBS for internal demo Instance.
• Enabled Port 80/443 configuration and implemented SSL for R12 EBS Demo Instance.

Confidential

Environment: Siebel 8.1.1 CRM, Solaris 10

Responsibilities:

• Independently Installed Siebel CRM in a Test Environment on Solaris server.
• Was part of a team wherein Siebel CRM was installed on 6 Solaris Servers in a High Available Environment.
• Applied Siebel Patches to upgrade from 8.1.1 to 8.1.1.1 in a Test environment.
• Troubleshooting Startup and Shutdown of Siebel CRM services.
• Created shell script for starting up and shutting down of Siebel CRM Services.
• Enabled trace and performed TkProf as requested by teh application team.
• Migration of Repository across instances.
• Worked wif Oracle Support for issues resolution
• Have written scripts for purging application server log files
• Worked on performance tuning of teh environment.
• Have given Knowledge transition of Oracle DBA and Application Access to teh IT Team at Mauritius Police Force.
• Have configured auditing at both database and application level
• Have done documentation of tasks as and when needed
• Have enabled auditing of teh system as per teh requirements.
• Troubleshooting of end user related issues like browser compatibility issues

Confidential

Environment: Oracle 10g 10.2.0.1, AIX 5.3, Oracle Flex Cube, Oracle 10g AS (Forms)

Responsibilities:

• Provided support for teh Oracle Environment in a VERITAS Cluster Environment.
• Frequent refresh of teh main schema from PROD to TEST database.
• Migrated database from Linux to AIX.
• Enabled trace and performed TkProf as requested by teh application team.
• Troubleshooting issues related to Flash Recovery Area.
• Have applied opatches for both Oracle Database and Oracle Application Server.
• Monitored and killed locks when issues are reported.
• Purging of log files on teh Oracle 10g AS environment.
• Monitoring and Managing Tablespaces and Disk Space.
• Have configured auditing as requested
• Gave to teh DBA’s working at Development Bank of Mauritius
• Worked wif Oracle Support for issues resolution
• Have written script for automatic export and ftp of schemas to teh DR server
• Have written scripts for purging application server log files
• Worked on performance tuning of teh environment.

Confidential

Environment: Oracle 11i EBS (11.5.10.2), Oracle Apps 11.0.28, Solaris

Responsibilities:

• Performed regular clone from PROD to TEST instance.
• Enabled Audit for certain period on Oracle Applications as requested by client.
• Startup and shutdown of Oracle Apps 11.0.28 which was used for reporting purposes.
• Have identified a mistake performed by a developer which stopped teh requests on Production for more TEMPthan a day.
• Application of patches as and when requested by ERP Development Team.
• Ran teh diagnostic scripts provided by teh Oracle Support for functional Issues.
• Recovered an Oracle 8 Database from backup after a disk corruption.
• Scheduled Gather Schema Statistics and Purge Concurrent Programs.
• Have created a menu on teh OS for doing system administration tasks.
• Purging of log and trace files.
• Have configured auditing of EBS related forms as needed.
• Worked wif Oracle Support for issue resolution
• Gave Oracle core DBA and Apps DBA to teh DBA team at Accountant General Office
• Have worked on performance tuning of couple of reports.

Confidential

Environment: Oracle 10g RAC & ASM, Solaris, Oracle 10g AS (Forms/Reports) in Active-Active Mode

Responsibilities:

• Have configured teh Oracle 10g As (Forms and Reports) in Active-Active mode.
• Configured teh (10g AS) report server clustering.
• Delivered Oracle 10g DBA to teh concerned police officers/engineers.
• Have raised a Severity 1 SR to work on an Oracle 10g Reports Issue and worked at a stretch of 28 hours.
• Created database links as requested by teh application team.
• Have applied Opatches for bug fixes and for performance issues.
• Worked on performance tuning of teh environment.
• Have performed tracing for specific functionalities.
• Ran ADDM reports as requested by teh application team.
• Looked into EM console related issues.
• Have enabled auditing at many levels as teh system TEMPhas very critical information.
• Have refreshed schemas between instances as requested by development team.
• Have done documentation as and when necessary
• Have worked wif Oracle Support for issues resolution.
• Troubleshooting of end user issues wif Jinitiator needed for accessing Oracle 10g Forms.

Confidential

Environment: Oracle 11i EBS, Oracle 11g OAM / Oracle 10g OID/SSO, AIX 6.1, Microsoft Active Directory

Responsibilities:

• Implemented Zero Sign-On, an advanced extension of Oracle SSO wif Oracle 11i EBS
• Implemented SSL (https) on 11i EBS for secure access of applications.
• Have upgraded teh database from 9i (9.2.0.6.0) to 11g (11.1.0.6.0 )
• Have installed 11g OAM and configured it on teh test server.
• Applied teh ATG RUP 7 patch, Developer 6i Patchset 18
• Have installed 10g Identity Management Suite.
• Have done a point upgrade of 10g IDM Suite
• Have used Third-Party VeriSign s for implementing SSL.
• Have supported Oracle Financials and applied related patches as requested.
• Performed clone of Zero Sign-on enabled 11i EBS environment.
• Delivered Oracle 11i Apps DBA to teh concerned System Engineers.
• Ran teh diagnostic scripts provided by teh Oracle Support for functional Issues.
• Have enabled auditing of System Administrator responsibility related forms.
• Customize teh Login Page to display teh company logo on teh login page.
• Scheduled Gather Schema Statistics and Purge Concurrent Programs.
• Performed clones as and when needed by teh development team.
• Have created Unix Shell Script for taking an offline backup.
• Troubleshooting of issues faced by end users. (Jinitiator, certdb.txt issues, etc.)
• Troubleshooting of EBS-OID Sync Issues.
• Performance tuning of EBS application which is integrated wif OID/SSO
• Have done documentation of tasks as and when needed.
• Have worked wif Oracle Support for teh OID/SSO Issues
• Have written scripts for purging and log rotation of 10g Identity Management Suite log files

Confidential

Environment: Oracle 11i EBS (11.5.9/11.5.10.2 ), HP-UX

Responsibilities:

• Was part of a team which maintained about 2 Production and more TEMPthan 20 EBS Test instances.
• Regularly cloned teh 11i ESB test instances.
• Applied patches as requested by teh application team.
• Monitored Tablespaces usage and disk space.
• Regularly restarted teh apache services whenever issues wif POS.
• Ran vertex updates.
• Performed offline backups and ftp’d teh same to backup server.
• Sent daily sanity check reports
• Provided 24/7 monitoring and support of teh EBS system.

Confidential - Westborough, MA

Environment: Oracle 11i EBS (11.5.10.2), Red hat AS 3.0

Responsibilities:

• Regularly cloned teh 11i EBS from PROD to TEST environment.
• Applied patches as requested by teh application team.
• Monitored Tablespaces usage and disk space.
• Regularly restarted teh apache services whenever issues wif POS.
• Ran vertex updates.
• Performed offline backups and ftp’d teh same to backup server.
• Working wif Oracle Support for SR Issue resolution