MOHD ABDUL RAFAY
Mobile: +919885742651 Email:
Professional Objective
To prove myself dedicated, worthful and energetic as a Database Administrator in a progressive organization that gives me scope to apply my knowledge and skills and be a member of a team that dynamically works towards success and growth of the organization.
Present Working
ØPresently working as “Database Administrator†with “KEDIA InfoTech†Hyderabad.
IT Exertion Exposure
ØOver all Two years of work exposal with IT organization.
ØWorked on various versions of Oracle ( 8.x,9.x ) on UNIX and Windows Platform.
ØInstalling and Upgrading Oracle Server and related Oracle Tools.
ØPlanning and Creating Database required for Production, Development and Test usage.
ØManaging Physical and Logical Structure of Database.
ØImplementing and enforcing Database Security.
ØPlan and Implement Backup and Recovery strategy in various environments.
ØMonitoring and optimizing the performance of Database.
ØPlanning and Maintaining Oracle Network environment.
ØPerform Capacity Planning required to create and maintain the Database.
ØNew features of Oracle 9i (Undo Tablespace, Spfile, Flash Query, multiple block size. etc)
Education
·B.E (Computer sci. & Engg.) from Swami Ramanand Teerth Marathwada University Maharashtra. (2003) in First Division with Distinction .
Skill Sets
Technical Skills
Operating Systems : Linux, Windows 2000 Server
Database : Oracle8.x, 9.x
Database Tools : OEM, RMAN, SQL*PLUS, SQL*Loader
Suites : Ms Office, Star office 5.2
Networking : TCP/IP, LAN
Name Services: NIS, NIS+ and DNS
Languages : C, C++, Java, and J2EE
Personal Skills
ØActive & Creative
ØDynamic & Optimist
ØAmbitious & Great Attitude
ØTeam spirited & selfconfident
Present Job Profile
Name of the Organization : Kedia InfoTech, Hyd.
Designation : Database Administrator
Period of Service : Since Dec 2003
Job Responsibilities
ØInstalling, configuring and upgrading of Oracle server software and related products.
ØManaging Production, Development and Test Database in 24x7 environments.
ØRegularly checking ALERT logs to know types of Bottlenecks recorded during the day.
if any, and rising to counter them.
ØManaging Redo logs and Data files like adding, renaming and resizing.
ØManaging Controlfiles like adding, recreating and tracing to physical locations and
Tracing backup.
ØUser authentication logging to database through operating system valid user.
ØPerformed time based incomplete recovery to recover accidentally dropped tables.
ØScheduled backups using CRON and AT job scheduling.
ØTaking backup after database is opened with a reset logs option, since backups before
reset logs become void.
ØRegularly taking LOGICAL backups (Export and Import) incremental level as an
alternative option in case of physical backups failure.
ØRollback segment related errors like unable to extend rollback segment was corrected
properly.
ØWrote RMAN scripts for backups.
ØUsed Oracle Enterprise Manager for monitoring events such as tablespace full and
database up and down.
ØImplemented multiple buffer pools for efficient utilization of database buffer cache.
ØCustomized the SGA (two init.ora files for different types of requirements).
ØMonitored the different memory structures such as shared pool, data dictionary cache,
library cache, buffer cache.
ØImplemented UNDO tablespace feature of Oracle 9i database.
ØImplemented multiple Archivelog destinations to archive redo logs to support database recovery
Personal Profile
Sex : Male
Martial Status : Single
Nationality : Indian

Page 1