Oracle DBA

JOB DETAILS

JOB BODY

·         Accustomed to providing support for a 24X7 environment.·         Enjoy troubleshooting, ongoing challenges and continuous learning of new systems and    
·         Software.
·         Zeal to accept work related challenges, dedication towards work.
·         Experience in DATABASE ADMINISTRATION for about 3 to 5 years
·         Good understanding of project documentation.
·         Total I.T. Experience 5+ years and around 3 to 4 years in DATABASE ADMINISTRATION.  On Solaris O/S

Responsibilities

Managing Data files, Control files, Online Redo Log files, Tablespaces

Administration of Tables & Indexes, Index Re-Organization, extent and user management            

Database Re-Organization.

Managing Password Security and Resources, Users, Privileges and Roles.

Implementation of Closed Database Backups (Cold Backups / Offline Backups).

Conversion of Database in Archive Log / No Archive Log Modes.

Setting up scripts necessary for export and to shutdown the databases and takes off-line    cold backup.

Designed and Developed Backup Strategies and Recovery Procedures to ensure the data        recoverability.

Implementation Complete Recovery (Archive Log Mode).

Importing data from old files using export/import utility

Configure and took Backup of database using RMAN.

Creating Database Links and Snapshots.

Used Oracle’s DATA PUMP utility for Tablespace cross platform transport

Critical patch application.

Created clone database of the production database.

Monitoring RAC instances and troubleshooting for the RAC environment.

Installation of Oracle client software and troubleshooting connectivity issues remotely for remote users

Configured Oracle 10g RMAN parameters for daily database backup.

Providing support to end users and developers.

       

 Security Administration by creating Users with appropriate Roles and Privileges.

Creating Users, Granting Privileges to Users and allocating Space.

Managing Data files, Control files, Online Redo Log files, Tablespaces

Implementation of Open Database Backups (Hot Backups / Online Backups).

Used Oracle’s DATA PUMP utility for Tablespace cross platform transport.

Recovery of Database from Disk or Instance failure

Regularly watching System logs, Alert logs to know types of bottlenecks recorded if any, and rising to encounter them.

Monitoring database for fragmentation and de-fragmenting of tables.

Implementing BACKUP and RECOVERY strategies for Offline and Online Backups.

Preparation of weekly and monthly maintenance schedules

Audited different Audited different users for suspicious activities.

Monitoring database performance and manages statistics of database object for performance..

       

Creating and maintaining users, roles and profiles. Granting and maintaining the privileges, roles and managing the resources with the profiles and managing security.

Played a key role in designing and implementing DATA GUARD for disaster recovery and high availability.

Used Oracle’s DATA PUMP utility for Tablespace cross platform transport.

Adjusted extent size of dynamic tables and indexes...

Monitoring database performance and manages statistics of database object for performance...

Was one of the team member in implementing Flash back database.

Responsible for creating new Schemas in the database.

Creating primary database objects (tables, views, indexes).

Installation of Oracle client software and troubleshooting connectivity issues remotely for remote users.

Applied patches and upgrades for Oracle database.

Worked as a part of a team and provide 24/7 production support.

Configured Oracle 10g RMAN parameters for daily database backup.

 Wrote various parameterized scripts for monitoring the status of the database instance, tablespace usage, performing offline backup, listener availability, and RMAN backups.

Created clone database of the production database.

Performed replication of the production database using materialized views and dblinks.