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.

Data Guard Expertise :

Good to Have :

GCP Environment Management :

Other Products and Platforms

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.

(ref : hirist.tech)