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.