Oracle DBA's Daily Duties

ORACLE – DATABASE ADMINISTRATOR

POSITION DESCRIPTION: This position requires the Data Base Administrator (DBA) to work on oracle databases from a unix/linux command line environment across the normal software life cycle spectrum of development, quality assurance, and production. The DBA is expected to have excellent knowledge of oracle internals and performance and tuning methods and processes. DUTIES AND RESPONSIBILITIES:
· Implementation of daily and weekly database policies and procedures
· Daily responsibility for database loads, database tuning, management of archive logs, journaling systems and preventive maintenance
· Development of tools to analyze the database SGA
· Development and maintenance of reports
· Support of application development
· Processing large datasets and implementation of data conversion routines
· Implementation and verification of tape backup activities
· Rotation of tape media to off site storage weekly
· Primary responsibility for development and test servers
· Client software installation and configuration for each host on the network
· Pre-release activities include functional and capacity review of new software and database changes and identification of performance issues as part of release
· Responsible for systems support as part of 24/7 support rotation.

Database Administrators
Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one person job. In such cases, there is a group of DBAs who share responsibility.
A database administrator's responsibilities can include the following tasks:
Installing and upgrading the Oracle server and application tools.
Allocating system storage and planning future storage requirements for the database system.
Creating primary database storage structures (tablespaces) after application developers have designed an application.
Creating primary objects (tables, views, indexes) once application developers have designed an application.
Modifying the database structure, as necessary, from information given by application developers .
Enrolling users and maintaining system security.
Ensuring compliance with your Oracle license agreement.
Controlling and monitoring user access to the database .
Monitoring and optimizing the performance of the database.
Planning for backup and recovery of database information.
Maintaining archived data on tape.
Backing up and restoring the database.
Contacting Oracle Corporation for technical support.

Job Responsibilities include:-
Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
Responsible for Oracle 9i logical and physical databases design, implementation and maintenance on NT.
Sizes of the databases varied from 5 GB to 10 GB.
Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flex Architecture.
Defragmentation of tables and indexes for improved performance and effective space management. Managing database security.
Creating and assigning appropriate roles and privileges to users depending on the user activity.
Developed Oracle backup and recovery strategy and scripts. Implemented database refresh using full export.
Used EXPORT/IMPORT to do table level and full database defragmentation.
Performed SQL tuning by using Explain Plan and Tkprof.
Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
Checking for errors in alert logs and trace files.Designing and developing the screen of the entire master.
Designing and developing of all the printing reports.Designing, developing & implementing automated data backup and restoration procedure.
Providing technical support for database maintenance & disaster Recovery procedure.
Developing stored procedures in PL/SQL for the Oracle application.