Premium Employer

i

This company page is being actively managed by Clover Infotech Team. If you also belong to the team, you can get access from here

Clover Infotech Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 1.1k Reviews

filter salaries All Filters

79 Clover Infotech Jobs

Oracle Database Administrator - Clover Infotech

3-8 years

Navi Mumbai, Chennai, Mumbai

5 vacancies

Oracle Database Administrator - Clover Infotech

Clover Infotech

posted 5d ago

Job Role Insights

Flexible timing

Job Description

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.


Please Share & Refer resume at ajay.kurlekar@cloverinfotech.com



Employment Type: Full Time, Permanent

Read full job description

Clover Infotech Interview Questions & Tips

Prepare for Clover Infotech Oracle Database Administrator roles with real interview advice

People are getting interviews at Clover Infotech through

(based on 66 Clover Infotech interviews)
Job Portal
Referral
Walkin
Company Website
Recruitment Consultant
Campus Placement
57%
12%
12%
3%
3%
2%
11% candidates got the interview through other sources.
High Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.

What people at Clover Infotech are saying

3.2
 Rating based on 45 Oracle Database Administrator reviews

Likes

Job security

Dislikes

Nothing to describe here for

Read 45 reviews

Oracle Database Administrator salary at Clover Infotech

reported by 476 employees with 1-5 years exp.
₹1.8 L/yr - ₹10 L/yr
23% less than the average Oracle Database Administrator Salary in India
View more details

What Clover Infotech employees are saying about work life

based on 1.1k employees
59%
47%
48%
98%
Flexible timing
Monday to Friday
No travel
Day Shift
View more insights

Clover Infotech Benefits

Submitted by Company
Group term insurance and medical cover
Gratuity
Paid Holidays
Provident Fund
ESIC
Performance incentive plan +1 more
Submitted by Employees
Soft Skill Training
Job Training
Health Insurance
Work From Home
Cafeteria
Team Outings +6 more
View more benefits

Compare Clover Infotech with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.7
Compare

HCLTech

3.6
Compare

Tech Mahindra

3.6
Compare

LTIMindtree

3.8
Compare

Mphasis

3.4
Compare

Hexaware Technologies

3.6
Compare

KPIT Technologies

3.5
Compare

3i Infotech

3.5
Compare

Sify Technologies

3.9
Compare

NeoSOFT

4.0
Compare

Microland

3.5
Compare

Newgen Software Technologies

3.6
Compare

Sonata Software

3.5
Compare

Happiest Minds Technologies

3.8
Compare

Prodapt

3.6
Compare

Test Yantra Software Solutions

3.2
Compare

Mastek

3.6
Compare

Lumina Datamatics

3.3
Compare

Similar Jobs for you

Oracle Database Administrator at Infosys

Hyderabad / Secunderabad, Chennai + 1

5-9 Yrs

₹ 3-8 LPA

Oracle Database Administrator at Infosys

Hyderabad / Secunderabad, Pune + 1

5-10 Yrs

₹ 4-9 LPA

Oracle Database Administrator at Tech Mahindra

Navi Mumbai

4-9 Yrs

₹ 13-18 LPA

Oracle Database Administrator at Sbase Technologies

Hyderabad / Secunderabad, Mumbai

5-8 Yrs

₹ 7-12 LPA

Senior Oracle Database Administrator at Cognisive (Formerly Indmax IT Services Pvt Ltd)

Hyderabad / Secunderabad, Coimbatore

6-11 Yrs

₹ 7-14 LPA

Oracle Database Administrator at Oracle

Mumbai

8-13 Yrs

₹ 15-30 LPA

Database Admin at BNP Paribas

Bangalore / Bengaluru

9-12 Yrs

₹ 18-25 LPA

Database Admin at Healthedge

Pune

3-6 Yrs

₹ 12-14 LPA

Oracle Database Administrator at Infosys Limited

Bangalore / Bengaluru

5-9 Yrs

₹ 7-11 LPA

Oracle Database Engineer at Softenger

Chennai

5-10 Yrs

₹ 18-22.5 LPA

Clover Infotech Mumbai Office Location

View all
Mumbai Office
Headquarter
2nd Floor, Dhana Singh Processors Building, Vazir Glass Lane, J B Nagar, Andheri (East) Mumbai – 400059, Maharashtra, India Mumbai
400059

Oracle Database Administrator - Clover Infotech

3-8 Yrs

Navi Mumbai, Chennai, Mumbai

6d ago·via naukri.com

Dot Net Developer

4-8 Yrs

Navi Mumbai, Mumbai

1d ago·via naukri.com

Machine Engine Experts (ITSM) - Mumbai candidates only.

3-8 Yrs

Navi Mumbai

2d ago·via naukri.com

Hiring For OAS/ OAC Developer For Mumbai (Goregoan).

3-6 Yrs

₹ 4 - 9L/yr

Mumbai

2d ago·via naukri.com

Oracle Fusion Finance Functional Consultant role in Pune OR Mumbai

6-11 Yrs

Mumbai, Pune

3d ago·via naukri.com

Oracle EBS Finance Functional Consultant role in Pune OR Mumbai

7-12 Yrs

Pune, Mumbai

3d ago·via naukri.com

Opportunities with Clover Infotech / Oracle EBS Technical Lead

7-12 Yrs

Pune, Mumbai

3d ago·via naukri.com

Oracle EBS OPM Functional Consultant (Oracle Process Manufacturing )

7-12 Yrs

Pune, Mumbai

3d ago·via naukri.com

Oracle Apps DBA role In Pune OR Mumbai

7-12 Yrs

Pune, Mumbai

3d ago·via naukri.com

Recently Viewed

write
Share an Interview
How was your last interview experience?