Oracle Management
Resume:
VIJAY VENKATESH
*********@*****.***
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