Oracle Database Administrator - ASM/RAC Modules (1-15 yrs)

Role : Oracle Database Administrator

Site : WFO/WFH

Industry Type : IT Services & Consulting

Department : Engineering - Software

Employment Type : Full Time, Permanent

Role Category : DBA

Database Administrator Responsibilities :

Oracle Database Architecture :

- Installation, configuration, and upgrading of Oracle server in a standalone or RAC Environment

- Implementing high availability solutions using Oracle Real Application Cluster

- Implementing DR solutions using Oracle Standby Database using Oracle Data Guard

- Start and Stop of Oracle Database Services

- Migrating schemas using traditional exp/imp and Oracle Data pump utilities.

- Cross-platform migration

- Usage of Oracle RMAN

- Usage of Alert logs

- Familiar with Oracle CPU and PSU patching procedures.

- Generating and Analyzing Oracle AWR and ADDM Reports

- Monitor data backup process and perform data recovery if needs be.

- Study database-related issues that could affect the database production infrastructure and document the issues.

- Develop scripts to automate functions, processes and monitor database performance

- Defining database standards and procedures to cover the instance parameters, object sizing, storage, and naming.

- The procedures define the process for install/ upgrade, corporate database requirements, security and automate the same.

- Knowledge of ALL Oracle backup and recovery scenarios.

- Should have live experience of Database Upgrade/Migration from multiple database versions and OS.

Database Administrator Requirements :

- Graduation

- At least 1+ years of experience as an Oracle Database Administrator

- Strong communication, coordination, and interpersonal skills

- Strong Core Oracle Database knowledge (12c and 19c) including RAC/ASM

- Strong SQL, PL/SQL, and shell /Perl scripting skills

- Basic knowledge of Oracle Fusion Middleware (e.g. WebLogic)

- Basic knowledge of Cloud (OCI, AWS, or AZURE)

- Knowledge of Enterprise Manager

- In-depth knowledge of Oracle database technologies and architecture

- Knowledge of best practices in database management.

- Exceptional organizational skills and attention to detail