Oracle Management
Resume:
MALAIYAPPAN. M
*************@*****.***
CAREER OBJECTIVE:
Fast, Accurate, Flexible and Trusted. Proficiency in both hands-on and architectural. Complete knowledge transfer to team. 24x7x365 on-call support including weekend and overnight shifts.
PROFESSIONAL SUMMARY:
4.6 years of experience on Oracle Database Administration.
Good working experience with ORACLE 11gR2/10g/9i.
Involved in database administration installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security production support in multiple database in oracle enterprise server 10g, 11g and 10g RAC.
Good understanding of RAC Architecture.
OCR and Voting Disk backup and restoring manually if required.
Service management to implement TAF using SRVCTL and DBCA.
Administrating cluster database using utilities like OCRCONFIG, SRVCTL and CRSCTL etc.
Maintaining Oracle Apps DBA EBS server 11.5.10.2 and R12 applications.
Maintaining Oracle Application Starting and stopping the Oracle Application Services.
Creating Custom Concurrent Managers and Assigning Work shifts to it.
Involved in Web Logic 10.3, Oracle Fusion Middleware and installation and configuration in development to production environments deployment war, ear file on web logic server.
Sound understands of ITIL guidelines.
Involved Configuring / maintaining the Data guard Physical / Logical Standby environment.
Extensively used Oracle utilities like Export / Import, Data pump (Expdp / Impdp Tools).
Involved in Expertise RMAN Setup, Backup, Restore and Recovery.
Experience in Upgrade the database version from 10g (10.2.0.4) to 11.2.0.3
Experience in applying PSU patch set for any database version. Last applied for 11.1.0.7 (7272646).
Interacted with Oracle Meta link Support for troubleshooting critical database issues.
Experience in Database cloning using RMAN including active duplication in 11.2.0.3
Managing Control files, Online Redo logs, Archive Redo logs.
Monitoring Database Activities, checking for Table space availability, data files, Creating Index, User Management, checking the Alert log file for errors.
Extensive experience in performance tuning of database, memory & I/O using tools such as AWR,ADDM and ASH analyzing queries using EXPALIN PLAN and TKPROF.
EXPERIENCE DETAILS:
Currently working as Oracle Database Administrator in Red Leaf Technologies Private Limited from 2014 Apr to present.
Worked as a Oracle Database Administrator in Pageone Technologies, Chennai, IN from July 2010 to 2014 April.
TECHNICAL SKILLS:
OPERATING SYSTEM
UNIX, Linux, RHEL 5, OEL 6, Solaris, Windows Server, Vmware
DATABASE
Oracle 12c, 11g, 10g, 9i, Ms Sql server 2005
TOOLS
OUI, DBCA, DBUA, OEM,SQL*Plus, NETCA, Toad, OEM, 11g client, Sql developer, Putty, Vncviewer, Data pump, Command –line tools
EBS APPLICATION
Oracle Application 11i( 11.5.10.2), R12, Web logic server 11g 12c
TICKETING TOOLS
Remedy 7.0
LANGUAGE
UNIX/Linux Shell Scripting, SQL, PL/SQL
HARDWARE
IBM, HP, SUN server and Stand alone servers.
PROJECT ONCORE ELECTRONIC DISTRIBUTION DELIVERY SYSTEMS
INSURE PRO
Duration : Apr 2014 to till date.
Environment : Oracle 11g,10g, RAC database running on Linux,Solaris, Window Server.
Role : Oracle DBA (Apps DBA) Maintaining EBS apps server R12.
Client : Red Leaf Herbals.
Responsibilities:
Installation & support Oracle Binaries, patching, Upgrading & Migration of databases.
Experience in maintaining 11g RAC.
Performed database wide tuning using AWR and ADDM.
Taking cold Backups hot backups and RMAN backups.
Maintaining Oracle apps EBS r12. Run Autoconfig is the AD Utilities to automate the configure Management.
Setting the Environment before start any AD utility APPLL_TOP and database.
Performed logical backup, Schema Refresh using Export & Import and Data pump.
Monitoring overall system environment performing hot and cold backup
Configuring physical standby in Data guard environment.
Configure LISTENER & TNSNAMES files & Troubleshooting.
Database administration activities in Development, Test and Production Environments.
Application team generation the request, which we have to as per SLA’s.
Exporting the table from live server to training environment.
PROJECT
INSURE PRO
Duration : Feb 2012 to Apr 2014
Environment : Oracle 11g,10g database running on Linux & Windows server.
Role : Oracle DBA
Client : Reliance General Insurance.
Roles & Responsibilities:
As a Database Administrator, I am Responsible for administrator of all Oracle Databases.
Taking cold Backups hot backups and RMAN backups.
Performed logical backup, Schema Refresh using Export & Import and Data pump.
Configuring physical standby in Data guard environment.
Analyzed statements with Tkprof and Explain plan.
Configure LISTENER & TNSNAMES files & Troubleshooting.
Database administration activities in Development, Test and Production Environments.
Loading Bulk data from flat files using SQL Loader.
Setup of standby database and data guard setup high availability.
Oracle 10g Flashback database, Tables.
Performed Database Cloning from Production to Test environment and performing health checkups
Designed RMAN backup strategy for all dev and production environments.
Involved in monitoring and optimizing the performance of the Database through Stats pack/AWR.
RECORD MANAGEMENT SYSTEM
Duration : July 2010 to Jan 2012
Environment : Oracle 10g 9i Database running on Linux & Windows server.
Role : Oracle DBA
Client : Oriental Hospital, Kanpur.
Roles & Responsibilities:
Installation and Configuration of oracle database to various client machines.
Daily monitoring the performance of database
Applied High priority, security patches downloaded from Metalink.
Performing oracle installations & manual db creation.
Performing logical backup using Export and Import operations.
Performing backup and recovery operations if needed
Managing Table spaces, Data files, Control files, Redo Log files.
Upgrade database from oracle 10.2.0.4 to 11.2.0.3
Creating Database objects, Users, Roles, Profiles for the databases.
Performing backup and recovery using RMAN.
Applying Point –In-Time Recovery through Recovery Manager.
EDUCATION:
M.sc (Information Technology) -2009 - Bharathidasan University, Trichy, TN, IN.
PERSONAL INFORMATION:
Marital status : Single
DOB : 23-Apr-1986
Languages Known : English, Tamil and Telugu.
Passport : Yes (Valid till 2019)
Nationality : Indian
(Malaiyappan.M)
Contact this candidate