Murali 16/4 New Street, Old Mambalam Road West Mambalam, Chennai

MURALI 16/4 New Street, Old Mambalam Road West Mambalam, Chennai -33 [email protected] http://www.linkedin.com/in/skrmurali +91 9884503724 Date of Birth : 15-03-1978 Marital Status : Single Passport No : F0911736 Professional Summary

•

Over 5+ years experience in IT Industry, Good Experience in Oracle Database/Apps Administration and System administration.

•

3+ Years as Oracle Apps and Database Administration, 2 yrs exp in System Administration.

•

Having experience in Oracle Apps R12, 11.5.9 and 11.5.10.2, Oracle Database 8i, 9i, 10g and 11g on Oracle Enterprises Linux, Red hat Linux and Windows.

•

Good Knowledge of Oracle Applications (11i) System Administration and Core Database Administration.

•

Provided Technical and Architectural solutions for Implementations of Oracle Database Environments.

•

Good Exposure to Implementations, Upgrades, Migrations and Rollouts.

•

Installing Oracle Demantra 7.2 and Integration Oracle Application R12(EBS)

•

Installation and Configuration of Oracle R12,11i Applications (11.5.9/10) and Release 12i, Application servers (10gAS, 9iAS) and Oracle Databases (11g,10g,9i) for major clients. •

Upgrade Oracle Applications 11i Database 9i (9.2.0.6) to 10g R2 (10.2.0.1)

•

Implemented and Configured Oracle 10g RAC with Firewier HDD.

•

Installing and Upgrade Oracle Financial Services Applications 4.5 (OFSA).

•

Installing and Upgrade Application Express 3.1.2(Apex)

•

Installing and Configure Oracle Web logic Server 10g.

•

Upgrade Oracle Database 9i to 10g.

•

Upgrading Developer 6i with Oracle Applications 11i

• Maintain, Administer Oracle Technology Stacks and other Tools necessary for Oracle Applications 11i.

•

Performance Analysis and tuning of large Databases up to 2.5 TB.

• Implemented Best Practices for Maintenance, Management, Contention Resolution, Defrag etc. •

Monitoring,

Backup/Recovery,

Growth

Performing the Single node, two node and Multi node installations on different environments.

• Administrate the oracle applications with the AD utilities. Adautocfg, adaimgr, adadmin, adpatch, adrelink • Having experience and Production Support a result oriented, self-motivated and well organized having individual abilities in Database Administration. •

Having Good experience in System administration and Networking Concepts.

•

Configuring Oracle Application Express to use BI Publisher PDF Printing. http://oracledbas.blogspot.com

1

Professional Experience



Working as Oracle DBA at Doyensys System Pvt Ltd, Chennai from Mar’2007 to till date.

 Worked as System Support Executives at Byzan System Pvt Ltd, Chennai from Jun’2006 to Mar ‘2007.

 Worked as System Engineer at Softline Computer, Pudukkottai from Sep ‘2002 to May ‘2006. Professional Education 

Completed B.Sc.,(Computer Science) from J.J College of Arts & Science, Bharathidasan University, Trichy, Tamil Nadu.

Professional Qualification/IT Certifications

 OCA ( Oracle Certified Associate)  CCNA (Cisco Certified Network Associate)  MCSA (Microsoft Certified Systems Administrator on Microsoft Windows 2000 ) 

MCSA:MESSAGING (Messaging on Microsoft Exchange 2000)

Skill Set OS

TOAD

:

Red Hat Linux 4&5, Sun Solaris and Windows 2000&2003

RDBMS

:

Oracle 8i, 9i and Oracle10g.

Database Tools

:

Oracle Enterprise Manager (Intelligent Agent, Tuning Pack),

Backup Tools

:

Recovery Manager (RMAN)

Network Protocol

:

Net 8, SQL*Net, TCP/IP and CCNA

Scheduling Tools

:

Oracle Enterprise Manager (Intelligent Tools), Crontab for Linux

