Senior Site Reliability Engineer

Oracle GoldenGate: Strong hands-on experience implementing, administering, troubleshooting, and supporting Oracle GoldenGate in production, including change data capture (CDC), transactional replication, and end-to-end data synchronization.

GoldenGate Microservices Architecture: Practical experience configuring and operating Service Manager, Administration Service, Distribution Service, Receiver Service, and Performance Metrics Service. Ability to manage deployments using the web interfaces, Admin Client, and REST APIs.

Solution Architecture and Design: Ability to independently design and implement GoldenGate solutions for new business requirements, including source and target selection, replication topology, deployment sizing, network connectivity, security, availability, and operational support. Document design decisions and evaluate performance, cost, and recovery tradeoffs.

Replication Configuration: Experience configuring Extract, integrated capture, Replicat, integrated and parallel apply where supported, distribution paths, trail files, checkpoints, table and schema mappings, filtering, and transformations. Understand appropriate use of unidirectional, bidirectional, and hub-based replication patterns.

Oracle Database Fundamentals: Strong SQL and working knowledge of Oracle Database architecture, redo and archive logs, supplemental logging, SCNs, transactions, database privileges, schema changes, and multitenant environments. Ability to investigate database conditions affecting capture and apply.

Initial Load and Data Consistency: Experience planning initial loads and consistent instantiation, coordinating snapshot or export/import activities with ongoing change capture, validating source and target consistency, and safely resynchronizing affected tables.

Cloud Infrastructure: Production experience with OCI or another major cloud platform such as AWS, Google Cloud, or Azure. Understand compute, storage, IAM, virtual networks, routing, DNS, private connectivity, security rules, monitoring, and secrets management as they apply to GoldenGate deployments.

Performance Tuning and Capacity Planning: Ability to diagnose replication lag, slow capture or apply, large transactions, database contention, network bottlenecks, and trail storage growth. Tune supported process configurations and parallelism, forecast capacity, and validate performance under representative workloads.

Production Troubleshooting: Independently investigate process failures, missing or duplicate records, constraint violations, DDL replication issues, connectivity failures, trail and checkpoint problems, and transaction backlogs. Use error logs, report files, database diagnostics, and trail inspection tools such as Logdump.

High Availability and Disaster Recovery: Experience implementing and testing recovery procedures for GoldenGate processes and deployments. Understand checkpoint-based restart, trail retention, backup and restore, failover, failback, and recovery objectives expressed as RPO and RTO.

Monitoring and Site Reliability: Build dashboards and actionable alerts for replication lag, throughput, process health, resource utilization, trail storage, and data freshness. Define and track service level indicators and objectives, participate in on-call support, and reduce recurring operational work.

Automation and Infrastructure as Code: Proficiency in Python and/or shell scripting, REST APIs, Git, and tools such as Terraform or Ansible. Automate provisioning, configuration, health checks, monitoring, validation, and repeatable maintenance with appropriate testing and safeguards.

Security: Experience implementing least-privilege access, secure credential storage, TLS and certificate management, and trail encryption where applicable. Maintain secure connectivity and follow organizational data protection requirements.

Lifecycle and Change Management: Plan and execute installations, patching, upgrades, configuration changes, and migrations. Assess compatibility and dependencies, validate changes in non-production environments, and prepare tested rollback procedures.

Technical Ownership and Collaboration: Independently deliver defined projects, write architecture documents and operational runbooks, lead incident investigations for assigned services, perform root cause analysis, and drive preventive improvements. Collaborate with database, application, networking, security, and cloud teams; escalate broader design or service risks appropriately.

Direct experience with OCI GoldenGate, including deployments, connections, private networking, IAM policies, Vault integration, monitoring, and capacity management.

Experience with uni/bidirectional or active-active replication, including conflict detection and resolution, loop prevention, and application consistency considerations.

Experience with heterogeneous replication involving supported platforms such as PostgreSQL, MySQL, or SQL Server, and supported streaming or analytics targets such as Kafka.

Experience delivering low-downtime database migrations, cloud migrations, controlled cutovers, rollback plans, and post-migration data validation.

Familiarity with Oracle RAC, Data Guard, RMAN, and Data Pump and how these technologies interact with GoldenGate deployment and recovery designs.

Experience with data validation approaches such as GoldenGate Veridata or equivalent, and migrating legacy Classic Architecture deployments to Microservices Architecture.