VIJAY VENKATESH

729-***-****

aco9j5@r.postjobfree.com

Oracle Testing ID : OC0886301

Profile Highlights

Having 3 + years of experience in IT Industry of which 2 + years of experience as Oracle

Database Administrator involved in Database creation, Space Management, Backup and

Recovery, Cloning in Oracle 9i/10g and 1 + year of experience as Oracle Developer.

Having 3 + years of experience in Non-IT Industry as an Oracle Technical Trainer.

A good team worker with good communication skills and ability to handle projects independently.

Summary

Worked as an Oracle Database developer and Administrator in Development and Testing

Environments.

Experienced In Tablespace management, User management and performing Logical Backups

(using Export/Import as well as Data Pump).

Management of logical & physical database structures, and System security functions like

managing system/object privileges, roles and profiles.

Analyze the index if necessary rebuild or Coalesce index to rectify index fragmentation.

Perform Creation of Clone database for Development and Testing Environments.

Monitor the performance of the database and report to Performance and Tuning team

when the process gets delay.

Involved in Backups and Recovery strategies using Rman and Hot/Cold backups in oracle

9i/10g databases.

Responsible for hot and cold backups as well as cloning in oracle 9i databases.

Worked on Ticketing tools for managing incident and change request.

Apart from the above mentioned tasks, daily monitoring was carried out before start of business

hours to ensure database availability and smooth functioning of databases.

Professional Experience

Page 1 of 4

Currently working with InfinIT Infoserv Pvt Ltd., Chennai as Oracle DBA from 2012 Nov to

till date and worked as Oracle Developer from 2011 April to 2012 Oct.

Worked with SmartEntry IT Infrastructure., Chennai as Oracle Technical Trainer from 2007

Nov to 2011 March.

Academic profile

B.Tech (Computer Science) from Sri Manakula Vinayagar Engg College, Pondicherry

(Pondicherry University).

Technical Skills

Operating System : RedHat Linux 4.0/5.0, Windows

DB Languages : SQL

Databases : Oracle 9i, 10g

Tools And Utilities : Data Pump, Export/Import, RMAN, NID, DB

Verify, DBCA

Certification

Oracle Certified Professional (OCP) in 10g R2 Database Administration.

Professional Experience

Project # 2

Client : Royal Hospital, UAE

Environment : Oracle 10g/9i, Linux,Windows

Role : Junior Oracle DBA

Roles and Responsibilities

Involved in creation of 9i/10g databases in Linux Advanced Server and Windows Platforms.

Create new users and manage privileges and monitor user access to the databases.

Checking the Backup Data Files for Consistency using DBVerify utility and Monitoring CPU

resource utilization and database growth. .

Page 2 of 4

Analyse the index if necessary rebuild or Coalesce index to rectify segment fragmentation and to

improve the database performance.

Managing undo, redo logs, Checking alert log and trace files for errors.

Checked the configuration and performance of the existing databases including data file

allocation, index, fragmentation and the impact on system performance.

Responsible for taking logical backups of data using exp, Imp, Expdp and Impdp.

Creating Clone Databases and Responsible for checking the backup logs to ensure backups were

taken, monitoring the alert log and general database housekeeping.

Day to day troubleshooting like adding space in tablespace when required, rebuilding indexes,

trace file and monitoring of system availability, database availability, listener availability.

Monitoring Alerts about invalid Objects, CPU Usage, and Long Pending processes.

Checking the tablespace’s space as per the alert and adding or resizing based on situation for the

performance of the database.

Reorganizing the fragmented tables and indexes and Managing Space Management and User

management.

Controlling and monitoring user access to the database for new and existing databases

Project # 1

Client : CFS Financial Services Ltd., New Delhi

Environment : Oracle 9i/10g, Windows

Role : Oracle DBA

Roles and Responsiblities

Involved in the creation of 9i databases in Windows as per the client requirement..

Involved in Performing manual database refreshes using cold and hot backups

Doing Database Reorganization regularly to remove row migrations and fragmentation using

export and import utilities

Involved in various administration jobs, like storage of database objects, monitoring extents and

max extents, LMT, tables and indexes.

Take necessary actions for Row Migration and Row Chaining and maintain the database stability.

Creating, renaming and relocating control files and multiplexing of control files for database

performance as per the client request.

Page 3 of 4

Creation of Oracle Users, Roles, Granting Privileges and Profiles etc. as per the requirement.

Monitoring the database for CPU utilization and killing unwanted user process

Monitoring the Table Fragmentation and rectifying them.

Creation of Schema with Quota Maintenance for users as per the requirement.

Frequent analysis of objects or schemas to improve the speed of the database

Checking Alert log file for errors and making necessary actions to rectify them.

Creating Schema objects like tables, views and indexes which are given by users.

Personal Profile

Name : S.Vijay Venkatesh

Father Name : A.Sivanesan

Date of Birth : 26-05-1985

Marital Status : Single

Languages Known : Tamil, English (Read,Write, Speak)

Page 4 of 4

Contact this candidate