Role Description : Oracle GoldenGate Administrator

Job Level: P3

Primary Skill: Oracle GoldenGate Administration

Secondary Skills: Oracle Database Administration and Microsoft SQL Server Administration

Experience Required: 5 to 8 years

Support Model: 24x7 production support, including rotational on-call coverage

Role Summary

We are looking for an experienced Oracle GoldenGate Administrator to manage, monitor, and support enterprise-level database replication environments. The professional will be responsible for Oracle GoldenGate installation, configuration, administration, troubleshooting, performance optimization, patching, upgrades, and migration activities.

The role also requires strong knowledge of Oracle database administration, including Oracle Exadata, RAC, ASM, RMAN, Data Pump, database upgrades, patching, backup and recovery, and performance tuning. Working knowledge of Microsoft SQL Server Administration is required as a secondary competency.

Key Responsibilities

Oracle GoldenGate Administration

- Install, configure, administer, and maintain Oracle GoldenGate Classic Architecture and Microservices Architecture.

- Configure and manage

- Extract processes

- Data Pump processes
- Replicat and Parallel Replicat processes

- Trail files and checkpoints

- Manager and Distribution Services
- Implement and support real-time, high-volume, and heterogeneous data replication environments.
- Configure uni-directional, bi-directional, active-passive, and active-active replication, as applicable.
- Implement appropriate DML and DDL replication strategies.
- Monitor replication processes, lag, latency, throughput, and data divergence.
- Troubleshoot GoldenGate ABENDs, trail file issues, checkpoint failures, mapping errors, discard files, and replication latency.
- Perform performance tuning and optimization of GoldenGate replication pipelines.
- Analyse GoldenGate logs, reports, error files, and operational statistics to identify and resolve issues proactively.
- Plan and execute GoldenGate patching, upgrades, migrations, and architecture conversion activities.
- Support data consistency, reconciliation, validation, and correction activities.
- Perform initial load and synchronization activities for source and target databases.
- Work with application, infrastructure, network, and database teams to resolve replication-related incidents.
- Develop and maintain operational procedures, technical documentation, runbooks, and troubleshooting guides.

Oracle Database Administration
- Install, configure, administer, monitor, and troubleshoot Oracle Database environments.
- Provide technical and operational support for Oracle database servers across development, staging, testing, and production environments.
- Manage Oracle Database versions 12c, 19c, and later.
- Support Oracle Exadata, Real Application Clusters, and Automatic Storage Management environments.
- Perform Oracle database installation, upgrade, migration, cloning, and refresh activities.
- Perform patching of Oracle Grid Infrastructure and database software.
- Implement and maintain database backup, restore, and recovery processes.
- Work with Oracle native tools such as:

- RMAN

- Data Pump

- SQL*Loader

- SQL*Plus

- Automatic Workload Repository

- Automatic Database Diagnostic Monitor
- Monitor database availability, capacity, performance, and resource utilization.
- Perform database and SQL performance tuning.
- Analyse execution plans, wait events, blocking sessions, locking issues, and system bottlenecks.
- Estimate database capacity and develop methods for monitoring database growth, utilization, and future capacity requirements.
- Perform regular database maintenance activities, including:

- Table reorganization

- Index rebuilding and reorganization

- Statistics gathering

- Data archiving

- Space management
- Proactively identify, troubleshoot, and resolve production database issues.
- Participate in the creation of development, testing, staging, and production database instances.
- Support database migrations and data movement between environments.
- Work with Oracle Support to resolve business-critical and high-priority incidents.
- Develop automation scripts using UNIX/Linux shell scripting and PL/SQL.

Production Operations and Support
- Provide 24x7 production support as part of a rotational on-call model.
- Monitor GoldenGate and database environments to ensure availability, stability,



and performance.
- Respond to s, incidents, service requests, and production escalations within defined service-level agreements.
- Perform root cause analysis for recurring or critical production issues.
- Implement corrective and preventive actions to minimize future incidents.
- Participate in incident, problem, change, release, and service management processes.
- Prepare implementation, rollback, validation, and communication plans for production changes.
- Coordinate planned maintenance, disaster recovery, failover, switchover, upgrade, and migration activities.
- Ensure database and replication activities comply with organizational security and operational standards.

Required Technical Skills

Oracle GoldenGate

- Strong hands-on experience in Oracle GoldenGate administration.
- Experience with GoldenGate Classic Architecture and Microservices Architecture.
- Expertise in configuring and managing Extract, Data Pump, and Replicat processes.
- Strong troubleshooting knowledge of ABENDs, trail files, checkpoints, lag, latency, and data divergence.
- Experience in GoldenGate performance tuning, patching, upgrades, and migrations.
- Knowledge of DDL and DML replication.
- Experience in data validation, reconciliation, and synchronization.
- Understanding of GoldenGate security, credential management, encryption, and connectivity.

Oracle Database
- Minimum 4 years of experience with Oracle Database 12c, 19c, or later versions.
- Minimum 4 years of experience with Oracle Exadata, RAC, and ASM configuration and administration.
- Minimum 3 years of experience in Oracle database upgrades and migrations.
- Minimum 3 years of experience in Oracle Grid Infrastructure and database patching.
- Minimum 2 years of experience using Oracle tools such as RMAN, Data Pump, and SQL*Loader.
- Strong knowledge of Oracle backup, restore, recovery, performance tuning, and capacity management.
- Hands-on experience with PL/SQL and UNIX/Linux shell scripting.
- Experience in Oracle database maintenance, monitoring, troubleshooting, and automation.
- Strong understanding of Oracle database architecture, storage, memory, background processes, and high-availability configurations.
- Knowledge of database environments hosted on IaaS and PaaS cloud platforms.

