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