Principal Dba

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.

**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.

**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.