ERP-JOBS | Useful Links

Main
About
Submit Profile
Subscriber Area
Job Postings
Contact
Corporate Subscriber List
Post a Job & Subscription Information
Resources
Advertising
RFP/RFI Area
Newsletter
References

Oracle DBA Job Description

```
Patch Application
```
```
Software Installation
```
```
Database Tuning
```
```
Database Design
```
```
Unix Level Commands
```

Compile an object manually when the recompile_objects.sql fails and you have

          two many invalid objects

Find errors after applying a db patch and things that need to be done (post

          Install steps) for patches

Find out the errors with concurrent managers

Manage the concurrent manager queues on instances

Take steps to prevent overloading of the managers and resources

```
Check the disk utilization
```

Maximize the performance by scripts and periodic maintenance

```
Look to maximize the space on the disk
```

Eliminate log files that build up very fast

Pinpoint the errors with the packages /procedures

```
Use the dynamic tables
```

Backup/restore database with cold backup

```
Backup/restore database with hot backup
```
```
Monitor rollbacks
```

Write rollback statements where there are periodic constraints

```
Manage tablespaces
```

Effectively run scripts that give the performance of db

Use different utilities of the database for appls

```
Run adodfcmp
```
```
Run concsub
```
```
Run adrelinks
```
```
Run adpatch
```
```
Run adadmin
```
```
Monitor alert logs
```
```
Manage the db
```
```
Run the trace(s)
```
```
Tune the trace(s)
```
```
Writing effective ddls
```

Edit and effectively manage the tnsnames /listener files on the server

```
Use the client monitors
```
```
Stop and start concurrent managers
```
```
Stop and start listeners
```
```
Stop and start databases
```
```
Monitor users on the systems
```
```
Export and import databases
```
```
Set up the Unix environments
```
```
Set up the Applications environments
```
```
Set up the Oracle environments
```
```
Monitor file systems
```
```
Schedule reboots on the systems
```

Check the patch availability of operating system

Check the patch availability for Oracle apps

```
Recompile reports for applications
```

Recover database files and manage database recovery - outlining the faster

          recovery

Control the deteriorating system and find the possible causes

```
Check the sqlnet log files
```
```
Tuning sqlnet
```

By providing these links, www.erp-jobs.com LLC is not undertaking any responsibility or liability for information or publications of third parties on the Internet regardless of how they are accessed.