oracle dba
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 difficulttask, 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 tuningand monitoring.
- Job scheduling and monitoring.
- Oracle application tuning.
- Capacity planning, and monitoring growth of oracle database system.
- Trouble shooting and providing in housesupport 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 features company is using the tasks for DBA can increase and decrease. The job description also changes if the organization have multiple Oracle DBA's on staff to handle Production / QA UAT and development tasks separately.