- Skill Set: SQL
- Total Experience: 3.00 to 7.00 Years
- No of Openings: 1
- Job Post Date: 13/10/2021
- Job Expiry Date: 12/11/2021
- Domain: IT
- Location: PUNE [India]
Should have experience to work in 24*7 production environment with 10g/11g/12c/10c versions
Should have sound knowledge of configuring physical standby database with different protection modes and must be aware of switchover/failover activities.
Should have experience in database version upgrades, database migration on different server, application of PSU/Bug fix patches
Should have experience about working in 11g/12c/19c RAC/ASM database, RAC performance issues, troubleshooting cluster issues etc.
Should have knowledge of Performance tuning, to do review database, periodic database health check, provide recommendations based on AWR/ADDM reports etc.
Should have experience in working in Golden gate replication, (experience of oracle vs. SQL golden gate replication would be added benefit)
Should have experience in working on OEM12c monitoring framework, agent installation/DB configuration in OEM, generating reports using OEM etc. (Knowledge of BI publisher would be added benefit)
Should have experience in database restoration using RMAN, point in time recovery, handling corruption issues etc.
Should have knowledge about implementing security measure as per audit requirements, also should have knowledge about implementing database best practices
Knowledge about EXADATA systems would be added advantage.
Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release
DB upgrade experience, which should takes place with minimal impact.
Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
Assists with impact analysis of any changes made to the database objects.
Troubleshoots with problems regarding the databases, applications and development tools
JD For Golden Gate
Installation and configuration Oracle Golden Gate environment for Cluster and Standalone environment.
Configuration of Change Capture and Initial Load
Managing Oracle Golden Gate instances
Performing zero downtime database migration with Golden Gate.
Oracle Golden Gate facilities to detect and resolve data conflicts in active to active replication implementations
Performing Golden Gate upgradation to latest version
Configure Golden Gate in OEM.
Use of GGSCI commands for gathering process evidence
Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization, SQLEXEC, file maintenance and more
Monitoring the lag and statistics
Performing tuning of Manager, Extract and Replicate.
Expertise in Oracle Golden Gate advanced configuration options
Master Oracle Golden Gate facilities to detect and resolve data conflicts in active to active replication implementations
Familiar with GG 11g and 12c advanced features