Job Description Oracle Database Administrator + GoldenGate
Job Title:
Job Summary
Oracle Database Administrator (DBA)
Key Responsibilities
Oracle Database Administration
- Install, configure, upgrade, patch, and maintain
Oracle databases
. - Perform day-to-day administration across development, test, and production environments.
- Monitor database health, availability, storage, and performance.
- Perform
SQL/query performance tuning
, indexing, and database optimization. - Manage users, roles, privileges, and database security.
- Troubleshoot database connectivity, performance, locking, and space-related issues.
- Support database migration, refresh, and environment-related activities.
Oracle GoldenGate
- Install, configure, and administer
Oracle GoldenGate
environments. - Configure and manage
Extract, Data Pump, and Replicat
processes. - Monitor replication lag, trail files, processes, and data synchronization.
- Troubleshoot replication failures, abends, latency, and data consistency issues.
- Perform GoldenGate upgrades, configuration changes, and maintenance activities.
- Support
real-time and near-real-time data replication
between Oracle databases. - Perform recovery and restart of GoldenGate processes while maintaining data integrity.
Backup, Recovery & High Availability
- Manage
RMAN backup and recovery
activities. - Support disaster recovery and business continuity initiatives.
- Perform database recovery, restore, and failover-related activities.
- Monitor database availability and ensure SLA compliance.
Production Support
- Provide
L2/L3 production support
for critical Oracle databases and replication environments. - Analyze incidents and perform
root-cause analysis
. - Participate in change, release, and maintenance activities.
- Coordinate with application, infrastructure, network, and support teams.
- Participate in on-call and weekend support as required.
Mandatory Skills
Oracle Database Administration
Oracle GoldenGate
- Oracle installation, configuration, patching, and upgrades
- GoldenGate Extract, Pump, and Replicat
- Replication monitoring and troubleshooting
- RMAN Backup & Recovery
- SQL and PL/SQL
- Performance tuning
- Database security and user management
- Production support
Good to Have
- Oracle RAC
- Oracle Data Guard
- Oracle Enterprise Manager (OEM)
- Linux/Unix administration
- Shell scripting
- Cloud database platforms
- Data migration and upgrade experience
- High Availability and Disaster Recovery
Candidate Profile
5–8 years
of experience in Oracle Database Administration.- Strong hands-on experience with
Oracle GoldenGate
in enterprise environments. - Good understanding of database performance, backup/recovery, replication, and production support.
- Strong troubleshooting and problem-solving skills.
- Good communication and collaboration skills.
Key Skills
Oracle DBA | Oracle Database | GoldenGate | Extract | Data Pump | Replicat | RMAN | SQL | PL/SQL | Performance Tuning | Replication | Backup & Recovery | Oracle RAC | Data Guard | Linux | Production Support
