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.
Career Level - IC4
Jobs at Bengaluru
Product Manager, Android App Safety
Freshers/Experienced
Bengaluru, Karnataka
Last Date: May 1, 2025
Amazon
SDE-2, RBS Tech
Freshers/Experienced
Bengaluru, Karnataka
Last Date: April 29, 2025
Oracle
Software Development Manager
Professional
Bengaluru, Karnataka
Last Date: Sept. 3, 2025
Oracle
Senior Oracle Fusion SCM Technical …
Professional
Bengaluru, Karnataka
Last Date: May 31, 2025
Oracle
Oracle Fusion Financials Techno Fun…
Professional
Bengaluru, Karnataka
Last Date: Aug. 31, 2025
Oracle
Assistant Manager, Customer Support…
Professional
Bengaluru, Karnataka
Last Date: Aug. 6, 2025
Software Engineer III, Networking, …
Freshers/Experienced
Bengaluru, Karnataka
Last Date: May 8, 2025
Amazon
Software Development Manager, Amazo…
Freshers/Experienced
Bengaluru, Karnataka
Last Date: April 29, 2025
Oracle
Principal Site Reliability Develope…
Professional
Bengaluru, Karnataka
Last Date: July 29, 2025
More Jobs at Oracle
Oracle
Credit & Collections Analyst 1-Fin
Professional
Bengaluru, Karnataka
Last Date: July 27, 2025
Oracle
HCM Cloud Principal Consultant
Professional
Bengaluru, Karnataka
Last Date: May 11, 2025
Oracle
Oracle Fusion Financials Techno Fun…
Professional
Bengaluru, Karnataka
Last Date: Aug. 31, 2025
Oracle
Senior Software Developer
Professional
Bengaluru, Karnataka
Last Date: Sept. 13, 2025
Oracle
Senior Hyperion/EPM Lead
Professional
Bengaluru, Karnataka
Last Date: April 29, 2025
Oracle
Applications Developer 3
Professional
Bengaluru, Karnataka
Last Date: Sept. 13, 2025
Oracle
Oracle Fusion SCM Techno Functional
Professional
Bengaluru, Karnataka
Last Date: Aug. 30, 2025
Oracle
Software Development Manager
Professional
Thiruvananthapuram, Kerala
Last Date: June 11, 2025
Oracle
Senior Principal Consultant- Core B…
Professional
Bengaluru, Karnataka
Last Date: May 23, 2025
Actively Recruiting Companies at Bengaluru, Karnataka