SUMMARY

• A Self - motivated and result oriented Professional with more than 12+ years of IT experience, Work experience involves Oracle Apps DBA (11.5.10, R12.0 and R12.1), Oracle DBA and Oracle Golden gate 11g/12c admin.
• 12+ years of IT experience as Oracle Apps DBA/Oracle DBA.
• 4+ Years of extensive experience on Oracle Goldengate 11g/12c real time data replication solution, design and implementation
• Exposure to work on Oracle Exadata Cloud and Oracle IaaS. Migrated (Lift and Shift) large oracle databases 11gR2 and Oracle EBS applications 12.1.3 from on Premise Data Center to Oracle Exadata cloud and Oracle compute cloud nodes.
• Exposure to EBS cloud admin tool to provision multi node EBS instances on Oracle Cloud.
• Experience huge database upgrade from various version 9i to 11g, 10gR2 to 11gR2 and 11gR2 to 12c
• Experience application and huge database migration from on premise to Oracle Cloud environments
• Extensive experience on Disaster Recovery setup for Production Databases Non-RAC and RAC environments
• Complete Life Cycle experience in Oracle Database and Applications projects including Business Needs Analysis, Solution, Design Capacity Planning, Installation & Development, Maintenance & upgrades
• Extensive experience to provide Oracle Database best practice solution, design and implement the Maximum Availability Oracle database Architecture using Oracle RAC, Data Guard, RMAN and Goldengate for mission critical systems.
• Experience on installing and administration of Weblogic 11g/12c and deploying Oracle Middleware applications like ODI, J2EE, OTD and Veridata etc.
• Worked as DBA on diverse platforms on Oracle Databases covering HP-UNIX, IBM AIX, SUN Solaris, and Linux.
• Goldengate SME, anchoring the Oracle Goldengate COE group at Oracle unit level.
• Actively involved in various POCs, RFPs and Training at organization level for various client.
• Actively involved in Client interaction to understand the requirement, further enhancement and maintenance.

TECHNICAL SKILLS

• Oracle DBA - Oracle Database 9i/10g/11g/12c
• Oracle Apps DBA - Oracle E-Business Suite 11i/R12 Installation
• Maintenanceand Administration
• Oracle Goldengate 11g/12c
• Oracle Cloud DBA
• SQL/PLSQL
• Operating System: HP-UNIX
• Solaris 9/10
• AIX Power Machine and Linux 5/6
• UnixShell Scripting
• Oracle Weblogic 11g/12c
• ODI 11g/MDM (AIA11g)
• Oracle Veridata 12c
• Oracle Exadata and Oracle IaaS & PaaS cloud

PROFESSIONAL EXPERIENCE

Sr. Oracle Apps DBA

Confidential

Responsibilities:

• Oracle Apps DBA, responsible for oracle EBS 12.1.3 migration from clients on premise datacenter to Oracle Cloud.
• Provisioning of Oracle RAC databases instances using Oracle Exadata Cloud Service
• Provisioning of Oracle Compute nodes to host the Oracle Application Servers
• Migrated RAC 11.2.0.4 databases from on premise Linux 6 server to Oracle Exadata Cloud RAC+ASM.
• Migrate EBS 12.1.3 applications from on premise Solaris to Oracle cloud compute Linux nodes.
• Implementation of Oracle Traffic Director (OTD) 12.2 to load balance the EBS applications server.
• Implemented OTD as revere proxy server for External iSupplier node.
• Implemented and Configured the Oracle Connection Manager to manage the Oracle Database connections.
• Implement backups using RMAN, disaster recovery using Physical Data Guard
• Recommend solutions and provide guidance to project teams during project Execution.
• Diagnose and Fix the post migration issues

Environment: Oracle ExaCS quarter rack for database and Oracle IaaS Linux 6.x compute for Application hosting

Confidential

Responsibilities:

