SUMMARY

• A highly accomplished infrastructure DBA Tech Lead handling Oracle databases and Oracle Applications ERP & EBS from 11 Years, Strong expertise in Oracle databases, Applications E - Business Suite 11i/R12.2 overseeing the streamlined operations of DBA Services.
• Oracle Apps Database Lead, having hands on expertise in database & application administration, production support, installations, configurations, upgrades, migrations, releases, patches, performance tuning, backup/recovery, cloning, space management, database security, auditing, troubleshooting, database design, high availability, oracle metalink support, disaster recovery, Unix shell scripting and documentation.
• A strategic planner with competency in efficient Database strategy and executing the same with a view to achieve highest availability and performance.
• Experienced with Oracle Enterprise Manager, RMAN, ticketing system, Kintana Tools, SVN, Puppet etc.
• Experience on Highly Integrated Telecom, Health care industry database systems, managing large Oracle databases
• Expertise with Oracle Apps R12 and 12c Databases
• Expertise in OracleGoldengateproficient in Oracle 11g/12c software installations, migrations, database capacity planning, automated backup implementation, performance tuning on Linux/Unix and AIX Platforms.
• Expertise in integrating oracle identity manager(OIM) with fusion middleware products OID, OAM and third-party products like Active directory etc.
• Upgraded current OIM and OAM 11gR2 PS2 implementation to OIM and OAM 11gR2 PS3 and also migrated customizations to 11gR2 PS3.
• Expertise in Oracle Applications upgrade from 11.5.10.2 to R 12.1.3/12.2.5 and Oracle Database upgrades from 10.2.0.5 to 11.2.0.3, 10.2.0.5 to 11.2.0.4 & 12C
• Expertise on end to end administration of Oracle EBS 11i / R12.2 on RAC/ASM
• Expertise in end-to-end implementation of IAM solution using Oracle's suite of Identity and Access Management
• Maintenance and support of OBIEE 10g and 11g including DAC and Informatica
• Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operation.
• Expertise on PCP and middle tier Load balancer setup / troubleshooting
• Expertise in proactive patch management, cloning, code migrations, release management
• Expertise in troubleshooting Oracle EBS issues related to Concurrent Manager / OPMN / Workflow.
• Expertise in Golden Gate replications, shareplex, defining software for tasks associated with the developing, debugging or designing of software applications or operating systems.
• Specify, design and implement modest changes to existing software architecture to meet changing needs. Oracle Golden Gate (OGG) provides a complete solution in high availability, real-time data integration, transactional change data capture, data transformations, and verification.
• Installation of RMS(Retail Merchandising System) in Oracle database 11G and supporting performance issues to business users in order to resolve complex inventory issues
• Expertise in working on Production Support issues of WebLogic & SOA middleware Administration.
• Experience with installing and upgrading E-business suite R12.2.
• Experience in Web logic and Fusion Administration.
• Implemented ASCP, Demantra and ODI in multiple R12 environments.
• Implemented Oracle Ware house management in R12 environments.
• Experienced with SOX, FDA audit and compliance procedures.
• Experienced with system roll-outs and change management during project implementation.
• Proven ability to combine project and staff management with technical expertise to consistently exceed corporate goals.
• Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually. Possessing excellent developmental and analytical skill

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Responsibilities:

• Senior Oracle Apps DBA responsible for Oracle 12C databases, 11i ERP, R12.2.3 + R12.2.5 Oracle E-Business & boundary systems and maintaining security as per standards
• Managing Oracle Support team supporting Oracle EBS, Database including RAC, OBIEE, SOA/ Weblogic and custom applications developed on various Oracle platforms
• Implementation of Oracle E-Business which includes latest versions of R12.2.3 and R12.2.5, Oracle Databases, EBS Tech Stack, EBS Applications and standalone Oracle Fusion Middleware using OS distribution, OPatch, adop, bsu and custom deployment scripts
• Technical Research and implementation of Latest CPU patching of Operating system, Grid Infrastructure, RAC, EBS & Weblogic
• Implement & Configure DMZ/Reverse Proxy to EBS and monitor Application health & support network firewalls following standard security systems
• Implemented & set up oracle identity and oracle access managers under delegated administration
• Involved in User provisioning, groups & organization level provisioning security set up provisioning to OID & AD from OIM
• Extensively worked on integrating OIM, OAM applying single sign on to oracle EBS application R12.2 & configured authentication & authorization policies for protecting Confidential web applications with SSO functionalities
• Extensively participated in integrating OIM, OAM, OID to Confidential internal password repository application to ensure passwords are protected with security as per policies
• Install oracle RMS in Oracle database 11G and support RMS performance issues with development teams
• EBS & Functional deployments using Puppet and Confidential tools (Piper, g4 & Rapid)
• Responsible for resolving R12 Security bugs following oracle standard way maintaining through Confidential policies
• Day to day analysis on Oracle 12C database, maintaining Schema’s Audit & working on R12 Security features assessment
• Implementing standardization of EBS/JSESSIONID cookies with HTTOPNLY/SECURE, Webfe deployments to block black listed JSP’s & redirects security features as per Confidential requirements
• Regular DBA support, monitoring 11i/R12 environments & helping functional teams as per requirements

