Application Support Engineer - Oracle Database Administration

Accenture India Private Limited; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Accenture India Private Limited is seeking a Senior Oracle Database Administrator to manage and support mission-critical Oracle databases in Bengaluru. The role emphasizes RAC, Data Guard, RMAN, and performance tuning for large-scale production environments.

The candidate should have 5–10 years of Oracle DBA experience, strong automation skills, and cloud/database migration exposure. Applicants will collaborate with application teams during deployments and DR drills.

Qualifications

• We are seeking an experienced Senior Oracle Database Administrator to manage and support mission-critical Oracle database environments.
• Must have extensive Oracle DBA expertise including RAC, Data Guard, ASM, and backup/recovery strategies.
• Hands-on experience with large-scale production environments, security, and performance optimization.
• Minimum 5–10 years of Oracle DBA experience with 15 years of education.

Responsibilities

• Install, configure, administer, and maintain Oracle Database across Dev, Test, UAT, and Production.
• Design and implement highly available Oracle solutions using RAC and Data Guard.
• Perform upgrades and migrations using DBUA, Auto Upgrade, and manual methods.
• Plan migrations across servers, storage, OS, and cloud platforms.
• Clone databases with RMAN and storage snapshot tech; manage ASM and Clusterware.
• Administer RAC, troubleshoot cluster issues, and perform RAC maintenance.
• Manage Data Guard, including switchover/failover; develop DR strategies and drills.
• Manage RMAN backups and perform PITR; diagnose corruption and performance bottlenecks.
• Monitor performance, tune SQL, and optimize resources; apply RU/PSU patches and grid patches.
• Automate DBA tasks with Shell, Python, and Ansible; support Multitenant (CDB/PDB).

Skills

Oracle Database Administration

Oracle RAC Administration

RMAN Backup & Recovery

PITR (Point-in-Time Recovery)

Performance Tuning

DB Upgrade & Migration

Shell Scripting

Python scripting

Linux/Unix Administration

Automation/DevOps

Cloud Database Administration

Education

15 years full time education

Tools

Oracle Enterprise Manager

OPatch

DBUA

Grid Infrastructure

Ansible

Job description

Application Support Engineer Project Role

Application Support Engineer Project Role : Application Support Engineer Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems. Must have skills : Oracle Database Administration (DBA) Good to have skills : NA Minimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary: We are looking for an experienced Senior Oracle Database Administrator to manage and support mission-critical Oracle database environments. The ideal candidate should possess strong expertise in Oracle database architecture, high availability, disaster recovery, performance optimization, database upgrades, and automation. The role requires hands‑on experience in administering large‑scale production environments while ensuring database security, availability, and optimal performance.

Roles & Responsibilities:

• Install, configure, administer, and maintain Oracle Database environments across Development, Test, UAT, and Production.
• Design and implement highly available Oracle database solutions using Oracle RAC and Oracle Data Guard.
• Perform database upgrades and migrations using DBUA, Auto Upgrade, and manual methods.
• Plan and execute database migrations across servers, storage, operating systems, and cloud platforms.
• Perform database cloning using RMAN, duplicate databases, and storage snapshot technologies.
• Configure and manage Oracle ASM and Clusterware environments.
• Administer Oracle RAC, troubleshoot cluster issues, and perform RAC maintenance.
• Configure, administer, and monitor Oracle Data Guard, including switchover and failover activities.
• Develop and test Disaster Recovery (DR) strategies and conduct DR drills.
• Manage RMAN backup strategies and perform complete, incomplete, Point-in-Time Recovery (PITR), and block media recovery.
• Diagnose and resolve database corruption, performance bottlenecks, and critical production issues.
• Perform database health checks and capacity planning.
• Monitor database performance and optimize SQL queries, execution plans, wait events, and system resources.
• Tune Oracle databases using AWR, ASH, ADDM, SQL Tuning Advisor, and Execution Plan analysis.
• Apply Oracle Release Updates (RU), Patch Set Updates (PSU), one‑off patches, and perform Grid Infrastructure patching.
• Perform Oracle Database and Grid Infrastructure upgrades with minimal downtime.
• Implement database security, auditing, encryption (TDE), and user privilege management.
• Automate routine DBA tasks using Shell scripting, Python, or Ansible.
• Support Oracle Multitenant (CDB/PDB) administration.
• Collaborate with application teams during deployments, troubleshooting, and performance optimization.
• Create and maintain technical documentation, SOPs, and operational runbooks.
• Mentor junior DBAs and provide technical leadership for database initiatives.

Professional & Technical Skills:

• Proficiency in Oracle Database Administration (11g, 12c, 19c, 21c or later)
• Oracle RAC Administration
• Oracle ASM Administration
• Oracle Data Guard (Physical and Logical Standby)
• RMAN Backup & Recovery
• Point-in-Time Recovery (PITR)
• Block Media Recovery
• Database Cloning
• Database Upgrade and Migration
• Auto Upgrade and DBUA
• Oracle Grid Infrastructure Administration
• Oracle Enterprise Manager (OEM)
• Database Performance Tuning
• SQL Performance Tuning
• Execution Plan Analysis
• AWR, ASH, ADDM, Statspack
• Oracle Patching (OPatch, OPatchAuto)
• Oracle Multitenant (CDB/PDB)
• Linux/Unix Administration
• Shell Scripting (Bash/Korn)
• Python scripting (preferred)
• Storage concepts (SAN, NAS, ASM)
• Oracle Security (TDE, Auditing, Roles & Privileges)

Preferred Cloud Skill:

• Oracle Cloud Infrastructure (OCI) Database Administration
• OCI Base Database Service and Exadata Database Service
• Oracle Cloud Backup and Recovery
• Database migration to/from OCI
• Experience with AWS RDS for Oracle or Azure Oracle deployments
• Infrastructure as Code (Terraform) exposure is an added advantage

Cloud Skills (Preferred)

• Experience managing large production environments (24x7 support).
• Strong troubleshooting and root cause analysis skills.
• Experience with automation and DevOps practices.
• Knowledge of ITIL processes and change management.
• Excellent communication and stakeholder management skills.
• Ability to lead production incidents and mentor junior team members.

Preferred Certifications - Nice to have

• Oracle Certified Professional (OCP)
• Oracle Certified Master (OCM) (preferred)
• Oracle Cloud Infrastructure Certification

Additional Information:

• The candidate should have minimum 5-10 years of experience in Oracle Database Administration (DBA).
• This position is based at our Bengaluru office.
• A 15 years full-time education is required.