• Oracle DBA, maintaining, Implementing and administrating Oracle Databases.
• Liaise closely with client Architects, Oracle SME and Developers & Dev Ops resources in order to ensure database design, high availability, performance, scalability and reliability.
• Architecting Oracle database Maximum Availability Architecture (MAA) for critical databases within NAB
• Architecting and implemented various Oracle Goldengate 11g/12 projects which involve ODS replication for Low Value Payments, Offloading Remedy reports from Active Data Guard to Reporting server and NPP (National Payment Program) ODS replication using OGG.
• Recommend solutions and provide guidance to project teams during project Implementation
• Performed POC to Upgrade and Migration Oracle 11gR2 to 12.1.0 from AIX to Exadata Machine using GoldenGate with zero down time.
• Provide recommendations for leveraging the existing security policies and compliance with statutory obligations
• Accountable and responsible for managing server capacity requests and forecast
• Use the Oracle Database tuning methodology and available tools AWR, ASH, ADDM etc.
• Apply database patches, updates and perform upgrades as per Software Roadmap
• Design, install, configure and support Oracle Real Application Clusters (RAC)
• Implement backups using RMAN, disaster recovery using Data Guard
• Use Enterprise Manager performance-related pages to monitor an Oracle Database
• Diagnose and tune common SQL related performance problems

Environment: Oracle Database 11g/12c, Oracle GoldenGate 11g/12c, Oracle RAC 11gR2/12c, Oracle Data Guard, Oracle Veridata 12c

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Establish Instance Strategy.
• Installation and maintenance of R12.0/R12.1 environment.
• Oracle Discoverer 10g Installation and Integration with Oracle E-Business Suite R12.
• Upgrade Oracle E-Business Suite from 12.0.4 to 12.1.3
• Installation and administration of Weblogic server11g, SOA Server 11g and AIA 11g (Application Integration Architecture).
• Integration of PIM 12.1.3 E-Business Suite with Inventory E-Business Suite via Fusion Middleware AIA11g PIPs (Product MDM PIP).
• Plan growth and changes (capacity planning)
• Establish and maintain backup and recovery policies and procedures.
• Setting up monitoring templates for various Oracles targets such as Database, E-Business suite, Oracle Applications servers, etc.
• Patching Oracle Applications and Database
• Using Rapid Clone to clone the Oracle Applications. Implementing Refresh strategy.
• Tuning Database and Application.

Environment: Oracle E-Business Suite 12.0.4/12.1.3 , Oracle Database 11g, Discoverer, Oracle Workflow, RMAN, Data Guard, MDM.

Confidential

Oracle Apps DBA

Responsibilities:

• Support of 11.5.10 environments.
• Troubleshooting
• Support for Oracle 10g databases RAC two nodes.
• Patching Oracle Applications and Database
• Using Rapid Clone to clone the Oracle Applications
• Using AD Utilities
• Workflow Administration
• Concurrent Manager Setup and scheduling.
• Database re-organization.
• Administering Concurrent Managers.
• Implementing changes as requested either by client or from internal support team.
• Implementing any change within the environments
• Menus, Forms, Report, Table and View Registration
• Creation of users, responsibilities, managing concurrent managers, setting profile options, managing access to users
• Enrolling users and maintaining system security
• Define users’ responsibilities and menus

Environment: Oracle E-Business Suite 11.5.10, Oracle Database 10g, Discoverer, Oracle Workflow

Confidential

Oracle Apps DBA

Responsibilities:

• Maintain, Administer Oracle Databases (9i/10g)
• Maintain, Administer Oracle Applications (11.5.10)
• HRMS upgrades to Family Pack K and ATG RUP 4
• Implementing custom templates to negate changes from ATG RUP4 for Autoconfig
• Patching Oracle Applications and Database
• Using AD Utilities
• Using Rapid clone to clone Oracle Applications
• Installation and Configuration of new Oracle 11i Applications (11.5.10) .
• Implementing Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management
• Shell scripts to automate and improve predefined tasks
• Oracle Workflow administration
• Using OAM to maintain and configure Oracle Database
• Creating and Rebuilding Indexes
• Reorganization of database tables
• Day to day Database Administration tasks
• Using cron to schedule jobs
• Performance monitoring and tuning
• Provided Technical and Architectural solutions for Implementations of Oracle ERP Environments
• Dealing with Oracle for support by raising SR's or using Oracle Forums

Environment: Oracle Applications 11.5.8/11.5.10 , Oracle Workflow, Oracle Data warehouse, HP-UX B.11.23.