Oracle Database Administrator

We are thrilled to let you know that Clover Infotech (Mumbai / Chennai) has returned with yet another amazing opportunity for Oracle Database Administrator professional.

Title: Oracle Database Administrator (L2 & L3)

Work Location: Mumbai / Navi Mumbai / Chennai (Work from Office)

Education Qualification: Bachelors degree in Computer Science, Information Technology, or a related field.

Experience: 3 - 10 Years.

Key Skills:

1. In-Depth Knowledge of Oracle Database/DG/RAC

• Oracle Database: Strong understanding of Oracle's architecture, including memory structures (SGA, PGA), background processes, and table storage mechanisms.
• Data Guard (DG): Involves creating and maintaining disaster recovery solutions. Candidate should know how to configure primary and standby databases, manage redo log transport services, and handle role transitions (switchover, failover).
• Real Application Clusters (RAC): Knowledge of configuring Oracle RAC for high availability. Should be able to manage clusterware, interconnects, and shared storage to ensure database uptime and scalability.

2. Implementation of Oracle Databases with DG and RAC

• DG Implementation: Setting up Oracle Data Guard with both physical and logical standby databases. Understanding the setup of redo transport services, managing data protection modes.
• RAC Implementation: Deploying Oracle RAC with shared storage, configuring the Oracle Clusterware, setting up database instances across nodes, and ensuring high availability.

3. Backup Strategies with RMAN and EXPDP-IMPDP

• RMAN (Recovery Manager): Ability to configure and manage RMAN backups (full, incremental, and archived logs). Understanding backup retention policies, the recovery process, and performing point-in-time recovery.
• EXPDP/IMPDP (Data Pump Export/Import): Knowledge of export/import utilities for logical backups and data migrations, including parameter tuning for large data sets, performing data transformations, and managing job logs.

4. Knowledge of ASM Management (Create, Drop, Alter Diskgroups/Add and Drop Disks)

• ASM (Automatic Storage Management): Expertise in managing disk groups for storage. This involves creating, deleting, and altering ASM disk groups, adding/removing disks from groups, and troubleshooting ASM-related issues.

5. Troubleshooting Database Issues/Errors in DG and RAC

• Troubleshooting: Proficiency in identifying and resolving critical errors in Oracle DG (e.g., synchronization issues, log transport errors) and RAC environments (e.g., instance failures, network issues, resource contention).
• Familiarity with Oracle alert logs, Data Guard logs, and Oracle Clusterware logs.

6. Adherence to SLAs

• SLAs (Service Level Agreements): Understanding and meeting database performance, availability, and recovery time objectives as defined by SLAs. Proactive monitoring and response to ensure compliance.

7. Migration of Databases on Homogeneous and Heterogeneous OS Platforms

• Expertise in migrating databases between similar OS environments (homogeneous) as well as different OS platforms (heterogeneous), including setting up appropriate data transport, character set conversions, and handling any OS-specific differences.

8. Patching for Oracle Database/DG/RAC Environments

• Patch Management: Knowledge of patching Oracle Database, Data Guard, and RAC systems. This involves understanding patch levels, testing patches, applying patches using OPatch, and ensuring minimal downtime during patching operations.

9. Upgradation of Database for SIFS, SIHA, and RAC Environments

• Upgradation: Ability to upgrade databases, including the use of Oracle tools like Database Upgrade Assistant (DBUA). This includes upgrades for features like SIFS (Single Instance File System), SIHA (Single Instance High Availability), and RAC environments to newer Oracle versions.

10. Identification and Troubleshooting of Critical Errors

• A deep understanding of potential issues like performance degradation, connectivity problems, and Oracle errors (ORA-xxxx codes). Candidate should be able to identify, diagnose, and resolve issues related to database instances, RAC nodes, or DG standby.

11. Planning and Implementing Database Migration, Patching, and Upgradation

• Involves creating strategies for database migration (both logical and physical), planning patch cycles, testing environments, and ensuring smooth upgrades. Documenting rollback plans and ensuring high availability during these operations is crucial.

12. Knowledge of Database Level and Query Level Tuning

• Database Level Tuning: Optimizing database performance by adjusting memory structures (SGA, PGA), configuring database parameters, managing storage, and tuning background processes.
• Query Level Tuning: Ability to analyze and optimize SQL queries by reviewing execution plans, indexing strategies, and SQL performance analysis.

13. Security Baseline Updates for Databases

• Regularly updating database security patches, managing user access and privileges, configuring auditing, and applying Oracle's security best practices to protect sensitive data and prevent unauthorized access
• Database hardening & patching

14. Knowledge of Oracle GoldenGate

• Oracle GoldenGate: Understanding how to configure and manage Oracle GoldenGate for real-time data replication across heterogeneous systems. Proficiency in setting up replication, troubleshooting replication issues, and ensuring data consistency between source and target databases.