28 Sep
|
Accenture India Private
|
Bengaluru
28 Sep
Accenture India Private
Bengaluru
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).
- Robust 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.
📌 Application Support Engineer - Oracle Database Administration (Bengaluru)
🏢 Accenture India Private
📍 Bengaluru