SUMMARY

• Over 12 years of experience in enterprise database applications involving in Oracle technology. Performed multiple implementations, installations, configurations and upgrades of Oracle EBS systems. Strong in data modelling, database design, capacity planning, and resource optimization, leading development and administration team.
• Primarily responsible for administering, managing and supporting corporate Oracle EBS R11i/12.1.x/12.2 Applications.
• In - depth knowledge and great enthusiasm towards Oracle Technology. Self-motivating and excellent troubleshooting skills. Very good team player and proven mentor for the development team.
• Responsible for providing the roadmap for Oracle Apps in IT infrastructure and presenting the high-level reports on Oracle Apps to the Executive managers. Formulated the procedures and reports for internal corporate audit and SOX compliance.
• Worked in the Manufacturing, Transportation, Logistics, Warehouse and Utilities Industries supporting the enterprise database systems.
• Cloning Oracle Applications 12.2.X and Patching Oracle Applications 12.2.X Upgrade Oracle Applications to 12.2.X from 11i and 12.1.X Install, Administer and configure Oracle Applications 11i and R12/12.2.X
• Upgrade Oracle Applications from 11.5.10.2 to R12 (12.1.X). Configure Standby (DR) for oracle Database and administration. Experience with RAC and ASM and Experience with Fusion Middleware.
• SSO configuration, OID configuration and Integration with R12 and 11i. Experience with RMAN, Export, Data pump, Import. Experience with tables, Indexes, LOBS Re-Organization.
• Experience with Weblogic, SOA implementation and administration. Cloning RAC RAC and RAC NON RAC systems. Patching CPU/HRMS/One-Offs.
• Converting Character set using CSSCAN. Upgrade of Oracle Database from 9i 10g and 10.1.X 10.2.X -> 11.X >12.x and Install, Configure and administer Oracle Applications R12. Apply/Rollback Oracle Database patches, PCP configuration and testing. Debugging Apache/Jserv.
• FRA Configuration & administration. Implementation of Vertex/Sabrix direct and indirect tax system for Oracle Apps. Implementation of Brazil Tax System (Master SAF) Implementation of Secure Enterprise Search. Implementation of Work Order Printing with attachments.
• Implementation of AutoVue from Work order Printing. Implementing active data guard and administration and Implementation of Shared Appl Top and Cloning Oracle Applications shared Appl Top
• Automation of Patching using Application Change Management Pack. Proactive working 24*7 for P1 Production Issues. Working with Tools: RMAN, EXPORT, IMPORT, SQLLDR, DATAPUMP, OEM. Worked with Operating Systems: Linux, Solaris, HP UNIX, IBM Aix Working with 12c plus pluggable databases. (POC)

PROFESSIONAL EXPERIENCE

Confidential - NEW YORK

Sr Oracle Applications DBA

Responsibilities:

• Upgrade of Oracle Databases from 10.X to 11.X/12.X
• Shell scripts to monitor custom specific services/requirements
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Taking periodic backups/regular backups and milestone backups
• Working with import, export and DATAPUMP
• Transition of new environments in to data center.
• Re organization of tables/indexes to improve performance and to remove fragmentation.
• Performing Oracle Database and Applications upgrades (11i-12.1/12.2 & DB 10g-11g/12c)
• Application of one-off, CPU patches to database and applications.
• Performing SYSADMIN activities which include creating users and assigning responsibilities.
• Administer and define custom concurrent managers.
• Performed automated backups and scheduling using scripting. Environment: Oracle 11g RAC, Oracle 10g RAC, Oracle 9i, Red Hat Linux, HP-UX, Windows IBM AIX, Sun Solaris, Data Guard, Grid Control/Oracle Enterprise Manager (OEM), RMAN, ASM.
• Cloning Oracle Database and applications from Production to NON production
• Cloning Oracle applications 12.2 from production to NON production multi node env
• Patching Oracle applications 12.2 using ADOP
• Adding and deleting managed servers based on the requirement.
• Migrating code using open bravo/quest stat and HPPPM
• Mentoring juniors on issues and resolutions.
• Importing code signing JAVA certificates to Oracle Applications
• Handling Production maintenances weekly/monthly/quarterly
• Attending customer calls on forecasting goals and pipelined projects
• Preparing POC’s for customer requirements
• Working with AD utilities (adadmin/adpatch/adsplice/admrgpch/adctrl)
• Administering Oracle Database on Exadata LINUX/AIX platforms
• Upgrading Oracle Database from 10G-11G/11G-12C with SAP applications in place.
• Working with re organization of tables/indexes and advanced compression
• Optimizing oracle database towards performance improvement.
• Install and administer OEM 12c Cloud Control on OEL 6.5
• Performing code migrations using Flyway

