Title: System Engineer(Contract)
Requisition ID:
3467
City:
Chennai
Country/Region:
IN
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 user’s 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
JD:
Must to have:
Oracle Admin and exp of 5 plus to 7 years. With Golden Gate and Performance tuning experience.