Knowledge of Sybase Database administration along with Oracle DBA will be preferred.
• Installing and configuration of Oracle server.
• Creation of database and maintaining schema generation scripts
• Creating a primary database storage structures
• Creating the primary objects (tables,Views,indexes)
• Modify the database structure as necessary
• Creating and managing development database users, giving the privileges and assigning roles for data access
• Monitoring the performance of the databaseÂ
• Export and Import of databases and their objects, as required.
• Managing the database backup policies for the clients
• Troubleshooting connectivity problems between Oracle Client and Server by configuring listener and tnsnames file.
• Management of data files, control files, redo logs and other objects
• Implementing securities using role and privileges
• Defining and Implementing database backup and recovery .
• Taking Online Backup of the database.
• Configuration of RMAN repository database. Automating backup task for target databases with backup scripts.
• Maintaining Standby Databases
• Rman Backup and Recovery