We provide IT Staff Augmentation Services!

Senior Lead Oracle Apps Dba Resume

SUMMARY

  • Competitive, Dynamic professional with 12+ 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 that 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

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 that includes all flavours 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 this 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
  • Have been highly appreciated by customer for successful implementation with 100% deliverables
  • 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

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 that 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 Confidential 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.5.10 to R12
  • 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 Confidential network and outside Confidential network
  • Goldengate 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 the database system
  • User Management, assigning roles and profiles, Audit in support to SOX for maintaining system security through monitoring user access to the 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

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 Confidential PS-2 project, that covered UK, US, India, Netherland locations
  • Worked along with Business Director IT for successful completion of Confidential PS-2 project
  • Driven six sigma software license projects for Confidential .

Hire Now