SUMMARY

• Having 9.5+ years of IT industry experience as Oracle DBA, Oracle Apps DBA and Oracle Fusion Middleware Administrator in Implementation, Upgrade and Support projects on multiple platforms (Linux, Sun Solaris, IBM AIX and Windows).
• Worked as team lead as well as team member in different projects and currently leading a team of 12 DBA’s and managing 90+ non - production and 35+ production environments.
• Involved in all phases of project life cycle including requirements gathering, planning, POC and implementation.
• Created and maintained the technical documentation for applications, starting from requirement gathering to till the completion of project.
• Comprehensive understanding of change control system, business initiated issues and follow-up procedures and processing of emergency and non- emergency tickets.
• Supervised and implemented the process of reviewing routine activities, code move process to QA and production in collaboration with the IM managers, to assess the security, compatibility, operability and supportability.
• Established practices to track and record application & database security issues and worked closely with the Security Administration groups to ensure alignment on all security processes, procedures and implementations.
• Served as the primary point of contact on behalf of the DBA team, who was responsible for coordinating critical upgrades, releases, GO LIVES and disaster recovery procedures directly impacting the stability of database/application.
• Delivered the excellence in customer service through problem analysis and timely addressed the issues as per SLA.
• Have good knowledge on Golden gate and good experience on Oracle streams.
• Managed the several assignments simultaneously and meet deadlines.
• Created and configured the FWM (SOA, WebLogic, and OHS) Clustered environments.
• Upgraded the Oracle WebLogic from version 12.1.1 to version 12.1.3
• Upgraded the SOA FWM from 11.1.1.6 to 11.1.1.7.
• Installed and Configured Oracle AIA Foundation Pack for Oracle FMW 11g SOA.
• Created and configured the Oracle WebLogic domains & Managed servers
• Worked on security roles, user authentication, auditing and authorization
• Deployment and troubleshooting of JAR, WAR, and EAR files.
• Installed & configured the oracle HTTP server on the Web tiers.
• Configured the oracle http server with SSL & load balancing.
• Cloning of FMW environments from production to DEV/VT/QA as per the requests
• Analyzed and applied the patches to SOA, WebLogic and OHS servers.
• Supported 28+ non-production and 8 production FWM environments in 24*7 model.
• Created the wallets. Generate CSR and renewed the SSL certificates.
• Installed and configured the oracle EBS R12 (12.1.1) and R11i (11.5.10.2).
• Upgraded the Oracle E-Business suite environments from 11.5.10.2 to R12.1.3.
• Planning go-live, upgrade downtime reduction and Resource management.
• Analyzed and applied the Application patches and tech stack patches.
• Applied vertex/tax related patches (Customer specific) on every month.
• Good experience in cloning from Production to Dev (RAC to non-RAC and vice versa).
• Created and configured the EBS applications with single sign on (SSO).
• Performed Oracle applications Jar file signing.
• Worked on PCP, Shared APPL TOP, Oracle wallets and SSL certificates.
• Supported 30+ non-production and 6 production EBS environments in 24*7 model.
• Planning and execution of release cycles, periodic maintenance outages for critical patch updates.
• Coordination with various Application support teams, functional/technical consultants and end users.
• Created and configured 11g/12c RAC databases and single instance database
• Upgraded the oracle grid/cluster from 11.2.0.3 to 12.1.0.2
• Upgrade of databases from 10g to 11g and 11g to 12c (12.1.0.2 RAC Database)
• Upgrade of EBS database from 11.1.0.7 to 11.2.0.4.
• Worked on Oracle streams setup and initiated 200+ Oracle tables from source to target database
• Created and configured the oracle data guard.
• Performed the database drills & disaster recovery.
• Worked on database cloning from single node to multinode and vice versa.
• Analyzed and applied PSU patches to Oracle grid and databases.
• Worked on data file and block level recovery.
• Supported 60+ non-production and 25+ production databases in 24*7 model.
• Good experience on oracle OEM12c, EM agents, addition of new targets, hosts, databases, scheduling jobs, Metrics setups, named credentials, blackouts etc.
• Analyzed and applied the patches to OEM database and OMS.
• Have brief knowledge on Oracle UPK and Oracle e-Billing products.
• Installed & configured the oracle self- service e-Billing software as per client requirement.
• Oracle UPK knowledge center upgraded from 12.1.0.0 to 12.1.0.1.

TECHNICAL SKILLS

Operating System: LINUX RHEL 6.8, 5 & 4, IBM AIX 5.3, Sun Solaris 5.10 and windows Server 2003/2005/2008

Oracle Fusion Middleware: SOA (11.1.1.6, 11.1.1.7) WebLogic server 12c (12.1.1, 12.1.3)Oracle http server (OHS) 12.1.3, Oracle AIA 11.1.1.7.

Oracle E-Business Suite: Oracle Applications 11i & R12 (R12.1.3, 12.1.1, 11.5.10.2) Oracle 10g Developer Suite, Oracle Forms & Oracle reports.

Oracle Database: Oracle database 10g, 11g & 12c, Oracle Streams, Oracle Golden gate.

Programming Languages: SQL, PL/SQL

Oracle Utilities: Oracle Applications Manager (OAM), Oracle Enterprise Manager (OEM), RMAN, Oracle Form Builder, Oracle Report Builder, AD utilities (adadmin, adpatch, adconfig, adcfgclone, adctrl, admrgpch, adident, adsplice,adrelink), RCU, WLST, PSA, oracheck, expdp, impdp etc.

Tools: Putty, VNC viewer, Xming, WINSCP3, MobaXterm, PL/SQL Developer, SQL Developer, Toad.