A production DBA, supporting oracle versions 8i to10g on SUN Solaris and Windows Platforms to its EU
and Japan customers with production database varying is sizes from 150gb to approx. 1.2 tb.
Oracle DBA activities:
* DB software installation, upgrade, patching
* DB recovery, cloning, backup, restore .
* User support on an oracle clinical application
* Setup and administer Spotfire environment.
* User/helpdesk support and troubleshooting
* Supporting, monitoring & tuning the database subsystems & instances.
* Carrying out application performance tuning and testing.
* Create instances and databases with appropriate initialization parameters and database structures
(i.e., data files, rollback segments, table spaces, etc.).
* Manage physical database resources.
* Review and monitor system and instance resources to insure continuous database operations (i.e.,
database storage, memory, CPU, network usage, and I/O contention).
* Perform database software maintenance.
* Move, rebuild, or change database objects as required in production.
* Develop database administration tools/utilities/operation procedures.
* Developing & maintaining naming standards for database objects such as table spaces, tables,
indexes & views.
* Implement and review appropriate security guidelines/mechanisms.
* Implement, maintain, and test backup & recovery strategies.
* Developing & implementing database administration policies & procedures including subsystem.
* Develop and test database migration procedures. Participating in database migration reviews.
* Upgrade/migrate databases to current release levels.
* Develop operational procedures.
* Providing technical assistance to other team members.