SUMMARY:

• 17+ years in Oracle Applications installation, setup, implementation, customization and product support of Oracle Applications R12 (12.1.3), 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2) and connected systems integrating with Fusion Middleware components
• 17+ years in Oracle 7, 8i, 9i, 10g and 11g,12c Administration and trained in MongoDB 3.2 from Confidential
• Hands on experience on ERP 12.2
• Involved in Weblogic cluster setup and support environments which has integration with E - Business systems and also Agile Environments(Clustered Setup)
• Involved in DMZ setup for E-Business system and also load balancer setup
• Hands on experience on Oracle Database advance security features like TDE, encryption and redaction
• Involved in supporting SOA fusion applications like webcenter, weblogic etc
• Expert in database installations, upgrades, instance creations and refreshes from Production to Test and Dev Environments
• Involved in Data masking of sensitive data from Prod to Non-prod during cloning proces
• Maintained and administered RAC instances and ASM
• In-depth knowledge of Oracle backup/recovery techniques, RMAN
• Extensive DBA experience in maintenance, development, Export/Import and Backup/Recovery
• Hands on experience on middleware technology productions like SOA,BPEL and webcenter
• Experience and exposure to Oracle Application Server, portal, SSO and OID
• Experience in database upgrade methods and the upgrade process for all versions
• Strong knowledge of installing, and configuring 9i, 10g OEM and Cloud Control 12c
• Performed daily tasks of analyzing schemas and objects, creating and maintenance of tables, indexes, tablespaces, rollback segments, datafiles, control files, creation of users and database security
• Hands on experience on Oracle Advanced Security with Oracle Key vault, Audit Vault and Database Firewall
• Configured and maintained SQL.Net, listeners and the config files
• Installed and Configured Oracle Application Server (Oracle 9i and 10g)
• Cloning of Oracle applications on RAC and non-RAC environments from multi node to single node
• Involved in DR/standby database setup
• Hands on experience in Oracle Agile 9.3.3 PLM upgrade from 9.3.0.2 cluster configuration
• Involved in cross platform migration of Oracle Applications from Solaris to Unix
• Created users, responsibilities, menus and form functions, registering reports
• Automated the application and database jobs to cleanup logs
• Administered Concurrent Managers and Concurrent Processing
• Implemented PCP and Application failover for R12 environment
• Analyzed application patches and expert knowledge of patch application process using adpatch utility
• Implemented the automation of the patch to reduce the system down time
• Involved in identifying and analyzing the latest CPU patches for all eBusiness applications, Oracle and Oracle middle tier
• Developed and implemented Unix shell scripts for automation of patching
• Involved in automation of the ERP cloning using Unix shell scripts
• Expert knowledge of all admin tasks using ad utilities
• Configured Forms, Report Servers and Printers in Oracle Apps,
• Monitored the Applications and database performance using OEM Grid Control
• Expert knowledge of administering and troubleshooting of Oracle applications Server issues
• Used Oracle Metalink, opening TARs, TAR escalation process, executing and communicating the steps recommended to end users
• Worked with functional analysts to resolve Production issues
• Strong experience in installation and support Application Desktop Integrator (ADI), Oracle Discoverer, Web ADI, Oracle express Server and Financial Analyzer
• Strong experience in Oracle Work Flow administration
• Supported the PeopleSoft application on RAC databases
• Installation and Configuration of OID, BI Publisher and Integration of BI publisher with APEX
• Implementation of SSL for eBusiness including Oracle Discoverer 10g
• Involved in the various upgrades projects(11.5.9 to 11.5.10,11.5.10 to R12) and JRE upgrade
• Supported the end-to-end implementation for HRMS and Oracle Time and Labor
• Applied India Localization patches in 11i
• Exposure to Demantra integration with E-Business
• Conversion of Database character set from European to UTF8 and MLS in EBS 11i
• Tuned databases, used explain plan, TKPROF, init.ora parameters, OEM, Cloud, TOAD and SQL
• Prepared SOW’s, managed teams, mentored the junior DBA’s, assigned and monitored tasks

TECHNICAL SKILLS:

Operating Systems: HP-UX,Solaris 10, Linux, AIX, Windows NT/2000

Languages: SQL, PL/SQL, Unix Shell Scripts

Databases: Oracle 8.x / 9.x/10g/11g and Teradata V2R5

