Database Administrator RESUME NJ - Hire IT People

SUMMARY

Three plus yrs experience in Oracle Database Administration (9i, 10g).
To work as a Database Administrator in the organization where I can apply & enhance my skills and be a part of the team in achieving organization success.
Would like to exhibit my skills in user management, database object management, resource management, etc.
Can create and maintain Oracle databases in Linux and Windows.
A very quick learner and a self starter and can manage the work assigned sincerely.
Positive Attitude, Good Communication, Team Player, dedicated and hardworking.

ACADEMIC QUALIFICATIONS

TECHNICAL SKILLS

Databases

Oracle 8i, Oracle 9i, Oracle 10g(features)

Oracle Utilities

Export & Import,SQL Loader,NID,TkProf and Rman

Database Monitoring

Statspack & Dbverify

Languages

SQL

Operating Systems

Redhat Linux AS4, AS5, Windows 2000/NT, Solaris

WORK EXPERIENCE

Database Administrator from July 2006.

Involved in Backup methodologies, Cloning and User management and Space
Management etc.

PROJECT EXPERIENCE

PROJECT 1
Title NH
Confidential, Germany
Role Database Administrator
Environment Red Hat Linux-Oracle 10g

As an Oracle Database Administrator, my primary roles and responsibilities Involved:-

Installation of Oracle on Linux

Creation of schema with quota maintenance
Creation of oracle roles, granting privileges and profiles
Monitor physical and logical backup
Monitor the database by collecting statistics of instance and files by querying data dictionary views
SQL trace files and TKPROF, STATSPACK to find ways to improve the database’s performance
Created Partitions for large tables
Creating Materialized Views
Created and maintained different database entities included tablespace, data files,

redo log files and renaming/relocating of data files on servers

PROJECT 2
Title UAIC
Confidential,Florida
Role Database Administrator
Environment Red Hat Linux-Oracle 9i

As an Oracle Database Administrator, my primary roles and responsibilities Involved:-

Creation and Maintenance of Oracle Databases as per the requirement.
Creation of Schema with Quota Maintenance.
Creation of oracle Users, Roles, Granting Privileges and Profiles etc.
Database Creation/Maintenance (database instances), managing logical and physical database structures.
Loading Bulk data from flat files using SQL*Loader, Creating users and security management.
Managing Undo Segments Redo Logs, Checking Alert Log and Trace Files for errors.
Monitor the database by collecting statistics of instance and files by querying data dictionary views, SQL trace files and TKPROF, STATSPACK to find ways to improve the database’s performance.
Analyze SQL statements using Explain Plan.
Created partition tables to increase the Performance.
Database administration, Managing Tablespaces, Objects, Disk Space.
Configuring Archive Log Mode for Database and Maintaining Archive files.
Monitoring backups.
Gathering Schema level statistics and Table level statistics using DBMS_STATS Procedure in non business hours and Monitoring the table fragmentation and rectify by online redefinition of Tables

PROJECT 3
Title PHM
Confidential,US
Role Database Administrator
Environment Red Hat Linux-Oracle 9i

As an Oracle Database Administrator, my primary roles and responsibilities Involved:-

Part of a 7 member DBA team which was involved in the maintenance of the oracle 9i database for the development environments
Creating and maintaining users and granting them privileges and roles
Creating database objects like tables as per the users requests
Analyze Tables and Index to rectify segment fragmentation
Creating and maintaining Tablespaces
Performed logical backups using Export/Import utilities
Attending Database related user complaints
Generating & interpreting Database statistics using STATSPACK
Data Loading using SQL* Loader