Application Support Engineer

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.