Confidential, Connecticut

Responsibilities:

• Global Apps DBA responsible for Oracle E-Business Databases, 11i ERP, R12.2 EBS Applications and custom applications.
• Implementation of Oracle E-Business which includes latest versions of R12.2.3 and R12.2.5.
• Oracle SOA Gateway for EBS 12.2 with ADF installation
• Implementing OBIEE in oracle 12C databases and support OBIEE Applications to ensure customer advocacy in providing OBIEE reports in time.
• Oracle Fusion Middleware Installations
• Monitoring Oracle RMS 13.1 Application and resolve complex performance issues related to retail & inventory forecast and ensure business users are actively processing reports
• Price, Quote, SAP & RMS components and Installations.
• Provide consulting to client for best practices to be followed and manage documentation, issue tracker & time capturing for all the installations.
• Upgrading 11G 11.2.0.4 Oracle databases to Multitenant 12C databases and migrating 12C oracle databases to Exadata in a specific migration process.
• Integrating OIM (oracle identity manager) with fusion middleware products OID, OAM and resolving complex WebLogic performance issues
• Involved to set up OAM and creating application domains & setting up web gates & proxy configurations
• Worked with various application & functional teams to get all data sync witgh directory services
• Implementation of new ideas to customer with latest installed E-Business modules
• Monitor and check all E-Business Applications & databases are healthy
• Technical project lead for Oracle E-Business 12.2 implementation for Financial and Leasing modules
• Implement ASCP and Demantra in R12.2 environments and monitor closely & fix for any issues
• Cloned Oracle Database and applications for R12.2.3
• Worked on applying patches using ADOP utilities.
• Effectively troubleshooting on User problems and coordinating with functional teams on deployments.
• Troubleshooting performance related issues by working with Development Team using Explain Plan and tracing techniques.
• Analyzed and applied latest TXK7 Delta Patches.
• Worked on DC Migration for Production and Non-Production Instances.

Confidential, Allendale, New Jersey

Responsibilities:

• Leading implemented DR Solution for Oracle E-Business.
• Leading DBA team operational support and Migrations.
• Supporting Demantra implementation & R12 upgrade for APS System.
• R12 implementation for applications
• Strategic Support for MDM, SOA, CTMS and Aurgus rollouts.
• Strategized, designed, vendor selected and implementing Global Support Team under offshore Model.
• Coordinating offshore team on daily operations support
• High Visibility on Database Audit model with business to ensure database systems meet with IT Quality
• Implemented, administered, reorganized and subsequently tuned all Oracle databases (development - production) databases
• ONSITE Support Model/Leading Offshore team, Responsible for 24*7 supporting 500+ Oracle databases (11g/10g/9i) wherein the major chunk of the databases hold data of enterprise applications as a Database, PLM, WINDCHILL Process applications and ORTHO Spine
• By Implementing the Advance Security Wallet Manger on oracle 10g database, solve many audit and application connectivity issue.
• Successfully migrated Oracle 10g databases to Oracle 11g databases
• Responsible for analyzing and designing the process to implement the oracle patch sets available in Oracle.
• Responsible key member in designing/testing/implementing enterprise level move from user-managed backups to RMAN on Oracle 10g environments.
• Configured database cloning to copy production to other prod copy (for adoc report purpose) using Business Continuity Volumes (BCVs).
• Responsible for Validating Database integrity, security, auditing through SOX twice years to ensure the databases are FDA compliant.
• Involved in performing Disaster Recovery drills twice a year for all production systems using BCV splits of remote standby databases and tape recovery for non-BCV enabled systems.
• Maintaining strong working relationship with customers (UNIX, storage, developers and team leads).
• Prepare validation documents for database setup (installation, configuration, operation, etc.) in a FDA regulated environment.
• Strictly followed Change Control/Change management procedures as laid down by the organization in a highly qualified environment.
• Strongly involved in daily meetings with business in terms of growth, organizing more systems to improve quality on databases
• Followed compliance policies, monthly/quarterly/yearly Audit requirements & maintained standard metrics delivered as per SLA
• Implemented and worked in organized structure to troubleshoot on Critical concurrent programs performance issues, long running jobs & maintained good rapoo with users to ensure there are no issues from database
• Involved in creating, maintaining and refreshing required Oracle instances/databases for development, test and production environments.
• Provided DBA support to the application development and acceptance team, both onsite and offshore for loading and
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes
• Was responsible for setting up standards for database maintenance and monitoring.
• Responsible for Report generation, monitoring disk usage, keeping systems healthy for the production environment.
• Implemented changes into the existing cron jobs as per the business needs.
• In conjunction with the security administrator established and managed user access, along with designing and implementation of user environments, also establishing enterprise level security standards.
• Extensively used metalink for resolving technical issues, opening SR and use collaborative support for database related issues.
• Responsible for documenting important scripts and administration of server environment.
• Responsible for conducting weekly meeting, tele/video conference with clients, development teams both onsite as well as offshore.