Middle Tier: Oracle 9iAS, Oracle 10gAS,Oracle SOA, JCAPS, Oracle Weblogic 12c, Tomcat

GUI: Oracle Enterprise Manager, Oracle Grid Control, Oracle Applications Manager

Tools: Oracle Application Express(HTMLDB),RMAN, Statspack,Oracle Discover, Oracle BI Publisher, Teradata Administrator, Teradata Manager, Ferret Utliity, Priority Scheduler.Multiload,BTEQ script in MVS,MAXIMO and Omgega PS, opatch, adpatch, Oracle Agile PLM 9.3.3, Kintana, Service Now. Demantra

ERP: Oracle Application R12,Oracle Application Rel 11.5.10 cu2,Oracle Applications Rel 11i (11.5.1 - 11.5.9 ) and Rel 11.0.3

PROFESSIONAL EXPERIENCE:

Confidential

Lead Oracle Apps DBA Consultant

Responsibilities:

• Responsible for supporting the entire ERP production suite and it’s integrated tools
• Leading the DBA team of 8 people from off-shore
• Reported to the Manager and responsible for all ERP production environment and it’s boundary systems responsibilities of identifying the existing issues and provide resolutions on a timely manner
• Support day to day development/test/production issues through incident management
• Co-ordinate with Oracle support for any outstanding issues especially P1s
• Manage and Lead the team of 8 in On-site/Off-shore model
• Cloning of Oracle Applications using Storage technology
• Configure and monitor all oracle products( both database, e-business and middleware products) using OEM 12c Grid Control
• Supporting Production/test database issues and assign the roasters within the team
• Involved in DR tabletop exercises along with Unix and network team
• Manage the team meetings within the DBA team and also L2 & L3 DBA meetings
• Responsible for delivering the SOX audits and controls
• Supporting and managing the other key applications which talks to E-Business are:
• Oracle Agile 9.3.3
• Oracle Demantra
• Kintana
• Customer Master database(CMAT)
• Markview/Kofax
• Sabrix

Confidential

Lead Oracle Apps DBA Consultant

Responsibilities:

• Working as the L3 Delivery Lead DBA and responsible for managing large number of enterprise Applications and databases in dev,test and staging environments.
• Work with the team or as an individual contributor delivering enhancements to large number of databases and Oracle ERP Applications.
• Engaged in patching, performance tuning, upgrading and maintaining Oracle relational databases in both Real Application Cluster (RAC) and stand-alone databases for Oracle E-Business Suite.
• Co-ordinate with development, QA, Production users for testing for ongoing production releases.
• Proactive automation my writing monitoring scripts to ensure the health of the critical databases.
• Work closely with the team and provide recommandations on best practices.
• Manage the off-shore team of 10DBA’s working 24*5 and 19*2 schedules

Confidential

Lead Oracle Apps DBA Consultant

Responsibilities:

• Involved in Performance review of Oracle ERP - Company Master Structure optimization
• Involved in SQL Query tuning and provided tuning recommendations to developers and DBA’s
• Generated AWR reports for Oracle 10g(Apps 11i) database and analyzed the queries for Oracle wait events, time consuming SQL queries
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like initialization parameters, table reorg, archive and redo log analysis
• Used Explain Plan, Oracle hints, parallelism and creation of new indexes to improve the performance of SQL statements
• Played a pivotal role in stabilizing the data conversion efforts on war foot basis bringing down the execution times drastically from 32hrs to 9hrs to meet the go live time duration
• Managed L2DBA’s from off-shore for execution of the production cut-over
• Masking of data using Oracle Label Security after the clone from Prod to Non-production

Confidential

Lead Oracle Apps DBA Consultant

Responsibilities:

• Solaris to Linux migration of DB along with the application upgrade 9.3.0.2 to 9.3.3
• DB Schema upgrade from 9.3.0.2 to 9.3.3 using Averity/AUT utility
• Installation and Configuration of WebLogic 12c on multimode
• Weblogic Patching using smart update utility
• Installation and Cluster configuration of Agile application
• (1 Admin and 2 Managed Servers along with Autovue on different node)
• Configuration of filemanager/Autovue
• LDAP and load balancer setup
• Co-ordination of the project deliverables between off-shore/onsite

Confidential

Lead Oracle Apps DBA Consultant

Responsibilities:

