Oracle DB2+Netezza patch mgmt

About Company : Our Client Corporation provides digital engineering and technology services to Forbes Global 2000 companies worldwide. Our Engineering First approach ensures we can execute all ideas and creatively solve pressing business challenges. With industry expertise and empowered agile teams, we prioritize execution early in the process for impactful results. We combine logic, creativity and curiosity to build, solve, and create. Every day, we help clients engage with new technology paradigms, creatively building solutions that solve their most pressing business challenges and move them to the forefront of their industry.

Job Type : CONTRACT

Role : Oracle DB L2 Administrator

Experience : 10+ Years

Work Location : Bengaluru,Chennai,Pune,Coimbatore, Hyderabad

Payroll on : People Prime World Wide

Notice : 0 to 15 days

Detailed JD :

Oracle DB L2 Administrator Support Role

Shift Timings 24 / 7

Role Overview

An Oracle Database Administrator L2 Support is responsible for maintaining monitoring and optimising Oracle database environments This role focuses on operational stability patching performance tuning and incident resolution ensuring high availability and compliance with security standards

Key Responsibilities

Manage and maintain Oracle databases to ensure optimal performance and availability

Monitor database health using tools like Oracle Enterprise Manager and respond to s promptly

Troubleshoot and resolve L2level database issues escalating to L3 when necessary

Perform root cause analysis for recurring issues and implement preventive measures

Apply Oracle patches RU RUR PSU CPU and perform prepostpatch validations

Coordinate with application teams for patching windows and rollback planning

Execute and validate backups using RMAN and Data Pump

Perform recovery operations as per defined SLAs

Analyse AWRASH reports and optimise SQL queries and database parameters

Implement database security best practices manage user roles and ensure compliance with audit requirements

Maintain accurate documentation of configurations patch inventory and operational procedures

Provide regular health check and performance reports

Required Skills

Strong knowledge of Oracle Database architecture 11g12c19c

Proficiency in SQL PLSQL and UnixLinux shell scripting

Experience with RMAN Data Pump and Oracle Enterprise Manager

Familiarity with Grid Infrastructure RAC environments and ASM

Understanding of ITIL processes for incident change and problem management

Basic knowledge of automation tools Shell Python Ansible is an advantage

Certifications Oracle Certified Associate OCA or higher preferred

Soft Skills

Strong analytical and problemsolving abilities

Good communication and collaboration skills for working with crossfunctional teams

Ability to work in 24x7 support environments and handle oncall duties