Oracle DBA with IaaS Environment

  • Full-time

Company Description

We provide Recruitment and Staffing services to many industries and domain through our innovative and customized solutions and passionate commitment to research. Ability to understand the hiring strategies, availability of talent and compensation benchmarking makes us proud hiring partner for various industries. We work as trusted business partners and always strive to deliver the most value and highest return on investment for our clients. We are highly trained business professionals with strong understanding of clients need. We work closely with the leading staffing trade associations, training, and research organizations to ensure we are knowledgeable of the latest industry trends and technologies.

Job Description

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.
 

Regards,

Mohammed ilyas,

PH - 229-264-4024 or Text - 229-469-1455 or You can share the updated resume at Mohammed@vtekis. com

 

 

Additional Information

All your information will be kept confidential according to EEO guidelines.