Confidential, San Jose, CA

Responsibilities:

• Upgraded oracle applications from 11.5.10 to R12 on RHEL5.
• Involved in Cloning and patching of oracle applications 11.5.10/R12.
• Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments.
• Responsible for Installation of 11g database on 2 nodes RAC, Grid Infrastructure with ASM file systems.
• Expert in effective troubleshooting of those problems encountered daily in production & development database environments along with the problems encountered in performance monitoring.
• Provided Database Administration support (24x7) for 8TB production oracle 11g Databases.
• Responsible for installation, creation of 11g RAC databases for Development and user acceptance test.
• Responsible for Upgrading the Database from 10.2.0.3 to 11.1.0.6. Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Responsible for undo rollback management. Created database objects, users, roles and profiles
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.
• Excellent in depth understanding of Oracle automatic Undo Management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Updated development databases by using import/export and SQL loader utilities.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
• Responsible for configuration and implementation of backup and recovery using RMAN.
• Installed and configured Recovery Manager Catalog Database.
• Configuration of Shareplex (Dell Support) between two databases.
• Responsible for automation of startup and shutdown on all production and development databases.

Confidential

Responsibilities:

• Upgraded oracle applications from 11.5.10 to R12
• Involved in Cloning and patching of oracle applications 11.5.10/R12.
• Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments.
• Responsible for Installation of 11g database on 2 nodes RAC, Grid Infrastructure with ASM file systems.
• Expert in effective troubleshooting of those problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.
• Provided Database Administration support (24x7) for 8TB production oracle 11g Databases.
• Responsible for installation, creation of 11g RAC databases for Development and user acceptance test.
• Responsible for Upgrading the Database from 10.2.0.3 to 11.1.0.6. Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Responsible for undo rollback management. Created database objects, users, roles and profiles
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.
• Providing 24X7 Oncall DBA support for 500+ Production instances
• Installation, maintenance cloning, patching and post Go-Live support of Production and development environments.
• Experience in Installation and configuration of Oracle Applications E-Business suite 11i and Licensing the new Oracle application products
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during implementation
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data
• Work with Oracle support in resolving bugs, bug fix patches, multiple sev 1 SRs etc
• Implement oracle standard procedures for purging, archiving solutions.
• Created the new custom top on Oracle application tier
• System Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request Sets
• Handling issues related to concurrent manager and performance of concurrent manager
• Performed multiple clones from Production to Test environments
• Performed tracing for various user sessions and for various concurrent Programs
• Managing backups of the apps instances & maintaining daily hot backups of database of dev/test and involved in recovery of database
• Regular checking alert log and trace files for errors
• Expertise in configuring Workflow Mailer, troubleshooting and rebuilding workflow queues as and when necessary.

Confidential

Responsibilities:

• Installation, configuration, upgradation, Patches and maintenance of oracle database of oracle 10g & Oracle 11g&12c on RHEL.
• Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure
• Managed Users and maintained security, populated databases of oracle 10g & oracle 11g on RHEL, Solaris and windows 2003.
• Converted single Instance Databases to RAC databases manually and expertise in troubleshooting RAC issues,
• Migrated, upgraded Oracle databases from 9i/10g/11gR1 to 11gR2/12c including the cross platform.
• Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
• Work with development teams to implement change management for custom code migrated into environments.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. Performing monthly and annual performance reports for trend analysis and capacity planning.
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance
• Performed Data guard switch over to check the standby database is in SYNC with production as per the business requirement and also operated standby database using Data Guard broker.
• Extensively used Flashback for Supporting DML, DDL changes, and handled daily production problems/change requests (DBCRS) with Oracle Patching.
• Perform activities related to the day-to-day administration and maintenance of database systems.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Taking the RMAN incremental and cumulative and scheduling the databases backup using Cron tab.
• Developed backup, restore and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions

Confidential

Responsibilities:

• Applying high priority, security patches, patch sets to oracle using OPatch Utility, runInstaller.
• Database Refresh/Cloning from production to setup test (QA) and development environments.
• Planned and implemented Disaster Recovery (DR) solutions using Oracle Standby Database/Data Guard.
• Experience with SQL, PL/SQL and UNIX Shell Scripting, writing stored procedures, functions and database triggers for maintaining data integrity in the databases.
• SQL Query tuning, application tuning using sql trace, explain plan, hints, tkprof, AWR reports, Statspack reports, ADDM reports, initialization parameters, etc.
• Partitioned the large tables and indexes by determining the suitable methodology to improve performance and manageability, Extract, Transform and Load (ETL) data from flat files into database using SQL* Loader.
• Defining and implementing Backup and Recovery Strategies on production, test, development databases using RMAN, VERITAS Net backup, and RECOVERPOINT, Hot and Cold Backups.
• Recovered tablespaces, datafiles on Oracle 10g using Recovery Manager (RMAN).
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS).
• Crontab jobs and UNIX Shell scripts to automate backups, exports/imports, analyzing table’s indexes, monitor tablespace growth, alert logs, startup, shutdown of databases, gathering statistics.