Oracle DBA & GoldenGate Expertise
$15-25 USD / hour
Posted 1 minute ago
•
Ends in 6 days
$15-25 USD / hour
I’m looking for a senior-level Oracle professional who can guide and execute work across three tightly connected areas: core database administration and performance tuning, GoldenGate replication, and proactive monitoring through Oracle Enterprise Manager (OEM). My estate is a hybrid mix of on-premise databases and Oracle Cloud instances, so you’ll need to be comfortable jumping between both. Here’s what I need over the next few weeks: • Review the current database configurations (19c and a few legacy 12c servers) and recommend performance tweaks, index or parameter changes, and any capacity planning adjustments. • Validate and, where necessary, rebuild GoldenGate processes to guarantee zero-data-loss replication between our primary on-prem RAC cluster and the cloud standby. Troubleshooting extract/pump issues and lag is part of the brief. • Tighten OEM 13c monitoring: build custom metrics, fine-tune alert thresholds, and enable meaningful notifications so our operations team can act before problems surface. Acceptance will be based on: – Stable replication showing sustained low lag for 48 hours. – OEM dashboards with clear, noise-free alerts and documented metric settings. – A concise handover report covering all database changes and performance results. When you reach out, focus on your direct experience delivering similar hybrid solutions—particularly any wins involving RAC, ASM, Data Guard coexistence with GoldenGate, and hands-on OEM customization. Screenshots or brief case notes are perfect proof points.
Project ID: 40820980
About the project
16 proposals
Open for bidding
Remote project
Active 4 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
16 freelancers are bidding on average $19 USD/hour for this job


I can handle the database, replication and monitoring work as one connected review, rather than tuning each area in isolation. I work hands-on with Oracle 19c/12c, RAC/ASM, GoldenGate and OEM 13c across hybrid environments. One distinction I would verify early: low GoldenGate lag does not, by itself, prove zero data loss. I’ll check extract and pump checkpoints, trail retention, apply errors and source-to-target consistency, alongside how GoldenGate coexists with Data Guard and your failover procedures. I’ll baseline database performance before recommending index, parameter or capacity changes, then validate the effect of each approved change. For OEM, I’ll tune alerts around actionable symptoms—such as replication lag, tablespace growth and resource pressure—so the operations team gets useful notifications rather than noise. You’ll receive a documented change and performance summary, clear OEM metric settings, and evidence of sustained replication health across the required 48-hour window. If you can share a sanitized topology and current GoldenGate status, I can identify the highest-risk areas first; I’m also happy to provide relevant redacted case notes where permitted.


Hi - Adelman here from Texas ORACLE RAC, GOLDENGATE & OEM - the priority is stable hybrid replication with low lag, reliable monitoring and database changes that are measured and documented. I'd approach this with an initial review of the 19c/12c configurations, replication topology and OEM alert setup. I'd identify performance and capacity issues, inspect Extract/Pump checkpoints and lag, and review how GoldenGate operates alongside RAC and Data Guard. Any configuration changes should be tested and backed up before implementation, followed by a 48-hour replication observation and a concise handover report. I want to be transparent: I can't provide verified Oracle DBA, RAC or GoldenGate case studies or screenshots, so I won't claim specialist production experience I can't substantiate. Can you share the current GoldenGate version and whether Data Guard is actively running alongside the replication setup? Looking forward to work with you.


Hello, Your hybrid setup with on-prem RAC feeding a cloud standby is the kind of estate where GoldenGate and OEM have to pull together, not sit as afterthoughts. I would open with a short discovery pass on the 19c and leftover 12c boxes: wait events, top SQL, ASM space trends, and parameter drift. From that I would give you a prioritized tweak list so we land the changes that move the needle first, then fold those into a capacity picture you can actually plan around. On replication, I would walk the extract and pump paths end to end, check trail integrity, and rebuild anything fragile so we hold sustained low lag with zero data loss between the RAC primary and the cloud side. Where Data Guard already sits beside GoldenGate, I keep the two from stepping on each other instead of treating them as separate silos. For OEM 13c I would cut the noise: custom metrics that mirror real failure modes, alert thresholds that fire early enough for ops to act, and a clean dashboard pack. Acceptance for me means 48 hours of stable low lag, quiet OEM alerts with documented settings, and a short handover report covering every change and the performance results. I can put in 40 hours each week over the next stretch and keep you posted as we clear each acceptance checkpoint.


Hello, I’m excited about the opportunity to assist with your Oracle DBA & GoldenGate project. With over a decade of experience in Oracle environments, I am well-equipped to manage and optimize your hybrid database estate. I've successfully handled complex Oracle setups, including RAC and ASM, and have ensured seamless coexistence of Data Guard and GoldenGate. My approach to database administration focuses on meticulous performance tuning and ensuring high availability. I have a track record of diagnosing and fine-tuning configurations, particularly with Oracle 19c and legacy 12c versions, to enhance performance and reliability. For the GoldenGate replication, I will meticulously review and, if necessary, reconstruct processes to ensure zero-data-loss replication. I have resolved many extract/pump issues in the past, reducing lag to minimal levels. With Oracle Enterprise Manager, I specialize in creating custom metrics and configuring alert systems that preemptively address potential issues. My goal is to deliver dashboards that provide clear, actionable insights without overwhelming your team with unnecessary alerts. I am committed to producing stable replication with minimal lag, and I will document all changes in a detailed handover report that outlines performance improvements and database modifications. I look forward to discussing how I can bring these capabilities to your project and help achieve your objectives efficiently. Best regards, Dominique