Mar ‘2007 to Till Role : Oracle Apps DBA, Oracle DBA



Installation and Configuration of Oracle 11i Applications (11.5.9/10) and Release 12, Application servers (10gAS, 9iAS) and Oracle Databases (11g,10g,9i) for major clients. 

Installing Oracle Demantra 7.2 and Integration Oracle Application R12(EBS)



Installing and Configure Oracle Application Express 3.1.2(Apex)



Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i)



Upgrade Oracle Applications 11i Database 9i (9.2.0.6) to 10g R2 (10.2.0.1)



Upgrade Oracle Application R12.0.4 to R12.0.6.



Upgrading Developer 6i with Oracle Applications 11i



Configured in Database of Oracle Advanced Security.



Configured in Oracle streams for High-speed data replication and integration.



Oracle Stream’s monitoring and troubleshooting



Installing Oracle Application Server 10g and Oracle Forms Developer 10g. http://oracledbas.blogspot.com

2



Implemented and Configured Oracle 10g RAC with Firewier HDD.



Installing and Configure Oracle Financial Services Applications 4.5.2 (OFSA).



Upgrade Oracle Financial Services Applications 4.5.39 (OFSA).



Upgrade Oracle Database 10.2.0.1 to 10.2.0.3



Day-to-day Database Administration.



Oracle Database Refresh



Patching the Different Applications at Both Tiers.



Configuring SSL in Oracle Application 11i (HTTP Server)



Performance Analysis and tuning of large Databases up to 2.5 TB.

Project 6

: Implementation Oracle E-Business (EBS) Release R12 and Web Hosting

Client

: Enrich IT, USA.

Environment: Red hat Ent 4.5, Oracle Apps R12,Oracle Database 10.2.0.3 Project Description: The main core of a project Implementation Oracle E-Business (EBS) Release R12 and Web Hosting Remote Support.



Installing Oracle E-Business (EBS) Release R12 (12.0.4).



Enable SSL (http to https).



Configure Online Web Hosting.



Create a self signed certificate with Applications generated by OpenSSL for Web

Sever.



Configure certificate in Oracle E-Business (EBS) Release R12 (12.0.4).



Upgrade Oracle Application R12.0.4 to R12.0.6

Project 5

: Implementation Oracle Application Express (APEX)

Client

: Sical Logistics Ltd, Chennai.

Environment: Red hat Ent 4.5, Oracle Apps 11i (11.5.9),Oracle Database 10.2.0.1 Project Description: The main core of a project Implementation Oracle Application Express (APEX).



Installing Oracle Application Express 3.1.0. (Apex)



Upgrade Oracle Application Express 3.1.2. (Apex).



Migration and data integration into Oracle Apex.



Installing Oracle BI Publisher for PDF Printing.



Configuring Oracle Application Express to use BI Publisher PDF Printing.



Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i)



Configuring Apex web server in Oracle Application Server (10.1.3)



Configuring SSL in Oracle Application Express.

http://oracledbas.blogspot.com

3

Project 4

: Configuring SSL in Oracle Applications 11i (HTTP server)

Client

: Sical Logistics Ltd, Chennai.

Environment: Red hat Ent 4.5, Oracle Apps 11i (11.5.9) Project Description: The main core of a project Configuring SSL in Oracle Applications 11i (HTTP Server).



Configuring SSL in Oracle Application 11i (HTTP Server).



Configure SSL parameters for web server.



Configure in Apache configuration file (http.conf).



Applied http patches.



Create a self signed certificate with Applications generated by OpenSSL for Web

Sever.

http://oracledbas.blogspot.com

4

Project 3

: Oracle Apps11i Implementation

Client

: India Trans, Chennai.

Environment: Oracle Red hat Ent 4.5, Oracle Apps 11i (11.5.10.2) Project Description: The main core of a project Installing and Configure in Oracle Apps 11i and Upgrade Applications 11i Database 9i (9.2.0.6) to 10g R2 (10.2.0.1) Transport Module

in Oracle



