Oracle Manager
Resume:
Ilayaraja.u
*********.*@*****.***
Professional Summary of Experience:
> Around 1.7 Years of professional experience in the IT industry as ORACLE
DBA.
> Work experience in 24x7 Production environments.
> Strong experience in Installation and administration of Oracle 9i, 10g on
Sun Solaris, Redhat Linux and Windows.
> Upgrading from Oracle Database 9i to 10g and 10g to 11g of production
Databases.
> Patching or upgrading Oracle 10.2.0.1.0 to 10.2.0.5.0 or higher.
> Experience in backup and recovery strategies through physical and logical
backups.
> Responsible for monitoring and optimizing the performance of the
database, assisting developers in optimizing their queries, etc
> Creation of Standby databases (Oracle Data guard) and monitoring the log
shipping and log Sync with the production Database.
> Creation of Logical Standby databases for report Purposes.
> Performed Query tuning, Instance/Memory tuning by using various
performance tools TKProf, Explain Plan, Statspack, Etc
> Experience in providing Security User Management, Privileges, Roles,
Quotas, Auditing, Profiling, Authentication.
> Strong experience in Sizing, Table space Management and Security
Administration in Oracle
> Analysis of the top resource consuming queries using AWR Reports and
optimizing the same.
> Scheduling and monitoring of jobs processes, memory space and alert log
files.
> Strong knowledge in Automatic Database Diagnostic Monitor, ASM, RMAN.
> Strong knowledge in Flashback Technology & Automatic Workload Repository
(AWR), AWR DIFF Reports etc.
> Strong knowledge in DATAGUARD BROKER.
> Strong knowledge in RAC environment.
TECHNICAL SKILLS
Data Base : Oracle 9i/10g,11g
Operating Systems : Windows NT/2K, Linux, Solaris 10
Languages : SQL
Scripting Languages : Unix Shell Script
Dev Tools : SQL*Plus, Import/Export, SRVCTL, ONS Alerts
Performance Tools : EXPLAIN PLAN, TKPROF, Statspack
Admin Tools : Putty, SSH, X manager,Toad,Jira
WORK EXPERIENCE
> Working as Database Administrator in Softinn software services, Bangalore
From August 2012 to till date.
TECHNICAL SUPPORT
Project : Production Support
Platform : Oracle 9i, 10g on Linux and windows
Duration : August 2012 to till date
Role : Database Administrator
Responsibilities:
> Users Quota Maintenance.
> Monitoring the table space growth periodically.
> Creation of table spaces, adding and resizing data files.
> User Management, Role and Profile creation.
> Resolving Database related problems.
> Performing Restoring and recovery in case of failures.
> Taking RMAN incremental backups.
> Identifying Chained Rows and rectify to increase the Performance.
> Handling issues regarding Performance Tuning.
> Creating and altering database objects like tables and indexes as per
user requests.
EDUCATION
> M.C.A, 2009-2012: Passed out with 72.12% from Sri Muthukumaran
Institute of Technology under Anna University, Chennai.
> B.Sc (Computer Science), 2006-2009: Graduated with 58.48% from
Muthayammal College Arts and Science under Periyar University, Salem.
Contact this candidate