SUMMARY:

• Competitive, Dynamic professional with 15+ years of total experience as an Oracle DBA/Apps DBA on UNIX/LINUX and Windows Servers environment.
• Excellent working knowledge of Oracle E - Business Suite Applications R12.2.7 and R12.2.X, R12.1.X, 11i, ASCP and Oracle Database versions 19c, 12.1.0.2, 11.2.0.4, 10g on Solaris and EXADATA Linux Platform
• Implementation and support for EBS and ASCP R12.2.7 on Exalogic on Exadata (X8-Half RAC) systems
• Expertise in Installation and support for OBIEE 12c, OBIA 11g, APCC 12.2.1.2 on OBIEE 12c, ASCP-SPWA 11.1.1.9, GoldenGate 12c, ISG/SOA EBS 12.2.7 (SOAP and REST) and Demantra 12.2.7
• Good exposure on Exadata Database Machines X-8, X-7, X-6, X-4 half RAC and Exalogic systems
• Expertise in Oracle Cloud Infrastructure move projects for EBS, ASCP, OBIEE applications from ON-PREM to OCI
• Excellent in troubleshooting issues and root cause analysis related to database and Oracle EBS, OBIEE, OBIA, ASCP and Weblogic administration
• Expertise in Oracle EBS and Database upgrades and Installation
• Installation/Setup & Maintenance of multiple 11gR2/12C RAC environments with ASM Clusterware on Exadata machine.
• Implemented Data guard physical standby database on Exadata RAC ASM systems and performed switch overs during maintenance activities
• Good Knowledge on creating Partitions and Sub partitions for ASCP tables
• Good Experience in Performance Tuning of Database and application, Proactive performance Tuning activities like Baseline, execution plans, trace file, AWR, ADDM analysis and recommendations.
• Trained and certified in Oracle Exadata database machines
• Expertise in various Application Maintenance and Patching activities
• Extensive experience in troubleshooting various performance, technical issues in EBS 11i, R12.1.X, R12.2.X and Oracle database from10g to 12c
• Expertise in Database backup and restore, upgrades on various OS like Linux, OEL and RAC database
• Experienced in using Import and Export database utilities, Data pump, configuration of SSO and SSL in EBS 12.2.7 and OBIA environments
• Setting up and maintaining Golden Gate on Oracle 10g, 12c databases
• Implemented classic Golden gate replication as well as integrated replication
• Troubleshooting issues related to GoldenGate replications
• Worked as Technical Project Manager for Database upgrade project from 10g to 11gR2 for total 42 Instances dat includes 14 Prod upgrades
• Worked as Tech Lead for ClearCase Implementation project and Global co-ordinator for Infrastructure projects
• Knowledge in other databases like PostgreSQL, MSSQL
• Experience in Release Management ITIL process for code migrations
• Experience in creating project cutover plans and driving cutover meetings
• Expertise in resolving performance related issues related to custom code and concurrent managers, weblogic and FMW related issues
• Expertise in Custom Code Migration activities along with Code Reviews and Technical Reviews
• Experience in EBS cloning and refreshes of 11i, R12 applications and database on both RAC and NON RAC database
• UNIX shell scripting knowledge and carried out multiple automations
• SOX audit quarterly data and managing CAR and reviews with auditors
• Work experience in multiple geographical locations USA, UK, India
• Commitment to deliver big projects timely with highest customer satisfaction
• Strong interpersonal and presentation skills, great ability to interact with customers and vendors

TECHNICAL SKILLS:

Databases: Oracle Database 19c, 12c, 11gR2, 10g, PostgreSQL, MSSQL

Operating Systems: OEL 6 and OEL 7 Unix operating system, Unix Solaris on SPAC 64-bit, Linux X-86 on Exadata and Exalogic, Redhat Linux

EBS Version: Oracle EBS and ASCP R12.2.7, R12.1.3, 11.5.10

