Oracle Data

SRIRAM . SARATHI

Email id : ***********@*****.***

Mobile No - 709-***-****

Career Objective

To be in a professional position and build career with a corporate software concern with committed & dedicated people, which will help me explore myself and in being fully resourceful.

ACADEMIC CREDENTIALS

M.Sc (CS) - 2011 with 65%- AVC College (Autonomous)-Bharathidasan University

B.Sc(CS) - 2009 with 67%- Annai College of Arts & Science-Bharathidasan University

HSC - 2006 with 51%- T.A Higher Sec. School, Thiruvidaimaruthur

SSLC - 2004 with 67%- Government High School, Thirubuvanam

Technical Expertise

Operating System : Red Hat Enterprise Linux 4.0,5.0

Language : Shell Script, SQL and Plsql

Database Administration : Oracle 10g,11g

Oracle Utilities : Nid, Sqlloader, DBverify, Exp/Imp, Expdp/Impdp, Rman, Tkprof

Professional Experience

Feria IT Solutions Pvt Ltd, Chennai.

Database Administrator Sep 2011 – 25 March 2019

7+ yrs of experience in IT industry as an Oracle Database Administrator.

Roles and Responsibilities

•Installation of Oracle in Linux Platform.

•Configuration of physical standby database using Oracle Dataguard.

•Switch from primary database to standby and standby to primary database.

•Upgradation from10g to 11g databases.

•Applying patches from 10.2.0.1.0 to 10.2.0.4.0

•Tuning Sql Query depends upon request from seniors and developers.

•Monitoring sessions using TKPROF

•Analyzing the database performance using Statspack and AWR report.

•Creating catalog mode and register the database in RMAN.

•Performing Backup and Recovery using Rman.

•Taking Cold and Hot Backup.

•Performing logical backup on Tables, Schema and Database level.

•Schema Refresh using Exp/Imp Utility.

•Cloning database from Production to Testing Environment.

•Creating Schema with quota maintenance and roles and privileges

•Managing schema objects such as tables, indexes, and views.

•Analyze table to increasing performance and detecting Row Chaining and Row Migration.

•Monitoring the table fragmentation and rectify by online redefinition of Tables.

•Analyze the index if necessary rebuild index to rectify segment fragmentation

•Created partition tables to increase the Performance

•Recovering lost objects using Flashback Table.

•Loading Bulk data using SQL Loader.

•Checking the Data Files consistency using DB verify utility

Project Title

Management System

Client

Qatar - Chemical Limited

Technologies

Oracle 10g, 11g

Duration

June 2014 to Till date

Roles & Responsibilities in Project :2

•Configuration of physical standby database using Oracle Dataguard

•Switchover from primary database to standby and vice versa.

•Generation reports for database tuning through AWR.

•Analyze SQL statements using Explain Plan and TKprof.

•Recovered Oracle database using RMAN.

•Configured the RMAN Catalog environment .

•Taking backup using RMAN

•Backup on Tables, Schemas and Database using Expdp/Impdp .

•Schema refresh using exp/imp and Datapump.

•Cloning database from Production to Testing using RMAN.

•Managed tablespaces and other database objects.

•Applying Oracle Patches from 10.2.0.1.0 to 10.2.0.4.0.

•Upgradation of database from 10g to 11g.

Project Title

Constructions

Client

Qatar - Construction Company W.L.L

Technologies

Oracle 10g

Duration

Sep 2011 - June 2014

Roles & Responsibilities in Project :1

•RMAN Implemented in production server

•Recovery of data files using RMAN

•Crosscheck the backups and report, delete obsolete backups

•Backup on Tables, Schemas and Database using Export/Import .

•Taking backup of control file, datafiles and archivelog files using RMAN

•Take hot backup and cold backup of database using user level managed backup.

•Monitoring the database for Memory,CPU and I/O utilization

•Analyze the index, if necessary rebuild index to rectify index fragmentation.

•Monitoring and dropping unused indexes.

•Recovering lost objects using Flashback.

•Managed tablespaces and other database objects.

•Check the Tablespace growth.

•Loading Bulk data from flat files using SQL Loader.

PERSONAL DETAILS

Father’s Name : M.J. Sarathi

Gender : Male

Nationality : Indian

Religion : Hindu

Marital status : Single

Passport No : N4640273

Date of Birth : 05 June 1989

Permanent Address : 154/77, East Street, Thirubuvanam, Thanjure (DT) -612103.

Contact this candidate