Required Secondary Skill: SQL Server Administration
- Experience installing, configuring, administering, monitoring, and troubleshooting Microsoft SQL Server environments.
- Knowledge of SQL Server 2005 through SQL Server 2019 or 2022.
- Experience in SQL Server upgrade and migration services.
- Ability to upgrade and migrate SQL Server databases from older versions to current supported editions.
- Experience installing SQL Server service packs, cumulative updates, security updates, and hotfixes.
- Experience creating and configuring databases according to application requirements.
- Perform online index rebuilding and monitor scheduled index maintenance jobs.

- Configure and manage

- Schemas and users

- Windows and SQL authentication
- Server-level and database-level roles

- Linked Servers
- Backup, restore, and recovery models
- Experience in configuring, monitoring, and troubleshooting SQL Server Log Shipping.
- Knowledge of Log Shipping failover and switchover scenarios.
- Experience configuring Always On Availability Groups across Windows Server Failover Clusters.
- Knowledge of synchronous and asynchronous availability modes.
- Experience configuring and supporting Transactional, Snapshot, and Merge Replication.
- Troubleshoot replication agent failures, primary key violations, synchronization issues, and table additions to existing publications.
- Monitor and troubleshoot replication through SQL Server Replication Monitor.
- Strong understanding of SQL Server architecture, relational engines, and storage engines.
- Understanding of SQL Server background processes, including:

- Checkpoint

- Lazy Writer

- Eager Writer

- Log Writer
- Strong knowledge of Heap, Clustered, and Nonclustered index structures and B-tree architecture.




- Diagnose server-level, application-level, and database-level performance issues.
- Monitor and analyse SQL Server wait types.
- Troubleshoot blocking and deadlock issues using Extended Events.
- Recommend appropriate isolation levels and indexing strategies to minimize blocking and deadlocks.
- Understand SQL Server locks and lock escalation.
- Resolve space management issues, including:

- Transaction log file full

- Data file full

- TEMPDB full
- Implement SQL Server security and hardening best practices.
- Working knowledge of advanced SQL Server features such as:

- Resource Governor
- Policy-Based Management

- SQL Server Auditing

- Transparent Data Encryption

- Always Encrypted
- In-Memory OLTP

- Query Store

Cloud and Platform Knowledge
- Strong understanding of database environments hosted on IaaS and PaaS platforms.
- Experience supporting databases on Microsoft Azure, Amazon Web Services, or other cloud platforms.
- Knowledge of Azure SQL Database, Azure SQL Managed Instance, or Amazon RDS will be an advantage.
- Understanding of connectivity, security, monitoring, backup, and high availability in cloud database environments.

Desirable Skills
- Experience with other relational database platforms such as IBM Db2, MySQL, and PostgreSQL.
- Familiarity with database migration utilities, replication tools, and ETL processes.
- Understanding of database design, data modelling, normalization, and schema management.
- Knowledge of data warehousing, analytics, and big data platforms.
- Exposure to automation and configuration management tools.
- Knowledge of disaster recovery, business continuity, and high-availability architecture.

Process and Service Management Skills
- Good understanding of ITIL-aligned processes, including:

- Incident Management

- Problem Management

- Change Management

- Release Management

- Service Request Management
- Ability to prepare implementation plans, rollback plans, root cause analysis reports, and operational documentation.
- Ability to manage high-priority incidents and coordinate with multiple technical teams.
- Robust orientation toward proactive problem management and service improvement.

Education and Experience
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline.
- Overall experience of approximately 5 to 8 years in database administration and production support.
- Minimum 4 years of relevant experience in Oracle database administration.
- Strong hands-on experience in Oracle GoldenGate administration and troubleshooting.
- Relevant Oracle, GoldenGate, SQL Server, Azure, or AWS certification will be an advantage.

Behavioral Competencies
- Strong analytical and troubleshooting abilities.
- Excellent verbal and written communication skills.
- Ability to work independently and handle production-critical situations.
- Strong ownership and accountability for assigned incidents and activities.
- Ability to collaborate effectively with application, database, infrastructure, cloud, and vendor teams.
- Ability to prioritize multiple tasks in a production support environment.
- Willingness to work in shifts and participate in 24x7 on-call support.

P3-Level Expectations The Candidate Should Be Able To

- Independently manage assigned Oracle GoldenGate and database environments.
- Handle medium to complex production incidents with minimal supervision.
- Perform GoldenGate configuration, monitoring, troubleshooting, patching, and upgrade activities.
- Drive root cause analysis and recommend permanent corrective actions.
- Execute approved production changes, migrations, and maintenance activities.
- Guide junior team members on routine operational and troubleshooting activities.
- Coordinate effectively with internal teams, business stakeholders, and external vendors.
- Maintain accurate technical documentation, operational runbooks, and audit evidence.

Key improvements made
- Established Oracle GoldenGate as the primary skill while retaining Oracle DBA and SQL Server as supporting competencies.
- Reorganized the content into clear sections for easier candidate screening and stakeholder review.
- Removed repeated requirements and corrected fragmented wording.
- Added practical P3-level expectations, including independent ownership, incident handling, documentation, and junior team guidance.
- Standardized technical terminology, product names, and experience requirements.

📌 Oracle DBA with Golden Gate (Bengaluru)
🏢 LTM
📍 Bengaluru