Takes proactive steps to design and architect infrastructure and service to ensure reliability and functionality. Forecasts demands and responds to capacity needs. Collaborates with software development teams to develop reliable and scalable infrastructures. Performs data collection to maintain and optimize operations and reliability. Leverages knowledge to perform incident response and/or maintenance tasks. Provides health and performance reporting. Identifies opportunities for automation. Communicates about services and identifies and explains the potential impact of changes. Provides support for technology and documents incidents. Experiments with new tools and assesses potential impact and develops knowledge of site reliability trends. Responsibilities Required Skills and Technical Expertise
• 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 current 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. Preferred Skills
• 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. Suggested Skills Tags Oracle GoldenGate; GoldenGate Microservices Architecture; OCI GoldenGate; Change Data Capture; Data Replication; Solution Architecture; Oracle Database; SQL; OCI; AWS; Google Cloud; Linux; Python; Shell Scripting; REST APIs; Terraform; Performance Tuning; Capacity Planning; High Availability; Disaster Recovery; Monitoring and Observability; Incident Management; Root Cause Analysis; Database Migration; Cloud Networking; Security. Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded across our products and services, we help customers turn that promise into a better future for all. Discover your potential at a company leading the way in AI and cloud solutions that impact billions of lives. True innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing a workforce that promotes opportunities for all with competitive benefits that support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs. We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing
[email protected] or by calling 1-(phone hidden) in the United States. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.
📌 Senior Site Reliability Engineer (India)
🏢 Oracle
📍 India