Suvin P.

Name: Suvin Prathab Experience: 2.5 Years CERTIFICATIONS: OCA – Oracle Certified Associate in Oracle 9i DBA OCP – Oracle Certified Professional in Oracle 9i DBA TECHNICAL SKILLS: • Database : Oracle 9i, Oracle 10g • Oracle Utilities : Export & Import, DBVerify, RMAN, Statspack & TKProf • Languages : SQL, PL/SQL, Unix Shell Script • Operating Systems : Linux(RHEL4,RHEL5),IBM AIX, HP-Unix,Windows Server 2003 ROLE SUMMARY: Ø Creation and Maintenance of Oracle Databases as per the requirement. Ø Installation of Oracle in Linux Ø Creation of Schema with Quota maintenance. Ø Creation of Oracle Roles, Granting Privileges and Profiles. Ø Managing Tablespaces, Objects & Disk Space. Ø Implementation of Database Backup Strategy, hot & cold backups. Ø Performed logical backups using Export/Import utilities. Ø Recovery of lost Objects and Datafiles. Ø Monitor the database by collecting statistics of instance and files using SQL trace files, TKPROF and STATSPACK. Ø Analyze SQL statements using Explain Plan. Ø Review and modification of SQL queries for performance enhancement. Ø Loading Bulk data from flat files using SQL*Loader. Ø Checking the Data Files consistency using DBverify utility. Ø Applied Patches for Oracle 9i & 10g. Ø Migrating database from old version to newer version.