Oracle DBA Sample Resumes

Oracle DBA Sample Resume 5+ Years Experience




 

·         Six plus years of experience in Information Technology as Oracle Database Administrator and knowledge in Systems Analysis and Design, Development and Documentation at various levels.

 

·         Performed Oracle 8i/9i/10g software and database installation and upgraded various versions.

 

·          5.0 + Years of professional experience in different aspects of Oracle Apps Database Administrator/System Administrator of ERP (Oracle Applications 11.5.10.2/9/8) on 8.x/ 9.x production database

 

·          Experience in administering, tuning and monitoring database using Toad, OEM

 

·         Designed strategies for performing database backups and recovery

 

·         Debugging with procedures, Function, Triggers, Packages and other PL/SQL objects

 

·         Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask

 

·         24x7 on-call Production support fordatabase activities.

 

TECHNICAL SKILLS

Databases:

Oracle 8i / 9i / 10g, SQL Server,MS Access

Operating Systems:

UNIX, Windows NT/2000

Programming Languages:

PL/SQL, UNIX Shell Script

Database Tools:

Toad, OEM, DBA Studio

ETL Tools:

SQL Loader, Erwin

Version Control Tools:

Visual Source Safe

Telnet Tool:

Putty, Hummingbird Connectivity (9.0)


PROFESSIONAL EXPERIENCE

Client Name

From Date - To Date

Oracle DBA

 

Project : Maintenance and support for oracle 7/8i/9i/10g databases.


Responsibilities:

 

 

Supporting more than 40 instances.

 

·         Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.

 

·         Automated hot backups using a combination of incremental, differential and full RMAN backups.

 

·         Maintaining archive data on appropriate storage devices.

 

·         Tracing, troubleshooting with database performance and tuning issues.

 

·         Export/Import of oracle databases.

 

·         Tuning SQL queries.

 

·          Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.

 

·         Analyzing and validating database objects.

 

·         Coordinating with team members.

 

·         On call support 24x7.

Environment: Oracle Server 7.0.3/8i/9i/10g, SQL Server, HP –UNIX, AIX, Sun OS, Clarify, SPIN, Business objects.

Client Name

From Date - To Date

Oracle DBA

 

Project: Maintenance and support for oracle 8i/9i databases.
Responsibilities:

 

·          Supporting more than 30 instances.

 

·          Installing 9i database.

 

·           Upgraded oracle 9i /10g.

 

·           Extensively worked on Real Application Cluster (RAC).

 

·         Creating stand by database.

 

·         Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.

 

·          Automated hot backups using a combination of incremental, differential and full RMAN backups.

 

·          Maintaining archive data on appropriate storage devices.

 

·         Tracing, troubleshooting with database performance and tuning issues.

 

·          Export/Import of oracle databases.

 

·          Tuning SQL queries.

 

·         Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.

 

·         Analyzing and validating database objects.

 

·         Coordinating with team members.

 

·         On call support 24x7

.

Environment: Oracle Server 9i/10g, Sun OS, FLS

Client Name

From Date - To Date

Oracle DBA

 

Project: Brodvision Maintenance and support for oracle 8i/9i databases.


Responsibilities:

 

 

·           Installing 9i database.

 

·         Upgraded oracle 9i /10g.

 

·          Creating stand by database.

 

·         Extensively worked on Real Application Cluster (RAC).

 

·           Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.

 

·          Automated hot backups using a combination of incremental, differential and full RMAN backups.

 

·         Maintaining archive data on appropriate storage devices.

 

·          Tracing, troubleshooting with database performance and tuning issues.

 

·          Export/Import of oracle databases.

 

·         Tuning SQL queries.

 

·          Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.

 

·         Analyzing and validating database objects.

 

·          Coordinating with team members.

 

·         On call support 24x7.

Environment: Oracle Server 8i / 9i / 10g, Sun OS, Broadvision 7.1

Client Name

From Date - To Date

Oracle DBA

 

Project : Upgrade from oracle 8i to oracle 9i


Responsibilities:

 

 

·         Installing 9i database.

 

·          Upgraded oracle 8i to 9i.

 

·          Provided and implement the DR solution.

 

·         Used Oracle Dataguard tool for creating the standby database.

 

·          Automated the process of oracle backup.

 

·          Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.

 

·         Tracing, troubleshooting with database performance and tuning issues.

 

·          Export/Import of oracle databases.

 

·          Tuning SQL queries.

 

·         Maintaining archive data on appropriate storage devices.

 

·         Analyzing and validating database objects.

 

·          Coordinating with team members.

 

·         On call support 24x7.

 

Client Name

From Date - To Date

Oracle DBA

 

Project: Maximo Management System
Responsibilities:

 

·           Installing ORACLE 8i Server and application tools.

 

·           Allocating system storage and planning future storage requirements for the database.

 

·         Involved in writing stored procedures/functions as per requirements.

 

·          Maintaining archived data on appropriate storage devices.

 

·         Controlling and monitoring user access to the database.

 

·          Database performance and tuning issues.

 

·         On call support 24x7.

Environment: Oracle 8i, SQL, PL/SQL, SQL Loader, Toad, Windows NT Maximo 4.1.

Client Name

From Date - To Date

Oracle DBA

 

Project : Payroll Management System 

The project involves maintaining the monthly payroll of employees of a company & handles the following functions. Maintaining the employee attendance, recording daily working hours, Calculation for standard deduction & net salary.


Responsibilities:

 

 

·         Study and Analysis of Business requirements

 

·         Interacted with the Technical Design team and contributed in impact analysis and creation of the Technical specifications.

 

·         Consistently delivered work assignments within given timeframe, with high quality and zero defect work which was highly appreciated by the client

 

·         Was involved in database design and implementation.

 

·         Participated constructively to help and enable team members with their challenges

 

·          Provided technical assistance to the testing team to understand and setup the testing scenarios and to execute technical intervention test cases.

 

·         Involved in end-user training and creating user manual document

Environment: Oracle 8i, Forms 4.5, Windows NT, HP - UNIX

EDUCATION
Degree from Ozmania University - 1996
CERTIFICATIONS