System Engineer ( Contract)

Do

• Configuration control and management for project deliverables including new database installation and setup.
• Design and implement the high availability solutions ( Golden Gate and Dataguard)
• Periodic database instance performance review and tuning recommendation
• Write and troubleshoot shell scripting, SQL and PL/SQL scripts
• Data guard: DR Drill (Data guard Switchover)
• DG Architecture Standby Recreation Standby Duplicate Standby database non- Checking the number of missing logs - Checking MRP process which applies the redo data in to standby database.
• Recovery Manager and Backup: Refresh databases using RMAN and User Managed Backup
• Performing tape level Backup and Recovery using RMAN.
• Recovery catalogue register/unregister
• Data Pump: Export/Import of Tables, Table spaces and Full Databases. Schema Refresh using Exp/Imp Utility Taking logical backups of table segments having more no of records using exp and data pump utilities.
• Remap Schema Other Daily Activities: Managing Table spaces, data files, and users creation.
• Data Refresh Schema and Database as per requirement using data pump.
• OEM grid configuration.
• Adding data disks to an ASM disk group. OEM configuration User and application connectivity issues.
• Configuration of manual housekeeping jobs and backup using cron job.
• User creation and Granting the necessary roles, privileges and profiles to the users.
• Monitoring the Inactive user session and killing them if required, Table lock issue handling

Must to have:

Oracle Admin and exp of 5 plus to 7 years. With Golden Gate and Performance tuning experience.