Oracle DBA Job at Yochana, Dallas, TX

T2dyMFcyYjI1VVdZNkx3L21MTENVUWxLRGc9PQ==
  • Yochana
  • Dallas, TX

Job Description

Oracle RAC 19c Database Administrator

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.

Job Tags

Similar Jobs

Elite Security & Staffing

Armed Security Guard Job at Elite Security & Staffing

 ...Now Hiring: Armed Security Officers Elite Security & Staffing is actively expanding our elite armed division and seeking highly professional, dependable Armed Security Officers ready to work prestigious assignments throughout San Diego County. All work will be based... 

Enviri Corporation

Overhead Crane Operator Job at Enviri Corporation

 ...available as production allows. Responsibilities: # Operates cab-controlled traveling crane to lift; move and position scrap from railcars onto the...  ...with both feet. ~ Ability to perform sustained overhead reaching on occasional basis. ~ Ability to tolerate extreme... 

Busch's Inc.

Wine & Beverage Specialist — In-Store Tastings & Pairings Job at Busch's Inc.

 ...professional to promote alcohol beverages and manage inventory. This role requires culinary training and experience in the food, wine, or beer industry.The ideal candidate will excel in communication and merchandising skills, along with a strong knowledge of wines, liquors,... 

US Bankruptcy Court

Remote Clinical Admin Coordinator - Scheduling Data Entry Job at US Bankruptcy Court

 ...leading service provider is seeking a Clinical Administrative Coordinator to deliver essential support to their Help Desk Program. This remote position requires managing calls and documentation updates, ensuring confidentiality and exceptional service. Ideal candidates... 

The Staff Pad

Orthopedic Technician Job at The Staff Pad

 ...Orthopedic Clinic Technician The Staff Pad is partnering with a healthcare organization in Helena, MT, to hire an Orthopedic Clinic Technician for their orthopedic care team. This position assists physicians with both surgical and non-surgical procedures while delivering...