Confidential - CAMPHILL PA

Oracle DBA and Applications DBA

Responsibilities:

• Upgrade of Oracle Applications from 12.1 to 12.2 and database from 11.2.0.4 to 12.1.0
• Setting custom cron scripts to monitor custom programs and processes
• Cloning of Oracle Applications along with 3 node RAC database from production to non-production systems.
• Taking regular backups using 12c Grid Control.
• Data masking using grid control.
• Patching Oracle Applications and database
• Re organization of tables/indexes to improve performance and to remove fragmentation.
• Application of one-off, CPU patches to database and applications.
• Performing SYSADMIN activities which include creating users and assigning responsibilities.
• Administer and define custom concurrent managers.
• Performed automated backups and scheduling using scripting. Environment: Oracle 11g/12c RAC
• Adding and deleting managed servers based on the requirement.
• Migrating code using quest stat
• Mentoring juniors on issues and resolutions.
• Handling Production maintenances weekly/monthly/quarterly
• Preparing POC’s for customer requirements
• Working with AD utilities (adadmin/adpatch/adsplice/admrgpch/adctrl)
• Optimizing oracle database towards performance improvement.
• Gathering requirement for product development life cycle
• Working with development team closely for respective requirements
• Handling development issues towards DBA activities
• Working with Oracle Support for bugs and resolutions
• Handling scheduled/unscheduled outages when needed
• Providing support on 24*7 basis being a responsible DBA
• Working POC on transparent data encryption TDE
• Working on POC on Exadata and Exalogic.

Confidential

Senior Consultant Oracle DBA and Applications DBA

Responsibilities:

• Upgrade of Oracle Databases from 10.X to 11.X/12.X
• Shell scripts to monitor custom specific services/requirements
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Taking periodic backups/regular backups and milestone backups
• Working with import, export and DATAPUMP
• Transition of new environments in to data center.
• Re organization of tables/indexes to improve performance and to remove fragmentation.
• Performing Oracle Database and Applications upgrades (11i-12.1/12.2 & DB 10g-11g/12c)
• Application of one-off, CPU patches to database and applications.
• Performing SYSADMIN activities which include creating users and assigning responsibilities.
• Administer and define custom concurrent managers.
• Performed automated backups and scheduling using scripting. Environment: Oracle 11g RAC, Oracle 10g RAC, Oracle 9i, Red Hat Linux, HP-UX, Windows IBM AIX, Sun Solaris, Data Guard, Grid Control/Oracle Enterprise Manager (OEM), RMAN, ASM.
• Cloning Oracle Database and applications from Production to NON production
• Cloning Oracle applications 12.2 from production to NON production multi node env
• Patching Oracle applications 12.2 using ADOP
• Adding and deleting managed servers based on the requirement.
• Migrating code using open bravo/quest stat and HPPPM
• Mentoring juniors on issues and resolutions.
• Importing code signing JAVA certificates to Oracle Applications
• Handling Production maintenances weekly/monthly/quarterly
• Attending customer calls on forecasting goals and pipelined projects
• Preparing POC’s for customer requirements
• Working with AD utilities (adadmin/adpatch/adsplice/admrgpch/adctrl)
• Administering Oracle Database on Exadata LINUX/AIX platforms
• Upgrading Oracle Database from 10G-11G/11G-12C with SAP applications in place.
• Working with re organization of tables/indexes and advanced compression
• Optimizing oracle database towards performance improvement.
• Install and administer OEM 12c Cloud Control on OEL 6.5
• Performing code migrations using Flyway