My database design and optimization experience, supported by SQL and troubleshooting skills, enables me to investigate database performance issues and improve the reliability of data-driven systems. I work across backend architecture and cloud-native solutions, including deployments on AWS, Azure, and Google Cloud, which aligns well with the hybrid nature of your Oracle estate. I can contribute to configuration reviews, query and schema analysis, capacity considerations, and systematic troubleshooting of replication or monitoring issues. My experience building scalable APIs, microservices, and database-backed platforms also helps me assess how database behavior affects the wider application environment and produce clear technical documentation for handover. I would be glad to apply my database optimization and troubleshooting expertise to your Oracle environment and help deliver a stable, well-documented solution.


Hello, After reviewing your requirements, I understand the focus: Oracle 19c/12c tuning, reliable hybrid GoldenGate replication, and actionable OEM 13c monitoring. I’m available to start immediately at $20/hr. I can help review RAC/ASM configuration, SQL execution plans, indexing, and capacity, then validate Extract/Pump/Replicat checkpoints, trail retention, and recovery procedures alongside Data Guard. One key challenge is keeping replication consistent during failures—not just reducing lag. I would assess supplemental logging and recovery gaps, address bottlenecks, and verify sustained low lag over 48 hours. For OEM, I would refine custom metrics, thresholds, and notification rules, documenting changes and performance results for handover. Zero-data-loss feasibility would need validation against your architecture. I have a couple of quick questions. • Which GoldenGate version and architecture are deployed, and what are the cloud targets? • Is Data Guard protecting the same databases, and what replication lag and recovery targets apply? I would be glad to discuss the environment and agree on a safe execution plan. Looking forward to hearing from you. Best regards, Carlos.


Hello, I can optimize your Oracle database configurations and GoldenGate processes to ensure efficient performance and zero-data-loss replication between your on-prem RAC cluster and cloud standby. I recommend utilizing Oracle Enterprise Manager (OEM) to build custom metrics and fine-tune alert thresholds, which will proactively monitor your database performance and minimize potential issues. My approach will involve reviewing your current configurations, implementing necessary changes, and testing replication stability for at least 48 hours. I can deliver a concise handover report documenting all adjustments. Can you confirm if you have specific performance metrics in mind for the OEM customization? Please feel free to reach out to me. I look forward to working with you. Best regards, Billy Bryan


Hello, My closest relevant experience is in backend integrations and troubleshooting data consistency across connected services. I have used Postman to reproduce asynchronous events, investigate duplicate and out-of-order notifications, and identify inconsistencies between systems. This experience has strengthened my approach to data integrity, fault investigation, and systematic validation. For your hybrid environment, I would approach the review by establishing a clear baseline of database health, replication status, resource utilization, and existing monitoring before proposing changes. Replication validation should include lag measurements, recovery scenarios, data consistency checks, and documented evidence. OEM alerting should also distinguish genuine operational risks from routine fluctuations. However, I want to be transparent: I cannot substantiate hands-on production experience administering Oracle RAC, ASM, Data Guard, GoldenGate, or OEM 13c. Given your zero-data-loss requirement, I would not misrepresent my integration experience as specialist Oracle DBA expertise. If you are open to support focused on integration analysis, technical documentation, and validation workflows alongside an experienced Oracle DBA, I would welcome a discussion. Best regards, Nicolas


Hi, I like this project because I realized what you want in this and have already found some technical solutions for it. My 20+ years of senior engineering experience make me well suited to review complex, business-critical systems where reliability, performance, and sound architecture matter. I have worked across architecture, implementation, deployment, optimization, and long-term technical strategy, including rescuing fragile or legacy systems and making them stable and maintainable. For your hybrid Oracle environment, my SQL expertise supports the database configuration and performance-review requirements, while my broader background in distributed systems, cloud infrastructure, scalability, and technical leadership is relevant to coordinating on-premise and cloud workloads. I approach database changes with a focus on measurable performance, operational reliability, and clear documentation rather than isolated fixes. My hands-on engineering background also means I remain involved in implementation and troubleshooting instead of only producing recommendations. I would be glad to bring this senior, independent approach to your Oracle DBA, GoldenGate, and OEM objectives and deliver a concise, practical handover. Looking forward to having a quick talk.


My nearly 20 years in software engineering and technology leadership, supported by a Bachelor’s degree in Computer Science and a PhD in Artificial Intelligence, give me a strong foundation for complex database administration, Oracle environments, and performance-focused technical consulting. I would be pleased to apply my Oracle and database administration skills to your RAC, replication, and OEM objectives and support a reliable, well-documented outcome.


Hello, My SQL expertise is the strongest direct match I can offer for database-focused work, including querying, data validation, and analysis of performance-related issues. I also build production-grade backend and cloud applications with Python, FastAPI, Node.js, Docker, Kubernetes, and CI/CD, giving me a solid foundation for working across hybrid environments and integrating operational data into reliable systems. My experience with scalable architectures, secure deployments, automated testing, and monitoring-oriented engineering can support structured investigation of database behavior and clear technical documentation. I can contribute carefully to SQL analysis, configuration review, data consistency checks, and a concise handover report while keeping changes controlled and well documented. I would welcome the opportunity to apply my SQL and production engineering background to your Oracle environment and help deliver dependable, clearly documented results. Thanks!
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