
Oracle DBA (oracle database administration)
Oracle DBA manage and administer the relational database management system (RDBMS)
officially called Oracle Database (and commonly referred to as Oracle RDBMS or simply
as Oracle) has become a major presence in database computing. Oracle Corporation
produces and markets this software.
Oracle administration is generally little more difficult task, compared to
SQL Server and My SQL databases. Oracle have many more features and administration
of each feature makes the job much more complicated. Since oracle is highly
configurable, stable, with built in tools for management, which actually helps
the Oracle DBA in administration tasks and makes the job easy. Oracle is also
one of the most powerful database system available.
What does Oracle DBA do
- Installation and configuration of oracle database servers.
- Upgrading of Oracle server software
- Evaluate new feature and third party Oracle related products
- Backup / Restore.
- Designing Disaster recovery strategies and implementing them.
- Database designing.
- Database security, creating users and assigning roles.
- Oracle dba most important task Database performance tuning and monitoring.
- Job scheduling and monitoring.
- Oracle application tuning.
- Capacity planning, and monitoring growth of oracle database system.
- Trouble shooting and providing in house support for oracle related issues.
- Working with oracle database developers to provide consultation and suggestions.
- Writing SQL code and review code by developers.
Oracle database administrators does lot more things then i mentioned in above list,
depending on the oracle features a particular company is using, the tasks for DBA can increase and decrease.
The job description can also change if the organization have multiple Oracle DBA's on staff to
handle Production / QA UAT and development tasks separately.