Tools: and Applications: OEM 13c,12c, 11g, RMAN Backup and Recovery, FMW, iStore, iSupplier, Demantra, Application Manager, OBIEE, OBIA APCC, ISG/SOA, Goldengate, Dataguard, Toad, Remedy, SNOW, UNIX shell scripting, TDE and SSL wallets, AWR and ADDM reports

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Senior Lead Oracle Apps DBA

Responsibilities:

• Lead DBA for Implementation and support for Oracle EBS and ASCP R12.2.7 on Exadata and Exalogic servers on X-7 and X-8 Half RAC machines
• Installation and support for OBIA (OBIEE+ODI) release 11.1.1.8.1 & 11.1.1.10.2 , APCC on OBIEE 12c 12.2.1.2.0 , ASCP-SPWA 11.1.1.9 and Oracle Integrated SOA Gateway (SOAP and REST)
• Installation of multiple Production Instances on single Exadata and Exalogic machine
• SSO and SSL configuration for OBIEE environments with OUD and LDAP ODSEE
• Troubleshooting issues and planning and implementation for OBIEE and EBS and ASCP version upgrades passive and active replication
• ASCP creation of partitions and sub partitions on big tables to increase performance
• Carried out 12c to 19c database upgrade as POC on Exadata RAC machines
• Upgrades and clones of EBS and Databases on Exadata RAC ASM environments
• Demantra 12.2.7 installation on windows interfacing with R12.2 ASCP applications
• Worked on EBS, ASCP, OBIA migrations from ON-PREMISE to OCI
• Logical hostnames setup for EBS, OBIA, APCC, SPW applications
• OCI Installation of APCC with OBIEE 12c, SPW supporting applications for ASCP
• TDE and SSL Wallet configuration for 11g and 12c databases on RAC environment
• Weblogic installation, configuration and deployment of various applications
• 11.2.0.3 to 11.2.0.4 and 12.1.0.2 upgrade for RAC databases on Exadata Machine
• Implemented DR sites using Physical Data guard of Oracle application RAC database and performed switch over testing
• Troubleshooting issues related to Data guard replication
• Switchover to Secondary DR during Exadata & Exalogic patching activities
• Migration of customized code across instances using adop patching cycle
• Cloning EBS and ASCP 12.2.7 using automated scripts
• Cloning for OBIA Instances release 11.1.1.8.1 and 11.1.1.10.2
• Application Manager Installation and upgrade from 9.2.0, 9.3.0 and 9.3.3 versions
• Configsnapshot tool Implementation for setup, roles and responsibilities migrations
• ILM installation and upgrade for Oracle Smart Partitioning Implementation
• Multiple automation carried out in Project like OBIA start-up/shutdown, R12.2 release code migration etc though Unix shell scripting
• Setting up and maintaining Golden Gate on Oracle 10g, 12c databases.
• Implemented classic Golden gate replication as well as integrated replication.
• Troubleshooting and Administration of GoldenGate 12c
• Implementation and support for 60 plus Instances dat includes all flavors of environments like EBS 12.2.7, OBIA 11.1.1.10.2 , Appworx 9.2, RAC 11gR2, 12c on Exadata machine, Demantra etc
• Monitoring Exalogic and Exadata instances through OEM 13c
• Raising Oracle SR for critical issues and work with oracle team till resolution
• Change Management activities, co-ordination for IT projects and Production migrations and Installation and support for Atomic Appworx Application Manager
• Handling technical code reviews along with development team
• Release Management ITIL process for change management for code migrations
• Generate and Provide monthly reports, planning for upgrades and team co-ordination
• Interaction with PMs, IT Leads, Business stakeholders, Design Leads for New Implementation and roll-out of projects
• Interaction with multiple vendors and teams like Oracle, MW, Web Team, SOX Auditors, Exadata, IAM, F5 Load Balancer, Firewall, Windows etc
• Applying latest application technology patches on quarterly basis

Confidential

Lead Oracle Apps DBA

Responsibilities:

