Oracle
Principal DBA (GoldenGate & Performance Tuning Expert)
Job Description
Database administration
- Design and implement database migration strategies using OCI Data Pump, GoldenGate, and Oracle Cloud MAA best practices.
- Database RU Patching in Exadata DB systems.
- Database upgrade.
GoldenGate Administration & Data Replication
- Deploy, configure, and manage Oracle GoldenGate for real-time data replication and transformation across heterogeneous environments.
- Troubleshoot GoldenGate replication issues, ensuring data synchronization, conflict resolution, and high availability.
- Perform database migrations using GoldenGate, OCI Data Transfer, Data Pump, and GoldenGate Cloud Service.
- Implement GoldenGate streaming to Kafka, Snowflake, and other data lake services for real-time analytics and event-driven architectures.
- Ensure seamless data integration, migration, and replication between ATP, ADW, and on-prem databases.
Oracle Cloud Infrastructure (OCI) Database Management (Oracle 23ai ATP & ADW Expertise)
- Deploy and manage OCI-based database services, including DBaaS, Exadata, and Oracle Autonomous Database.
- Configure OCI networking, IAM roles, security groups, and database encryption for a secure database environment.
- Automate database provisioning and management using Terraform, Ansible, or OCI CLI.
- Implement automated performance tuning, auto-scaling, and security policies for ATP & ADW.
Performance Tuning & Optimization
- Conduct advanced SQL query tuning using AWR, ADDM, ASH, TKPROF, and execution plans.
- Optimize Exadata Smart Scan, Hybrid Columnar Compression (HCC), and storage indexes to maximize performance.
- Design and implement high-performance database architectures for mission-critical applications.
High Availability (HA) & Disaster Recovery (DR) Solutions
- Design and implement HA/DR strategies using Data Guard, GoldenGate, and Oracle Maximum Availability Architecture (MAA) best practices.
- Troubleshoot HA, replication failures, and latency issues across distributed environments.
Automation, DevOps & Cloud-Native Database Administration
- Develop automation scripts using Shell, Python, Perl, Ansible for routine database maintenance, patching, and monitoring.
- Integrate DevOps practices using CI/CD pipelines, GitHub, Jenkins, and Terraform for cloud infrastructure automation.
- Manage cloud-native databases on OCI, AWS, and Azure, ensuring security, scalability, and compliance.
Troubleshooting & Customer Escalation Management
- Serve as the SME for critical customer issues, providing expert-level database troubleshooting and resolution.
- Act as the technical lead in high-priority incidents, working closely with support, development, and cloud infrastructure teams.
Security & Compliance
- Ensure database environments comply with security best practices, regulatory compliance, and enterprise policies.
- Implement database auditing, encryption, and user access management to prevent unauthorized data access.
Collaboration & Leadership
- Act as the Oracle SME in customer calls/escalations, providing clear technical solutions and recommendations.
Jobs at Bengaluru
Amazon
Manager Inventory Planning, Amazon …
Freshers/Experienced
Bengaluru, Karnataka
Last Date: March 25, 2025
Oracle
Technical Account Representative (T…
Professional
Bengaluru, Karnataka
Last Date: April 14, 2025
Oracle
Software Developer 3
Professional
Bengaluru, Karnataka
Last Date: April 16, 2025
Oracle
Principal Member of Technical Staff
Professional
Bengaluru, Karnataka
Last Date: Aug. 12, 2025
Amazon
Program Manager - Network Planning,…
Freshers/Experienced
Bengaluru, Karnataka
Last Date: March 25, 2025
Oracle
Senior Consultant - Oracle AIA for …
Professional
Bengaluru, Karnataka
Last Date: June 22, 2025
Oracle
Oracle HCM (Fusion) - Technical/Fun…
Professional
Bengaluru, Karnataka
Last Date: March 19, 2025
Oracle
EPM PBCS/EPBCS/FCCS/ARCS/PCMCS/EDMC…
Professional
Bengaluru, Karnataka
Last Date: April 30, 2025
Senior Software Engineer, Android, …
Freshers/Experienced
Bengaluru, Karnataka
Last Date: March 27, 2025
Amazon
Software Development Engineer - II,…
Freshers/Experienced
Bengaluru, Karnataka
Last Date: March 25, 2025
More Jobs at Oracle
Oracle
Senior Principal Consultant
Professional
Bengaluru, Karnataka
Last Date: May 7, 2025
Oracle
Senior Member of Technical Staff
Professional
Bengaluru, Karnataka
Last Date: March 29, 2025
Oracle
Senior Software Developer
Professional
Bengaluru, Karnataka
Last Date: April 23, 2025
Oracle
Fusion HCM Technical Senior Consult…
Professional
Bengaluru, Karnataka
Last Date: July 29, 2025
Oracle
Software Developer 3
Professional
Bengaluru, Karnataka
Last Date: March 17, 2025
Oracle
Applications Developer 3
Professional
Bengaluru, Karnataka
Last Date: May 19, 2025
Oracle
Lead Oracle DBA/Exadata DBA
Professional
Mumbai, Maharashtra
Last Date: Aug. 31, 2025
Oracle
Cloud Oracle DBA - Exadata
Professional
Bengaluru, Karnataka
Last Date: March 18, 2025
Actively Recruiting Companies at Bengaluru, Karnataka