Aeris - Senior Database Administrator - Oracle DB

About Aeris :

For more than three decades, Aeris has been a trusted cellular IoT leader enabling the biggest IoT programs and opportunities across Automotive, Utilities and Energy, Fleet Management and Logistics, Medical Devices, and Manufacturing.

Our IoT technology expertise serves a global ecosystem of 7,000 enterprise customers and 30 mobile network operator partners, and 80 million IoT devices across the world.

Aeris powers todays connected smart world with innovative technologies and borderless connectivity that simplify management, enhance security, optimize performance, and drive growth.

Built from the ground up for IoT and road-tested at scale, Aeris IoT Services are based on the broadest technology stack in the industry, spanning connectivity up to vertical solutions.

As veterans of the industry, we know that implementing an IoT solution can be complex, and we pride ourselves on making it simpler.

Our company is in an enviable spot.

Were profitable, and both our bottom line and our global reach are growing rapidly.

Were playing in an exploding market where technology evolves daily and new IoT solutions and platforms are being created at a fast pace.

A few things to know about us :.

We put our customers first.

When making decisions, we always seek to do what is right for our customer first, our company second, our teams third, and individual selves last.

We do things differently.

As a pioneer in a highly competitive industry that is poised to reshape every sector of the global economy, we cannot fall back on old models.

Rather, we must chart our own path and strive to out-innovate, out-learn, out-maneuver and out-pace the competition on the way.

We walk the walk on diversity.

Were a brilliant and eclectic mix of ethnicities, religions, industry experiences, sexual orientations, generations and more and thats by design.

We see diverse perspectives as a core competitive advantage.

Integrity is essential.

We believe in doing things well and doing them right.

Integrity is a core value here : youll see it embodied in our staff, our management approach and growing social impact work (we have a VP devoted to it).

Youll also see it embodied in the way we manage people and our HR issues : we expect employees and managers to deal with issues directly, immediately and with the utmost respect for each other and for the Company.

We are owners.

Strong managers enable and empower their teams to figure out how to solve problems.

You will be no exception, and will have the ownership, accountability and autonomy needed to be truly Title : Senior Oracle Database Administrator (DBA) GCP

Location : Noida, India

We are seeking a highly skilled and experienced Senior Oracle DBA to manage and maintain our critical Oracle 12c, 18c, 19c, 21c single instance with DG and RAC databases, hosted on Google Cloud Platform (GCP).

The ideal candidate will possess deep expertise in Oracle database administration, including installation, configuration, patching, performance tuning, security, and backup/recovery strategies within a cloud environment.

They will also have expertise and experience optimizing the underlying operating system and database parameters for maximum performance and 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 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 :

1. 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.

2. Optimizing PGA allocation (PGA_AGGREGATE_TARGET, PGA_AGGREGATE_LIMIT) to prevent excessive swapping and ensure efficient SQL execution.

3. Understanding the interaction between SGA and PGA memory regions and how they are affected by GCP instance memory limits.

4. 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 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 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 :

- 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.

Aeris may conduct background checks to verify the information provided in your application and assess your suitability for the role.

The scope and type of checks will comply with the applicable laws and regulations of the country where the position is based.

Additional detail will be provided via the formal application process.

Aeris walks the walk on diversity.

Were a brilliant mix of varying ethnicities, religions, cultures, sexual orientations, gender identities, ages and professional/personal/military experiences and thats by design.

Diverse perspectives are essential to our culture, innovative process and competitive edge.

Aeris is proud to be an equal opportunity employer.