Oracle*i Database Administrator Certified Associate

Oracle9i Database Administrator Certified Professional

Mona Shah

**** ******** ******

Elgin, IL 60124

847-***-**** abnr8k@r.postjobfree.com

QUALIFICATIONS

• Experience in business application implementation on a variety of platforms with

current focus on Oracle Database

Provide internal Oracle database related support by

•

administering Oracle 8i, 9i, and 10g databases, performing installation of Oracle

software, maintaining availability of all instances, reviewing alert logs, monitor

background processes, SQL query performance, and executing backup and recovery

procedures

PROFESSIONAL EXPERIENCE

Avis Inc, St Charles, IL, June 2008 - Present

Database Administrator

• Maintain entire database environment which runs on Oracle 9i and perform daily

routine tasks to ensure smooth functioning of the databases

• Utilize SQL Plus and Oracle Reports 6i to generate reports on the daily vehicle

inventory

• Modify the business data by using DDL and DML statements to ensure up-to-date

pricing information

• Write queries using Transact SQL (T-SQL) to extract data from the SQL Server 2005

• Gather technical requirements and implement PL/SQL code that consists of

Packages, procedures, functions, triggers using implicit, explicit cursors and bind

Variables

• currently installing oracle 11g working with new version.

AT&T Inc, Hoffman Estates, IL April 2006-May 2008

Oracle Database Administrator Consultant

• Responsible for creating, upgrading, and maintaining entire Oracle 8i and 9i Database

environment running on Sun Solaris O/S version 5.8

• Maintain performance of 20 Oracle 9i databases that stores 1Terabyte of data with 400

tables and approximately 1 million rows

• Utilize Oracle Enterprise Manager to monitor Oracle 8i and 9i databases and create

standby Databases to have backup copied of production database

• Proficient in using export/import feature for backup of Oracle 9i Databases and Data

Pump for Oracle 10g Databases

• Create Oracle 8i, 9i and 10g Databases using the Database Configuration Assistant

• Use numeric, date, and string SQL functions to write SQL queries

• Manage availability of Oracle 8.2, 9.2.0.1 and 10.2.0.1 database instance and listeners

• Monitor the Oracle 8i and 9i DBMS growth and space utilization

• Maintain Oracle 8i, 9i and 10g DBMS configuration files such as Data file, Control file,

Alert log and Redo Log files

• Ensure Oracle init.ora parameters such as SGA, Log buffers, and Sort Area deliver

optimum performance to the database

• Create and manage Oracle 9i and 10g DBMS tablespaces using Create and Alter

commands

• Utilize V$ views to detect locked user sessions and TKPROF tool to determine SQL

query execution time

• Transport transactional data between servers by creating database links and exporting

data from source database 8i, 9i and 10g to target database 8i, 9i and 10g

• Use Trace Files to track various Oracle Background processes

• Grant System and Object Privileges to various users

• Review SQL Scripts that contain either DDL or DML statements to ensure no syntax

errors, proper spooling, and no constraint violations

• Use the DDL statements CREATE and ALTER within a Dynamic SQL script to create

Schemas, Synonyms and Roles

• Activate the AUTOTRACE ON feature to review the Execution Plan and tune SQL

queries to enhance performance using the Oracle Optimizer for Oracle 10g Database

• Write UNIX shell scripts in Korn Shell on Sun Solaris version of UNIX

Nirma Ltd Oct 2005-March 2006

Database Administrator/Developer

• Responsible for creating, upgrading, maintaining, and monitoring 10 SQL Server 2005

and Oracle 9i Databases running on Windows 2003 and Windows XP O/S respectively

• Configure the IBM 570 servers by installing Oracle 9i Database software

• Utilize Oracle Form 6i for data entry purposes and create reports based on user

requirements using Oracle Report 6i

• Write queries using Transact SQL (T-SQL) to extract data from the SQL Server 2005

• Create and execute packages, procedures, functions, triggers using PL/SQL code

SKILLS

Oracle 8i, 9i, 10G PL/SQL SQL

UNIX Win 98, 2000, XP

TECHNICAL TOOLS

Enterprise Manager 9.1.0.4 Toad 8.1.7

EDUCATION

Bachelor of Computer Engineering, A D Patel Institute of Technology, Sept 2005

CERTIFICATION

• Oracle Certified Associate (OCA) - Database Oracle9i-SQL

Database Architecture and Fundamentals

• Oracle Certified Professional (OCP) - Performance and Tuning.

Continue Masters in information management systems from Devry university.

Contact this candidate