Oracle DBA

Title- Oracle DBA

Location- Dallas, Texas

Type- FTE

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.