Oracle Database Support Engineer

Systems Arabia; India; On-site; INR 900,000 - 1,700,000; Full time

Job summary

Systems Arabia in India is seeking an Oracle Database Support Engineer with 3–7 years of production database experience. You will ensure availability, reliability, security, and performance while collaborating with application, development, and infrastructure teams.

Responsibilities include on-call support, performance tuning, RMAN backups, patching, upgrades, RCA, and data integrity. Familiarity with Oracle RAC/Data Guard and Linux is a plus.

Qualifications

• Bachelor's degree in Computer Science, IT, Engineering, or related field.
• 3–7 years of hands-on Oracle Database administration and production support experience.
• Strong knowledge of Oracle architecture, SQL, performance tuning, query optimization, and troubleshooting.
• Experience with RMAN, backup/recovery, and database monitoring.
• Experience with patching, upgrades, maintenance, and production deployments.
• Willingness to participate in on-call/rotational production support.
• Knowledge of Oracle RAC, Data Guard, ASM, replication, Linux/Unix, shell scripting, OCI, and automation is a plus.
• Oracle OCP certification and ITIL experience are desirable.

Responsibilities

• Provide production and on-call support for Oracle databases, including incident resolution and troubleshooting.
• Monitor database performance, availability, capacity, and health.
• Perform SQL and database performance tuning, including execution plans, indexing, statistics, and query optimization.
• Troubleshoot slow queries, locking, blocking sessions, deadlocks, wait events, and database errors.
• Maintain data integrity, consistency, security, and availability.
• Manage users, roles, privileges, schemas, storage, and routine database maintenance.
• Perform and support RMAN backup, restore, recovery, and disaster recovery activities.
• Support patching, upgrades, migrations, deployments, and configuration changes.
• Conduct root-cause analysis (RCA) and implement corrective/preventive actions.
• Collaborate with development, application, and infrastructure teams on database-related issues and SQL optimization.
• Monitor alerts and proactively identify performance, capacity, and availability risks.
• Follow security, compliance, change management, and data governance standards and maintain technical documentation.

Skills

SQL tuning

Incident management

Performance tuning

Troubleshooting

On-call support

Communication

Education

Bachelor's degree in CS/IT/Engineering

Tools

RMAN

Oracle RAC

Data Guard

OCI

Linux/Unix

Shell scripting

Job description

We are looking for an Oracle Database Support Engineer with 3–7 years of experience in production database support, performance tuning, SQL optimization, troubleshooting, backup/recovery, and data integrity. The role requires ensuring database availability, reliability, security, and performance while collaborating with application, development, and infrastructure teams.

Responsibilities

• Provide production and on-call support for Oracle databases, including incident resolution and troubleshooting.
• Monitor database performance, availability, capacity, and health.
• Perform SQL and database performance tuning, including execution plans, indexing, statistics, and query optimization.
• Troubleshoot slow queries, locking, blocking sessions, deadlocks, wait events, and database errors.
• Maintain data integrity, consistency, security, and availability.
• Manage users, roles, privileges, schemas, storage, and routine database maintenance.
• Perform and support RMAN backup, restore, recovery, and disaster recovery activities.
• Support patching, upgrades, migrations, deployments, and configuration changes.
• Conduct root-cause analysis (RCA) and implement corrective/preventive actions.
• Collaborate with development, application, and infrastructure teams on database-related issues and SQL optimization.
• Monitor alerts and proactively identify performance, capacity, and availability risks.
• Follow security, compliance, change management, and data governance standards and maintain technical documentation.

Requirements

• Bachelor's degree in Computer Science, IT, Engineering, or related field.
• 3–7 years of hands-on Oracle Database administration and production support experience.
• Strong knowledge of Oracle architecture, SQL, performance tuning, query optimization, and troubleshooting.
• Experience with execution plans, indexing, statistics, joins, partitioning, transactions, and data integrity.
• Hands‑on experience with RMAN, backup/recovery, and database monitoring.
• Good understanding of database security, users, roles, and privileges.
• Experience with patching, upgrades, maintenance, and production deployments.
• Strong problem‑solving, RCA, communication, and incident‑management skills.
• Willingness to participate in on‑call/rotational production support.
• Knowledge of Oracle RAC, Data Guard, ASM, replication, Linux/Unix, shell scripting, OCI, and automation is a plus.
• Oracle OCP certification and ITIL experience are desirable.