• Involved in current upgrade issues and resolutions
• Involved in performance issues both DB and Applications
• Support day to day development issues
• Cloning of Oracle Applications using filers
• Identification and resolution of performance bottlenecks using Oracle Grid Control
• Identify existing DR configuration and modify the required setup as part of go live
• Involved in Performance tuning of the application after post go-live

Confidential

Lead Oracle Apps DBA

Responsibilities:

• Responsible for the entire Oracle Apps environments as a Lead Apps DBA
• Reported to the Apps Team Manager in a Managed Services Delivery project with the responsibilities of identifying the existing risks and issues, innovative mitigation of same which will benefit the organization
• Support day to day development/test/production issues
• Application of the latest CPU patches for Oracle E-Business/Oracle/Oracle Middle-Tier
• Co-ordinate with Oracle support for any outstanding issues.
• Managed the team of 4 DBA’s in Oracle and SQL Server
• Cloning of Oracle Applications using Rapid clone
• Cloning of Oracle Applications using Rapid clone both RAC and Non-RAC
• Configuration and setup of Oracle Dataguard,PCP and Oracle Application failover
• Installation and Configuration of Oracle Hyperion
• Identification and resolution of performance bottlenecks using Oracle Grid Control
• Clone the Instance from Production using RMAN backup, whenever need arise
• Configuration of OEM 12c for monitoring and maintenance of various Oracle products
• Supporting Production/test database issues and assign the roasters within the team
• Involved in implementation of security feature using RBAC in E-Business R12

Senior Oracle Apps DBA Consultant

Confidential

Responsibilities:

• Involved in de-commissioning of Oracle Applications R12 from one client to another
• Cross platform migration of Oracle Applications from Solaris to Linux
• Upgrading Database from 9i to 11gR2
• Managed the team of 2 DBA’s in Oracle
• Installation and Configuration experience in Oracle Middleware products
• Involved in mentoring the junior DBA’s and assign the responsibilities to perform tasks

Confidential

Senior Oracle Apps DBA

Responsibilities:

• Identified the existing risks and issues of the current system
• Involved in providing the innovations which will benefit for organization
• Supporting day to day development, test and Production Issues
• Co-ordinate with Oracle support for any outstanding issues
• Involved in identifying and applying the latest CPU patches for Oracle E-Business, Oracle and Oracle Middle-Tier for every quarter in Development, Test and Production Environments
• Involved in improving the performance tuning of the E-Business system
• Cloning of Oracle Applications using Rapid clone
• Identify the performance bottlenecks using Oracle Grid Control
• Monitoring application performance
• Supporting day to day development, test and Production Issues
• Whenever need arise, Clone the Instance from Production using RMAN backup
• Involved in helping the Business Analyst to resolve the issues
• Supporting Production/test database issues and also involved in On-call roaster

Confidential

Oracle Apps DBA Consultant

Responsibilities:

• Involved in transitioning the DBA support from current incumbent
• Involved in identifying the existing risks and issues of the current system
• Involved in providing the innovations which will benefit for organization
• Supporting day to day development, test and Production Issues
• Provide the SOW associated with the outstanding issues and involved in completion task
• Involved in providing the project proposal for new assignments
• Co-ordinate with Oracle support for any outstanding issues
• Involved in identifying and applying the latest CPU patches for Oracle E-Business, Oracle and Oracle Middle-Tier for every quarter in Dev,Test and Prod environments
• Involved in improving the performance tuning of the E-Business system
• Cloning of Oracle Applications (11.5.10) using Rapid clone
• Identified the performance bottlenecks using Oracle Grid Control and monitored application performance
• Creation of custom concurrent manager and assign the custom reports
• Supporting day to day development, test and Production Issues
• Whenever need arise, Clone the Instance from Production using RMAN backup
• Involved in helping the Business Analyst to resolve the issues
• Supporting Production/test database issues and also involved in On-call roaster

Confidential

Oracle Apps DBA Consultant

Responsibilities:

• Involved in supporting peoplesoft RAC databases
• Involved in building the new RAC database required for peoplesoft applications
• Involved in refreshing the Oracle RAC databases
• Supporting day to day development, test and Production Issues
• Installation and configuration of Oracle 11g on Linux for OATS
• Involved in providing the day-to-day support for the team with varied database issues
• Involved in Oracle CPU patch application on RAC database

Confidential

Oracle Apps DBA Consultant

Responsibilities:

