SUMMARY:

• Confidential has done his Master of Computer Applications. He has around 16Yrs of experience relating to Oracle Database Administration, Backup & Recovery, Tuning and Installation, Configuration of Oracle Applications including System Administration.Murali has in - depth knowledge in applying patches for bugs and product enhancements and upgrades on Oracle Application. He has handled the team of DBA’s for project deliverables and support the production database.
• He was involved in installation, configuration and Maintenance of various Oracle Products like Oracle Database Server 8i/9i/10g/11g, Web Application Server like Oracle9ias,Oracle Applications Server 10g,Oracle Weblogic, OEM 12c Grid Control,Oracle Enterprise Manager and Oracle Applications Rel 11.x and Oracle Applications R12.
• His experience includes working on various platforms like HP-UX,Sun Solaris, Linux, AIX and Windows NT/2000. He is proficient in use of tools like Oracle Enterprise Manager, Oracle Grid Control RMAN, and Oracle Discoverer etc. As a Database Administrator, he has expert knowledge in Databases Creation, Database Configuration, Space management, User management, Backup and Recovery, Database Cloning, Performance and Tuning,Database Maintenance and Database Security. He also has expertise in Shell Scripting, Applying Oracle Patches and Database Upgrades from one version to another version.
• He has worked in various project based implementations, managed services environment and also worked as a Lead Oracle Apps DBA consultant for various projects. He has a very good exposure and experience in supporting production environments, project deliverables and also post project support. He worked with various clients across the globe and also worked in On-site/Off-shore Model. He also involved in helping the sales team in providing the inputs for DBA related activities for new project proposals. He also has an exposure in mentoring the juniors in various Oracle DBA technologies including Oracle Applications. He is very familiar with ITIL process and PRINCE2 Methodologies.

TECHNICAL SKILLS:

Operating Systems: HP-UX,Solaris 10, Linux, 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

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

Tools: & Utilities: 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

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

System Analyst

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

Confidential

Senior Oracle Apps DBA Consultant

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
• 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
• 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 tablespaces 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 & WebIntelligence, 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

Confidential

Responsibilities:

• Installation of Oracle Applications release 11.0.3 on Sun Solaris
• Cloning of Oracle Applications for Testing Purpose
• Tuning through Explain plan and tkprof
• Applying the patches whenever the need arise

Confidential

Responsibilities:

• As Teradata DBA, Supported Production Database Server of 27TB of Database with 36 nodes running on MP-RAS Unix machine
• Space Management, User Creation, Database Creation, Allocation of Spool through Teradata Manager
• Monitoring of jobs through Teradata Manager and Regular Space maintenance Activity
• Maintenace of Regular DBC Cleanup activity
• Submission of Production Staging batch jobs for deletion
• Perform Check Table and Pack Disk activity on database
• Submission of jobs through Control M
• Regular Backup Activity which is performed remotely through Netvault Software
• Archiving of Production jobs on Monthly Basis and used BTEQ to stage the archive data
• Installation of Oracle Applications Rel.11.5.9 on Sun Solaris
• Installation and Configuration of Oracle9I with RAC option
• Switch the Applications 11.5.9 ORACLE HOME to Oracle9iRAC ORACLE HOME
• Convert the single instance 11iOracle9I database to Oracle9iRAC

Confidential

Responsibilities:

• Installation and Cloning of Oracle Applications Rel.11.5.9 on Linux
• Installation and Configuration of Oracle Express Server, Oracle Financial Analyzer
• Creation and Configuration of Oracle Discoverer EndUser Layer

Confidential

Responsibilities:

• Cloning of Oracle Applications (ver 11.0.3) from prodution as part of pre-upgrade
• Carried out the 3 pilot iterations and the actual production upgradation
• Cloning of Oracle Applications 11i during the upgrade for testing purpose

Confidential

Responsibilities:

• Converting the existing database character set from European to UTF8
• Use of CSSCAN utility to identify any data loss during db character conversion
• Export the Oracle Applications 11i database before MLS installation and re-create/import the database with new character set
• Activate the additional language (Russian) using adlicmgr
• Convert the application character set using “convert character set” option with adadmin
• Perform Maintain multilingual tables option with adadmin and apply NLS driver patches

Confidential

Responsibilities:

• Cloning of Oracle Applications (ver 11.0.3) from production to the test environment
• Applying the minipack for GL on the test and production environment
• Concurrent manager scheduling

Confidential

Responsibilities:

• First RAPIDSTART implementation in India
• Installation and Configuration of Oracle Applications release 11i using Rapidstart
• Workflow Mailer Configuration
• Installation and Configuration of ADI

Confidential

Responsibilities:

• Installation and Configuration of Oracle Applications release 11i
• Creation of application users, responsibilities and menus
• Database Reorganization
• Setting up database privileges and roles and customizing user access to database
• Performance tuning using tkprof and explain plan

Confidential

Responsibilities:

• Installation of Oracle Applications release 11.0.3 on Sun Solaris.
• Customization with Oracle Applications.
• Patching the E-Bizz environment
• Support the day to day issues with the production environment