About Aeris:

• Database Administration:
  • Install, configure, and maintain Oracle 12c, 18c, 19c, 21c single instance with DG and RAC databases on GCP Compute Engine.
  • Implement and manage Oracle Data Guard for high availability and disaster recovery, including switchovers, failovers, and broker configuration.
  • Perform database upgrades, patching, and migrations.
  • Develop and implement backup and recovery strategies, including RMAN configuration and testing.
  • Monitor database performance and proactively identify and resolve performance bottlenecks.
  • Troubleshoot database issues and provide timely resolution.
  • Implement and maintain database security measures, including user access control, auditing, and encryption.
  • Automate routine database tasks using scripting languages (e.g., Shell, Python, PL/SQL).
  • Create and maintain database documentation.
• Database Parameter Tuning:
  • In-depth knowledge of Oracle database initialization parameters and their impact on performance, with a particular focus on memory management parameters.
  • Expertise in tuning Oracle memory structures (SGA, PGA) for optimal performance in a GCP environment. This includes:
    • Precisely sizing the SGA components (Buffer Cache, Shared Pool, Large Pool, Java Pool, Streams Pool) based on workload characteristics and available GCP Compute Engine memory resources.
    • Optimizing PGA allocation (PGA_AGGREGATE_TARGET, PGA_AGGREGATE_LIMIT) to prevent excessive swapping and ensure efficient SQL execution.
    • Understanding the interaction between SGA and PGA memory regions and how they are affected by GCP instance memory limits.
    • Tuning the RESULT_CACHE parameters for optimal query performance, considering the available memory and workload patterns.
    • Proficiency in using Automatic Memory Management (AMM) and Automatic Shared Memory Management (ASMM) features and knowing when manual tuning is required for optimal results.
    • Knowledge of how GCP instance memory limits can impact Oracle's memory management and the appropriate adjustments to make.
  • Experience with analysing AWR reports and identifying areas for database parameter optimization, with a strong emphasis on identifying memory-related bottlenecks (e.g., high buffer busy waits, excessive direct path reads/writes).
  • Proficiency in tuning SQL queries using tools like SQL Developer and Explain Plan, particularly identifying queries that consume excessive memory or perform inefficient memory access patterns.
  • Knowledge of Oracle performance tuning methodologies and best practices, specifically as they apply to memory management in a cloud environment.
  • Experience with database indexing strategies and index optimization, understanding the impact of indexes on memory utilization.
  • Solid understanding of Oracle partitioning and its benefits for large databases, including how partitioning can affect memory usage and query performance.
  • Ability to perform proactive performance tuning based on workload analysis and trending, with a focus on memory usage patterns and potential memory-related performance issues.
  • Expertise in diagnosing and resolving memory leaks or excessive memory consumption issues within the Oracle database.
  • Deep understanding of how shared memory segments are managed within the Linux OS on GCP Compute Engine and how to optimize them for Oracle.
• Data Guard Expertise:
  • Deep understanding of Oracle Data Guard architectures (Maximum Performance, Maximum Availability, Maximum Protection).
  • Expertise in configuring and managing Data Guard broker for automated switchovers and failovers.
  • Experience in troubleshooting Data Guard issues and ensuring data consistency.
  • Knowledge of Data Guard best practices for performance and reliability.
  • Proficiency in performing Data Guard role transitions (switchover, failover) with minimal downtime.
  • Experience with Active Data Guard is a plus.
• Operating System Tuning:
  • Deep expertise in Linux operating systems (e.g., Oracle Linux, Red Hat, CentOS) and their interaction with Oracle databases.
  • Performance tuning of the Linux operating system for optimal Oracle database performance, including:
    • Kernel parameter tuning (e.g., shared memory settings, semaphores, file descriptor limits).
    • Memory management optimization (e.g., HugePages configuration).
    • I/O subsystem tuning (e.g., disk scheduler selection, filesystem optimization).
    • Network configuration optimization (e.g., TCP/IP parameters).
  • Monitoring and analysis of OS performance metrics using tools like vmstat, iostat, top, and sar.
  • Identifying and resolving OS-level resource contention issues (CPU, memory, I/O).
• Good to Have:
  • GCP Environment Management:
    • Provision and manage GCP Compute Engine instances for Oracle databases, including selecting appropriate instance types and storage configurations.
    • Configure and manage GCP networking components (VPCs, subnets, firewalls) for secure database access.
    • Utilize GCP Cloud Monitoring and Logging for database monitoring and troubleshooting.
    • Implement and manage GCP Cloud Storage for database backups.
    • Experience with Infrastructure as Code (IaC) tools like Terraform or Cloud Deployment Manager to automate GCP resource provisioning.
    • Cost optimization of Oracle database infrastructure on GCP.
• • Other Products and Platforms
    • Experience with other cloud platforms (AWS, Azure).
    • Experience with NoSQL databases.
    • Experience with Agile development methodologies.
    • Experience with DevOps practices and tools (e.g., Ansible, Chef, Puppet).
    • Experience with GoldenGate.

• Bachelor's degree in Computer Science or a related field.
• Minimum 12+ years of experience as an Oracle DBA.
• Proven experience managing Oracle 12c, 18c, 19c, and 21c single instance with DG and RAC databases in a production environment, with strong Data Guard expertise.
• Extensive experience with Oracle database performance tuning, including OS-level and database parameter optimization.
• Hands-on experience with Oracle databases hosted on Google Cloud Platform (GCP).
• Strong understanding of Linux operating systems.
• Excellent troubleshooting and problem-solving skills.
• Strong communication and collaboration skills.
• Oracle Certified Professional (OCP) certification is highly preferred.
• GCP certifications (e.g., Cloud Architect, Cloud Engineer) are a plus.