Installing Oracle E-Business (EBS) Release 11i (version 11.5.10.2).



Applying Patches, Mini Packs, Maintenance Packs, Family Packs to Oracle11i Applications.



Clone the instances using Rapid Cloning for 11.5.10.2.



Defined and Maintained Concurrent Manager and Programs.



Provided technical assistance in Development Environment.



Upgrading Developer 6i with Oracle Applications 11i (Patch set 18).



Upgrade Oracle Applications 11i Database 9i (9.2.0.6) to 10g R2 (10.2.0.1).



Schedule Concurrent Program and maintain the Applications.



Uploaded data from Legacy system to Oracle Applications using SQL*Loader.



Oracle Database Refresh

Project 2

: Oracle Performance Tuning

Client

: Hexaware Technologies, Chennai.

Environment: Oracle Database 9i, Sun Solaris, Web logic Project Description: The main core of a project time reduces for Jobs and Database performance tuning.



Analyze and statistic Database Objects.



Run the Stats pack and Analyze long running Query’s.



Using Trace ORADEBUG and TKPROF.



Oracle Database level Parameter changing for Tuning.



Application Developer invokes and changing query level tuning.

Project 1

: Oracle 10g Streams Implementation

Client

: Computer Age Management Services Pvt. Ltd, Chennai.

Environment: Windows 2003 Server, Oracle 10g (10.2.0.3.0) Project Description: The main core of a project by using Oracle streams for High-speed data replication and integration. 

Configured a Downstream database and archive log receiving in standby database.



Setup of Oracle Streams by using different tables and columns at the Target database.



Configured Capture rules in Rename schemas, Rename tables and Delete Columns.



Configured Propagation to Downstream Database.



Configured the addition of SCN and Timestamp in all target tables.



Oracle Stream’s monitoring and troubleshooting.



Cloned downstream database to change other server. http://oracledbas.blogspot.com

5



Upgrading Oracle Database 10.2.0.1 to 10.2.0.3.



Backup, Export/Import and streams database issues.

June ‘2006 to Mar ‘2007 Role

:

Oracle DBA, Application Support.

Environment

:

Oracle 9i, Citrix, Linux and Windows.

Responsibilities:



Installing and upgrading the Oracle Database and application tools



Cloned Prod Database to Development Database and applied patches.



Upgrading Oracle database 9.2.0.8 to 10.1.0.3



Creating the required table spaces, users, profiles and roles

 Allocating system storage and planning future storage requirements for the database system  Creating primary objects (tables, views, indexes) once application developers have designed an application  Modifying the database structure, as necessary, from information given by application developers 

Enrolling users and maintaining system security



Ensuring compliance with your Oracle license agreement



Controlling and monitoring user access to the database



Monitoring and optimizing the performance of the database



Planning for backup and recovery of database information



Maintaining archived data on tape



Contacting Oracle Corporation for technical support



Backup, Export/Import and various database issues.



Performing upgrades of the database and software to new release levels



Monitored Hot and Cold backups.

Job Profile: Oracle DBA, DBA, System Engineer Sep ‘2002 to May ‘2006 Role & Responsibilities:



Installing Oracle 8i and 9i Database on Linux and windows platform



Creating Oracle database and configuring



Upgrade database 8.1.4 to 9.2.0.4



Setup & Maintenance of the Domain controller for file server, user authentication, user policy rights enforcement & the implementation of the Desktop Security policy.



Backup, Export/Import and various database issues



Installed and Administrating Software Update Services in Windows 2000 for Automated

Patch. Updating the anti-virus, hot fixes, service packs, and Critical patches on regular basis.

 

Periodic review of the Network, LAN user profiles as per the audit standards.



Performing scheduled backup of servers using Veritas Backup. http://oracledbas.blogspot.com

6

 Creating, Modifying, Moving mail box & Deleting User Accounts in Exchange server 2000. Installing Custom made software’s and troubleshooting Software related Problems

 

Troubleshooting and setting up mail accounts for users.

http://oracledbas.blogspot.com

7