Oracle DBA Admin L1

Newgen; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

Newgen is seeking an Oracle Database Administrator with 2-3 years of experience to manage, monitor, and support Oracle database environments. The role covers maintenance, backups, patching, user management, and performance monitoring.

The candidate will work with RMAN, Data Pump utilities, and ASM, ensuring security, integrity, and compliance while coordinating with storage, application, and infrastructure teams.

Qualifications

• 2-3 years of Oracle DBA experience needed.
• Experience with Oracle DB versions 11g/12c/19c.
• Unix/Linux command line proficiency for DB administration.

Responsibilities

• Perform daily health checks of Oracle databases and monitor uptime, space, and performance.
• Manage backups and restorations using RMAN.

Skills

SQL

PL/SQL

Monitoring

Performance tuning

Tools

RMAN

Data Pump expdp/impdp

OPatch

ASM

AWR/ADDM/OEM

Job description

Job Summary

We are seeking an Oracle Database Administrator with 2-3 years of experience in managing, monitoring, and supporting Oracle database environments. The candidate will be responsible for database maintenance, backups, patching, user management, and performance monitoring.

Responsibilities

• Perform daily health checks of Oracle database instances (uptime, space utilization, performance).
• Monitor tablespaces, datafiles, redo logs, and alert logs for potential issues.
• Manage user accounts, roles, and privileges following security policies.
• Perform database backups and restorations using RMAN (Recovery Manager).
• Support database patching and version upgrades.
• Monitor and optimize database performance using AWR, ADDM, and OEM tools.
• Assist in installation and configuration of Oracle Database software (11g/12c/19c).
• Troubleshoot connectivity, performance, and locking issues.
• Perform data export/import using Data Pump utilities (expdp/impdp).
• Monitor ASM disk groups and coordinate with the storage team for space management.
• Support database cloning, refresh activities, and schema migrations.
• Ensure database security, integrity, and compliance as per company standards.
• Support DR (Disaster Recovery) and high availability setups (RAC/Data Guard).
• Coordinate with application, middleware, and infrastructure teams for smooth operations.
• Maintain documentation for configurations, backups, and recovery procedures.

Technical Skills Required

• Oracle Database Administration (11g/12c/19c) - installation, configuration, maintenance.
• Experience in RMAN backup recovery operations.
• Working knowledge of SQL and PL/SQL for query tuning and issue diagnosis.
• Understanding of tablespace, datafile, and control file management.
• Hands-on experience with Data Pump (expdp/impdp).
• Familiar with ASM (Automatic Storage Management).
• Knowledge of database patching using OPatch.
• Exposure to RAC and Data Guard concepts.
• Working knowledge of Unix/Linux commands for DB administration.

Key Skills

• Oracle DBA