Database Oracle

Job Scope & Responsibilities

Having experience of 7+ years as senior oracle DBA Architect HA and DR Solutions for PAAS services like Exadata, Autonomous Databases (ATP,ADW), RAC & Dataguard) Installation and upgrade of Oracle and RAC on 10g/11g/12c/18c/19c version under Linux/AIX platforms.

Must have oracle ASM/ACFS implementation experience Good scripting skills to automate regular DBA admin tasks Strong experience on backup utilities or tools like RMAN & EXPDP/IMPDP, CRSCTL, SRVCTL, NetBackup, Networker.

Applying grid and DB PSU patch in standalone and multi-node RAC cluster servers Should have good command over speaking and writing. 

Strong experience on database and SQL queries tuning for Oracle and RAC databases.

Should have knowledge of oracle OEM 12C/13C.

He will be customer facing for all operational issues and activities Strong experience on configure and troubleshoot physical standby database using dataguard broker.

Strong experience on configure and troubleshoot golden gate replication components Good Grip over Tables fine tuning and troubleshooting Implement backup and recovery of Oracle databases for various scenarios.

Administration over DB Objects including Tables , Clusters , Views , Procedures etc. 

Good in Impact Analysis of DB Change / DB Design Change etc. 

In-depth understanding of Advanced Architectures (Multi-Node, RAC, ASM) Good understanding of core support processes and change management, maintain documentation standards.

Must have experience in Database tuning including I/O, Load Analysis, ADDR, AWR, SQL Profiling etc.

Responsible for installation, upgrades (Database and RAC), patches, SR support, database tuning, concurrent manager administration, cloning.

Able to work in 24 by 7 Support

Requirements:

Candidate must possess at least a bachelors degree, Post Graduate Diploma, Professional Degree (MCA / BE / BSC or SC computer science) Oracle 10g/11g/12c/18c/19c OCP certification is must Having oracle RAC certification will be added advantage.

Having previous banking BAU support will be added advantage Having experience on additional database technologies MSSQL or DB2 or Sybase will be added advantage.

At least 7 year(s) of working experience in the related field is required for this position.

Preferably Senior Executives specializing in IT/Computer Network / System/ Database Admin or equivalent.

Full-Time position.