Oracle DBA Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Faron Samin

   Oracle DBA                                                                           

750-559-2501

Samin.09@gmail.com

Background

                                                                       

·         Oracle DBA with 5 years of experience in Oracle as Oracle 11g Database Administrator (DBA) on Operating Systems viz.  HP-UX, client-server based databases and applications Server in 24x7 basis for Production, Development and Test Environments.

·         Specialize in Oracle, advanced PL/SQL queries, installations, upgrade & performance tuning    

·         Managed Backup & Recovery using Export & Import, Data pump, Hot backup, & RMAN    

·         Used SQL Loader for text files, flat file to load data.      

·         Experience as a Database Administrator for Oracle 9i, 10g, 11g under UNIX, Windows NT.

·         Created and Administered Oracle 11g RAC Databases using OEM GRID control.

·         Real Application Clusters (RAC) monitoring, tuning, load balanced.

·         Upgraded databases from 10g to 11g environment for multiple applications.

·         Configure networking for oracle databases, tnsnames.ora, listener.ora

·         Managing Database Structure, Storage Allocation, Building objects Table/Index segments, Views, Constraints, Database Access, Security Roles and Privileges.

·         Acquired and nurtured the skill of computer programming, posses a natural ability and talent for dealing with computers and software related issues.

Education:

Bachelor in Engineering – Pune University, India

Certification: Sun Certified Java Programmer (SCJP edition 1.6)

TECHNICAL SKILLS

Advance DBA Tools: Oracle Enterprise Manager, Oracle Replication Manager,

                                      RMAN, RAC

Development Tools:   Forms 6i Reports 6i

Operating Systems:    Windows NT/2000, UNIX, Linux red hat

RDBMS:                      Oracle 9i/10g/11g

Languages:                 SQL, PL/SQL, C, C++, Java, VC++.

 

PROFESSIONAL EXPERIENCES

Duke Energy, Cincinnati, OH                                                     Duration: Dec’10-PRESENT

Role:    Oracle DBA

Responsibilities:

·         Installations of Oracle11G, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Windows and Linux Servers

·         Configuring RMAN and refreshing/Cloning databases using RMAN.

·         Migration of system and applications from Oracle 10g to Oracle 11g. Install and maintain the application software at server and client end.

·         Create and maintain multiple databases. Extensive experience in working in multi-site environments.

·         Used IMP/EXP, IMPDP/EXPDP utility for export and import.

·         Constant monitoring of database space and space management

·         Setting up Oracle Standby and Oracle Data Guard.

·         Setting up of Oracle and Application user accounts and passwords, monitoring application security

·         Table Partitioning, Creating Index Organized tables, Creating Locally managed table spaces.

·         Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of the query.

·         Used ADDM and SQL tuning Advisor for performance tuning.

·         Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (RMAN)

·         Worked on advance features such as Automated Storage Management (ASM) & Flashback Features.

·         Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.

·         Tablespace creation, adding data files, allocated quotas to user and managed Disk space    

·         Writing database triggers, packages, procedures, functions, utilities for application development for the applications

·         Application Up-gradation of Oracle 11.5.10.2 to Release 12.0.4.

·         Oracle Application maintenance, applying of patches and cloning.

·         Setting up of Oracle and Application user accounts and passwords, monitoring application security

Environment: PL/SQL, SQL, SQL*Plus, Oracle 10G, , Oracle Applications R12, 11i, 11.0.3

Tekseed Inc. Princeton NJ                                                    Duration:     June’09-Nov’10

Role:  Oracle DBA

Responsibilities:

·                     Upgrading databases from 10g to 11g oracle for multiple Applications for different             business units.

·                     Refreshing/Cloning databases, export and import data using oracle imp/exp utility,

Sql*loader, Data pump. 

·                     Install Oracle RAC with Data Guard implementation for along with standby and Dataguard for availability and disaster recovery.

·                     Upgraded Oracle from 10g to 11g RAC.

·                     Typically involved in to configure RAC environment on Oracle11g.

·                     Create and maintain multiple databases.

·                     Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 11g

·                     RMAN configuration and doing backup/recover & database clone using RMAN.

·                     10G RAC configuration, implementation, and testing.

·                     Worked on Setting up, troubleshooting & tuning of RAC (2 nodes) on Oracle 11g.

·                     Monitor database performance and resolve performance related issues.

·                     Created password verifies function profiles and users for security.

·                     Monitor database health on daily basis and monitoring table-space growth periodically.

·                     Helping user community and resolving user errors and improving performance of queries.

·                     Building table indexes for improving performance.

·                     Expert in oracle sub programs (Procedures/Function/Packages & Triggers).

·                     Monitor Stand by Database.

·                     Table space creation, adding data files, allocated quotas to user and managed Disk space.    

·                     Worked on 24X7 production support on large databases.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 11g, RAC, HP Unix, Windows XP, NT, Oracle Reports 11g, Oracle Enterprise Manager grid control.

Genscape. Louisville, KY                                              Duration: Apr’08-May’09

Role:    Oracle DBA

Responsibilities:

·         Troubleshooting and performance tuning, development consultations, production database tuning, production system maintenance management. Monitoring system implementation.

·         Created tables, inserted data with CSV, txt files using sql loader

·         Worked in 24X7-distributed environment ready to support any time required by the IT team.

·         Developed shell scripts to execute and automate to run Sql loader  & pl/sql packages and added in crontab file for daily, weekly and Monthly cronjobs

·         Modified and added new database triggers, packages, procedures, functions, utilities for application development for the applications for better performance.

·         Wrote scripts for scheduling hot backups and table space management.

·         Implemented Data Guard, maintain primary and standby databases.

·         Changed passwords for privilege users and changing links (Dropping & recreating) with new passwords for security.

·         Perform Export and Import of User, Tables, Schemas and Database

·         Managing Table spaces, adding data files/resizing for the Table spaces filling up, coalesce the table space, managed extents.

Environment: Oracle 9i UNIX & Windows XP

Tech Mahindra India.                                                                               ( Apr 2006 - Mar 2008)

Database Administrator

Responsibilities:

·         Conducting Installations of Oracle9i, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers

·         Data modeling / Logical database design and implementation (including index design)

·         Migration of system and applications from Oracle 8i to Oracle 9i. Install and maintain the application software at server and client end.

·         Configuring and using the Oracle Enterprise Manger   for Performance, Maintenance and Administration tasks

·         Create and maintain multiple databases.

·         Used IMP/EXP utility for export and import.

·         Constant monitoring of database space and space management

·         Setting up Oracle Standby and Oracle Data Guard.

·         Setting up of Oracle and Application user accounts and passwords, monitoring application security

·         Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (RMAN)

·         Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.

·         Table space creation, adding data files, allocated quotas to user and managed Disk space    

·         Writing database triggers, packages, procedures, functions, utilities for application development for the applications

·         Performance analysis and evaluation of queries and Databases in a slow running

   application and monitoring / optimizing / tuning the performance of the SQL               

      Server

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, Oracle Developer

Download Resume Format