What I have done as a DBA

As an Oracle DBA, I expect to be involvedin the following tasks:

·        Installing Oracle software

·        Creating Oracle databases

·        Performing upgrades of thedatabase and software to new release levels

·        Starting and shutting down thedatabase instance

·        Managing the storage structuresof the database

·        Managing users and security

·        Managing database objects, suchas tables, indexes, and views

·        Backing up the database andperforming recovery operations when necessary

·        Monitoring the state of thedatabase and taking preventive or corrective action as required

·        Monitoring and tuning databaseperformance

·        Diagnosing and reportingcritical errors to Oracle Support Services

But the other details are as below:

Install the RAC 10G on the Sun cluster.

Migrate the 9i on linux to 10G to Solaris.

Modify RMAN backup script to send trap onfailure to email alias.

Write the shell script to rotate the log the partition duplicate the database and generate the performace report.

Test and Compare performance on prod between thestream and materialize views to populate the data into a remote database.

Reclaim the disk space through the data cleansingand index rebuild.

Healthcheck on database through generatingthe health check report for db trend analysis, ,performance analysis,findingthe problematic SQL.

Create a data dictionary for the objects inthe database.To create the ERDs first, thenfill in the table and column definitions for all data elements.

Test the DR site when both of the prod andDR are in the sun cluster.

Recovery the database when the undo tablespace corrupted,redo log file lost,data files lost and user mistaked steps.

Propose the option or requirement to OS team on the disk layout, disk space size,system parameter configuration.

Draft up the SQL guildline to developers and support them to do the SQL tuning and release the database change on Prod.