SUMMARY

• 10+ years of experience as Oracle DBA/EBS DBA, with extensive hands on experience in 10g, 11g, 12c Oracle database and 12.2.5,12.2.4,12.1.3 and 11.5.10.2 E - Business Suite. Application and database support, upgrades, migration and implement security solutions
• Oracle Implementation and support 9i,10g,12c and EBS application
• Database Security Implementation on 10g,11g, 12c and R12.2 Applications.
• Implement security solution to oracle database and application.
• Implementation and support of EBS 12.2.6, R12.2.5, 12.2.4, 12.1.3, 11.5.10.2
• Worked on Oracle Applications upgrade from 11.5.10.2 to R12.2.5
• Cloning of Run File System, patching using ADOP on R12.2.4
• Implement Shared Application Tier, PCP Setup and Load balancing
• Upgrade of databases from Oracle 9i to 10g and 10g to 11g and 12c.
• Oracle Security implementation for EBS 12.2 and 12c, 11g database
• Demantra 12.2.5 Installation and configure with EBS
• Automation of Apps cloning from single node to single-node and multinode
• Installation and configuration knowledge of Oracle Audit/Key Vault.
• Deploying Composites Application in SOA and monitoring the Instances
• Proficient in Database Administration activities such as Upgrades, Patches, Cloning,
• Data guard setup, RMAN Level backups. Worked on RAC and ASM
• Installation and configuration oracle Golden gate 11.2.1 and 12.1.2
• Oracle Data Integration Installation and configure
• Project planning and deliver task with SLA agreement
• EBS SSL and load balancing implementation,
• Implement and Support Oracle Golden Gate replication in Prod and DEV
• Oracle security implementation 12c Database and R12.2 application
• CPU /PSU patch analysis and apply on database and Application
• Oracle support on Exadata x5-2 environment with flash cache, patching HCC.
• WebLogic/SOA Administration with expertise in Administration and support
• Worked on the JRE plugin upgrade from 1.6.x to 1.7.x for R12.1.3
• Worked on install, upgrade and maintenance of Oracle with WebLogic Server.
• Database Audit and FGA enable, oracle TDE setup, oracle wallet setup
• Maintaining Agile servers and applying patches for Agile applications
• Discoverer setup and configuration with Ebusiness suite
• Worked on analysis of MWA Services configuration
• Database / Application patch analysis and apply using adop, adpatch, opatch.
• Worked on various database and application security issue

TECHNICAL SKILLS

Skills: E-Business suite 11i, R12,RAC,Data Guard, MAN

Tools: Oracle SQL Plus, Telnet, Toad

ERP: Oracle Applications 11.5.10.2, R12.1.3,12.2.4, R12.2.5

Operating System: Red-Hat Enterprise Linux 4/5/6/, UNIX, SUN Solaris

Database: Oracle 10G, 11g,12c, golden gate, exadata

Utilities: AD utility, Opatch, RMAN.ADOP

Applications: Oracle SOA, WebLogic, OBIEE, Fusion Middleware

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Environment: Oracle Applications 11.5.10.2, R12.2.5, DB Security.12c

Responsibilities:

• Upgrade E-Business suite from 12.1.3 to 12.2.5 and with database 11.2.0.4
• Database Upgrade from 11.2.0.4 to 12.1.0.2 and support.
• Configure RUN and Patch file system in upgrade application
• Implement security solution to database and application.
• Enable ADOP feature in 12.2.5 and follow patching cycle for EBS patching
• Clone DEV, Test and configure adop and maintain Fs1 and Fs2 with dualfs option.
• Install, maintain, administrating, supporting application R12.1.3
• Code Migration, MD120 preparation to DEV, TEST, PROD.
• Enable Audit and FGA policy and data masking on oracle database
• Expertise in cloning the ERP instance for the development and Test
• Limit access to system components and implement security model to restrict controls
• Followed patching cycle (ADOP) in R12.2.5 using run and patch file edition
• R12.2.5 server cloning using rapid clone and maintain RUN and PATCH edition
• Perform database security baseline on various instance.
• Implement Data encryption methods to protects vital information.
• Enable adop and configure custom top as per 12.2.5 standards
• Monitor and configure WebLogic environment
• Enable SSL on R12.2.5 E-Business Suite.
• Application User management creating, disabling, responsibility management.
• Enable Share App Tier configuration and add node to Application
• Create DB and application backup strategies on various phase of upgrade.
• Oracle Applications upgrade from R12.2.0 to R12.2.5 and required AD, TXK patches

Confidential, Sunnyvale

Oracle Database Engineer

Environment: Oracle Applications 11.5.10.2, R12.2.5, DB Security

Responsibilities:

• Database Security Implementation for 11g, 12c and R12.2 Application
• Evaluate current processes and address excessive privileges and access
• Limit access to system components and implement security model to restrict controls
• Evaluate current access, roles for PROD & non-PROD environments in DB and O/S
• Implement security solution to database and application.
• Upgrade E-Business suite from 11.5.10.2 to 12.2.5, 12.2.6 and oracle database
• Implement access control models, restrict privileged access and remove privilege
• Install, maintain, administrating, supporting the oracle application 11i/R12/R12.2.
• Database FGA enable, oracle TDE and wallet enable in prod and non-prod database.
• Expertise in cloning the ERP instance for the development and Test
• Followed patching cycle (ADOP) in R12.2.5 using run and patch file edition
• R12.2.5 server cloning using rapid clone and maintain RUN edition and patch edition
• Fix security bugs and Implement database scanner MOKO Confidential framework.
• Enable OS level syslog auditing and implement FGA for database
• Worked on python scripting for moko framework and modify json files
• Baseline database security task and implement on various environments
• Performed Sysadmin tasks as per the requirement.
• Application User management creating, disabling, responsibility management.
• Support developer team for migration in development and production
• Interacting with Oracle Support for technical assistance request
• Work with oracle support for critical SR and OWC requests
• Performed patch analysis for patches involving lot of pre-requisites.

