Oracle Hiring for Principal DBA (GoldenGate & Performance Tuning Expert) at India Full Time

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.

Responsibilities

Required Qualifications:

• 10+ years of experience in Oracle Database Administration , including Exadata, GoldenGate, and Performance Tuning .

• Hands-on experience in Oracle RAC, Data Guard, and GoldenGate deployments .

• Expertise in Oracle Autonomous Database (ATP/ADW) for performance optimization, monitoring, and security .

• Strong knowledge of cloud-native databases and experience managing OCI, AWS, or Azure database services .

• Hands-on experience in GoldenGate for real-time replication, data streaming (Kafka), and migration .

• Proficiency in SQL, PL/SQL, and database performance tuning techniques .

• Strong background in database migration, upgrades, and automation using Terraform, Ansible, and OCI CLI .

• Experience in REST API integration for database automation and monitoring.

• Deep understanding of HA/DR solutions including Data Guard, GoldenGate, and Active-Active replication .

• Experience in cloud networking, security, and IAM best practices for databases.

• Strong analytical and problem-solving skills, capable of troubleshooting complex, high-impact issues independently.

• Excellent verbal and written communication skills , with experience presenting technical concepts to stakeholders.

Preferred Qualifications:

• Experience in a Solutions Architect role , designing large-scale cloud database deployments .

• Good to have experience in Oracle Middleware administration .

• In Depth knowledge of storage, networking, and security principles in cloud environments.

BS degree in Computer Science, Information Systems, or equivalent work experience. Identifies and implements complex solutions in Technical Infrastructure support and server administration in a mid-sized environment; supporting and troubleshooting distributed applications, software, and operating systems; and administering and troubleshooting issues with messaging middleware and message brokers. Knowledge of enterprise platforms. Desire to keep up with modern technology and make recommendations. Knowledge of network architecture and protocols. Experience with enterprise administrative scripting using a major scripting language and experience with software deployment. Travel may be required in accordance with business needs. Related technical experience may be substituted for degree requirements, including Infrastructure support and server administration; supporting and troubleshooting distributed applications, software, and operating systems. Advanced knowledge of network architecture and protocols. Strong experience with enterprise administrative scripting using a major scripting language. 8+ years or more of related technical experience may be substituted for degree requirements, including Infrastructure support and server administration; supporting and troubleshooting distributed applications, software, and operating systems.

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.

When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.

We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first 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 calling +1 888 404 2494, option one.

Disclaimer:

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.

* Which includes being a United States Affirmative Action Employer