• Implemented EBS R12 (12.1.3) suite with India Localization
• Implemented Isupplier, RMAN, OEM, IAS upgrade to 10.3.0.5 as part of dis project
• Customized mailer setup with IMAP configuration
• R12 implemented with 11gR2 on Solaris Sparc 11
• UPK (R11) single user installation and contents published through web login
• Production instance implemented on high end servers with OS cluster and separate LDOM’s for database and application node
• SHA-1 setup for Isupplier node with around 60 application patches, data fixes and 22 fresh install or clones carried out during implementation project
• Entire Implementation project carried out in record duration of seven months
• Configured and used highly advanced in-house developed tool for data migration from 11i to R12
• Co-ordinated with IT Managers for project deliverables and UNIX team for designing and implementation of R12 on new infrastructure
• Has been highly appreciated by customer for successful implementation with 100% deliverables

Confidential

Technical Project Manager

Responsibilities:

• Delivered database upgrade for 42 EBS Instances in short spam of six months
• Headed a strong team of 21 DBA’s and 5 Technical support members dat looked over testing of key critical jobs
• Project planning, execution and convinced business for upgrade benefits
• Upgrade project included critical finance upgrade with database size of 2.7 TB & Multi location MFG site upgrade
• Maintained repository & provided solutions for around 40 DBA & Technical issues faced during upgrade
• Worked along with Oracle PUMA program especially designed for critical upgrades
• Reduced upgrade downtime by using pre-patched oracle home during all upgrades
• Carried two iteration of upgrades with key critical business jobs testing before Prod upgrade
• Project timely deliverables has been highly appreciated by Cummins top management & Business IT leaders
• EBS ChainLink database upgrade from 9i, 10g to 11gR2
• Worked on automation of MWA setup across all EBS Instances

Confidential

Senior Oracle Apps DBA

Responsibilities:

• 24*7 Production support for Oracle Application 11i, R12.1.3
• Application Upgrade projects 11.
• Database upgrade projects 9i to 10g and 10g to 11g
• Cloning, Refresh (Manual and Automated using RMAN & customized scripts) from Production to proxy test and development instances
• Reviews and migration of code and objects across instances
• Implementation of Logical Apps, Review and migration of Apps Rules across instances
• Setups FTP communication across Cummins network and outside Cummins network
• Golden gate Installation and support
• Moving instances across servers, cloning Multi node to Single Node instances, single node to multi node configuration
• Discoverer administration of EUL, scheduling reports, workflow setups
• Maintaining ClearCase servers and monitoring Chain link instance
• CUSTOM.pll Special Migrations and forms personalization implementation
• Allocating system storage and planning future storage requirements for teh database system
• User Management, assigning roles and profiles, Audit in support to SOX for maintaining system security through monitoring user access to teh database
• Support for Planning Instance ASCP & Demantra
• SR support and OWC conference support
• Performance analysis & providing fixes for customized jobs
• Managed team and groomed their personal and technical skills
• Worked on new POC’s and presented same to business leaders
• Co-ordinated with various support groups like UNIX, Storage, Appworx etc
• Daily Instance performance monitoring through OEM
• Generated monthly reports and presented to key critical business IT leaders
• Server space management and Monitoring Backups though Appworx 8 and scheduling cronjobs
• Worked on automation of MWA setup across all EBS Instances

Confidential

Project Manager, Global Onsite Co-ordinator

Responsibilities:

• Leading strong team of 23 Engineers
• Managing and providing support to 56 remote offices across Maharashtra and Goa
• Handling stringent SLA of IBM and Escalations
• Holding weekly review meetings with team and IT Leads
• Handling processes as per IBM and generating reports for same
• Provided Infrastructure support for Oracle 8i MES Reporting server, Lotus domino administration,
• Citrix, Check Point Firewall, VLAN, Switches, Routers, RAS, Wan/LAN networks
• Implementation of Security Policies GSD for Servers and Network
• Windows/Linux Backup Management
• Worked as Onsite Coordinator for Cummins PS-2 project, dat covered UK, US, India, Netherland locations
• Worked along with Business Director IT for successful completion of Cummins PS-2 project
• Driven six sigma software license projects for Cummins.