Confidential

Oracle Application DBA Consultant

Environment: Oracle Applications 11.5.10.2, R12.2.5

Responsibilities:

• EBS Application upgrade from 11.5.10.2 to 12.2.5
• Oracle Database and GRID upgrade to 11.2.0.4 from 11.2.0.2.
• Planning and preparation for database and Application upgrade
• Capacity planning for Hardware and software requirement
• Install, maintain, administrating, supporting the oracle application R12.2.5
• Cloning of 12.2.5 ERP instance for the Development and Test performance tuning during upgrade of Application and Database
• Long running SQL tuning using SQLT output and AWR report
• R12 Oracle Application upgrade Module AP, AR, GL,OKL,ASCP
• Enabling online patching enhancement on 12.2.0 file system.
• Followed patching cycle in R12.2.5 using run - file edition and patch - file edition
• R12.2.5 server cloning using rapid clone and maintain RUN edition and patch edition
• Troubleshooting concurrent manager issues and Application performance
• Exadata specified feature smart scan, HCC, patching, flash cache etc.
• Support Oracle Instance in exadata x5-2 configuration.
• Oracle Grid and ASM support with ACSF file system.
• Applied PSU/CPU patches for WebLogic, EBS, Database
• EBS fresh Installation of 12.2.5 and build server as per development team request
• Managing team members with Onsite and offshore model
• Performed patch analysis for patches involving lot of pre-requisites
• Applied application patch using ADOP feature and followed patching cycle
• Create backup strategies for various gold backups during Upgrade process
• Managing RAC and ASM database also with ACSF file system
• GRID Home patching and upgrade ASM to 11.2.0.4
• Support and Upgrade EBS 12.2.5 in AIX and Linux Environments
• Apply Database and Application related missing patches by ETCC report.
• Vertex application integration with E- Business suite R12.2.5

Confidential

Principal Oracle Apps DBA

Environment: Oracle Applications 11.5.10.2, R12.2,R12.1.3,10g, 11g

Responsibilities:

• 24*7 production & Implementation Application DBA support.
• Oracle Application & database upgradation to 11g, 12c and R12.1.3 R12.2.4
• Oracle Application 11i, R12 support with R12.2.4 and R12.1.3, 11.5.10.2
• Planning and implementing Backup & Recovery using RMAN
• E-Business suit OID, SSO configuration with R12.1.3
• WebLogic/SOA Administration and implementation
• Vertex integration with oracle R12 E-Business suite.
• Worked on shell/perl/python scripting for monitoring alerts
• Supported RAC databases and ASM instances
• Installation and configure golden gate 11.2.1 with unidirectional replication
• Support Golden gate in production and dev environments.
• Configure Golden gate replication parameter for DDL replication.
• Worked tax series update vertex and sabrix with R12 E-Business suite
• Expertise in deploying the Composites in SOA and monitoring the Instances
• EBS upgrade from R12.1.3 to R12.2.4 DB upgrade from 11.2.0.4 to 12.1.0.1
• Oracle data Integrator installation and configure.
• Install and configure new SQL Servers 2014, 2012.
• Oracle EBS R12 DMZ setup for Application server.
• Database schemas management, exp/imp, expdp/impdp, excel files.
• Monitor and scheduled OS jobs using cron and autosys
• Oracle Fusion middleware product installation FMW, RCU, OBIEE, SOA
• Performance tuning of Database and Application servers.
• Worked on OID, OAM and WebLogic and SOA suite
• Performed data guard implementation and support.
• Databases TDE and database wallet configuration.
• Oracle cloud/Amazon AWS migration of E-business suite R12.1.3 instance

Confidential, Regeneron

Senior Oracle Apps DBA

Environment: Oracle Applications 11.5.10.2, R12.2, 10g, 11g

Responsibilities:

• Upgraded E-Business application from older versions of R12.1.2 to R12.1.3
• Support oracle 10g, 11g and 12c database with Application 11i/R12.1, R12.2
• Cloning and refresh of Application and Database servers.
• Implement and support Golden Gate replication in prod and dev environment
• Applied application patches and merged patches manually
• Performed Ad-admin tasks. Performance related issues. Front end login issue.
• Analyzing AWR reports, explain plan & TKPROF results.
• Maintaining Agile server monitoring, Patching, Agile refresh
• SOA server maintenance with PIP servers
• Database upgrade from 11.2.0.3 to 12.1.0.2
• Vertex latest Tax Q series update on database.
• Demantra 12.2.5 Installation and Setup.
• Working various Oracle Apps Utilities
• R12.1.3 DMZ setup for procurement
• SOX changes implementation on Application and Database
• CPU /PSU patch analysis and apply on database and Application
• Created MySQL database and created required tablespaces on servers
• Managing multimode RAC with ASM databases
• Patch analysis and apply for database and applications patches