Oracle DBA

Key Responsibilities: • Oracle RAC 19c Configurations: Set up, manage, and troubleshoot Oracle RAC 19c configurations to ensure high availability and performance. Incorporate Oracle RAC best practices. • SQL Tuning: Optimize SQL queries and indexing strategies to enhance database performance. Perform detailed SQL tuning to ensure efficient query execution. • Multitenant Architecture: Implement and manage Multitenant architecture for better resource utilization and management. Ensure optimal performance and security of pluggable databases. • SGA and PGA Management: Appropriately size the Shared Global Area (SGA) and Program Global Area (PGA). Implement Automatic Memory Management to optimize database performance. • IAAS Implementation: Architect and manage Infrastructure as a Service (IAAS) solutions, including deployment, configuration, and ongoing support. • Automatic VM Failure Detection: Implement and manage automatic virtual machine (VM) failure detection mechanisms to ensure high availability. • Auto Scaling, Auto Healing, Auto Recovery: Design and implement auto scaling, auto healing, and auto recovery solutions to maintain system resilience and performance. • Disaster Recovery: Develop and implement disaster recovery plans and procedures to ensure business continuity. Recommend solutions for resilience or disaster recovery (DR). • Server Health and Performance Monitoring: Monitor server health and performance, troubleshoot issues, and optimize system resources to ensure availability and efficiency. Troubleshoot instance initialization, redo log files, and control files. • Third-Party Software Installations: Manage the installation and configuration of third-party software to meet business requirements. Troubleshoot using monitoring tools. • OS Upgrades and Patches: Perform operating system upgrades and implement patches to maintain system security and performance. • Monitoring Tools: Utilize existing third-party monitoring tools like Splunk or Squared Up to enhance system monitoring and reduce manual intervention. • Database Segregation: Segregate application databases to improve resiliency and performance.

Experience: • Typically requires 15+ years of experience in managing IAAS environments, including hands-on experience with installation, configuration, and customization of IAAS features. • Extensive experience with Oracle RAC 19c and SQL tuning. • Experience in managing and optimizing Shared Global Area (SGA) and Program Global Area (PGA). • Experience with disaster recovery implementations and reducing Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).

Technical Skills: • Proficiency in IAAS solutions and related technologies. • Good knowledge of Ansible is essential for automation tasks. • Experience with disaster recovery implementations. • Strong skills in server health and performance monitoring. • Proficiency in third-party software installations. • Experience with OS upgrades and patches. • Expertise in Oracle RAC (Real Application Clusters) 19c and SQL tuning. • Familiarity with third-party monitoring tools like Splunk or Squared Up. • Knowledge of Multitenant architecture. • Excellent performance tuning skills. • Ability to debug system-side configuration issues.

Desired Skills: • Strong analytical and problem-solving abilities. • Excellent communication and collaboration skills to interact with technical and non-technical stakeholders. • Ability to mentor and train junior associates on IAAS-related tasks. • A commitment to continuous learning to stay updated with the latest developments in IAAS technology and practices.