What I have done as a DBA

<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->

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

· Installing Oracle software

· Creating Oracle databases

· Performing upgrades of the database and software to new release levels

· Starting and shutting down the database instance

· Managing the storage structures of the database

· Managing users and security

· Managing database objects, such as tables, indexes, and views

· Backing up the database and performing recovery operations when necessary

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

· Monitoring and tuning database performance

· Diagnosing and reporting critical 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 on failure 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 the stream and materialize views to populate the data into a remote database.

Reclaim the disk space through the data cleansing and index rebuild.

Healthcheck on database through generating the health check report for db trend analysis, ,performance analysis,finding the problematic SQL.

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

Test the DR site when both of the prod and DR 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.