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, AutoUpgrade, 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:
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
AutoUpgrade 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)
Cloud Skills (Preferred)
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
Preferred Skills
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.

Additional Information:

Preferred Certifications - Nice to have
Oracle Certified Professional (OCP)
Oracle Certified Master (OCM) (preferred)
Oracle Cloud Infrastructure Certification

Qualification 15 years full time education