• Involved in upgrade of R12
• Supporting multiple customers with varied Oracle/Oracle Apps databases and Tools
• Actively involved in 24*7 on-call roaster
• Supporting day to day development, test and Production Issues
• Involved in Monthly DB Report preparation and provide the recommendations for any outstanding issues
• Provide the statement of work associated with the outstanding issues and involved in completion task
• Involved in installation and configuration of Oracle Applications R12 Vision instance
• Involved in providing the project proposal for new assignments
• Involved in train the sub-ordinates in varied technologies
• Co-ordinate with Oracle support for any outstanding issues
• Involved in providing the recommendations to various customers about new technology implementations

Confidential

Oracle DBA

Responsibilities:

• Involved in Installation and Configuration of Oracle Application Server SOA
• Creation of OC4J instance
• Installing and configuring a database for Oracle Identify Manager(IAM)
• Installing Oracle Identify Manager Server on UNIX
• Upgrade to Release 9.0.3.1
• Applied the patch to upgrade to 9.0.3.0.3
• Installation of OID, Oracle E-Business Connectors and AD connectors
• Installation of Oracle BI Publisher on top of Oracle SOA
• Integration of Oracle BI Publisher with Oracle Application Express for publishing reports in PDF format

Confidential

Responsibilities:

• Cloning of Oracle Applications (11.5.10) using Rapid clone
• Identify the latest and greatest patch set for OTL
• Installation and Configuration of Custom Objects for OTL Implementation
• Creation and Configuartion of Oracle Discover Business Areas and Reports
• Creation of custom concurrent manager and assign the custom reports
• Involved in Business requirement gathering for OTL implementation
• Performed 3 Pilot iterations before the Actual Production Upgrade
• Cloning of Production Database for Pilot Iterations
• Involved in Upgrade Oracle Applications 11.5.9 to 11.5.10 CU2
• Standalone installation and configuration of Oracle Discoverer10g (10.1.2.0.2 )
• Performed the discoverer 4i upgrade to Discoverer 10g
• Upgrade of Oracle Jinitiator from 1.1.8.16 to 1.3.1.26. and upgrade JDK13 to JDK15
• Installation of Oracle10g on separate Home and upgrade the Database from 9i to 10g
• Involved in applying the product patches
• Installation of Oracle EBS CPU (Critical Product Patches) on new 11.5.10 CU2 instance
• Implementation of SSL for E-Business and also for Oracle Discoverer10g

Confidential

Responsibilities:

• Cloning of Oracle Applications (11.5.9) using Rapidclone
• Installation and Configuration of Custom Objects required for HR Implementation
• Creation and Configuartion of Oracle Discover Business Areas and Reports
• Creation and Configuration of Oracle Discoverer EndUser Layer
• Application tuning using explain Plan and tkprof
• Monitoring application performance
• Monitoring and improve the performance of concurrent program for Payroll
• Involved in Implementation of HR Project carried out couple of iterations before actual implementation.Involved in installation of various HRMS patches before and during the implementation of HR module
• Involved in Business requirement gathering for HR implementation

Confidential

System Analyst

Responsibilities:

• Installed & Configured Oracle Software with OFA Compliance
• Giving support on 24x7 basis
• Design and creating new Oracle Instance
• Creation of new data marts in Production, Development and Testing (QA) Environment based on the Erwin data model
• Replication and Migration of the data marts between production, testing, and Development environment using Erwin a data modeling tool.
• For tuning, we are maintaining custom developed SQL scripts and Shell Scripts
• Re-organization of indexes and tables
• Space Management - Temp TBSP, RBS, Data Space
• Backup and Restoration tools like ADSM and DSMC are used for this purpose at Operating system level
• Volumetric estimations for the creation of a new table spaces for new data marts in Production, Development and QA Environment
• Monitoring of file system, Tablespaces while ETVL loading
• Maintenance of system security
• Monitoring and optimizing performance of database
• Archival Space monitoring - and regulating arch growth
• Database Cloning - for Recovery purpose
• Install and configure Webserver - Apache 1.3.x & Iplanet
• Install and configure Weblogic - 4.5.1/5.1 & Web Intelligence, Apply Service pack for Webi server for upgrades and bug fixing
• Created Repositories for Informatica, Business Objects and Brio
• Security implementation for applications
• Troubleshooting the long running reports in BO and Brio and tuned the reports for better performance
• Migration of repositories to higher version and troubleshooting and bug fixing
• Installation and upgrade of application server and Web Servers